In [5]:
import pandas as pd
from pandas import ExcelWriter
from pandas import ExcelFile
df = pd.read_excel('https://data.london.gov.uk/download/homelessness/7b28ad56-5698-4ea0-9a94-f301fcb62b3e/statutory-homelessness-borough%202017-18%20revised.xls', '2017-18')
df.iloc[21, 26]


Out[5]:
12.7

In [3]:
import matplotlib.pyplot as plt
plt.plot([1, 2, 3, 4])
plt.ylabel('some numbers')
plt.show()



In [ ]: