Exporting to CSV in Data Analysis Python

Introduction

Exporting data to CSV lets you save your data in a simple file. This file can be opened by many programs like Excel or shared easily.

You want to save your cleaned data for later use.

You need to share your data with someone who uses Excel.

You want to create a backup of your analysis results.

You want to move data from Python to another program.

You want to create a report in a simple text format.

Syntax

Data Analysis Python

dataframe.to_csv('filename.csv', index=False)

Replace 'dataframe' with your actual data variable name.

Setting index=False avoids saving row numbers in the file.

Examples

Exports the DataFrame 'df' to a file named 'data.csv' including row numbers.

Data Analysis Python

df.to_csv('data.csv')

Exports 'df' without row numbers, making the file cleaner.

Data Analysis Python

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

Exports 'df' using semicolon as separator instead of comma.

Data Analysis Python

df.to_csv('data.csv', sep=';')

Sample Program

This program creates a small table with names and ages. It saves the table to 'people.csv' without row numbers. Then it reads the file back and prints it to confirm the export worked.

Data Analysis Python

import pandas as pd

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

# Export the data to CSV without row numbers
df.to_csv('people.csv', index=False)

# Read back the file to check
check_df = pd.read_csv('people.csv')
print(check_df)

Important Notes

CSV files are plain text and easy to open with many tools.

Always check if you want to keep row numbers by using index=True or index=False.

You can change the separator with sep if needed for your region or software.

Summary

Exporting to CSV saves your data in a simple, shareable file.

Use to_csv() method on your DataFrame to export.

Control row numbers with the index option.