read_csv parameters (sep, header, index_col) in Pandas - Mini Project: Build & Apply

Using read_csv Parameters: sep, header, index_col

📖 Scenario: You have a small sales data file saved as a text string. The data uses semicolons to separate columns, has no header row, and the first column should be used as the row labels.We want to load this data correctly into a pandas DataFrame for analysis.

🎯 Goal: Load the sales data into a pandas DataFrame using read_csv with the correct parameters sep, header, and index_col.

📋 What You'll Learn

Create a multi-line string variable data with the exact sales data

Use pd.read_csv with sep=';', header=None, and index_col=0

Store the result in a variable called df

Print the DataFrame df to see the loaded data

💡 Why This Matters

🌍 Real World

Data often comes in different formats. Knowing how to adjust <code>read_csv</code> parameters helps you load data correctly for analysis.

💼 Career

Data scientists and analysts frequently clean and prepare data. Mastering <code>read_csv</code> options is a key skill for working with real-world datasets.

1

Create the sales data string

Create a variable called data that holds this exact multi-line string including newlines:
Apple;0.5;10
Banana;0.3;20
Cherry;0.2;15

Pandas

# Create the variable data with the exact multi-line string
# Your code here

Need a hint?

Use triple quotes """ to create a multi-line string exactly as shown.

2

Set up the separator and header parameters

Create variables separator and header_row with values ";" and None respectively.

Pandas

data = """Apple;0.5;10
Banana;0.3;20
Cherry;0.2;15"""
# Create separator and header_row variables
# Your code here

Need a hint?

Set separator to the semicolon character and header_row to None.

3

Load the data using read_csv with index_col

Import pandas as pd. Use pd.read_csv with sep=separator, header=header_row, and index_col=0 to read the data string using io.StringIO. Store the result in a variable called df.

Pandas

import pandas as pd
import io

# Read the data string into a DataFrame df using read_csv with sep, header, and index_col
# Your code here

Need a hint?

Use io.StringIO(data) to read the string as a file. Set index_col=0 to use the first column as row labels.

4

Print the DataFrame

Write a print statement to display the DataFrame df.

Pandas

import pandas as pd
import io

data = """Apple;0.5;10
Banana;0.3;20
Cherry;0.2;15"""
separator = ";"
header_row = None

df = pd.read_csv(io.StringIO(data), sep=separator, header=header_row, index_col=0)

# Print the DataFrame df
# Your code here

Need a hint?

Just write print(df) to show the DataFrame.