Lesson overview

In this lesson we will learn basics in reading and writing data from/to a file, and do some basic data manipulation and analysis using a Python module called Pandas. Pandas is a modern and feature rich data analysis framework for Python that is designed to make data analysis and manipulation straightforward and powerful using easy-to-use data structures and operations.

0. Summary of early course feedback
1. What is Pandas?
2. Exploring data using Pandas
   • Reading a file with Pandas
   • Exploring our dataset
3. Processing data with Pandas
   • Calculating with DataFrames
   • Selecting data using indices
   • Filtering and updating data
   • Dealing with missing data
   • Sorting data
   • Rounding and finding unique values
   • Writing data
4. Exercise 5
5. Hints for Exercise 5

Learning goals

• Read data from a .csv text file into Python using Pandas
• Do simple data analysis using Pandas data structures and related functions
• Write data from Pandas to a .csv text file