有2个csv表，利用左边表col2列中的数据对应的col1列，根据第二个数组中col3列中的数据，该如何生成新的列表？

Question

如题

c0I1 c0l2 c0l3 result_c0l
0 a a 0
1 b c 2
2 c d 3
3 d b 1
4 e g 6
5 f i 8
6 g h 7
7 h
8 i

Answer 1

import pandas as pd

df1 = pd.DataFrame(
    {
        "col1": [0,1,2,3,4,5,6,7,8],
        "col2": ["a", "b", "c", "d","e","f","g","h","i"]
    }
)
df2 = pd.DataFrame(
    {
        "col3": ["a", "c", "d", "b","g","i","h"],  
    }
)

mergeData = pd.merge(df1,df2,left_on="col2",right_on="col3",how="right")[["col3","col1"]].rename(columns={"col1":"result"})

mergeData