In [1]:

    

import pandas as pd


    

In [2]:

    

df = pd.DataFrame({'age': [24, 42], 'state': ['NY', 'CA'], 'point': [64, 92]},
                  index=['Alice', 'Bob'])


    

In [3]:

    

print(df)


    

    




       age state  point
Alice   24    NY     64
Bob     42    CA     92

In [4]:

    

for column_name in df:
    print(type(column_name))
    print(column_name)
    print('======\n')


    

    




<class 'str'>
age
======

<class 'str'>
state
======

<class 'str'>
point
======

In [5]:

    

for column_name in df.__iter__():
    print(type(column_name))
    print(column_name)
    print('======\n')


    

    




<class 'str'>
age
======

<class 'str'>
state
======

<class 'str'>
point
======

In [6]:

    

for column_name, item in df.iteritems():
    print(type(column_name))
    print(column_name)
    print('~~~~~~')
    
    print(type(item))
    print(item)
    print('------')
    
    print(item['Alice'])
    print(item[0])
    print(item.Alice)
    print('======\n')


    

    




<class 'str'>
age
~~~~~~
<class 'pandas.core.series.Series'>
Alice    24
Bob      42
Name: age, dtype: int64
------
24
24
24
======

<class 'str'>
state
~~~~~~
<class 'pandas.core.series.Series'>
Alice    NY
Bob      CA
Name: state, dtype: object
------
NY
NY
NY
======

<class 'str'>
point
~~~~~~
<class 'pandas.core.series.Series'>
Alice    64
Bob      92
Name: point, dtype: int64
------
64
64
64
======

In [7]:

    

for index, row in df.iterrows():
    print(type(index))
    print(index)
    print('~~~~~~')
    
    print(type(row))
    print(row)
    print('------')
    
    print(row['point'])
    print(row[2])
    print(row.point)
    print('======\n')


    

    




<class 'str'>
Alice
~~~~~~
<class 'pandas.core.series.Series'>
age      24
state    NY
point    64
Name: Alice, dtype: object
------
64
64
64
======

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

In [8]:

    

for row in df.itertuples():
    print(type(row))
    print(row)
    print('------')
    
    print(row[3])
    print(row.point)
    print('======\n')


    

    




<class 'pandas.core.frame.Pandas'>
Pandas(Index='Alice', age=24, state='NY', point=64)
------
64
64
======

<class 'pandas.core.frame.Pandas'>
Pandas(Index='Bob', age=42, state='CA', point=92)
------
92
92
======

In [9]:

    

for row in df.itertuples(name=None):
    print(type(row))
    print(row)
    print('------')
    
    print(row[3])
    print('======\n')


    

    




<class 'tuple'>
('Alice', 24, 'NY', 64)
------
64
======

<class 'tuple'>
('Bob', 42, 'CA', 92)
------
92
======

In [10]:

    

print(df['age'])


    

    




Alice    24
Bob      42
Name: age, dtype: int64

In [11]:

    

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


    

    




<class 'pandas.core.series.Series'>

In [12]:

    

for age in df['age']:
    print(age)


    

    




24
42

In [13]:

    

for age, point in zip(df['age'], df['point']):
    print(age, point)


    

    




24 64
42 92

In [14]:

    

print(df.index)


    

    




Index(['Alice', 'Bob'], dtype='object')

In [15]:

    

print(type(df.index))


    

    




<class 'pandas.core.indexes.base.Index'>

In [16]:

    

for index in df.index:
    print(index)


    

    




Alice
Bob

In [17]:

    

for index, state in zip(df.index, df['state']):
    print(index, state)


    

    




Alice NY
Bob CA

In [18]:

    

for index, row in df.iterrows():
    row['point'] += row['age']


    

In [19]:

    

print(df)


    

    




       age state  point
Alice   24    NY     64
Bob     42    CA     92

In [20]:

    

for index, row in df.iterrows():
    df.at[index, 'point'] += row['age']


    

In [21]:

    

print(df)


    

    




       age state  point
Alice   24    NY     88
Bob     42    CA    134

In [22]:

    

df['point'] += df['age']
print(df)


    

    




       age state  point
Alice   24    NY    112
Bob     42    CA    176

In [23]:

    

df['new'] = df['point'] + df['age'] * 2
print(df)


    

    




       age state  point  new
Alice   24    NY    112  160
Bob     42    CA    176  260

In [24]:

    

df['age_sqrt'] = pd.np.sqrt(df['age'])
print(df)


    

    




       age state  point  new  age_sqrt
Alice   24    NY    112  160  4.898979
Bob     42    CA    176  260  6.480741

In [25]:

    

df['state_0'] = df['state'].str.lower().str[0]
print(df)


    

    




       age state  point  new  age_sqrt state_0
Alice   24    NY    112  160  4.898979       n
Bob     42    CA    176  260  6.480741       c