Assume, you have a dataframe and the result for table-wise function is, Table wise function:    Id  Mark 0  6.0 85.0 1  7.0 95.0 2  8.0 75.0 3  9.0 90.0 4 10.0 95.0SolutionTo solve this, we will follow the steps given below −Define a dataframeCreate a user-defined function avg with ... Read More

Assume, you have a dataframe and the result for trim of minimum and the maximum threshold value, minimum threshold:    Column1 Column2 0    30    30 1    34    30 2    56    30 3    78    50 4    30    90 maximum threshold:   ... Read More

Assume, you have a dataframe and the result for quantify shape of a distribution is, kurtosis is: Column1    -1.526243 Column2     1.948382 dtype: float64 asymmetry distribution - skewness is: Column1    -0.280389 Column2     1.309355 dtype: float64SolutionTo solve this, we will follow the steps given below ... Read More

SolutionAssume you have a dataframe and mean absolute deviation of rows and column is, mad of columns: Column1    0.938776 Column2    0.600000 dtype: float64 mad of rows: 0    0.500 1    0.900 2    0.650 3    0.900 4    0.750 5    0.575 6    1.325 ... Read More

Assume, you have Panel and the average of the first row is, Average of first row is: Column1    0.274124 dtype: float64SolutionTo solve this, we will follow the steps given below −Set data value as dictionary key is ‘Column1’ with value as pd.DataFrame(np.random.randn(5, 3))data = {'Column1' : pd.DataFrame(np.random.randn(5, 3))}Assign data ... Read More

SolutionAssume, you have a dataframe and minimum rank of a particular column,  Id Name    Age    Rank 0 1 Adam    12    1.0 1 2 David   13    3.0 2 3 Michael 14    5.0 3 4 Peter   12    1.0 4 5 William 13   ... Read More

The result for a maximum value of the first column in panel ismaximum value of first column is ; Column1    1.377292SolutionTo solve this, we will follow the below approach −Set data value as dictionary key is ‘Column1’ with value as pd.DataFrame(np.random.randn(5, 3))data = {'Column1' : pd.DataFrame(np.random.randn(5, 3))}Assign data to ... Read More

Assume, you have a dataframe and the shift index by two periods in positive and negative direction is, shift the index by three periods in positive direction                      Id Age 2020-01-01 00:00:00 NaN NaN 2020-01-01 12:00:00 NaN NaN 2020-01-02 00:00:00 1.0 ... Read More

Assume, you have a dataframe and the result for removing first duplicate rows are,     Id Age 0    1 12 3    4 13 4    5 14 5    6 12 6    2 13 7    7 16 8    3 14 9    9 15 ... Read More

Assume, you have a dataframe and the result for calculating covariance from grouped data and corresponding column as, Grouped data covariance is:                   mark1       mark2 subjects maths    mark1    25.0    12.500000          mark2   ... Read More