Trying to do a "vlookup" with pandas. I have two data frames loaded. I suppose I would need to do a merge to connect both data frames. But my question is, how do I tell it which column to bring in for my result?I dont want to bring in all the columns, just a particular one. like in the vlookup sytax of "col_index_num"
excel vlookup syntax: vlookup(lookup_value,table_array,col_index_num,range_lookup)
say I merge df1 and df2 on colA, I want the result to bring in column B.
df1
df2
excel vlookup syntax: vlookup(lookup_value,table_array,col_index_num,range_lookup)
say I merge df1 and df2 on colA, I want the result to bring in column B.
df1
df2