Write a Python program to perform table-wise pipe function in a dataframe

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.0

Solution

To solve this, we will follow the steps given below −

• Define a dataframe

• Create a user-defined function avg with two arguments and return the result as (a+b/2). It is defined below,

def avg(a,b):
   return (a+b/2)

• Apply pipe() function to perform table-wise function inside first value as avg() and the second argument as 10 to calculate the avg of all the dataframe values.

df.pipe(avg,10)

Example

Let’s check the following code to get a better understanding −

import pandas as pd
df = pd.DataFrame({'Id':[1,2,3,4,5],'Mark':[80,90,70,85,90]})
print("DataFrame is:\n",df)
print("Table wise function:")
def avg(a,b):
   return (a+b/2)
print(df.pipe(avg,10))

Output

DataFrame is:
 Id Mark
0 1  80
1 2  90
2 3  70
3 4  85
4 5  90
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.0