Monday, October 30, 2017

Reading csv and excel files in pandas dataframe

Dataframe can be used to load the data from various files. Let's look into how we can load the data from excel and csv.


Make sure the data file that you are loading is present in the given location. In my case, I will be assuming that the data file is present at the same location where python code is.

Code to load different files


import pandas as pd

#install xlrd module to support excel.
#In python 3 use: pip3 install xlrd
#read the excel file by giving name and sheet
excel_df = pd.read_excel('titanic.xls',sheetname=0)
print(excel_df.head())

#Writing the csv file out
#By default index also goes in csv. It can be ignored
#sep is optional. By default it's comma
excel_df.to_csv('titanic.csv',index=False,sep=',')

#Reading the csv file is similar
#Let's read the same csv file that we generated
csv_df = pd.read_csv('titanic.csv')
print(csv_df.head())

No comments:

Post a Comment