Key Error when Merging columns from 2 Data Frames

Question

I am trying to create a new df with certain columns from 2 others:
The first called visas_df:

And the second called cpdf:

I only need the highlighted columns. But when I try this:

df_joined = pd.merge(cpdf,visas_df["visas"],on="date")

The error appearing is: KeyError: 'date'

I imagine this is due to how I created cpdf. It was a "bad dataset' so I did some fidgeting.Line 12 on the code snipped below might have something to do, but I am clueless...

I even renamed the date columns of both dfs as "date and checked that dtypes and number of rows are the same.

Any feedback would be much appreciated. Thanks!

Bushmaster · Accepted Answer · 2022-10-19 21:17:59Z

1

df['visas'] in merge function is not a dataframe and its not contain date column. İf you want to df as a dataframe, you have to use double square bracket [[]] like this:

df_joined = pd.merge(cpdf,visas_df[["date","visas"]],on="date")

edited Oct 19, 2022 at 21:17

answered Oct 19, 2022 at 21:12

Bushmaster

4,6364 gold badges11 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Key Error when Merging columns from 2 Data Frames

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