import pandas as pd
import openpyxl 

def preprocess_whisp_data(response): 

    # Get whisp metadata
    # whisp_metadata_url = "https://github.com/forestdatapartnership/whisp/blob/main/whisp_columns.xlsx"
    # df_metadata = pd.read_excel(whisp_metadata_url, engine="openpyxl")

    # Drop irrelevant entries
    preprocessed_response = response['properties']

    return preprocessed_response