Append data frames to and empty variable

Question

I've several data frames which all have the same columns:

df_list = [df1,df2,df3,dfn]

And I want to append those to a new data frame if a given condition is satisfied.

for df in df_list:
     if some_condition:
           new_df.append(df)

But that didn;t work, so I try this:

new_df = pd.DataFrame()
for column in df1.columns:
    new_df[column] = []

And just for testing it:

new_df.append(df1)

but new_df it's still empty.

It only works if I assign it explicity

new_df = new_df.append(df1)

jezrael · Accepted Answer · 2016-04-07 06:18:49Z

2

I think you need append to new list dfs and then concat:

dfs = []
for df in df_list:
     if some_condition:
           dfs.append(df)

print pd.concat(dfs)

answered Apr 7, 2016 at 6:18

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Do you have any idea of way new_df.append(df1) keeps new_df empy?

I think because append doesnt work inplace - returning a new object

I thought it was as in a list.