Spaces:

GIZ
/

chabo_whisp

Running on CPU Upgrade

chabo_whisp / utils /whisp_preprocessing.py

Update utils/whisp_preprocessing.py

95dc6ee verified 8 months ago

532 Bytes

import pandas as pd
import openpyxl 

def preprocess_whisp_data(response): 

    # Retrieve response
    print(response)
    whisp_response = pd.DataFrame(response['properties'])
    whisp_response = whisp_response.melt(var_name="Column", value_name="Value")

    # Load metadata
    whisp_metadata = pd.read_excel('././data/whisp_columns.xlsx')
    
    # Merge datasets
    full_df = pd.DataFrame(whisp_response).merge(whisp_metadata, left_on="Column", right_on="Column name").drop(columns={"Column name"})

    return full_df

	import pandas as pd
	import openpyxl

	def preprocess_whisp_data(response):

	# Retrieve response
	print(response)
	whisp_response = pd.DataFrame(response['properties'])
	whisp_response = whisp_response.melt(var_name="Column", value_name="Value")

	# Load metadata
	whisp_metadata = pd.read_excel('././data/whisp_columns.xlsx')

	# Merge datasets
	full_df = pd.DataFrame(whisp_response).merge(whisp_metadata, left_on="Column", right_on="Column name").drop(columns={"Column name"})

	return full_df