Working with CSV in Python Part 1 - Initial Setup

In this video, we cover the setup of a nice case for dealing with CSV data files. The case is set up as follows:

A teacher who runs a training program using courses on a third-party platform is interested in obtaining some custom reporting on the learning progress of his learners. However, the learning platform only provides very basic reporting.

For example, at any time you can see the percentage that each learner has gone into the course. So, if you want to see a week-by-week progression, you will have to download the CSV progress report on a weekly basis and find a way to keep track of each learner. This is the basic motivation for the problems we will tackle in this series. However, a couple of other problems show up once we download the report, which is in CSV. In the videos that follow, we will tackle several problems including:

• Normalizing the names column, i.e, replace the emails with actual names
• Filtering out names of people not enrolled in the course
• Creating a single master sheet to keep track of all learners (i.e., join multiple CSV files into a single file), etc.
• Stay tuned for more…

Source Code
Visit the following GitHub repository to follow along with the code used in this tutorial
https://github.com/quizem/data-skills-for-everyone/tree/main/Working%20with%20CSV%20in%20Python