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
  error bars with dataframe and pandas Hucky 4 282 Apr-27-2020, 02:02 AM
Last Post: Hucky
  Python Pandas DataFrame Help AmericanEagle1989 1 183 Apr-12-2020, 12:37 PM
Last Post: AmericanEagle1989
  How does pyplot know what was plotted by the output of pandas.DataFrame(...).cumprod( codeowl 2 196 Mar-28-2020, 08:27 AM
Last Post: j.crater
  Ordering of pandas DataFrame new_to_python 5 272 Mar-15-2020, 06:08 PM
Last Post: new_to_python
  Pandas dataframe merge snmmat 1 259 Mar-09-2020, 06:56 PM
Last Post: jefsummers
  Transform Facebook Graph API insights JSON to pandas dataframe usman 0 279 Mar-03-2020, 05:14 AM
Last Post: usman
  Obtaining Correct Date In Pandas DataFrame eddywinch82 14 1,400 Feb-17-2020, 11:45 AM
Last Post: eddywinch82
  Parse XML String in Pandas Dataframe creedX 2 951 Dec-09-2019, 07:35 PM
Last Post: creedX
  Pandas dataframe to join three tables using like condition among them sandeep_ganga 0 407 Nov-29-2019, 08:30 AM
Last Post: sandeep_ganga
  Pandas Dataframe to Google Big Query Ecniv 2 1,099 Nov-21-2019, 02:26 PM
Last Post: Ecniv

Forum Jump:


Users browsing this thread: 1 Guest(s)