3.15. Finding Largest and Smallest Dataframe#

import pandas as pd
import numpy as np
df=pd.DataFrame({
'Name':['Sahil Choudhary','Sonia Choudhary','Sourav','Vishal'],
'Age':[10,20,30,40],
'Gender':['M','F','M','M'],
'City':['J','K','L','P'],
'Work':[True,False,False,True]
}
)
df
Name Age Gender City Work
0 Sahil Choudhary 10 M J True
1 Sonia Choudhary 20 F K False
2 Sourav 30 M L False
3 Vishal 40 M P True
df.nlargest(2,'Age')
Name Age Gender City Work
3 Vishal 40 M P True
2 Sourav 30 M L False
df.nsmallest(3,'Age')
Name Age Gender City Work
0 Sahil Choudhary 10 M J True
1 Sonia Choudhary 20 F K False
2 Sourav 30 M L False