熊猫-选择多种数据标准

Question

我有一个包含多个列的DataFrame，我需要设置条件来访问来自两个不同列的特定值。我能够在一列上成功地完成它，如下所示：

status_filter = df[df['STATUS'] == 'Complete']

但我很难从两列中指定值。我试过这样做，但有错误：

status_filter = df[df['STATUS'] == 'Complete' and df['READY TO INVOICE'] == 'No']

这可能是一个简单的答案，但任何帮助都是值得感激的。

Answer 1

您的代码有两个非常小的错误: 1)两个或多个条件需要括号；2)您需要在标准之间使用符号：

status_filter = df[(df['STATUS'] == 'Complete') & (df['READY TO INVOICE'] == 'No')]

Answer 2

status_filter = df.ix[(df['STATUS'] == 'Complete') & (df['READY TO INVOICE'] == 'No'),]

欢迎

Answer 3

您可以使用：

status_filter = df[(df['STATUS'] == 'Complete') &  (df['READY TO INVOICE'] == 'No')]