Create dataframe from SUMMA output netCDF files for SWE and snow water drainage

create_dfs.py

def create_dfs(path,file):
    '''create df for swe, snow drainage from SUMMA .nc file'''
    ds = xr.open_dataset(path+file)
    
    # create swe dataframe
    df_swe = ds.scalarSWE.to_dataframe()
    df_swe = df_swe.reset_index(level='hru')
    df_swe.drop(['hru'], 1, inplace=True)
    
    # create snow drainage dataframe
    df_sd = ds.scalarSnowDrainage.to_dataframe()
    df_sd = df_sd.reset_index(level='hru')
    df_sd.drop(['hru'], 1, inplace=True)
    
    return [df_swe, df_sd]