如何使用Python在新列中执行vlookup？

import pandas as pd

df1 = pd.DataFrame({'A': [1, 2, 3, 4],
                    'B': ['a', 'b', 'c', 'd']})

df2 = pd.DataFrame({'A': [1, 2, 3, 4],
                    'C': ['x', 'y', 'z', 'w']})

result = pd.merge(df1, df2, on='A', how='left')

result = result.assign(D=result['C'])

import pandas as pd

df1 = pd.DataFrame({'A': [1, 2, 3, 4],
                    'B': ['a', 'b', 'c', 'd']})

df2 = pd.DataFrame({'A': [1, 2, 3, 4],
                    'C': ['x', 'y', 'z', 'w']})

result = pd.merge(df1, df2, on='A', how='left')
result = result.assign(D=result['C'])

print(result)

   A  B  C  D
0  1  a  x  x
1  2  b  y  y
2  3  c  z  z
3  4  d  w  w