Skip to main content

Reading and Exporting CSV Files Using Pandas

In this tutorial, we will learn how to read and export CSV files using the Pandas library in Python. CSV (Comma Separated Values) files are a common way of storing tabular data, and Pandas provides powerful tools for handling such data efficiently.

1. Introduction​

Up until now, we've generated our own data for analysis. However, creating large datasets manually is not practical. In real-world scenarios, we often utilize external datasets. A popular platform for accessing datasets is Kaggle.com. In this tutorial, we'll explore how to read CSV files and export them using Pandas.

2. Obtaining External Datasets​

Before we begin, ensure you have a CSV dataset to work with. For demonstration purposes, we'll use a dataset containing information about the top 100 richest people in the world. You can download this dataset from the resources section of this tutorial or directly from Kaggle.com.

3. Setting Up the Environment​

First, make sure you have Pandas installed. If not, you can install it via pip:

pip install pandas

Now, let's import Pandas and read the CSV file:

import pandas as pd

# Reading the CSV file
richest = pd.read_csv('richest_people.csv')

Replace 'richest_people.csv' with the path to your CSV file if it's located elsewhere.

4. Exploring the Data​

Let's start by exploring the dataset:

# Displaying the first few rows of the dataset
print(richest.head())

This will print the first few rows of the dataset, giving you an overview of its structure and contents.

5. Converting DataFrame to Series​

If you want to work with a single column as a Series instead of a DataFrame, you can use the squeeze() method:

# Converting DataFrame to Series
richest_series = richest.squeeze()

Now, richest_series contains the data as a Series.

6. Exporting Data to CSV​

To export the data to a CSV file, you can use the to_csv() method:

# Exporting the DataFrame to a CSV file
richest.to_csv('richest_export.csv', index=False)

The index=False argument ensures that the index is not included in the exported CSV file.

7. Assignment​

Objective​

The objective of this assignment is to familiarize students with reading and exporting CSV files using the Pandas library in Python.

Instructions​

  1. Dataset Acquisition:

    • Download the dataset containing information about the top 100 richest people in the world from the provided resources section or from Kaggle.com.

  2. Environment Setup:

    • Install the necessary libraries, especially Pandas, if not already installed.
    • Import the Pandas library in your Python environment.

  3. Reading CSV File:

    • Read the downloaded CSV file using Pandas and store it in a DataFrame.
    • Display the first few rows of the DataFrame to understand its structure and contents.

  4. Converting to Series:

    • Convert a specific column of the DataFrame into a Series.
    • Print out the Series to verify the conversion.

  5. Exporting Data:

    • Export the DataFrame to a new CSV file with a different name.
    • Ensure that the exported CSV file does not include the index column.

  6. Documentation:

    • Write detailed comments explaining each step of your code.
    • Provide explanations for any code optimizations or modifications you make.