search

WCRP-CORDEX / data-request-table

Machine readable data request tables
MIT License
0 stars 0 forks source link

dimension order #6

Closed larsbuntemeyer closed 8 months ago

larsbuntemeyer commented 8 months ago

should be X Y Z T.

larsbuntemeyer commented 8 months ago

here is how if fix it:

df = pd.read_csv("CORDEX-CMIP6/data-request.csv")
pd.set_option('display.max_rows', None)

def fix_order(dims):
    dims[-2], dims[-1] = dims[-1], dims[-2]
    return " ".join(dims)

def fix_dimension_order(df):
    to_fix = df[df.dimensions.str.split().map(len)==4]
    dims = to_fix.dimensions.str.split()
    return dims.map(fix_order)

fixed = fix_dimension_order(df)
df.loc[fixed.index, "dimensions"] = fixed