df19=df1.copy() df19=df19.drop(df19.columns[[3,4,5,6,7,8,9,10,11,12,13]], axis=1) df19=df19.rename(columns={'Q4-2018':'QGDP'}) df19.insert(3, "Date", ["2019-03-13" for index in range (60)]) df20=df1.copy() df20=df20.drop(df20.columns[[2,4,5,6,7,8,9,10,11,12,13]], axis=1) df20=df20.rename(columns={'Q1-2019':'QGDP'}) df20.insert(3, "Date", ["2019-05-22" for index in range (60)]) df21=df1.copy() df21=df21.drop(df21.columns[[2,3,5,6,7,8,9,10,11,12,13]], axis=1) df21=df21.rename(columns={'Q2-2019':'QGDP'}) df21.insert(3, "Date", ["2019-08-26" for index in range (60)]) df22=df1.copy() df22=df22.drop(df22.columns[[2,3,4,6,7,8,9,10,11,12,13]], axis=1) df22=df22.rename(columns={'Q3-2019':'QGDP'}) df22.insert(3, "Date", ["2019-11-19" for index in range (60)]) df23=df1.copy() df23=df23.drop(df23.columns[[2,3,4,5,7,8,9,10,11,12,13]], axis=1) df23=df23.rename(columns={'Q4-2019':'QGDP'}) df23.insert(3, "Date", ["2020-02-20" for index in range (60)]) df24=df1.copy() df24=df24.drop(df24.columns[[2,3,4,5,6,8,9,10,11,12,13]], axis=1) df24=df24.rename(columns={'Q1-2020':'QGDP'}) df24.insert(3, "Date", ["2020-06-11" for index in range (60)]) df25=df1.copy() df25=df25.drop(df25.columns[[2,3,4,5,6,7,9,10,11,12,13]], axis=1) df25=df25.rename(columns={'Q2-2020':'QGDP'}) df25.insert(3, "Date", ["2020-09-14" for index in range (60)]) df26=df1.copy() df26=df26.drop(df26.columns[[2,3,4,5,6,7,8,10,11,12,13]], axis=1) df26=df26.rename(columns={'Q3-2020':'QGDP'}) df26.insert(3, "Date", ["2020-12-14" for index in range (60)]) df27=df1.copy() df27=df27.drop(df27.columns[[2,3,4,5,6,7,8,9,11,12,13]], axis=1) df27=df27.rename(columns={'Q4-2020':'QGDP'}) df27.insert(3, "Date", ["2021-02-18" for index in range (60)]) df28=df1.copy() df28=df28.drop(df28.columns[[2,3,4,5,6,7,8,9,10,12,13]], axis=1) df28=df28.rename(columns={'Q1-2021':'QGDP'}) df28.insert(3, "Date", ["2021-05-20" for index in range (60)]) df29=df1.copy() df29=df29.drop(df29.columns[[2,3,4,5,6,7,8,9,10,11,13]], axis=1) df29=df29.rename(columns={'Q2-2021':'QGDP'}) df29.insert(3, "Date", ["2021-08-30" for index in range (60)]) df30=df1.copy() df30=df30.drop(df30.columns[[2,3,4,5,6,7,8,9,10,11,12]], axis=1) df30=df30.rename(columns={'Q3-2021':'QGDP'}) df30.insert(3, "Date", ["2021-12-18" for index in range (60)])
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter