Skip to content
henhuy edited this page Mar 11, 2021 · 6 revisions

Commands to format datapackage to correct format:

Replace single- with double-quotes:

sed "s/'/\"/g" oed_scalar.csv > oed_scalar_new.csv

Not very useful, if timeseries have different lengths! Change timeseries seperator from ";" to "," (only valid if series is 12th column and has 8784 values):

awk -F\; '{for (i=1;i<=NF;i++) printf "%s%s",$i,(i==NF?ORS:((i<12 || i>8794)?";":","))}' oed_timeseries.csv > oed_timeseries_new.csv

Clone this wiki locally