目录
业务情景:
我有一个dataframe,存储着一张图中所有的坐标点。我想确定这张图中的点是否跟另外一张图重合了,而另外一张图中的坐标点也是存储在dataframe中的。
做法 - apply
import pandas as pd
import numpy as np
mapA = pd.DataFrame([[1,2],[-1,3]], columns=['X', 'Y'])
mapB = pd.DataFrame([[1,2],[2,4]], columns=['X', 'Y'])
# get all record in mapA which also appears in mapB
in_mapB_or_not = mapA.apply(lambda r: not mapB[(mapB['X'] == r['X']) & (mapB['Y'] == r['Y'])].empty, axis=1)
# notice! axis=1 is required! since we want apply to work on columns
结果截图: