Python Forum
Problem with creating DataFrame using Dictionary
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem with creating DataFrame using Dictionary
#1
Hi,

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..
Reply


Messages In This Thread
Problem with creating DataFrame using Dictionary - by ift38375 - Jul-01-2019, 04:30 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Creating a Dataframe from Zenodo zip file with multiple CSVs about Spotify man0s 0 1,365 Apr-26-2022, 01:45 PM
Last Post: man0s
Question Pandas - Creating additional column in dataframe from another column Azureaus 2 2,992 Jan-11-2021, 09:53 PM
Last Post: Azureaus
  Create dataframe through Dictionary in pandas ift38375 2 2,254 Aug-11-2019, 01:09 AM
Last Post: boring_accountant
  Creating A List of DataFrames & Manipulating Columns in Each DataFrame firebird 1 4,325 Jul-31-2019, 04:04 AM
Last Post: scidam
  Problem while showing a Pandas DataFrame Sirduke1 0 2,098 Aug-29-2018, 06:14 AM
Last Post: Sirduke1

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020