python vlookup dataframe

PHOTO EMBED

Sun Jul 31 2022 17:17:38 GMT+0000 (Coordinated Universal Time)

Saved by @QuinnFox12

# import pandas
import pandas as pd
   
# read csv data
df1 = pd.read_csv('Student_data.csv')
df2 = pd.read_csv('Course_enrolled.csv')
   
Right_join = pd.merge(df1, 
                      df2, 
                      on ='Name',
                      how ='right')
Right_join
content_copyCOPY