Contents

Pandas Notes 1

• Data Structures in Pandas
• DataFrame: Accessing Values,Adding and Deletion of Rows and Columns
• Series Basic Functionality
• DataFrame Basic Functionality
• Descriptive Statistics
• pipe(), apply() and applymap()

Pandas Notes 2

• Basic Plotting: plot
• Bar Plot
• Histograms
• Area Plot
• Pie Chart
• Scatter Plot

Pandas Notes 3

• Window Functions and pct_change()
• Check for Missing Data / Null Values
• Filling and dropping missing values
• Replacing Values
• Read and Write Data from Database

Pandas Notes 4

• GroupBy
• Aggregations
• Merge and Concatenation
• Pivot Table and Pivot Table Grouper
• Data Wrangling and melt() function
• Stack
• Crosstab

Pandas Dates

• DatetimeIndex and resample()
• date_range
• to_datetime
• Period and PeriodIndex
• Shifting

Pandas Visualization

• Basic Plotting: plot
• Bar Plot
• Histograms
• Area Plot
• Pie Chart
• Scatter Plot