In [1]:

    

import pandas as pd
import matplotlib.pyplot as plt
import matplotlib.ticker as mticker
%matplotlib inline


    

In [4]:

    

df = pd.read_excel('data/2013_NYC_CD_MedianIncome_Recycle.xlsx')
df.shape


    

    
Out[4]:





(59, 3)

In [7]:

    

df.plot(kind='scatter', x='MdHHIncE', y='RecycleRate')


    

    
Out[7]:





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






    

In [11]:

    

print("The correlation is", df.corr()['MdHHIncE']['RecycleRate'])


    

    




The correlation is 0.884783182785