Join column in dataframe to another dataframe - Pandas

Question

I have 2 dataframes. One has a bunch of columns including f_uuid. The other dataframe has 2 columns, f_uuid and i_uuid.

the first dataframe may contain some f_uuids that the second dataframe doesn't and vice versa.

I want the first dataframe to have a new column i_uuid (from the second dataframe) populated with the appropriate values for the matching f_uuid in that first dataframe.

How would I achieve this?

Hi and welcome on SO. It will be great if you can have a look at How to Ask and then try to produce a minimal reproducible example. — rpanai
– rpanai, Commented Oct 5, 2021 at 15:11

fiphrelin · Accepted Answer · 2021-10-05 15:08:21Z

1

df1 = pd.merge(df1,
               df2,
               on='f_uuid')

If you want to keep all f_uuid from df1 (e.g. those not available in df2), you may run

df1 = pd.merge(df1,
               df2,
               on='f_uuid',
               how='left')

answered Oct 5, 2021 at 15:08

fiphrelin

3201 silver badge9 bronze badges

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

Comments

Viper · Accepted Answer · 2021-10-05 15:09:22Z

1

I think what your looking for is a merge : https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.merge.html?highlight=merge#pandas.DataFrame.merge

In your case, that would look like :

bunch_of_col_df.merge(other_df, on="f_uuid")

answered Oct 5, 2021 at 15:09

Viper

5053 silver badges14 bronze badges

Collectives™ on Stack Overflow

Join column in dataframe to another dataframe - Pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related