How to filter DataFrame rows containing specific string values with an AND operator?
Filter DataFrame rows with an AND operator:
import pandas as pd df = pd.DataFrame({'DateOfBirth': ['1986-11-11', '1999-05-12', '1976-01-01', '1986-06-01', '1983-06-04', '1990-03-07', '1999-07-09'], 'State': ['NY', 'TX', 'FL', 'AL', 'AK', 'TX', 'TX'] }, index=['Jane', 'Pane', 'Aaron', 'Penelope', 'Frane', 'Christina', 'Cornelia']) print(df) print("\n---- Filter DataFrame using & ----\n") df.index = df.index.astype('str') df1 = df[df.index.str.contains('ane') & df['State'].str.contains("TX")] print(df1)
C:\pandas>python example45.py DateOfBirth State Jane 1986-11-11 NY Pane 1999-05-12 TX Aaron 1976-01-01 FL Penelope 1986-06-01 AL Frane 1983-06-04 AK Christina 1990-03-07 TX Cornelia 1999-07-09 TX ---- Filter DataFrame using & ---- DateOfBirth State Pane 1999-05-12 TX C:\pandas>
2018-10-16T12:07:25+05:30
2018-10-16T12:07:25+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution