ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

在对数据框进行布尔索引的时候，出现下面的错误提示

In [14]: tab_all_timepoint[(tab_all_timepoint["loan_id"]==683756975054749696) and (tab_all_timepoint["mob_month_end"]==mob_month_end.iloc[0,0]) ]

Traceback (most recent call last):

File "<ipython-input-14-9c0941fc8247>", line 1, in <module>

tab_all_timepoint[(tab_all_timepoint["loan_id"]==683756975054749696) and (tab_all_timepoint["mob_month_end"]==mob_month_end.iloc[0,0]) ]

File "C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\generic.py", line 1555, in __nonzero__

self.__class__.__name__

ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().

原因是在对数据框进行布尔索引的时候,如果涉及到多个并且条件，必须要用&连接，不能用and连接，而且每个条件需要用括号括起来。

应该修改成如下：

tab_all_timepoint[(tab_all_timepoint["loan_id"]==683756975054749696) & (tab_all_timepoint["mob_month_end"]==mob_month_end.iloc[0,0]) ]