Skip to content
geeksforgeeks
  • Courses
    • DSA to Development
    • Get IBM Certification
    • Newly Launched!
      • Master Django Framework
      • Become AWS Certified
    • For Working Professionals
      • Interview 101: DSA & System Design
      • Data Science Training Program
      • JAVA Backend Development (Live)
      • DevOps Engineering (LIVE)
      • Data Structures & Algorithms in Python
    • For Students
      • Placement Preparation Course
      • Data Science (Live)
      • Data Structure & Algorithm-Self Paced (C++/JAVA)
      • Master Competitive Programming (Live)
      • Full Stack Development with React & Node JS (Live)
    • Full Stack Development
    • Data Science Program
    • All Courses
  • Tutorials
    • Data Structures & Algorithms
    • ML & Data Science
    • Interview Corner
    • Programming Languages
    • Web Development
    • CS Subjects
    • DevOps And Linux
    • School Learning
  • Practice
    • Build your AI Agent
    • GfG 160
    • Problem of the Day
    • Practice Coding Problems
    • GfG SDE Sheet
  • Contests
    • Accenture Hackathon (Ending Soon!)
    • GfG Weekly [Rated Contest]
    • Job-A-Thon Hiring Challenge
    • All Contests and Events
  • Data preprocessing
  • Data Manipulation
  • Data Analysis using Pandas
  • EDA
  • Pandas Exercise
  • Pandas AI
  • Numpy
  • Matplotlib
  • Plotly
  • Data Analysis
  • Machine Learning
  • Data science
Open In App
Next Article:
Python | Pandas dataframe.ne()
Next article icon

Python | Pandas DataFrame.isin()

Last Updated : 29 Nov, 2023
Comments
Improve
Suggest changes
Like Article
Like
Report

In this article, we will explore the Pandas DataFrame.isin() method provided by the Pandas library in Python. Python is widely recognized for its proficiency in data analysis, largely attributed to its exceptional ecosystem of data-centric packages. Among these, Pandas stands out as an essential tool that significantly simplifies tasks related to data import and analysis.

Pandas DataFrame.isin() Syntax

Syntax: DataFrame.isin(values)

Parameters: values: iterable, Series, List, Tuple, DataFrame or dictionary to check in the caller Series/Data Frame.

Return Type: DataFrame of Boolean of Dimension.

To download the CSV file used, Click Here.

isin() Function in Pandas Examples

The DataFrame.isin() method in Pandas is a powerful tool for filtering and selecting data within a DataFrame based on specified conditions. It allows you to create boolean masks to identify rows where the values in one or more columns match certain criteria. Let’s delve into the details of the isin() method

  • Single Parameter Filtering
  • Multiple Parameter Filtering

Single Parameter filtering Using Pandas DataFrame.isin()

In the following example, Rows are checked and a boolean series is returned which is True wherever Gender=”Male”. Then the series is passed to the data frame to see new filtered data frame.

Python3




# importing pandas package
import pandas as pd
 
# making data frame from csv file
data = pd.read_csv("/content/employees (2).csv")
 
# creating a bool series from isin()
new = data["Gender"].isin(["Male"])
 
# displaying data with gender = male only
data[new]
print(data.head())
 
 
 
                          
 
 
 
 
Output
 
 
 As shown in the output image, only Rows having gender = “Male” are returned. 
 
Multiple parameter Filtering Using Pandas DataFrame.isin() 
 
In the following example, the data frame is filtered on the basis of Gender as well as Team. Rows having Gender=”Female” and Team=”Engineering”, “Distribution” or “Finance” are returned. 
 
 
 
Python3
 
  
 
 
 
 
                                      
 
                                    
                                     
 
 
                                    
 
 
                                    
                                     
                                                                      
 
 
 
 
 
 
  
  
 
# importing pandas package
 
import pandas as pd
 
 
 
# making data frame from csv file
 
data = pd.read_csv("/content/employees (2).csv")
 
 
 
# creating filters of bool series from isin()
 
filter1 = data["Gender"].isin(["Female"])
 
filter2 = data["Team"].isin(["Engineering", "Distribution", "Finance" ])
 
 
 
# displaying data with both filter applied and mandatory 
 
data[filter1 & filter2]
 
 
 
print(data.head())
 
 		 
  
 
 
 
 
 
                          
 
 
                          
 
 
 
 
Output
 
 
 As shown in the output image, Rows having Gender=”Female” and Team=”Engineering”, “Distribution” or “Finance” are returned.  
 

                                                                                      

                                                                                
                                          
                                                                                  
                                                                  
                              
                                
                                                                            Next Article                                                                                                                                                            
                                          Python | Pandas dataframe.ne()                                      
                                  
                                                          
                          
                              
                                          
                                              
                                                  
                                                  
                                                      
K
          
                        
          
                                                  
                                                  
                                                      Kartikaybhutani                                                
                                                  
                                                  
              
              
  
                                            
                                                                                        
                                          
                                                                                            
                                                                                                                                                  
                                                                                                                            
                                      Improve                                                                        
                                                                        
                          
                          
                                                              
                                      
Article Tags : 
                                      
                                                            
  •                   Python              
    •               
  •                   Pandas-DataFrame-Methods              
    •               
  •                   Python pandas-dataFrame              
    •               
  •                   Python-pandas              
    •                                     
                                                                      
                                                                                          
                                      
Practice Tags : 
                                      
                                              
  • python
    •                                     
                                                                      
                                                      
                          
                                                                                                                                 
                                  
Similar Reads
                                  
                                      
  •                       
    Python | Pandas dataframe.ne()                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.Pandas dataframe.ne() function checks for inequality of a dataframe element with a cons
                      
                      
                                                2 min read                  
                      
  •                       
    Python | Pandas dataframe.idxmin()                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas dataframe.idxmin() function returns index of first occurrence of minimum over r
                      
                      
                                                2 min read                  
                      
  •                       
    Python | Pandas DataFrame.ix[ ]                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric Python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas DataFrame.ix[ ] is both Label and Integer based slicing technique. Besides pure
                      
                      
                                                2 min read                  
                      
  •                       
    Python | Pandas Dataframe.iat[ ]                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric Python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas iat[] method is used to return data in a dataframe at the passed location. The
                      
                      
                                                2 min read                  
                      
  •                       
    Python | Pandas dataframe.div()                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.Pandas dataframe.div() is used to find the floating division of the dataframe and other
                      
                      
                                                3 min read                  
                      
  •                       
    Python | Pandas dataframe.eq()                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas dataframe.eq() is a wrapper used for the flexible comparison. It provides a con
                      
                      
                                                3 min read                  
                      
  •                       
    Python | Pandas dataframe.mask()                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas dataframe.mask() function return an object of same shape as self and whose corr
                      
                      
                                                3 min read                  
                      
  •                       
    Python | Pandas dataframe.notna()                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier.Pandas dataframe.notna() function detects existing/ non-missing values in the dataframe
                      
                      
                                                2 min read                  
                      
  •                       
    Python | Pandas dataframe.equals()                      
                          
    Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric python packages. Pandas is one of those packages and makes importing and analyzing data much easier. Pandas dataframe.equals() function is used to determine if two dataframe object in con
                      
                      
                                                2 min read                  
                      
  •                       
    Python | Pandas DataFrame.ftypes                      
                          
    Pandas DataFrame is a two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns). Arithmetic operations align on both row and column labels. It can be thought of as a dict-like container for Series objects. This is the primary data structure o
                      
                      
                                                2 min read                  
                      
                                 
                              
                                                                                
                                  
                                                                                                            
                              
                            
                              
                                                                                      
                                
                              
                                                                                    
                      
                  
              
                  
          
              
                  
                      
                                        
                   
                            
                                  
                              
                                  
              
          
              
                        
  	  	  	
  		
  					
  			
  			
  					
  	
    	  	
  		
  					
  			
  			
  			
  				
  	
  	  	        	  	
  		
  					
  			
  			    	  	
  		
  		   		
  	
  
                    
          
      
      
          
              
              
          
      
  
    
                        	
    
      
                
          
                    
              
                
                                  
                        
        
      
    
      
        
        
            
                                  geeksforgeeks-footer-logo                                
                    
                      
                                               
                                               
Corporate & Communications Address:
                                              
                        A-143, 7th Floor, Sovereign Corporate Tower, Sector- 136, Noida, Uttar Pradesh (201305)                    
                      
                    
                                               
                                                  
                          
Registered Address:
                          K 061, Tower K, Gulshan Vivante Apartment, Sector 137, Noida, Gautam Buddh Nagar, Uttar Pradesh, 201305                      
                      
                                        
                
                
                                            
                                                                
                                                                
                                                                
                                                                
                                    
                
                    GFG App on Play Store                    GFG App on App Store                
                
                  Advertise with us                
             
          
            
  • Company
  • About Us
  • Legal
  • Privacy Policy
  • In Media
  • Contact Us
  • Advertise with us
  • GFG Corporate Solution
  • Placement Training Program
  • Languages
  • Python
  • Java
  • C++
  • PHP
  • GoLang
  • SQL
  • R Language
  • Android Tutorial
  • Tutorials Archive
  • DSA
  • Data Structures
  • Algorithms
  • DSA for Beginners
  • Basic DSA Problems
  • DSA Roadmap
  • Top 100 DSA Interview Problems
  • DSA Roadmap by Sandeep Jain
  • All Cheat Sheets
  • Data Science & ML
  • Data Science With Python
  • Data Science For Beginner
  • Machine Learning
  • ML Maths
  • Data Visualisation
  • Pandas
  • NumPy
  • NLP
  • Deep Learning
  • Web Technologies
  • HTML
  • CSS
  • JavaScript
  • TypeScript
  • ReactJS
  • NextJS
  • Bootstrap
  • Web Design
  • Python Tutorial
  • Python Programming Examples
  • Python Projects
  • Python Tkinter
  • Python Web Scraping
  • OpenCV Tutorial
  • Python Interview Question
  • Django
  • Computer Science
  • Operating Systems
  • Computer Network
  • Database Management System
  • Software Engineering
  • Digital Logic Design
  • Engineering Maths
  • Software Development
  • Software Testing
  • DevOps
  • Git
  • Linux
  • AWS
  • Docker
  • Kubernetes
  • Azure
  • GCP
  • DevOps Roadmap
  • System Design
  • High Level Design
  • Low Level Design
  • UML Diagrams
  • Interview Guide
  • Design Patterns
  • OOAD
  • System Design Bootcamp
  • Interview Questions
  • Inteview Preparation
  • Competitive Programming
  • Top DS or Algo for CP
  • Company-Wise Recruitment Process
  • Company-Wise Preparation
  • Aptitude Preparation
  • Puzzles
  • School Subjects
  • Mathematics
  • Physics
  • Chemistry
  • Biology
  • Social Science
  • English Grammar
  • Commerce
  • World GK
  • GeeksforGeeks Videos
  • DSA
  • Python
  • Java
  • C++
  • Web Development
  • Data Science
  • CS Subjects
        
         
                              
            
                @GeeksforGeeks, Sanchhaya Education Private Limited, All rights reserved            
            
            
        
    
  
         
                We use cookies to ensure you have the best browsing experience on our website. By using our site, you          acknowledge that you have read and understood our          Cookie Policy &          Privacy Policy                      
        
     Lightbox       
                      
              
                  
                      
Improvement
                      
                                                
                  
                  
                      
                                          
                                                
                  
                  
                    
                      
                        
Suggest Changes
                        
Help us improve. Share your suggestions to enhance the article. Contribute your expertise and make a difference in the GeeksforGeeks portal.
                      
                      
                        geeksforgeeks-suggest-icon                      
                    
                    
                      
                        
Create Improvement
                        
Enhance the article with your expertise. Contribute to the GeeksforGeeks community and help create better learning resources for all.
                      
                      
                      geeksforgeeks-improvement-icon                      
                    
                    
                  
              
              
                                    
                    
                      
                                              
                      
Suggest Changes
                    
                    
                                              
                  
                  
                          
min 4 words, max Words Limit:1000
                          
                          
                                                    
                                
Thank You!
                                
Your suggestions are valuable to us.
                          
                  
                                     
                      
                                        
              
                        
                                                        
       
         
             
                 
What kind of Experience do you want to share?
                 
             
                          
                                      
                         
                     
                     
                         Interview Experiences                     
                                                       
                         
                     
                     
                         Admission Experiences                     
                                                       
                         
                     
                     
                         Career Journeys                     
                                                       
                         
                     
                     
                         Work Experiences                     
                                                       
                         
                     
                     
                         Campus Experiences                     
                                                       
                         
                     
                     
                         Competitive Exam Experiences