Reading Excel File in Python

Sample Excel Sheet



import pandas as pd
f = pd.ExcelFile("customers.xlsx")
dfs = {sheet_name: f.parse(sheet_name)
          for sheet_name in f.sheet_names}
s=dfs["Sheet1"]

#print(s)

#print column names only
for r in s:
    print(r,end=" ")
print()

#print the column data
for i in range(len(s)):
    for r in s:
        print(s.at[i,r],end=' ')
    print()
i=0   

Output



Comments

Post a Comment

Popular posts from this blog

Converting Excel File to JSON File using xlrd module

from xlrd import open_workbook import json import os os.chdir("d:/2018/mayank") book = open_workbook('demo.xlsx') sheet = book.sheet_by_index(0) # read header values into the list keys = [sheet.cell(0, col_index).value for col_index in range(sheet.ncols)] print ("keys are", keys) dict_list = [] for row_index in range(1, sheet.nrows):     d = {keys[col_index]: sheet.cell(row_index, col_index).value          for col_index in range(sheet.ncols)}     dict_list.append(d) j = json.dumps(dict_list) with open('data.json', 'w') as f:     f.write(j)
Read more

Using Oracle with Python

Install the module     pip install cx_Oracle Import the module     import cx_Oracle Establish the connection     cn = cx_Oracle.connect('userid/password@servername') #rest commands are same as MySQL
Read more

Using time module

The time module provides the current date and time using time() function The time.time() returns the number of second elapsed from 1/1/1970 12:00 am till current date and time called as ticks >>> import time >>> time.time() 1522211915.914467 We can also convert these ticks into actual date and time using function time.localtime() >>> time.localtime(time.time()) time.struct_time(tm_year=2018, tm_mon=3, tm_mday=28, tm_hour=10, tm_min=10, tm_sec=0, tm_wday=2, tm_yday=87, tm_isdst=0) It returns a structure having different fields for date and time which we can convert into date or time format >>> t=time.localtime(time.time()) >>> currentdate='%02d-%02d-%d' % (t.tm_mday,t.tm_mon,t.tm_year) >>> currentdate '28-03-2018' >>> currenttime='%02d-%02d-%02d' % (t.tm_hour,t.tm_min,t.tm_sec) >>> currenttime '10-12-05' We can also use this structure inside the functions and ...
Read more