Bottom Page

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 ?
Quote
#2
Append qtr somewhere to the dictionary, e.g.
2011 :{ 'qtr1':5000,'qtr3':5000,'qtr4':5000, 'qtr': None}.
Quote
#3
The following should probably do what you want.
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)
ndf = ndf.append(pd.DataFrame(index=['qtr']))
print(ndf)
Output:
2011 2013 2015 2017 2019 qtr1 5000.0 5000.0 5000.0 44900.0 61000.0 qtr3 5000.0 5000.0 5000.0 57000.0 NaN qtr4 5000.0 5000.0 5000.0 59000.0 NaN qtr NaN NaN NaN NaN NaN
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  pandas dataframe iloc mystery edvvardbrian 0 42 Yesterday, 03:17 PM
Last Post: edvvardbrian
  How to add a few empty rows into a pandas dataframe python_newbie09 2 386 Sep-20-2019, 08:52 AM
Last Post: python_newbie09
  Dropping a column from pandas dataframe marco_ita 6 520 Sep-07-2019, 08:36 AM
Last Post: marco_ita
  created a pandas series instead of pandas DataFrame ibaad1406 6 509 Sep-06-2019, 06:23 AM
Last Post: ibaad1406
  Applying operation to a pandas multi index dataframe subgroup Nuovoq 1 295 Sep-04-2019, 10:04 PM
Last Post: Nuovoq
  Substr on Pandas Dataframe Scott 1 333 Sep-02-2019, 02:49 AM
Last Post: scidam
  Pandas Dataframe to Google Big Query Ecniv 1 397 Aug-21-2019, 04:56 PM
Last Post: ThomasL
  how to apply user defined function to Pandas DataFrame evelynow 3 576 Aug-20-2019, 11:35 PM
Last Post: scidam
  create 10 yearly blocks from time series using pandas Staph 1 193 Jul-23-2019, 12:01 PM
Last Post: Malt
  Problem with creating DataFrame using Dictionary ift38375 8 385 Jul-02-2019, 05:39 PM
Last Post: ThomasL

Forum Jump:


Users browsing this thread: 1 Guest(s)