The Ultimate Pandas Cheat Sheet: Master Data Analysis in Python

If you're working with data in Python, Pandas is your go-to library for fast, efficient data analysis. Whether you're handling large datasets, filtering, grouping, or transforming data, Pandas makes everything easier.

But let’s be real—remembering all Pandas functions is tough! That’s why we created this Ultimate Pandas Cheat Sheet, packed with the most important functions, commands, and real-world examples to help you work smarter, not harder.

📥 Download the Free Pandas Cheat Sheet

Key Takeaways

✅ Essential Pandas functions for data handling & manipulation
✅ Quick reference for DataFrame operations, filtering, sorting, and merging
✅ Hidden Pandas tricks for faster data processing
✅ FREE downloadable Pandas cheat sheet PDF for easy access!

🚀 3 Mind-Blowing Pandas Tricks You Didn't Know

💡 Trick #1: Replace Nested If Statements with One-Liner Pandas Magic
❌ Old Way (Too Much Code)

{% module_block module "widget_7e983a9a-cafc-4498-b704-1352243dd05d" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"df['Status'] = df['Age'].apply(lambda x: 'Teen' if x < 18 else ('Adult' if x < 60 else 'Senior'))"{% endraw %}{% end_module_attribute %}{% module_attribute "css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "definition_id" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "field_types" is_json="true" %}{% raw %}{"code_text":"richtext","title":"text"}{% endraw %}{% end_module_attribute %}{% module_attribute "label" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "module_id" is_json="true" %}{% raw %}187904137287{% endraw %}{% end_module_attribute %}{% module_attribute "path" is_json="true" %}{% raw %}"/OdinSchool_V3/modules/code block"{% endraw %}{% end_module_attribute %}{% module_attribute "schema_version" is_json="true" %}{% raw %}2{% endraw %}{% end_module_attribute %}{% module_attribute "smart_objects" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "smart_type" is_json="true" %}{% raw %}"NOT_SMART"{% endraw %}{% end_module_attribute %}{% module_attribute "tag" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "title" is_json="true" %}{% raw %}"Python code"{% endraw %}{% end_module_attribute %}{% module_attribute "type" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "wrap_field_tag" is_json="true" %}{% raw %}"div"{% endraw %}{% end_module_attribute %}{% end_module_block %}

✅ New Way (Cleaner & Faster)

{% module_block module "widget_101ef6a5-0ae0-4368-9646-f4664926ea32" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"df['Status'] = pd.cut(df['Age'], bins=[0, 17, 59, 100], labels=['Teen', 'Adult', 'Senior'])"{% endraw %}{% end_module_attribute %}{% module_attribute "css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "definition_id" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "field_types" is_json="true" %}{% raw %}{"code_text":"richtext","title":"text"}{% endraw %}{% end_module_attribute %}{% module_attribute "label" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "module_id" is_json="true" %}{% raw %}187904137287{% endraw %}{% end_module_attribute %}{% module_attribute "path" is_json="true" %}{% raw %}"/OdinSchool_V3/modules/code block"{% endraw %}{% end_module_attribute %}{% module_attribute "schema_version" is_json="true" %}{% raw %}2{% endraw %}{% end_module_attribute %}{% module_attribute "smart_objects" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "smart_type" is_json="true" %}{% raw %}"NOT_SMART"{% endraw %}{% end_module_attribute %}{% module_attribute "tag" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "title" is_json="true" %}{% raw %}"Python code"{% endraw %}{% end_module_attribute %}{% module_attribute "type" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "wrap_field_tag" is_json="true" %}{% raw %}"div"{% endraw %}{% end_module_attribute %}{% end_module_block %}

💡 Trick #2: Filter Data Like a Pro (No More Confusing Conditions)
❌ Messy Code with Multiple Conditions

{% module_block module "widget_54faf818-02bb-4927-b687-ee30177db380" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"df[(df['Age'] > 30) & (df['City'] == 'New York') & (df['Salary'] > 50000)]"{% endraw %}{% end_module_attribute %}{% module_attribute "css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "definition_id" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "field_types" is_json="true" %}{% raw %}{"code_text":"richtext","title":"text"}{% endraw %}{% end_module_attribute %}{% module_attribute "label" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "module_id" is_json="true" %}{% raw %}187904137287{% endraw %}{% end_module_attribute %}{% module_attribute "path" is_json="true" %}{% raw %}"/OdinSchool_V3/modules/code block"{% endraw %}{% end_module_attribute %}{% module_attribute "schema_version" is_json="true" %}{% raw %}2{% endraw %}{% end_module_attribute %}{% module_attribute "smart_objects" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "smart_type" is_json="true" %}{% raw %}"NOT_SMART"{% endraw %}{% end_module_attribute %}{% module_attribute "tag" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "title" is_json="true" %}{% raw %}"Python code"{% endraw %}{% end_module_attribute %}{% module_attribute "type" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "wrap_field_tag" is_json="true" %}{% raw %}"div"{% endraw %}{% end_module_attribute %}{% end_module_block %}

✅ New Way with .query() (Super Clean!)

{% module_block module "widget_d160788d-bca0-4c1a-8044-cb250f33b869" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"df.query(\"Age > 30 & City == 'New York' & Salary > 50000\")"{% endraw %}{% end_module_attribute %}{% module_attribute "css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "definition_id" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "field_types" is_json="true" %}{% raw %}{"code_text":"richtext","title":"text"}{% endraw %}{% end_module_attribute %}{% module_attribute "label" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "module_id" is_json="true" %}{% raw %}187904137287{% endraw %}{% end_module_attribute %}{% module_attribute "path" is_json="true" %}{% raw %}"/OdinSchool_V3/modules/code block"{% endraw %}{% end_module_attribute %}{% module_attribute "schema_version" is_json="true" %}{% raw %}2{% endraw %}{% end_module_attribute %}{% module_attribute "smart_objects" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "smart_type" is_json="true" %}{% raw %}"NOT_SMART"{% endraw %}{% end_module_attribute %}{% module_attribute "tag" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "title" is_json="true" %}{% raw %}"Python code"{% endraw %}{% end_module_attribute %}{% module_attribute "type" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "wrap_field_tag" is_json="true" %}{% raw %}"div"{% endraw %}{% end_module_attribute %}{% end_module_block %}

💡 Trick #3: The Fastest Way to Remove Missing Data (Without Loops!)
❌ Slow Way (Looping Through Rows 😩)

{% module_block module "widget_63ce013d-4192-4405-bfe2-e087efd7f3de" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

for index, row in df.iterrows():
if pd.isna(row['Salary']):
df.drop(index, inplace=True)

"{% endraw %}{% end_module_attribute %}{% module_attribute "css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "definition_id" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "field_types" is_json="true" %}{% raw %}{"code_text":"richtext","title":"text"}{% endraw %}{% end_module_attribute %}{% module_attribute "label" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "module_id" is_json="true" %}{% raw %}187904137287{% endraw %}{% end_module_attribute %}{% module_attribute "path" is_json="true" %}{% raw %}"/OdinSchool_V3/modules/code block"{% endraw %}{% end_module_attribute %}{% module_attribute "schema_version" is_json="true" %}{% raw %}2{% endraw %}{% end_module_attribute %}{% module_attribute "smart_objects" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "smart_type" is_json="true" %}{% raw %}"NOT_SMART"{% endraw %}{% end_module_attribute %}{% module_attribute "tag" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "title" is_json="true" %}{% raw %}"Python code"{% endraw %}{% end_module_attribute %}{% module_attribute "type" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "wrap_field_tag" is_json="true" %}{% raw %}"div"{% endraw %}{% end_module_attribute %}{% end_module_block %}

✅ New Way (One Line & 100x Faster)

{% module_block module "widget_0d242a8b-3e0d-4519-8917-fa04508aaa37" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

df.dropna(subset=['Salary'], inplace=True)

📊 Pandas Cheat Sheet: Every Essential Command (At a Glance!)

1️⃣ Load & Save Data (Goodbye Excel Crashes!)

{% module_block module "widget_7ec0f796-0d04-463c-93ab-14218ef644c5" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

df = pd.read_csv(\"data.csv\") # Load CSV
df.to_csv(\"output.csv\", index=False) # Save as CSV
df.to_excel(\"output.xlsx\", index=False) # Save as Excel

📌 Pro Tip: Need to load a huge file? Read it in chunks:

{% module_block module "widget_b417d377-db12-4287-94be-8fede53d1904" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

for chunk in pd.read_csv('big_data.csv', chunksize=5000):
process(chunk)

💡 Your laptop battery will thank you.

2️⃣ Selecting & Filtering Data (Google Search, But for Your Data)

📌 Pro Tip: Need to filter by multiple conditions?

{% module_block module "widget_05e40114-5781-4402-98de-e2d2b673de61" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

df['Name'] # Select column
df[df['Age'] > 25] # Filter rows
df.query(\"City == 'London'\") # Clean filtering

🎯 No more confusing brackets and ampersands!

{% module_block module "widget_d87306e2-0731-4d97-994d-d708a86b6730" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

df.query(\"Age > 25 & City == 'London'\")

3️⃣ Sorting & Ranking (For the Overachievers!)

{% module_block module "widget_52403d0a-9249-4913-8825-97649a2f478f" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

df.sort_values(by='Salary', ascending=False) # Sort salaries (Highest to Lowest)
df['Rank'] = df['Sales'].rank(method='dense') # Rank sales without gaps

💡 Use .rank() to find top performers in your data. Your boss will love it!

4️⃣ The ULTIMATE Merge Trick (VLOOKUP, But Better!)

{% module_block module "widget_8cc1a57c-8bf7-4726-a4e8-dffce2fe1201" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

df_final = pd.merge(df1, df2, on='Customer_ID', how='left')

📌 Alternative: Use .join() for faster merging:

{% module_block module "widget_ba3d46e0-b05e-4ddf-bd31-637c6cb7c733" %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "code_text" is_json="true" %}{% raw %}"

df1.join(df2.set_index('Customer_ID'), on='Customer_ID', how='left')

🔥 No more broken formulas!

Download the Pandas Cheat Sheet PDF!

Want to have this cheat sheet as a handy PDF? 📥
👉 Click here to download the Pandas Cheat Sheet PDF and keep it for quick reference.

{% module_block module "widget_b1726c0b-21c2-4451-9efd-64959e1956a7" %}{% module_attribute "alignments" is_json="true" %}{% raw %}"justify-content-md-start justify-content-center"{% endraw %}{% end_module_attribute %}{% module_attribute "button_2_text" is_json="true" %}{% raw %}"Download Cheat Sheet"{% endraw %}{% end_module_attribute %}{% module_attribute "child_css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "css" is_json="true" %}{% raw %}{}{% endraw %}{% end_module_attribute %}{% module_attribute "definition_id" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "display_button" is_json="true" %}{% raw %}"secondary"{% endraw %}{% end_module_attribute %}{% module_attribute "field_types" is_json="true" %}{% raw %}{"alignments":"choice","button_1_text":"text","button_2_text":"text","display_button":"choice","style":"group"}{% endraw %}{% end_module_attribute %}{% module_attribute "label" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "module_id" is_json="true" %}{% raw %}185831117368{% endraw %}{% end_module_attribute %}{% module_attribute "path" is_json="true" %}{% raw %}"/OdinSchool_V3/modules/College Courses/CTA 2 CP"{% endraw %}{% end_module_attribute %}{% module_attribute "schema_version" is_json="true" %}{% raw %}2{% endraw %}{% end_module_attribute %}{% module_attribute "smart_objects" is_json="true" %}{% raw %}null{% endraw %}{% end_module_attribute %}{% module_attribute "smart_type" is_json="true" %}{% raw %}"NOT_SMART"{% endraw %}{% end_module_attribute %}{% module_attribute "tag" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "type" is_json="true" %}{% raw %}"module"{% endraw %}{% end_module_attribute %}{% module_attribute "wrap_field_tag" is_json="true" %}{% raw %}"div"{% endraw %}{% end_module_attribute %}{% end_module_bl