Aug-11-2019, 01:09 AM
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