Saving a Pandas Dataframe as a CSV
Pandas is an open source library which is built on top of NumPy library. It allows user for fast analysis, data cleaning & preparation of data efficiently. Pandas is fast and it has high-performance & productivity for users.
Most of the datasets you work with are called DataFrames. DataFrames is a 2-Dimensional labeled Data Structure with index for rows and columns, where each cell is used to store a value of any type. Basically, DataFrames are Dictionary based out of NumPy Arrays.
Let’s see how to save a Pandas DataFrame as a CSV file using to_csv()
method.
Example #1: Save csv to working directory.
# importing pandas as pd import pandas as pd # list of name, degree, score nme = [ "aparna" , "pankaj" , "sudhir" , "Geeku" ] deg = [ "MBA" , "BCA" , "M.Tech" , "MBA" ] scr = [ 90 , 40 , 80 , 98 ] # dictionary of lists dict = { 'name' : nme, 'degree' : deg, 'score' : scr} df = pd.DataFrame( dict ) # saving the dataframe df.to_csv( 'file1.csv' ) |
Output:
Example #2: Saving CSV without headers and index.