How to Use isin() and not isin() Method in Pandas DataFrame
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!!
Program 1
import pandas as pd
emp=pd.read_excel("E:\mypandas\employee.xlsx")
#select * from emp where salary in(5000,6000,8000);
#print(emp[emp.salary.isin([6000,7000])])
#print(emp[emp.salary.isin([6000,7000,10000])])
#print(emp[emp.age.isin([30,21,50])])
#select * from employee where salary not in(5000,6000,8000);
#print(emp[~emp.salary.isin([6000,7000,10000])])
print(emp[(~emp.age.isin([30,21,40,25,45])) & (emp.salary>10000)])
Your 15 seconds will encourage us to work even harder
Please share your happy experience on Google

