Spaces:
Sleeping
Sleeping
File size: 1,009 Bytes
28ccc4e | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | import pandas as pd
import numpy as np
def feature_engineering(input_df: pd.DataFrame) -> pd.DataFrame:
# Get season
def get_season(month):
if month in [12, 1, 2]:
return 'Winter'
elif month in [3, 4, 5]:
return 'Spring'
elif month in [6, 7, 8]:
return 'Summer'
else:
return 'Autumn'
input_df['season'] = input_df['month'].apply(get_season)
# Soil ratios
input_df['soil_total'] = input_df['sand'] + input_df['silt'] + input_df['clay']
input_df['soil_total'] = input_df['soil_total'].replace(0, np.nan)
input_df['sand_ratio'] = input_df['sand'] / input_df['soil_total']
input_df['silt_ratio'] = input_df['silt'] / input_df['soil_total']
input_df['clay_ratio'] = input_df['clay'] / input_df['soil_total']
input_df = input_df.drop(columns=['soil_total'])
# Combined feature
input_df['soc_cec'] = input_df['soc'] * input_df['cec']
return input_df
|