Filtering DataFrame index row containing a string pattern from a Pandas
Filtering DataFrame Index:
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 Index contains ane ----\n") df.index = df.index.astype('str') df1 = df[df.index.str.contains('ane')] print(df1)
C:\pandas>python example44.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 Index contains ane ---- DateOfBirth State Jane 1986-11-11 NY Pane 1999-05-12 TX Frane 1983-06-04 AK C:\pandas>
2018-10-15T04:37:21+05:30
2018-10-15T04:37:21+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution