Python Pandas study group

As a group, we'll be going through a free online tutorial covering the 🐼 Pandas library for 🐍 Python.

• Pandas Tutorial (Data Analysis in Python)

I'll be adding excercises and sample data here for us to work with, and we'll aim to follow the schedule below.

If you want an introduction to Python as a programming language before diving into Pandas, I recommend DigitalGov's Introduction to Python.

April 15–19

• Python Pandas Tutorial 1. What is Pandas python? Introduction and Installation

• Python Pandas Tutorial 2: Dataframe Basics

• Python Pandas Tutorial 3: Different Ways of Creating a Dataframe

April 18: discussion

April 23–26

• Python Pandas Tutorial 4: Read Write Excel CSV File

• Python Pandas Tutorial 5: Handle Missing Data: fillna, dropna, interpolate

• Python Pandas Tutorial 6. Handle Missing Data: replace function

April 25: discussion

April 29–May 3

• Python Pandas Tutorial 7. Group By (Split Apply Combine)

• Python Pandas Tutorial 8. Concat Dataframes

• Python Pandas Tutorial 9. Merge Dataframes

May 2: discussion

May 6–10

• Python Pandas Tutorial 10. Pivot Table

• Python Pandas Tutorial 11. Reshape dataframe using melt

• Python Pandas Tutorial 12. Stack Unstack

• Python Pandas Tutorial 13. Crosstab

May 9: discussion

May 13–17

• Pandas Time Series Analysis Part 1: DatetimeIndex and Resample

• Pandas Time Series Analysis Part 2: date_range

May 16: discussion

May 20–24

• Pandas Time Series Analysis 3: Holidays

• Pandas Time Series Analysis 4: to_datetime

May 23: discussion

May 27–31

Week off from tutorials

June 3–7

• Pandas Time Series Analysis 5: Period and PeriodIndex

• Pandas Time Series Analysis 6: Timezone Handling

• Pandas Time Series Analysis 6 [sic]: Shifting and Lagging

June 6: discussion

June 10–14

• Pandas Tutorial 14: Read Write Data From Database (read_sql, to_sql)

June 13: discussion