Something went wrong. Try again.
A projectional editor that uses textual code as its source of truth. puredit.korz.dev
svelte dsl
Something went wrong. Try again.
12345678910111213import puredit.dsl as dsl
# load sheet "raw data " from "Raw data Chromatography.xlsx":with dsl.load_sheet("Raw data Chromatography.xlsx", "raw data ") as sheet: # take K, L from K4:L35 where isinstance(L, int) K, L = sheet.take("K4:L35", "isinstance(L, int)") # join A, B from A4:B46704 on K where abs(K - A) is minimal A, B = sheet.join("A4:B46704", K, "abs(K - A)", dsl.AggregationMethod["minimal"]) # store K, L, B in sheet "output" of "output.xlsx" dsl.store_sheet("output.xlsx", "output", [K, L, B]) # display K, L, B dsl.display([K, L, B])