How To Convert DataFrame To CSV File?
Table Of Contents:
- Syntax ‘to_csv( )’ Method In Pandas.
- Examples ‘to_csv( )’ Method.
(1) Syntax:
DataFrame.to_csv(path_or_buf=None, sep=',', na_rep='', float_format=None, columns=None,
header=True, index=True, index_label=None, mode='w', encoding=None,
compression='infer', quoting=None, quotechar='"', lineterminator=None,
chunksize=None, date_format=None, doublequote=True, escapechar=None,
decimal='.', errors='strict', storage_options=None)Description:
- Write a DataFrame to a CSV file.
(2) Examples Of to_csv() Method:
Example-1:
import pandas as pd
student = {'Name':['Subrat','Abhispa','Arpita','Anuradha','Namita'],
'Roll_No':[100,101,102,103,104],
'Subject':['Math','English','Science','History','Commerce'],
'Mark':[95,88,76,73,93]}
student_object = pd.DataFrame(student)
student_objectOutput:
# Storing DataFrame To A CSV File.
student_object.to_csv("C:/Users/SuSahoo/Blogs/Files/Student_Details.csv")
# Reading The CSV File
read_students = pd.read_csv("C:/Users/SuSahoo/Blogs/Files/Student_Details.csv", index_col=0)
read_students