Parsing & Analyzing CSV Data — I can parse a small CSV-like dataset from a file and compute summary statistics at my level.

Long before spreadsheets or databases existed, people needed a simple, universal way to store and share tabular data between different computer systems. The solution was remarkably straightforward: store each row of data on its own line, and separate each column value with a comma. This format became known as CSV, which stands for Comma-Separated Values. Despite its simplicity, CSV has endured for decades and remains one of the most widely used data exchange formats today. Almost every application that deals with data — from Google Sheets to scientific instruments — can export and import CSV files.

The fundamental question this lesson addresses is: How do you take raw data stored in a CSV file and transform it into useful information? Whether you are analyzing student grades, sports statistics, or weather data, the ability to read a CSV file, organize its contents, and compute summary statistics like averages, totals, and extremes is one of the most practical programming skills you can learn.

Before writing any code, you need to understand the key building blocks involved in parsing and analyzing CSV data. Parsing means reading raw text and breaking it into structured pieces your program can work with — think of it like slicing a sentence into individual words. When you combine parsing with computation, you can extract summary statistics, which are single numbers that describe an entire dataset, such as the average, minimum, or maximum.

The diagram above illustrates the three major stages in working with CSV data. On the far left, you see the raw text file — it looks like plain text with commas separating the values. In the center, after parsing, the data has been organized into a list of lists, which is Python's way of representing a table in memory. Each inner list corresponds to one row, and each element in that inner list corresponds to one cell. Finally, on the right, the analysis stage produces summary statistics — single values that describe the entire score column. Notice that at the parsing stage, the values are still strings (wrapped in quotes). You must convert numeric columns to integers or floats before computing any statistics.

The Python code for parsing a CSV file follows a consistent pattern. First, you open the file. Then you read it line by line (or use the csv module to handle splitting). Next, you skip or store the header row. Finally, you loop through the data rows, convert values as needed, and compute your statistics. Here is the core pattern expressed as formulas and pseudocode.

Let's examine two approaches to parsing a CSV file: the manual .split(',') approach and the more robust csv.reader approach. The diagram below compares them side by side, showing where each approach handles (or fails to handle) edge cases.

Looking at the code side by side, notice how similar the two approaches are. The manual method uses line.strip().split(',') to break each line apart, while the csv.reader does this automatically. The key difference is robustness: if a name like "Smith, Jr." appears in the data, the manual split would incorrectly create an extra column, but csv.reader understands that commas inside quotes are part of the value, not separators. For homework assignments and AP-level projects, always prefer the csv module.

Suppose you have a file called grades.csv with the following contents. Your task is to read the file, extract the scores, and compute the mean, minimum, and maximum scores.

There are several ways to parse CSV files in Python. Each approach has tradeoffs between simplicity, robustness, and power. The table below compares three common methods you might encounter.

The skills you learn in this lesson — opening files, parsing structured text, and computing summary statistics — are the foundation for everything in data science. As you advance, you will encounter more powerful tools, but they all build on the same concepts. The table below shows how what you learn now connects to what comes next.

The pandas library, which you may explore in a future course or on your own, essentially automates everything you are learning by hand today. Understanding the manual process first is important because it teaches you what is actually happening "under the hood." When something goes wrong with a pandas program — and things do go wrong — knowing how CSV parsing works at a fundamental level gives you the debugging skills to fix it.

Work through these five problems, which increase in difficulty. For each one, think about the code you would write and the result you would expect before checking the answer.