Filter multiple rows using isin in DataFrame
Filter rows using "isin" and multiple conditions:
import pandas as pd employees = pd.DataFrame({ 'EmpCode': ['Emp001', 'Emp002', 'Emp003', 'Emp004', 'Emp005'], 'Name': ['John', 'Doe', 'William', 'Spark', 'Mark'], 'Occupation': ['Chemist', 'Statistician', 'Statistician', 'Statistician', 'Programmer'], 'Date Of Join': ['2018-01-25', '2018-01-26', '2018-01-26', '2018-02-26', '2018-03-16'], 'Age': [23, 24, 34, 29, 40]}) print("\nUse isin operator\n") print(employees.loc[employees['Occupation'].isin(['Chemist','Programmer'])]) print("\nMultiple Conditions\n") print(employees.loc[(employees['Occupation'] == 'Chemist') | (employees['Name'] == 'John') & (employees['Age'] < 30)])
C:\python\pandas examples>python example6.py Use isin operator Age Date Of Join EmpCode Name Occupation 0 23 2018-01-25 Emp001 John Chemist 4 40 2018-03-16 Emp005 Mark Programmer Multiple Conditions Age Date Of Join EmpCode Name Occupation 0 23 2018-01-25 Emp001 John Chemist C:\python\pandas examples>
2018-10-27T00:57:08+05:30
2018-10-27T00:57:08+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution