In [18]:

    

%matplotlib inline

import pandas as pd
import matplotlib.pyplot as plt


    

In [19]:

    

df = pd.read_excel('data/price-of-a-latte-around-the-world.xlsx')

pd.to_numeric(df['Latte Price in U.S. Dollars'])

df.head()


    

    
Out[19]:







  

    

      

      
City
      
Currency
      
Latte Price in U.S. Dollars
    
  
  

    

      
0
      
Zurich
      
Swiss franc
      
5.76
    
    

      
1
      
Hong Kong
      
Hong Kong dollar
      
4.36
    
    

      
2
      
Singapore
      
Singapore dollar
      
4.24
    
    

      
3
      
Beijing
      
Chinese yuan
      
4.22
    
    

      
4
      
Shanghai
      
Chinese yuan
      
4.22
    
  

In [29]:

    

print(plt.style.available)
plt.style.use('seaborn')


    

    




['_classic_test', 'bmh', 'classic', 'dark_background', 'fast', 'fivethirtyeight', 'ggplot', 'grayscale', 'seaborn-bright', 'seaborn-colorblind', 'seaborn-dark-palette', 'seaborn-dark', 'seaborn-darkgrid', 'seaborn-deep', 'seaborn-muted', 'seaborn-notebook', 'seaborn-paper', 'seaborn-pastel', 'seaborn-poster', 'seaborn-talk', 'seaborn-ticks', 'seaborn-white', 'seaborn-whitegrid', 'seaborn', 'Solarize_Light2']

In [43]:

    

df.plot(kind='barh', x='City', y='Latte Price in U.S. Dollars',
        title='The price of a latte around the world', fontsize=24, figsize=(20, 15))


    

    
Out[43]:





<matplotlib.axes._subplots.AxesSubplot at 0x109d36b38>






    

In [ ]: