python中判断两列是否相等,python pandas：比较两列是否相等，并在第三个数据帧中得出结果...

how to print the result in the separate dataframe after comparing it with two columns in different dataframes.

consider two dataframes:

df1 = pd.DataFrame({'col1':['audi','cars']})

df2 = pd.DataFrame({'col2':['audi','bike']})

print (df1)

col1

0 audi

1 cars

print (df2)

col2

0 audi

1 bike

now the result should be in a different dataframe.

col1 col2 result

0 audi audi no change

1 cars bike changed

解决方案df = pd.concat([df1, df2], axis=1)

df['result'] = np.where(df['col1'] == df['col2'], 'no change', 'changed')

print (df)

col1 col2 result

0 audi audi no change

1 cars bike changed