Python Pandas - Cheat Sheet

pip install pandas

import pandas as pd

df = pd.read_csv('data.csv')

df = pd.read_excel('data.xlsx', sheet_name='Sheet1')

df = pd.read_html('data.html')[0]

import sqlite3
con = sqlite3.connect("database.db")
df = pd.read_sql_table("table_name", con)

df = pd.DataFrame({'Animal': ['Dog', 'Cat', 'Bird'], 'Age': [3, 4, 5]})

df = pd.DataFrame([['Dog', 3], ['Cat', 4], ['Bird', 5]], columns=['Animal', 'Age'])

df.columns

df.values

df['Animal']

df[['Animal', 'Age']]

df[df['Animal'] == 'Dog']

df[(df['Animal'] == 'Dog') & (df['Age'] > 3)]

df['Animal'].replace('Bird', 'Parrot')

df.rename(columns={'Animal': 'Species'}, inplace=True)

df.sort_values(by='Age')

df.drop(index=0)

df.drop(columns='Age')

df.drop_duplicates()

df1 = pd.DataFrame({'Animal': ['Dog', 'Cat', 'Bird'], 'Age': [3, 4, 5]})
df2 = pd.DataFrame({'Animal': ['Dog', 'Cat', 'Fish'], 'Age': [3, 4, 5]})
df3 = pd.concat([df1, df2])