Build Midi Map

Mix.install(
  [
    {:explorer, "~> 0.10.0"},
    {:kino_explorer, "~> 0.1.24"}
  ]
)

Section

require Explorer.DataFrame, as: DF
require Explorer.Series, as: S

df = DF.from_csv!(Path.expand("~/src/music_build/midi_instrument_map.csv"), delimiter: ",")

df = DF.sort_by(df, col("PC"))

df1 = DF.transform(df, [names: ["PC"]], fn row -> 
  r = row["PC"] - 1
  %{PC: r}
end)
|> DF.select(["PC_1", "Instrument"])
|> DF.rename(["PC", "Instrument"])

DF.to_csv!(df1, Path.expand("~/src/music_build/midi_instrument_map.csv"))