Check if certain value is contained in a dataframe column in pandas [duplicate]

by

You can simply use this:

'07311954' in df.date.values which returns True or False

Here is the further explanation:

In pandas, using in check directly with DataFrame and Series (e.g. val in df or val in series ) will check whether the val is contained in the Index.

BUT you can still use in check for their values too (instead of Index)! Just using val in df.col_name.values
or val in series.values. In this way, you are actually checking the val with a Numpy array.

And .isin(vals) is the other way around, it checks whether the DataFrame/Series values are in the vals. Here vals must be set or list-like. So this is not the natural way to go for the question.

More Related Contents:

  1. How to deal with SettingWithCopyWarning in Pandas
  2. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  3. How to add pandas data to an existing csv file?
  4. How to explode a list inside a Dataframe cell into separate rows
  5. How to print pandas DataFrame without index
  6. Reversing ‘one-hot’ encoding in Pandas
  7. Pandas split column into multiple columns by comma
  8. Repeat rows in a pandas DataFrame based on column value
  9. Accessing every 1st element of Pandas DataFrame column containing lists
  10. How to deal with multi-level column names downloaded with yfinance
  11. Replace all occurrences of a string in a pandas dataframe (Python)
  12. Running get_dummies on several DataFrame columns?
  13. Python – How to convert JSON File to Dataframe
  14. How to remove timezone from a Timestamp column in a pandas dataframe
  15. Pandas lookup from one of multiple columns, based on value
  16. Lookup Values by Corresponding Column Header in Pandas 1.2.0 or newer
  17. How to add a suffix (or prefix) to each column name?
  18. How to delete multiple pandas (python) dataframes from memory to save RAM?
  19. Capitalize first letter of each word in a dataframe column
  20. Compute the running (cumulative) maximum for a series in pandas
  21. Get total of Pandas column
  22. Unpivot Pandas Data
  23. How to read a Parquet file into Pandas DataFrame?
  24. Get first and second highest values in pandas columns
  25. Enumerate each row for each group in a DataFrame
  26. How to open and convert sqlite database to pandas dataframe
  27. Set value on an entire column of a pandas dataframe
  28. Pandas: Join dataframe with condition
  29. UnicodeDecodeError when reading CSV file in Pandas
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment