Scribd
Upload
8 views1 page

Pandas Complete Notes

This document is a comprehensive cheatsheet for the Pandas library, detailing various functions categorized by their purpose. It includes functions for data import/export, inspection, selection, filtering, handling missing data, and more, along with brief descriptions or examples for each. The cheatsheet serves as a quick reference for users to efficiently utilize Pandas for data manipulation and analysis.

Uploaded by

anuj.ghongade.17
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views1 page

Pandas Complete Notes

This document is a comprehensive cheatsheet for the Pandas library, detailing various functions categorized by their purpose. It includes functions for data import/export, inspection, selection, filtering, handling missing data, and more, along with brief descriptions or examples for each. The cheatsheet serves as a quick reference for users to efficiently utilize Pandas for data manipulation and analysis.

Uploaded by

anuj.ghongade.17
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

■ Pandas Complete Cheatsheet

Category Function Description / Example


Import/Export pd.read_csv(), df.to_csv() Read/Write CSV files

Inspection [Link](), [Link](), [Link]() View structure, metadata, and summary stats

Selection [Link][], [Link][], [Link]() Select rows/columns by label, index, or condition

Filtering df[df['age']>30], [Link]() Subset data using conditions

Missing Data [Link](), [Link](), [Link]() Detect, replace, or remove missing values

Duplicates [Link](), df.drop_duplicates() Find and remove duplicate rows

Transform [Link](), [Link](), [Link]() Convert datatypes, replace values, apply functions

Columns/Rows df['new']=df['A']+df['B'], [Link]() Create, insert, or delete columns/rows

Sorting df.sort_values(), [Link]() Sort data or get top/bottom values

Aggregation [Link](), df.pivot_table() Summarize and aggregate data

Merging [Link](), [Link]() Combine datasets (SQL-like joins, stacking)

Statistics [Link](), [Link]() Basic stats & correlations

Strings df['col'].[Link](), [Link]() Clean & manipulate text data

Dates pd.to_datetime(), [Link]() Handle time-series & resampling

Windows [Link](), [Link]() Rolling & exponential moving averages

Categorical [Link]('category') Optimize memory & encode categories

Reshaping [Link](), [Link](), [Link]() Restructure datasets

Visualization [Link](kind='line/bar/hist') Quick EDA visualizations

Advanced [Link], [Link](), [Link]() Styling, expressions, pipelines

You might also like