Tabulator

This notebook displays a browsable table based on the .csv data base used for intake-esm.

import panel as pn
import pandas as pd
import os
os.makedirs("html",exist_ok=True)
pn.extension('tabulator')

data_base=pd.read_csv("../scripts/conversion/dkrz_era5_disk.csv.gz")
data_base["variable-long_names"].apply(lambda s: eval)
data_base.loc[data_base["variable-long_names"].isna(),"variable-long_names"]="'Not set'"
drs="levelType_dataType_frequency"
for entry in drs.split('_'):
    data_base.loc[data_base[entry].isna(),entry]="'Not set'"

data_base["variable-long_names"]=data_base["variable-long_names"].apply(lambda f: eval(f))
data_base["catalog_entry"]=data_base["levelType"]+'.'+data_base["dataType"]+'.'+ data_base["frequency"]
data_base=data_base.explode("variable-long_names",ignore_index=True)
tabu=pn.widgets.Tabulator(
    data_base[drs.split('_')+["variable-long_names", "catalog_entry"]],
    show_index = False,
    header_filters=True,
    widths={"variable-long_names":200,"catalog_entry":150},
    selectable=1,
    pagination ="local",
    page_size =20
)

tabu.save("html/tabulator.html")

tabu