In [1]:

    

import pandas as pd


    

In [2]:

    

df = pd.read_csv('data/src/sample_pandas_normal.csv', index_col=0)
print(df)


    

    




         age state  point
name                     
Alice     24    NY     64
Bob       42    CA     92
Charlie   18    CA     70
Dave      68    TX     70
Ellen     24    CA     88
Frank     30    NY     57

In [3]:

    

print(df.index)


    

    




Index(['Alice', 'Bob', 'Charlie', 'Dave', 'Ellen', 'Frank'], dtype='object', name='name')

In [4]:

    

print(df.index.str.contains('li'))


    

    




[ True False  True False False False]

In [5]:

    

print(df[df.index.str.contains('li')])


    

    




         age state  point
name                     
Alice     24    NY     64
Charlie   18    CA     70

In [6]:

    

print(df.index.str.endswith('e'))


    

    




[ True False  True  True False False]

In [7]:

    

print(df[df.index.str.endswith('e')])


    

    




         age state  point
name                     
Alice     24    NY     64
Charlie   18    CA     70
Dave      68    TX     70

In [8]:

    

print(df.columns)


    

    




Index(['age', 'state', 'point'], dtype='object')

In [9]:

    

print(df.columns.str.endswith('e'))


    

    




[ True  True False]

In [10]:

    

print(df.loc[:, df.columns.str.endswith('e')])


    

    




         age state
name              
Alice     24    NY
Bob       42    CA
Charlie   18    CA
Dave      68    TX
Ellen     24    CA
Frank     30    NY

In [11]:

    

print(df.iloc[:, df.columns.str.endswith('e')])


    

    




         age state
name              
Alice     24    NY
Bob       42    CA
Charlie   18    CA
Dave      68    TX
Ellen     24    CA
Frank     30    NY

In [12]:

    

print(df.loc[df.index.str.contains('li'), df.columns.str.endswith('e')])


    

    




         age state
name              
Alice     24    NY
Charlie   18    CA