Re: Unable to read .xlsx file using pandas

2020-12-03 Thread MRAB
On 2020-12-03 12:13, A. M. Thomas [PETech MIET MBA] wrote: Kindly help manage read .xlsx files using pandas, thank you import numpy as np import pandas as pd from pandas import Series, DataFrame excelfile = pd.ExcelFile('C:\Users\THOMAS\Documents/Hash Analytics Internship - DemoS2.xlsx')

Unable to read .xlsx file using pandas

2020-12-03 Thread A. M. Thomas [PETech MIET MBA]
Kindly help manage read .xlsx files using pandas, thank you import numpy as np import pandas as pd from pandas import Series, DataFrame excelfile = pd.ExcelFile('C:\Users\THOMAS\Documents/Hash Analytics Internship - DemoS2.xlsx') dframe = excelfile.parse('Sheet10') print (dframe)