Blog

Pandas DataFrames can be easily read from and written to CSV files using the read_csv() and to_csv() methods.

Reading a CSV file into a Pandas DataFrame

To read a CSV file into a Pandas DataFrame, you can use the read_csv() method. The read_csv() method takes the path to the CSV file as input and returns a Pandas DataFrame.

Here is an example of how to read a CSV file into a Pandas DataFrame:

import pandas as pd


df = pd.read_csv('data.csv')

print(df)

This will read the CSV file data.csv into a Pandas DataFrame and print the DataFrame to the console.

Writing a Pandas DataFrame to a CSV file

To write a Pandas DataFrame to a CSV file, you can use the to_csv() method. The to_csv() method takes the path to the CSV file as input and writes the Pandas DataFrame to the file.

Here is an example of how to write a Pandas DataFrame to a CSV file:

import pandas as pd

df = pd.DataFrame({'name': ['Alice', 'Bob', 'Carol'], 'age': [25, 30, 35]})

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

This will write the Pandas DataFrame df to the CSV file data.csv without the index.