Write data on CSV format using pandas from DataFrame?

 Write data on CSV format using pandas from DataFrame?

If we want to convert application data into CSV format under data science then we can use to_csv().

Syntax  

df = pd.DataFrame(dict)

  

# saving the dataframe

df.to_csv('filename.csv')   

Now I am creating dictionary objects to store student records that will be saved into CSV file using data frames.

import pandas as pd

stu = {'rno':[1001,1002,1003],'sname':['stu1','stu2','stu3']}

df=pd.DataFrame(stu)

df.to_csv('stu.csv')

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

If we want to write a CSV file without an index or Without a Column Header then we can use the following property.

df = pd.DataFrame(dict)

# saving the dataframe

df.to_csv('file2.csv', header=False, index=False)

Example without header and indexing?

import pandas as pd

stu = {'rno':[1001,1002,1003],'sname':['stu1','stu2','stu3']}

df=pd.DataFrame(stu)

df.to_csv('stu.csv',header=False,index=False)

How to read excel files in pandas?

pip install openpyxl.

import pandas as pd

  

# Import the excel file and call it xls_file

excel_file = pd.ExcelFile('Test.xlsx')

  # View the excel_file's sheet names

print(excel_file.sheet_names)

  # Load the excel_file's Sheet1 as a dataframe

df = excel_file.parse('Sheet1')

print(df)