pandas read_excel doesn't return data

Question

I would like to know why the code below works fine when executed from Python interpreter but it returns no value when I "pack" it into the file.

import os
import pandas as pd
getFile = (input('\nEnter Excel file name: ')).lower()
getTab = (input('\nEnter tab name: ')).lower()
fileName = os.path.join(os.getcwd() + '\\' + getFile)
pd.read_excel(fileName, sheet_name=getTab, header=None)

Is there any reason I can't run this code from someFile.py? What I do wrong? Many thanks for your kind help. Please, be forgiving, I'm not a professional or skilful coder.

moys · Accepted Answer · 2019-08-09 03:21:22Z

1

You have to give a name to the dataframe into which the data should be read. Try the code below

df= pd.read_excel(fileName, sheet_name=getTab, header=None)

If you are working in Jupyter notebook, the below line will print the dataframe

df

answered Aug 9, 2019 at 3:21

moys

8,1173 gold badges19 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

woj Over a year ago

many thanks for your kind advice, however, it worked with some modification (i don't use Jupyter). df = pd.read_excel(fileName, sheet_name=getTab, header=None) print(df) Anyway, thanks for giving me a useful hint, I really appreciate your help!

woj Over a year ago

I found a few links with the explanation: link link @mohanys, again many thanks for solving my issue.

Collectives™ on Stack Overflow

pandas read_excel doesn't return data

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related