+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Create dataframe through Dictionary in pandas (/thread-20276.html)
Create dataframe through Dictionary in pandas - ift38375 - Aug-03-2019
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 NaNI 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 ?
RE: Create dataframe through Dictionary in pandas - scidam - Aug-04-2019
Append
qtr somewhere to the dictionary, e.g. 2011 :{ 'qtr1':5000,'qtr3':5000,'qtr4':5000, 'qtr': None}.
RE: Create dataframe through Dictionary in pandas - boring_accountant - Aug-11-2019
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