Locate Specific Value in pandas DataFrame in Python (2 Examples)
This article shows how to locate a particular value in a pandas DataFrame in Python.
Introduction of Example Data
import pandas as pd # Import pandas |
import pandas as pd # Import pandas
my_df = pd.DataFrame({'A':range(1, 7), # Constructing a pandas DataFrame 'B':[1, 3, 5, 7, 9, 3], 'C':range(17, 11, - 1)}) print(my_df) # A B C # 0 1 1 17 # 1 2 3 16 # 2 3 5 15 # 3 4 7 14 # 4 5 9 13 # 5 6 3 12 |
my_df = pd.DataFrame({'A':range(1, 7), # Constructing a pandas DataFrame 'B':[1, 3, 5, 7, 9, 3], 'C':range(17, 11, - 1)}) print(my_df) # A B C # 0 1 1 17 # 1 2 3 16 # 2 3 5 15 # 3 4 7 14 # 4 5 9 13 # 5 6 3 12
Example 1: Find pandas DataFrame Columns that Contain a Specific Value
print(my_df.isin([3]).any()) # Apply isin & any functions # A True # B True # C False # dtype: bool |
print(my_df.isin([3]).any()) # Apply isin & any functions # A True # B True # C False # dtype: bool
Example 2: Find pandas DataFrame Cells that Contain a Specific Value
print(my_df.isin([3])) # Apply isin function # A B C # 0 False False False # 1 False True False # 2 True False False # 3 False False False # 4 False False False # 5 False True False |
print(my_df.isin([3])) # Apply isin function # A B C # 0 False False False # 1 False True False # 2 True False False # 3 False False False # 4 False False False # 5 False True False
Related Articles
Furthermore, you may want to have a look at the other articles on this website.