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
  Difference of two columns in Pandas dataframe zinho 0 86 Jun-01-2020, 01:11 PM
Last Post: zinho
  error bars with dataframe and pandas Hucky 4 293 Apr-27-2020, 02:02 AM
Last Post: Hucky
  Python Pandas DataFrame Help AmericanEagle1989 1 189 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 201 Mar-28-2020, 08:27 AM
Last Post: j.crater
  Ordering of pandas DataFrame new_to_python 5 274 Mar-15-2020, 06:08 PM
Last Post: new_to_python
  Pandas dataframe merge snmmat 1 267 Mar-09-2020, 06:56 PM
Last Post: jefsummers
  Transform Facebook Graph API insights JSON to pandas dataframe usman 0 292 Mar-03-2020, 05:14 AM
Last Post: usman
  Obtaining Correct Date In Pandas DataFrame eddywinch82 14 1,410 Feb-17-2020, 11:45 AM
Last Post: eddywinch82
  Parse XML String in Pandas Dataframe creedX 2 971 Dec-09-2019, 07:35 PM
Last Post: creedX
  Pandas dataframe to join three tables using like condition among them sandeep_ganga 0 413 Nov-29-2019, 08:30 AM
Last Post: sandeep_ganga

Forum Jump:


Users browsing this thread: 1 Guest(s)