Hi, had a question about splitting a single column into multiple new columns. Let’s say I have a table with a column like this:
Table with 8434 rows, 2 columns:
STATION WND
───────────────────────────────
"72473323170" "999,9,C,0000,1"
"72473323170" "010,1,N,0015,1"
"72473323170" "150,1,N,0021,1"
"72473323170" "999,9,C,0000,1"
"72473323170" "120,1,N,0026,1"
"72473323170" "150,1,N,0041,1"
"72473323170" "140,1,N,0051,1"
"72473323170" "140,1,N,0046,1"
"72473323170" "150,1,N,0041,1"
"72473323170" "150,1,N,0036,1"
Is there a more efficient way to split that second column up by the comma and generate new columns aside from:
pushcol(tbl, :new_column => getindex.(split.(select(tbl, :WND), ','), 1)), :new_column2 => etc...
Thanks!