pandas Essential Training

Introduction

• Welcome
• What you should know
• Exercise files

• Installing Anaconda
• Downloading the data set
• Using the Jupyter notebook
• Using Pandas

• DataFrames
• Series
• Challenge
• Solution

• Using read_csv()
• Using shape
• Using head() and tail()
• Using info()

• Using value_counts()
• Using sort_values()
• Boolean indexing
• String handling
• Challenge
• Solution

• Basic plotting
• Plot types
• Colors
• Figsize
• Colormaps
• Seaborn basic plotting
• Challenge
• Solution

• Index
• Using set_index()
• Using reset_index()
• Using sort_index()
• Using loc[]
• Using iloc[]
• Challenge
• Solution

• Groupby
• Iterate through a group
• Groupby computations
• Challenge
• Solution

• Reshaping
• Using stack()
• Using unstack()
• Challenge
• Solution

• Learning heatmaps
• Creating your own colormaps

• Final challenge
• Final solution

• Next steps