import pandas as pd

data = pd.read_excel(
    "/Users/khalimconn-kowlessar/Downloads/Lambeth Reknocks.xlsx", sheet_name="Possible Route",
    header=1
)

data["Outcomes"].value_counts()

# Strip out: No

df = data[data["Outcomes"] == "See notes"]
notes_df = df[
    ("Notes (If 'no answer' under outcomes, have you checked around the property for access issues where "
     "possible?)")].value_counts().to_frame()

example = df[df["Notes (If 'no answer' under outcomes, have you checked around the property for access issues where "
                "possible?)"] == ('Access to rear of property only through number 10. Overgrown athe rear of property '
                                  'installer wont be able to access')
             ]

# 18 did not attend
#
