ValueError: The truth value of a DataFrame is ambiguous in Python

Dung Do Tien May 30 2021 326

I have an issue when I trying to filter the result dataframe with an OR operator.
I want to extract all column rsl_name values that satisfy the condition above 10 and below -10.

result = result[(result['rsl_name'] > 10) or (result['rsl_name'] < -10)]

The logic above give me an error is ValueError: The truth value of a DataFrame is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()

Please tell me why and how to fix it?

Have 2 answer(s) found.
  • N

    Nguyen Quoc Viet May 30 2021

    The or and and python statements require truth-values. For pandas these are considered ambiguous so you should use "bitwise" | (or) or & (and) operations:

    result = result[(result['var']>0.25) | (result['var']<-0.25)]

    In general. You need to change or to |

  • A

    Aa May 30 2021

    Well pandas use bitwise & | and each condition should be wrapped in a ()

    For example following works:

    data_query = data[(data['year'] >= 200) | (data['year'] <= 250)]

    I hope it resolves the issue for you.

Related Q&A May You Like

  1. ValueError: cannot reindex from a duplicate axis in Python
  2. ValueError: Cannot convert non-finite values (NA or inf) to integer in Python
  3. ModuleNotFoundError: No module named 'pandas' in Python
  4. How to print WITHOUT New line in Python using print method?
  5. How to print a new line in Python 3 with a long string?
  6. Short command to check python version in Linux or Window?
  7. SyntaxError: invalid character in identifier in Python
  8. ImportError: No module named 'ConfigParser' in Python
  9. ModuleNotFoundError: No module named 'numpy' in Python 3.x
  10. ImportError: No module named matplotlib.pyplot in Python
  11. Error divide by zero encountered in double_scalars in Python
  12. PermissionError: [Errno 13] Permission denied in Python
  13. ImportError: No module named MySQLdb in Python Django
  14. MongoDB throw certificate verify failed: certificate has expired in Python
  15. ImportError: No module named 'mysql' in Python Django
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions

Start Test

Asp.Net Core - Exam test 01

Start Test

Asp.Net Core - Exam test 02

Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close