The Org table is passed in to R as a data.frame, so all you need is this at the
start (with stringr loaded in previously):
#+begin_src R :session :colnames yes :var data=query
t <- str_split_fixed(data$te, " ", 3)
colnames(t) <- c('date','cycle','energy')
t
#+end_src
#+RESULTS:
| date | cycle | energy |
|-----------------+-------+----------------|
| 20210528-053900 | 1 | -1333.58106425 |
| 20210528-053900 | 2 | -1333.25006295 |
| 20210528-053900 | 3 | -1332.40596663 |
| 20210528-053900 | 4 | -1327.1880297 |
| 20210528-053900 | 5 | -1320.63944318 |
Bill
--
William Denton
https://www.miskatonic.org/
Librarian, artist and licensed private investigator.
