You’re the Expert!

data-analysis

Cheatsheets

Load a CSV File and Display Basic Information
import pandas as pd
df = pd.read_csv("data.csv")
print(df.info())
print(df.head())
copy to clipboard
Filter DataFrame Based on Condition
df_filtered = df[df['column_name'] > 50]
print(df_filtered)
copy to clipboard

Perform GroupBy and Aggregation
df_grouped = df.groupby('category_column').agg({'value_column': 'mean'})
print(df_grouped)
copy to clipboard
Merge Two DataFrames Based on a Common Column
df1 = pd.read_csv("data1.csv")
df2 = pd.read_csv("data2.csv")
df_merged = pd.merge(df1, df2, on='common_column', how='inner')
print(df_merged)
copy to clipboard

Apply Custom Function to DataFrame Column
def custom_function(x):
    return x * 2
df['new_column'] = df['existing_column'].apply(custom_function)
print(df.head())
copy to clipboard
Perform Time Series Analysis
df['date_column'] = pd.to_datetime(df['date_column'])
df.set_index('date_column', inplace=True)
df_resampled = df.resample('M').mean()
print(df_resampled)
copy to clipboard