Why data I/O matters in Pandas

Introduction

Data input and output (I/O) lets you bring data into your program and save results. It helps you work with real-world data and share your findings.

You want to read a spreadsheet with sales data to analyze it.

You need to save your cleaned data to a file for later use.

You want to load a CSV file from the internet to explore it.

You have results from your analysis and want to export them to Excel.

You want to share your processed data with a teammate.

Syntax

Pandas

import pandas as pd

# Read data from a CSV file
df = pd.read_csv('filename.csv')

# Write data to a CSV file
df.to_csv('filename.csv', index=False)

Use pd.read_csv() to load data from CSV files.

Use df.to_csv() to save DataFrame data back to CSV files.

Examples

This reads data from 'data.csv' into a DataFrame called df.

Pandas

import pandas as pd
df = pd.read_csv('data.csv')

This saves the DataFrame df to 'output.csv' without row numbers.

Pandas

df.to_csv('output.csv', index=False)

You can also read Excel files using pd.read_excel().

Pandas

df = pd.read_excel('data.xlsx')

Save your DataFrame to an Excel file with to_excel().

Pandas

df.to_excel('output.xlsx', index=False)

Sample Program

This program creates a small table of names and ages, saves it to a CSV file, then reads it back and prints it. It shows how data I/O works in pandas.

Pandas

import pandas as pd

# Create a simple DataFrame
data = {'Name': ['Anna', 'Ben', 'Cara'], 'Age': [28, 34, 22]}
df = pd.DataFrame(data)

# Save DataFrame to CSV
csv_file = 'people.csv'
df.to_csv(csv_file, index=False)

# Read the CSV back into a new DataFrame
new_df = pd.read_csv(csv_file)

print(new_df)

Important Notes

Always check the file path and name when reading or writing files.

Use index=False when saving to avoid adding extra row numbers.

Data I/O lets you connect your code to real data and share results easily.

Summary

Data I/O means reading data into your program and saving it out.

It helps you work with real data files like CSV and Excel.

pandas has simple functions like read_csv and to_csv for this.