Need help to open excel file and read in Python

Question

Dear team,

I m unable to do read from excel file using Python. I need your help to read and extract data from excel file in Python.

Answer 1

You can use pandas module to do so. You open a command prompt with administrator privileges and then execute this :

pip install pandas

This will download, install and add pandas to your existing python installation.

After that you can execute this code in a python file.

import pandas as pd
table = pd.read_excel('sales.xlsx',
                  sheetname = 'Month 1',
                  header = 0,
                  index_col = 0,
                  parse_cols = "A, C, G",
                  convert_float = True)

print(table)