Identify and Select All Merged Cells in Excel

Namita Aggarwal
Updated on 07-Aug-2023 19:43:27

393 Views

In this article, users will understand how to identify and select all merger cells in Excel. This article contains three examples, first example is based on the process of using the VBA code, the second process allows user the to find and select a method, and finally, the third option allows the user to use the Kutools options. Excel merging cells allow the user to improve the visual layout and organization of data. Some most common benefits of merging cells are : Included improving the readability and presentation of data. ... Read More

Hide Table Header Using JavaScript

Mrudgandha Kulkarni
Updated on 07-Aug-2023 19:42:52

3K+ Views

Tables are a common element in web development, used to organize and present data in a structured format. While table headers provide valuable context and help users understand the content within a table, there are situations where hiding the table header becomes necessary. Whether it's to enhance the visual design, improve user experience, or accommodate specific requirements, knowing how to hide the table header using JavaScript can be a useful skill for web developers. In this article, we will explore different methods to hide the table header using JavaScript. We will cover techniques that leverage CSS, manipulate the Document Object ... Read More

Highlight Searched String Result Using JavaScript

Mrudgandha Kulkarni
Updated on 07-Aug-2023 19:40:12

4K+ Views

Searching for specific content within a large body of text is a common task in web applications. However, simply displaying the search results without any visual indication can make it challenging for users to identify and focus on the relevant information. That's where the need for highlighting the searched string arises. By dynamically highlighting the matching portions of the text, we can improve the user experience and make it easier for users to locate the desired content. In this blog post, we will explore different methods to highlight the searched string using JavaScript. We'll cover various techniques that range from ... Read More

Handle Multiple Rows Selection Using jQuery DataTables Plugin

Mrudgandha Kulkarni
Updated on 07-Aug-2023 19:36:51

2K+ Views

Handling multiple rows selection in jQuery DataTables adds a powerful and intuitive interaction feature to your data tables. Whether you need to perform bulk actions, manipulate selected data, or simply provide a more user-friendly experience, the ability to select multiple rows simultaneously is invaluable. In this blog post, we will explore how to handle multiple rows selection using the jQuery DataTables plugin. We will delve into the configuration options, event handling techniques, and customization possibilities that allow you to seamlessly incorporate this functionality into your web applications. By the end of this article, you will have a solid understanding of ... Read More

Compute Outer Product of Two Vectors Using NumPy in Python

Niharika Aitam
Updated on 07-Aug-2023 19:35:47

323 Views

The Outer product of two vectors is the matrix obtained by multiplying each element of the vector A with each element in the vector B. The outer product of the vectors a and b is given as a ⊗ b. The following is the mathematical formula for calculating the outer product.a ⊗ b = [a[0] * b, a[1] * b, ..., a[m-1] * b] Where, a, b are the vectors. denotes the element-wise multiplication of two vectors. The output of the outer product is a matrix in which i and j are the elements of the ... Read More

Compute the Median of a Flattened NumPy Array

Niharika Aitam
Updated on 07-Aug-2023 18:17:02

142 Views

MedianThe median is the statistical measure for the central tendency that represents the middle value of the sorted list of values. In other words, we can say that the median is the value which separates the upper half of the dataset from the lower half of the dataset. The mathematical formula for calculating the median is as follows when the total number of elements is odd. Median = (n+1)/2 Where, n is the last element from the given set. Flattened array Flattening is a process of reducing the dimensionality of an array. flattened array is a 1-d ... Read More

Compute Mean, Standard Deviation and Variance of a NumPy Array

Niharika Aitam
Updated on 07-Aug-2023 18:08:11

563 Views

Mean, Standard Deviation and Variance are the statistical measures which are used to describe the distribution of the given dataset data. In Numpy library, we have the functions to calculate the mean, standard deviation and variance of the arrays. Let’s see one by one in detail. Mean Mean is also known as average, which is the sum of all the elements in the array divided by the total number of elements. It is used to represent the central tendency of the data. Syntax Following is the syntax for applying the mean function on the arrays - numpy.mean(arr) ... Read More

Compute the Inverse of a Matrix Using inv() Function of NumPy

Niharika Aitam
Updated on 07-Aug-2023 18:02:58

180 Views

The inverse matrix is a matrix that gives a multiplicative identity when multiplied with its original matrix. It is denoted by A-1. The inverse matrix can be calculated for the square matrices with the n x n size. The mathematical formula given for calculating the inverse matrix is as follows. A-1 . A = A . A-1 = I Where, A is the original matrix. A-1 is the inverse of the original matrix A. I is the identity matrix. Let’s take the original matrix as A with the size 2 x 2 and elements as ... Read More

Compute Inner Product of Vectors for d-Arrays Using NumPy in Python

Niharika Aitam
Updated on 07-Aug-2023 17:44:42

238 Views

Inner product is one of the most important operations in the linear algebra mathematical operations, which takes two vectors as input and gives the scalar value as the output. It is also known as the Dot product or the scalar product. The inner product of the two vectors is given as follows. a . b = ||a|| ||b|| cos(Ø) Where, ||a|| and ||b|| are the magnitudes of the vectors a and b respectively Ø is the angle between the vectors a and b a . b is the dot product of a and b Calculating Inner ... Read More

Compute Histogram of Nums Against Bins Using NumPy

Niharika Aitam
Updated on 07-Aug-2023 17:41:41

157 Views

In python, for creating histograms we have the numpy, matplotlib and seaborn libraries. In Numpy, we have the function namely histogram() to work with the histogram data. The input argument for the histogram() function is the nums and bins. The nums are used to create the numerical data. Before proceeding with the examples first of all let us understand what is histogram. What is histogram Histogram is the graphical representation of the dataset distribution. It represents the data in the form of series of bars, where the range of data values represented by each bar and height of the bar ... Read More

Advertisements