My Fav Pandas 🐼

pandas_cheatsheet.py

# Summary statistics for numeric variables
df.describe().transpose()

# Summary statistics for categorical/string variables
df.describe(include=['O']).transpose()

# Info about column names, datatypes, and null values
df.info()

# Get a sample 
df.sample(10)
df.username.sample(10)

# Frequency counts for categorical variable
df.state.value_counts()

# Count missing values for all columns / a specific column
df.isnull().sum()
df.state.isnull().sum()

# Get value at given quantile
df.upvotes.quantile(0.99)

# Correlation coefficient
df.awards.corr(df.upvotes)