我有两个数据帧df和df1.我想在df1中的第0行到第5行查找匹配(Df),并且只返回匹配值和范围. 例如,下面
import collections
import numpy as np
import pandas as pd
df = pd.DataFrame([[2],
[23],
[14],
[33],
[35],
[26]],
columns = ['Col1'])
df1 = pd.DataFrame([[1,2,4,5,6,8,-19],
[5,6,20,22,23,34,50],
[8,12,13,34,45,46,23],
[9,10,14,29,32,33,-10],
[1,22,13,23,33,35,2],
[1,6,7,8,9,10,6],
[0,2,3,5,6,8,23]],
columns = ['Num1','Num2','Num3','Num4','Num5','Num6','Range'])
我希望我的结果是这样的.
result = pd.DataFrame([[2,-19],
[2,23],
[23,50],
[23,2],
[14,-10],
[33,-10],
[33,2],
[35,2]],
columns = ['Match','Range'])