Data were munged here.



In [1]:

    
import pandas as pd
import numpy as np
from IPython.core.display import display, HTML
display(HTML("<style>.container { width:100% !important; }</style>"))
df = pd.read_csv('../../data/processed/complaints-3-25-scrape.csv')

How many substantiated complaints occured by the time Marian Ewins moved to Washington Gardens?

Marian Ewins moved in to Washington Gardens in May, 2015.



In [12]:

    
move_in_date = '2015-05-01'

The facility_id for Washington Gardens is 50R382.



In [16]:

    
df[(df['facility_id']=='50R382') & (df['incident_date']<move_in_date)].count()[0]









    Out[16]:





10