Sep-25-2022, 05:47 PM
i wanted to append only non empty dataframes from a set of dataframes.. using python!!
I tried so using following code:
dfs = [df2_test,df3_test,df4_test,df5_test,df6_test,df7_test,df8_test,df9_test,df10_test,df12_test,df13_test,df14_test,df15_test,df16_test,df17_test,df18_test,df19_test,df20_test,df21_test,df22_test,df23_test,df24_test,df25_test,df26_test,df27_test,df28_test,df29_test,df30_test]
df_final=pd.concat([df for df in dfs if not df.empty], axis=1, join='outer').to_csv("D:/tool/optimized_final_test.csv",header=True,index=False)
Can anyone help me out to fix it
note: the non-empty dataframe contains elements of size 30 x 4. say for eg if I have 4 nonempty df I should get 30 X 16 size dataframe.
I tried so using following code:
dfs = [df2_test,df3_test,df4_test,df5_test,df6_test,df7_test,df8_test,df9_test,df10_test,df12_test,df13_test,df14_test,df15_test,df16_test,df17_test,df18_test,df19_test,df20_test,df21_test,df22_test,df23_test,df24_test,df25_test,df26_test,df27_test,df28_test,df29_test,df30_test]
df_final=pd.concat([df for df in dfs if not df.empty], axis=1, join='outer').to_csv("D:/tool/optimized_final_test.csv",header=True,index=False)
Can anyone help me out to fix it
note: the non-empty dataframe contains elements of size 30 x 4. say for eg if I have 4 nonempty df I should get 30 X 16 size dataframe.