我想在df中创建一个新列,建立在比较两个系列对象的基础上,当我试图比较这两个系列时,我得到了
ValueError: can only compare identically-labeled Series objects
我正在尝试:
df = ((data1['price'] >= data2['amount_min']) & (data1['price'] <= data2['amount_max']))
系列对象示例:
data1 = 0 102340
1 234244
etc
data2 has only one value, let it be 100000
您可以使用df2['a'][0]
作为标量值,而不是Pandas系列:
df1 = pd.DataFrame(np.array([1, 2, 3]),
columns=['a'])
df2 = pd.DataFrame(np.array([1]),
columns=['a'])
df1['a'] > df2['a'][0]
# output
0 False
1 True
2 True
Name: a, dtype: bool
type(df2['a']) # pandas.core.series.Series
type(df2['a'][0]) # numpy.int32