In [1]:
import numpy as np
import pandas as pd
from pandas import DataFrame, Series
In [4]:
ser1 = Series(np.arange(3), index=['X','Y','Z'])
ser1 = 2*ser1
ser1
Out[4]:
In [6]:
ser1['Y']
Out[6]:
In [7]:
ser1[2]
Out[7]:
In [8]:
ser1[:1]
Out[8]:
In [9]:
# selecting with range by index
ser1[['X','Z']]
Out[9]:
In [11]:
# selecting by logic
ser1[ser1 > 3]
Out[11]:
In [13]:
# set values
ser1[ser1 > 3] = 10
ser1
Out[13]:
In [19]:
df1 = DataFrame(np.arange(25).reshape(5,5), index=['SF','DC','LA','NY','CH'],
columns=['Q','W','E','R','T'])
df1
Out[19]:
In [20]:
# selecting by columns name
df1['Q']
Out[20]:
In [21]:
df1
Out[21]:
In [22]:
df1[['W','T']]
Out[22]:
In [23]:
df1[df1['R'] > 8]
Out[23]:
In [24]:
# boolean datafarame
df1 > 10
Out[24]:
In [25]:
# using 'ix' function
df1.ix['DC']
Out[25]:
In [26]:
df1.ix[1]
Out[26]:
In [ ]: