Answers for "pandas dataframe limit rows by col value"

pandas dataframe limit rows by col value

# Reduce the DataFrame to Equal Count of Label Types
min = df.label.value_counts().min()
df = df.groupby('label').head(min).reset_index()

limit entries in dataframe column

DataFrame.clip(lower=None, upper=None, axis=None, inplace=False, *args, **kwargs)

python dataframe limit rows

# Import pandas package 
import pandas as pd 
    
# Define a dictionary containing employee data 
data = {'Name':['Jai', 'Princi', 'Gaurav', 'Anuj'], 
        'Age':[27, 24, 22, 32], 
        'Address':['Delhi', 'Kanpur', 'Allahabad', 'Kannauj'], 
        'Qualification':['Msc', 'MA', 'MCA', 'Phd']} 
    
# Convert the dictionary into DataFrame  
df = pd.DataFrame(data) 
    
# select three rows and two columns 
print(df.loc[1:3, ['Name', 'Qualification']])