I have a dictionary that stores all the dataframes from a given excel file.
import pandas as pd
xl=pd.ExcelFile('pandas_worksheets.xlsx')
mydic={}
for i in xl.sheet_names:
mydic[i] = xl.parse(i)
I can call any dataframe sheet using this syntax:
mydic['olympic']
But how do I simply call "olympic" to return that dataframe? (without using mydic)
somthing like this works...
olympic = xl.parse('olympic')
But the same logic does not work in the for loop
for i in xl.sheet_names:
i = xl.parse(i)
It saves the last dataframe as literal i instead of replacing it with sheet-name.
update:
mydic={'a':1, 'b': 2}
for i in mydic:
i = mydic[i]
a
NameError: name 'a' is not defined
(expected value 1 instead of NameError)
from saving all excel sheets as pandas dataframe
No comments:
Post a Comment