Reading CSV files with read_csv in Pandas - Mini Project: Build & Apply

Reading CSV files with read_csv

📖 Scenario: You have a CSV file containing sales data from a small store. You want to load this data into Python to analyze it easily.

🎯 Goal: Learn how to read a CSV file into a pandas DataFrame using the read_csv function.

📋 What You'll Learn

Use pandas library

Read a CSV file named sales_data.csv

Store the data in a variable called sales_df

Print the DataFrame to see the data

💡 Why This Matters

🌍 Real World

Reading CSV files is a common first step in analyzing data from spreadsheets, exports, or logs.

💼 Career

Data scientists and analysts often start their work by loading CSV files into pandas for cleaning and analysis.

1

Import pandas and create the CSV file

Import the pandas library as pd and create a CSV file named sales_data.csv with the following content:
Product,Price,Quantity Apple,0.5,10 Banana,0.3,15 Orange,0.7,7

Pandas

# Import pandas as pd
# Create the CSV file sales_data.csv with the given content
# Your code here

Need a hint?

Use import pandas as pd to import pandas.
Use Python's open function to create and write to the CSV file.

2

Set the CSV file path

Create a variable called csv_file and set it to the string 'sales_data.csv' to store the path of the CSV file.

Pandas

import pandas as pd

csv_content = """Product,Price,Quantity
Apple,0.5,10
Banana,0.3,15
Orange,0.7,7"""

with open('sales_data.csv', 'w') as file:
    file.write(csv_content)

# Create a variable csv_file with the value 'sales_data.csv'
# Your code here

Need a hint?

Just assign the string 'sales_data.csv' to the variable csv_file.

3

Read the CSV file into a DataFrame

Use pd.read_csv with the variable csv_file to read the CSV file and store the result in a variable called sales_df.

Pandas

import pandas as pd

csv_content = """Product,Price,Quantity
Apple,0.5,10
Banana,0.3,15
Orange,0.7,7"""

with open('sales_data.csv', 'w') as file:
    file.write(csv_content)

csv_file = 'sales_data.csv'

# Read the CSV file into sales_df using pd.read_csv
# Your code here

Need a hint?

Use sales_df = pd.read_csv(csv_file) to read the CSV file into a DataFrame.

4

Print the DataFrame

Print the variable sales_df to display the contents of the CSV file as a DataFrame.

Pandas

import pandas as pd

csv_content = """Product,Price,Quantity
Apple,0.5,10
Banana,0.3,15
Orange,0.7,7"""

with open('sales_data.csv', 'w') as file:
    file.write(csv_content)

csv_file = 'sales_data.csv'

sales_df = pd.read_csv(csv_file)

# Print the sales_df DataFrame
# Your code here

Need a hint?

Use print(sales_df) to show the DataFrame.