Parsing CSV Files and Converting Strings to Integers in C++

Welcome to the lesson on Parsing CSV Files and Converting Strings to Integers in C++. In this lesson, we will explore working with CSV files — one of the most common formats used for data storage and interchange. By the end of this lesson, you will learn how to read data from CSV files, identify rows and columns separated by commas, and convert string data into integers for further manipulation. This lesson builds on your existing knowledge of file parsing in C++ and introduces new techniques to enhance your data-handling capabilities.

CSV stands for Comma-Separated Values and is a format that stores tabular data in plain text. Each line represents a data row, and columns are separated by commas, allowing easy storage and interpretation.

Imagine you have a CSV file named data.csv:

Name,Age,Occupation
John,28,Engineer
Alice,34,Doctor
Bob,23,Artist

In this file:

• The first line contains the headers: Name, Age, and Occupation.
• Each subsequent line contains data for an individual, with values separated by commas.

Understanding the structure of CSV files is crucial as it guides us on how to parse the data effectively in our programming environment.

To effectively manage the data lines from a CSV file, we'll define a data structure to hold each row's information. In C++, we use a struct to represent a row of data.

// Define a struct to hold a row of data
struct Person {
    std::string name;
    int age;
    std::string occupation;
};

Here, the Person struct includes three fields: name, age, and occupation, representing each column in our CSV file. We'll also use a vector to store multiple Person structs, allowing us to manage the parsed data easily.

Let's start reading and parsing the CSV file using the <fstream> library to handle file input.

#include <iostream>
#include <fstream>
#include <sstream>
#include <vector>
#include <string>

// From previous section
struct Person {
    std::string name;
    int age;
    std::string occupation;
};

int main() {
    std::ifstream file("data.csv"); // Open the CSV file
    std::string line;
    std::vector<Person> data; // Vector to store Person structs

    // Skip the header line
    std::getline(file, line);

• We use std::ifstream to open and manage file input.
• We skip the first line, Name,Age,Occupation, as it's a header and not actual data.

In parsing each line of the CSV file, std::getline is employed with three parameters to extract individual data fields. Here's how it works:

1. First Parameter (Source Stream): This is the input stream from which std::getline reads. In our case, we can use std::istringstream (iss), which is initialized with a line from the CSV file. This stream represents a single row of data from the CSV.

2. Second Parameter (Destination): A string variable into which the extracted data will be stored.

3. Third Parameter (Delimiter): The delimiter character, specified here as a comma ','. This tells std::getline where to stop reading in the stream. It segments the line based on this delimiter, effectively breaking the line into separate data fields. If the delimiter is not specified, it defaults to '\n'.

It's important to note that std::getline always reads data as a string.

With these parameters, std::getline can be used to read fields separated by the specified delimiter, making it ideal for parsing CSV lines. Here's how we use it in our code:

while (std::getline(file, line)) {
    std::istringstream iss(line); // Create a string stream from the line
    std::string word; // Temporary string to hold extracted data
    Person person; // Struct to hold parsed details

    // Read name
    std::getline(iss, person.name, ',');

    // Read age
    std::getline(iss, word, ',');
    person.age = std::stoi(word);

    // Read occupation
    std::getline(iss, person.occupation, ',');

    // Add the person struct to the vector
    data.push_back(person);
}

In this code snippet:

• std::getline(iss, person.name, ','): Extracts the name field by reading from iss until the first comma is encountered, storing the result in person.name.

• std::getline(iss, word, ','): Retrieves the age as a string, again reading up to the next comma, and then converting it to an integer with std::stoi(word).

• std::getline(iss, person.occupation, ','): Captures the remaining part of the line as occupation, since there are no additional commas following this field.

Through the use of std::getline with a specified delimiter, this method efficiently separates a CSV line into distinct fields, allowing us to process and store each piece of data within the Person struct.

When parsing the Age value, it comes in as a string from the file. We convert this string to an integer using the std::stoi function. Let's discuss it separately:

    std::getline(iss, word, ',');
    person.age = std::stoi(word);

• std::stoi stands for "string to integer," and it converts the string-based age directly to an integer.
• This conversion allows us to handle numerical computations on age later if necessary.

In this lesson, we covered how to parse CSV files in C++, focusing on reading data with commas as delimiters and converting string data to integers. You've learned how to define data structures for holding parsed data and how to use file streams and string streams to handle and manage CSV content effectively.

It's a significant accomplishment to reach this stage, and I commend your determination and effort in completing the course. You are now equipped with valuable skills in file data handling and representation, which you can apply in various real-world scenarios.

As you move on to practice exercises, remember to verify the correctness of your parsed data and reflect on potential applications of what you've learned. Keep up the excellent work and continue exploring more advanced data-handling techniques in C++.