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 |