In [1]:

    

import numpy as np
import pandas as pd
from pandas import Series,DataFrame


    

In [2]:

    

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


    

    
Out[2]:






  

    

      

      
altitude
      
city
    
  
  

    

      
0
      
3158
      
Alma
    
    

      
1
      
3000
      
Brian Head
    
    

      
2
      
2762
      
Fox Park
    
  

In [3]:

    

state_map = {'Alma':'Colorado','Brian Head':'Utah','Fox Park':'Wyoming'}

state_map


    

    
Out[3]:





{'Alma': 'Colorado', 'Brian Head': 'Utah', 'Fox Park': 'Wyoming'}

In [4]:

    

df['state'] = df['city'].map(state_map)

df


    

    
Out[4]:






  

    

      

      
altitude
      
city
      
state
    
  
  

    

      
0
      
3158
      
Alma
      
Colorado
    
    

      
1
      
3000
      
Brian Head
      
Utah
    
    

      
2
      
2762
      
Fox Park
      
Wyoming
    
  

In [ ]: