pandas Essential Training

Introduction

• Welcome
• What you should know
• Exercise files

1. Technical Setup

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

2. Series and DataFrames

• DataFrames
• Series
• Challenge
• Solution

3. Data Input and Validation

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

4. Basic Analysis

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

5. Basic Plotting

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

6. Indexing

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

7. Groupby

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

8. Reshaping

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

9. Data Visualizations

• Learning heatmaps
• Creating your own colormaps

10. Challenge

• Final challenge
• Final solution

Conclusion

• Next steps