Saving processed Dataset to a CSV File using Pandas
16. Saving the Processed Dataset to a CSV File
Write a Pandas program to save the processed Dataset to a CSV file.
This exercise shows how to save the processed dataset to a CSV file using to_csv().
Sample Solution :
Code :
import pandas as pd
# Load the dataset
df = pd.read_csv('data.csv')
# Perform some data preprocessing (e.g., fill missing values)
df['Age'].fillna(df['Age'].mean(), inplace=True)
# Save the processed dataset to a CSV file
df.to_csv('processed_data.csv', index=False)
# Confirm the dataset is saved
print("Processed dataset saved to 'processed_data.csv'.")
Output:
Processed dataset saved to 'processed_data.csv'.
Explanation:
- Loaded the dataset using Pandas.
- Performed basic data preprocessing (filled missing values).
- Used to_csv() to save the processed dataset to a CSV file.
- Confirmed that the file was saved successfully.
For more Practice: Solve these Related Problems:
- Write a Pandas program to save a processed DataFrame to a CSV file with a custom delimiter and encoding.
- Write a Pandas program to export a DataFrame to CSV, ensuring that the index is not saved.
- Write a Pandas program to save a DataFrame to CSV and then load it back to verify the integrity of the saved data.
- Write a Pandas program to export multiple DataFrames to separate CSV files and document their file names.
Python-Pandas Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.