How to concat several dataframes in one dataframe with pandas

Question

I have several dataframes with 5 rows and 5 columns. How do I concat them so they will on under each other (I want to build csv file out of that). For example I have

df0

a/0/id a/0/team a/0/seed
6456   colorado  6
8978   oregon    7
0980   texas     1

df1

a/1/id a/1/team   a/1/seed
2342   nyc        12
8556   ucf        16
1324   california 5

How to get final dataframe like

final_df

6456   colorado   6
8978   oregon     7
0980   texas      1
2342   nyc        12
8556   ucf        16
1324   california 5

Thanks

jezrael · Accepted Answer · 2019-02-28 10:11:27Z

1

There is problem different columns names, so need some preprocessing before concat - e.g. split values by / and select last value - need same columns names for alignment in concat:

df0.columns = df0.columns.str.split('/').str[-1]
df1.columns = df1.columns.str.split('/').str[-1]
print (df0)
     id      team  seed
0  6456  colorado     6
1  8978    oregon     7
2   980     texas     1

print (df1)
     id        team  seed
0  2342         nyc    12
1  8556         ucf    16
2  1324  california     5

final_df = pd.concat([df0, df1], ignore_index=True)
print (final_df)
     id        team  seed
0  6456    colorado     6
1  8978      oregon     7
2   980       texas     1
3  2342         nyc    12
4  8556         ucf    16
5  1324  california     5

edited Feb 28, 2019 at 10:11

answered Feb 28, 2019 at 10:05

jezrael

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

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

Collectives™ on Stack Overflow

How to concat several dataframes in one dataframe with pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related