How do I translate this into python code? (excel vlookup)

[eeps24]

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