Python Megre multiple dataframes into single data frame

Question

How to merge multiple dataframes into single data frame? I have 3 different dataframes. I want to combine them and make then as one dataframe. Can you please provide the code?

Answer 1

You can merge the data frame using the various methods based on your requirement you can use join, merge, concat, append and so on to implement the merging. Example of using the concat method is as follows. Suppose you have 2 dataframe df1, df2 and df3. Then you can merge them as follows:

import pandas as pd
frames=[df1,df2,df3]
result=pd.concat(frames)

Hope this helps!!

If you need to know more about Python, join Python online course today.

Thanks!

Comments

That is not correct anaswer @Sharan. You are suggesting concat but the question is for merging. The correct answer for merging multiple dataframes into one is this :

(This is for 3 dataframes and can be modified accordingly)

exaple:

                   total = pd.merge((pd.merge(df1, df2, how='inner', on='name')), df3, how='inner', on='name')

---

Thanks a lot Supreet Chivukula, this is really what I am looking for so far. I have tried this solution just now and it is working for my project. Once again, thank you so much for your help and support. Wish you and family all the best.

Million Thanks

---

Hi, @Gemy Forson,

Thank you for your contribution to the Edureka Community.

Hey, Register/Sign up with the Edureka community regarding any tech-related queries. We have our tech subject matter experts to handle all your queries. You can ask questions, answer, upvote, and an answer.