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
  Dropping a column from pandas dataframe marco_ita 6 278 Sep-07-2019, 08:36 AM
Last Post: marco_ita
  created a pandas series instead of pandas DataFrame ibaad1406 6 358 Sep-06-2019, 06:23 AM
Last Post: ibaad1406
  Applying operation to a pandas multi index dataframe subgroup Nuovoq 1 180 Sep-04-2019, 10:04 PM
Last Post: Nuovoq
  Substr on Pandas Dataframe Scott 1 247 Sep-02-2019, 02:49 AM
Last Post: scidam
  Pandas Dataframe to Google Big Query Ecniv 1 321 Aug-21-2019, 04:56 PM
Last Post: ThomasL
  how to apply user defined function to Pandas DataFrame evelynow 3 441 Aug-20-2019, 11:35 PM
Last Post: scidam
  create 10 yearly blocks from time series using pandas Staph 1 167 Jul-23-2019, 12:01 PM
Last Post: Malt
  Problem with creating DataFrame using Dictionary ift38375 8 351 Jul-02-2019, 05:39 PM
Last Post: ThomasL
  [pandas] How to re-arrange DataFrame columns SriMekala 8 780 Jun-22-2019, 12:55 AM
Last Post: scidam
  Pandas - updating the original dataframe with sub selects Ecniv 0 201 Jun-21-2019, 02:12 PM
Last Post: Ecniv

Forum Jump:


Users browsing this thread: 1 Guest(s)