import pandas as pd
from pandas import DataFrame, Series

data_dict = {'name': ['Caleb','Whitney','Hastin','Rafe'], 
             'age': [27,26,3,1],
             'sex': ['M','F','M','M']}

frame = DataFrame(data_dict)
frame

frame[frame.age > 18]

print "Average age:", frame.age.mean()
print "Age standard deviation:", frame.age.std()

frame.name # Selecting a column returns a Series

frame.ix[[0,1]] # Selecting by index

frame.ix[2] # Selecting just 1 row returns a Series

frame['state'] = 'Wisconsin'
frame['country'] = 'USA'
frame

frame.drop('country', axis=1) # Creates a copy, doesn't change frame

frame = frame.append({'age': 22, 'name': 'Wes', 'sex': 'M'}, ignore_index=True)
frame

frame = frame.drop('country', axis=1)
frame

frame.ix[4]['state'] = 'Illinois'
frame

frame.pivot(index='name', columns='state', values='age')

frame.ix[[2,3], ['name','age']]

frame

frame.ix[:, ['name','age','sex','state']] # Nice way to do column reindexing