Hi,
When i am creating dataframe for desired table then it is working fine as given below
When i am creating dataframe for desired table then it is working fine as given below
import pandas as pd diSales= { 2016:{'qtr1':34500,'qtr2':56000,'qtr3':47000,'qtr4':49000}, 2017:{'qtr1':44900,'qtr2':46100,'qtr3':57000,'qtr4':59000}, 2018:{'qtr1':54500,'qtr2':51000,'qtr3':57000,'qtr4':58500}, 2019:{'qtr1':61000} } ks = pd.DataFrame(diSales) print(ks)and output for given code is :
Output: 2016 2017 2018 2019
qtr1 34500 44900 54500 61000.0
qtr2 56000 46100 51000 NaN
qtr3 47000 57000 57000 NaN
qtr4 49000 59000 58500 NaN
But when i am trying to change Column to Mon, Tues , Wed, Thrus then it is giving error import pandas as pd diSales= { Mon:{'qtr1':34500,'qtr2':56000,'qtr3':47000,'qtr4':49000}, Tues:{'qtr1':44900,'qtr2':46100,'qtr3':57000,'qtr4':59000}, Wed:{'qtr1':54500,'qtr2':51000,'qtr3':57000,'qtr4':58500}, Thrus:{'qtr1':61000} } ks = pd.DataFrame(diSales) print(ks)then it is showing error in output as :
Output:Traceback (most recent call last):
File "C:\Users\Bhavik\Desktop\agg.py", line 2, in <module>
diSales= { Mon:{'qtr1':34500,'qtr2':56000,'qtr3':47000,'qtr4':49000},
NameError: name 'Mon' is not defined
Plz solve my problem..