Python Forum
Create dataframe through Dictionary in pandas
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Create dataframe through Dictionary in pandas
#1
Hi,

I have given below table and i want to create dataframe of this table using Dictionary:

          2019        2017        2015       2013      2011
qtr1      61000       44900       5000       5000      5000
qtr3      NaN         57000       5000       5000      5000
qtr4      NaN         59000       5000       5000      5000
qtr       NaN         NaN         NaN        NaN       NaN
I am using given below code but no luck :
import pandas as pd
df2 = { 2019 :{ 'qtr1':61000, } ,
        2017 :{ 'qtr1':44900,'qtr3':57000,'qtr4':59000},
        2015 :{ 'qtr1':5000,'qtr3':5000,'qtr4':5000},
        2013 :{ 'qtr1':5000,'qtr3':5000,'qtr4':5000},
        2011 :{ 'qtr1':5000,'qtr3':5000,'qtr4':5000}
        }
ndf = pd.DataFrame(df2)
print(ndf)


How can i declare whole row of "qtr' as NaN here i am confused ?
Reply


Messages In This Thread
Create dataframe through Dictionary in pandas - by ift38375 - Aug-03-2019, 08:24 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  HTML Decoder pandas dataframe column mbrown009 3 1,030 Sep-29-2023, 05:56 PM
Last Post: deanhystad
  Use pandas to obtain cartesian product between a dataframe of int and equations? haihal 0 1,119 Jan-06-2023, 10:53 PM
Last Post: haihal
  Pandas Dataframe Filtering based on rows mvdlm 0 1,432 Apr-02-2022, 06:39 PM
Last Post: mvdlm
  Pandas dataframe: calculate metrics by year mcva 1 2,312 Mar-02-2022, 08:22 AM
Last Post: mcva
  Pandas dataframe comparing anto5 0 1,261 Jan-30-2022, 10:21 AM
Last Post: anto5
  PANDAS: DataFrame | Replace and others questions moduki1 2 1,797 Jan-10-2022, 07:19 PM
Last Post: moduki1
  PANDAS: DataFrame | Saving the wrong value moduki1 0 1,551 Jan-10-2022, 04:42 PM
Last Post: moduki1
  update values in one dataframe based on another dataframe - Pandas iliasb 2 9,264 Aug-14-2021, 12:38 PM
Last Post: jefsummers
  empty row in pandas dataframe rwahdan 3 2,447 Jun-22-2021, 07:57 PM
Last Post: snippsat
Question Pandas - Creating additional column in dataframe from another column Azureaus 2 2,964 Jan-11-2021, 09:53 PM
Last Post: Azureaus

Forum Jump:

User Panel Messages

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