-
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
-
How To Convert DataFrame To Pickle File?
How To Convert DataFrame To Pickle File? Table Of Contents: Syntax ‘isna( )’ Method In Pandas. Examples ‘isna( )’ Method. (1) Syntax: DataFrame.to_pickle(path, compression=’infer’, protocol=5, storage_options=None) Description: Convert DataFrame To Pickle File. Parameters: path: str, path object, or file-like object – String, path object (implementing os.PathLike[str]), or file-like object implementing a binary write() function. File path where the pickled object will be stored. compression: str or dict, default ‘infer’ – For on-the-fly compression of the output data. If ‘infer’ and ‘path’ is path-like, then detect compression from the following extensions: ‘.gz’, ‘.bz2’, ‘.zip’, ‘.xz’, ‘.zst’, ‘.tar’, ‘.tar.gz’, ‘.tar.xz’ or ‘.tar.bz2’ (otherwise no compression).
-
How To Convert DataFrame To Parquet Format?
How To Convert DataFrame To Parquet Format? Table Of Contents: Syntax ‘to_parquet( )’ Method In Pandas. Examples ‘to_parquet( )’ Method. (1) Syntax: DataFrame.to_parquet(path=None, engine=’auto’, compression=’snappy’, index=None, partition_cols=None, storage_options=None, **kwargs) Description: Write a DataFrame to the binary parquet format. This function writes the dataframe as a parquet file. You can choose different parquet backends, and have the option of compression. See the user guide for more details. Parameters: path: str, path object, file-like object, or None, default None – String, path object (implementing os.PathLike[str]), or file-like object implementing a binary write() function. If None, the result is returned as bytes. If a string or path, it
