Tag: How To Convert DataFrame To CSV File?


  • How To Convert DataFrame To CSV File?

    How To Convert DataFrame To CSV File?

    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_object Output: # 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

    Read More