Pandas_Lab_100_Functions.ipynb

Kernel: Python 3 (ipykernel)

Pandas Lab: Practice from Basic to Advanced

This lab contains 100 Pandas functions categorized into Basic, Intermediate, and Advanced levels. Practice using each command with the examples provided.

import pandas as pd

# Sample DataFrames
df1 = pd.DataFrame({
    'employee_id': [1, 2, 3,4],
    'name': ['Ashi', 'Su', 'Simaran','Akash'],
    'salary': [50000, 60000, 70000,100000]
})

df2 = pd.DataFrame({
    'id': [1, 2, 3,4],
    'department': ['HR', 'Finance', 'IT','HR']
})
df1.head()

Basic Functions (1-30)

pd.read_csv()

# Example usage of pd.read_csv()

df.head()

# Example usage of df.head()

df.tail()

# Example usage of df.tail()

df.info()

# Example usage of df.info()

df.describe()

# Example usage of df.describe()

df.columns

# Example usage of df.columns

df.index

# Example usage of df.index

df.dtypes

# Example usage of df.dtypes

df.shape

# Example usage of df.shape

df.values

# Example usage of df.values

df['col']

# Example usage of df['col']

df[['col1', 'col2']]

# Example usage of df[['col1', 'col2']]

df.iloc[0]

# Example usage of df.iloc[0]

df.loc[0]

# Example usage of df.loc[0]

df.set_index()

# Example usage of df.set_index()

df.reset_index()

# Example usage of df.reset_index()

df.rename()

# Example usage of df.rename()

df.drop()

# Example usage of df.drop()

df.sort_values()

# Example usage of df.sort_values()

df.sort_index()

# Example usage of df.sort_index()

df.isnull()

# Example usage of df.isnull()

df.notnull()

# Example usage of df.notnull()

df.fillna()

# Example usage of df.fillna()

df.dropna()

# Example usage of df.dropna()

df.duplicated()

# Example usage of df.duplicated()

df.drop_duplicates()

# Example usage of df.drop_duplicates()

df.astype()

# Example usage of df.astype()

df.apply()

# Example usage of df.apply()

df.map()

# Example usage of df.map()

df.unique()

# Example usage of df.unique()

Intermediate Functions (31-70)

df.value_counts()

# Example usage of df.value_counts()

pd.concat()

# Example usage of pd.concat()

pd.merge()

# Example usage of pd.merge()

pd.join()

# Example usage of pd.join()

df.groupby()

# Example usage of df.groupby()

df.agg()

# Example usage of df.agg()

df.transform()

# Example usage of df.transform()

df.pivot_table()

# Example usage of df.pivot_table()

df.stack()

# Example usage of df.stack()

df.unstack()

# Example usage of df.unstack()

df.melt()

# Example usage of df.melt()

df.nunique()

# Example usage of df.nunique()

df.sample()

# Example usage of df.sample()

df.query()

# Example usage of df.query()

df.eval()

# Example usage of df.eval()

df.between()

# Example usage of df.between()

df.clip()

# Example usage of df.clip()

df.corr()

# Example usage of df.corr()

df.cov()

# Example usage of df.cov()

df.rank()

# Example usage of df.rank()

df.nlargest()

# Example usage of df.nlargest()

df.nsmallest()

# Example usage of df.nsmallest()

df.idxmax()

# Example usage of df.idxmax()

df.idxmin()

# Example usage of df.idxmin()

df.memory_usage()

# Example usage of df.memory_usage()

df.cumsum()

# Example usage of df.cumsum()

df.cumprod()

# Example usage of df.cumprod()

df.cummax()

# Example usage of df.cummax()

df.cummin()

# Example usage of df.cummin()

df.diff()

# Example usage of df.diff()

df.pct_change()

# Example usage of df.pct_change()

df.rolling()

# Example usage of df.rolling()

df.expanding()

# Example usage of df.expanding()

df.ewm()

# Example usage of df.ewm()

df.plot()

# Example usage of df.plot()

df.hist()

# Example usage of df.hist()

df.boxplot()

# Example usage of df.boxplot()

df.to_csv()

# Example usage of df.to_csv()

Advanced Functions (71-100)

pd.read_json()

# Example usage of pd.read_json()

pd.read_excel()

# Example usage of pd.read_excel()

pd.to_datetime()

# Example usage of pd.to_datetime()

df.resample()

# Example usage of df.resample()

df.interpolate()

# Example usage of df.interpolate()

df.where()

# Example usage of df.where()

df.mask()

# Example usage of df.mask()

df.pipe()

# Example usage of df.pipe()

df.select_dtypes()

# Example usage of df.select_dtypes()

df.equals()

# Example usage of df.equals()

df.explode()

# Example usage of df.explode()

df.insert()

# Example usage of df.insert()

df.pop()

# Example usage of df.pop()

df.swapaxes()

# Example usage of df.swapaxes()

df.swaplevel()

# Example usage of df.swaplevel()

df.reorder_levels()

# Example usage of df.reorder_levels()

df.to_dict()

# Example usage of df.to_dict()

df.from_dict()

# Example usage of df.from_dict()

df.to_records()

# Example usage of df.to_records()

df.to_sql()

# Example usage of df.to_sql()

df.to_parquet()

# Example usage of df.to_parquet()

df.to_feather()

# Example usage of df.to_feather()

df.to_clipboard()

# Example usage of df.to_clipboard()

df.to_markdown()

# Example usage of df.to_markdown()

df.to_html()

# Example usage of df.to_html()

df.to_latex()

# Example usage of df.to_latex()

df.to_string()

# Example usage of df.to_string()

df.style

# Example usage of df.style

df.style.highlight_max()

# Example usage of df.style.highlight_max()