How can I use an index from a dataset without mergin all datasets?

user19562955 0
Viewed 15

My datasets:

df1:

Country Year Dem
Turkiye 1993 152
Spain 1993 223
Spain 1994 166
USA 1993 123

df2 (it has many more columns but I only want to use "Index":

Country Year Index
Turkiye 1993 0
Spain 1993 1
Spain 1994 1
USA 1993 1
pandas
1 Answers

Use pandas.merge as shown below :

df1.merge(df2[['Country', 'Year', 'Index']], on=['Country', 'Year'], how='left')
abokey0
Related