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['age'])
print(type(df['age']))


    

    




name
Alice      24
Bob        42
Charlie    18
Dave       68
Ellen      24
Frank      30
Name: age, dtype: int64
<class 'pandas.core.series.Series'>

In [4]:

    

print(df.age)
print(type(df.age))


    

    




name
Alice      24
Bob        42
Charlie    18
Dave       68
Ellen      24
Frank      30
Name: age, dtype: int64
<class 'pandas.core.series.Series'>

In [5]:

    

print(df[['age', 'point']])
print(type(df[['age', 'point']]))


    

    




         age  point
name               
Alice     24     64
Bob       42     92
Charlie   18     70
Dave      68     70
Ellen     24     88
Frank     30     57
<class 'pandas.core.frame.DataFrame'>

In [6]:

    

print(df[['age']])
print(type(df[['age']]))


    

    




         age
name        
Alice     24
Bob       42
Charlie   18
Dave      68
Ellen     24
Frank     30
<class 'pandas.core.frame.DataFrame'>

In [7]:

    

print(df['age':'point'])


    

    




Empty DataFrame
Columns: [age, state, point]
Index: []

In [8]:

    

print(df.loc[:, 'age':'point'])
print(type(df.loc[:, 'age':'point']))


    

    




         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
<class 'pandas.core.frame.DataFrame'>

In [9]:

    

print(df.iloc[:, [0, 2]])
print(type(df.iloc[:, [0, 2]]))


    

    




         age  point
name               
Alice     24     64
Bob       42     92
Charlie   18     70
Dave      68     70
Ellen     24     88
Frank     30     57
<class 'pandas.core.frame.DataFrame'>

In [10]:

    

print(df[1:4])
print(type(df[1:4]))


    

    




         age state  point
name                     
Bob       42    CA     92
Charlie   18    CA     70
Dave      68    TX     70
<class 'pandas.core.frame.DataFrame'>

In [11]:

    

print(df[:-3])
print(type(df[1:-3]))


    

    




         age state  point
name                     
Alice     24    NY     64
Bob       42    CA     92
Charlie   18    CA     70
<class 'pandas.core.frame.DataFrame'>

In [12]:

    

print(df[::2])
print(type(df[::2]))


    

    




         age state  point
name                     
Alice     24    NY     64
Charlie   18    CA     70
Ellen     24    CA     88
<class 'pandas.core.frame.DataFrame'>

In [13]:

    

print(df[1::2])
print(type(df[1::2]))


    

    




       age state  point
name                   
Bob     42    CA     92
Dave    68    TX     70
Frank   30    NY     57
<class 'pandas.core.frame.DataFrame'>

In [14]:

    

# print(df[1])
# KeyError: 1


    

In [15]:

    

print(df[1:2])
print(type(df[1:2]))


    

    




      age state  point
name                  
Bob    42    CA     92
<class 'pandas.core.frame.DataFrame'>

In [16]:

    

print(df['Bob':'Ellen'])
print(type(df['Bob':'Ellen']))


    

    




         age state  point
name                     
Bob       42    CA     92
Charlie   18    CA     70
Dave      68    TX     70
Ellen     24    CA     88
<class 'pandas.core.frame.DataFrame'>

In [17]:

    

print(df.loc['Bob'])
print(type(df.loc['Bob']))


    

    




age      42
state    CA
point    92
Name: Bob, dtype: object
<class 'pandas.core.series.Series'>

In [18]:

    

print(df.loc[['Bob', 'Ellen']])
print(type(df.loc[['Bob', 'Ellen']]))


    

    




       age state  point
name                   
Bob     42    CA     92
Ellen   24    CA     88
<class 'pandas.core.frame.DataFrame'>

In [19]:

    

print(df.iloc[[1, 4]])
print(type(df.iloc[[1, 4]]))


    

    




       age state  point
name                   
Bob     42    CA     92
Ellen   24    CA     88
<class 'pandas.core.frame.DataFrame'>

In [20]:

    

print(df['age']['Alice'])


    

    




24

In [21]:

    

print(df['Bob':'Dave'][['age', 'point']])


    

    




         age  point
name               
Bob       42     92
Charlie   18     70
Dave      68     70

In [22]:

    

print(df.at['Alice', 'age'])


    

    




24

In [23]:

    

print(df.loc['Bob':'Dave', ['age', 'point']])


    

    




         age  point
name               
Bob       42     92
Charlie   18     70
Dave      68     70