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)