May-26-2020, 01:39 AM
I have two dataframes and trying to do a excel vlookup type function.
excel's vlookup parameters: vlookup(lookup_value,table_array,col_index_num,range_lookup
How would I translate the following into python code?
Trying to do vlookup from df1 to df2. I dont know if I use a merge (all column names are different), map, etc. Im stuck on this problem. Im sure its a easy solution.
lookup_value: df1 column C apples
table_array: df2 A though D
col_index: df2 column D (apple_types)
below are column names...
df1
A | B | C | D
-----------------------------------
grapes|berry | apples | mango
df2
A | B | C | D
-----------------------------------
veggies|meat | drinks | apple_types
Thank you
excel's vlookup parameters: vlookup(lookup_value,table_array,col_index_num,range_lookup
How would I translate the following into python code?
Trying to do vlookup from df1 to df2. I dont know if I use a merge (all column names are different), map, etc. Im stuck on this problem. Im sure its a easy solution.
lookup_value: df1 column C apples
table_array: df2 A though D
col_index: df2 column D (apple_types)
below are column names...
df1
A | B | C | D
-----------------------------------
grapes|berry | apples | mango
df2
A | B | C | D
-----------------------------------
veggies|meat | drinks | apple_types
Thank you