In [1]:
from pandas import DataFrame, Series
import pandas as pd
import numpy as np

In [2]:
dframe = DataFrame({'city': ['Alma', 'Brian Head', 'Fox Park'], 'altitude': [3158, 3000, 2762]})

In [3]:
dframe


Out[3]:
altitude city
0 3158 Alma
1 3000 Brian Head
2 2762 Fox Park

In [4]:
state_map = {'Alma': 'Colorado', 'Brian Head' : 'Utah', 'Fox Park': 'Wyoming'}

In [5]:
dframe['state'] = dframe['city'].map(state_map)

In [6]:
dframe


Out[6]:
altitude city state
0 3158 Alma Colorado
1 3000 Brian Head Utah
2 2762 Fox Park Wyoming

In [ ]: