>
>
>
> This should also be possible but I cannot get it to work now:
>
> #+begin_src R :var recipe=recipe :var nutrition=nutrition :colnames yes
> :prologue sqldf(' :epilogue ')
> select * from recipe, nutrition where recipe.type=nutrition.type
> #+end_src
>
>
>
>
>
&g
Thanks for the link! It looks like some useful functions there. It would
be nice to integrate some of those with the rich output of a Jupyter
kernel so you could get native org tables automatically in org-mode.
Derek Feichtinger writes:
> Hi John,
>
> I invested time some years ago in preparing
Malcolm, thanks, and, yes, i'm of mixed mind, myself. cheers, Greg
02:13
To: Cook, Malcolm
Cc: John Kitchin ; Tim Cross ;
org-mode-email
Subject: Re: state of the art in org-mode tables e.g. join, etc
ATTENTION: This email came from an external source. Do not open attachments or
click on links from unknown senders or unexpected emails.
Malcolm,
> Check
Hi John,
I invested time some years ago in preparing babel examples, and a lot of
the description went into using tables. The most detailed documents I
had for elisp and python.
In order to be productive, e.g. for producing all kinds of scientific
graphs, but also for doing the finances and
Malcolm,
> Checkout what R sqldf package makes easy:
very nice!
Greg
ps -- (feeling a challenge... :) for base R, dplyr::inner_join, the
following seem to work (i apologize that i don't know how people embed
org-frags in e-mail, or how important that format might be?)
#+NAME: original
|
where recipe.type=nutrition.type
#+end_src
From: Emacs-orgmode On Behalf
Of John Kitchin
Sent: Sunday, February 21, 2021 10:24
To: Tim Cross
Cc: org-mode-email
Subject: Re: state of the art in org-mode tables e.g. join, etc
ATTENTION: This email came from an external source. Do not open
For fun, here is the sqlite equivalent of the Pandas example using the same
tables as before
** aggregation example
Examples from https://github.com/tbanel/orgaggregate
#+NAME: original
| Day | Color | Level | Quantity |
|---+---+---+--|
| Monday| Red |
Thanks Tim and Greg. I had mostly come to the same conclusions that it is
probably best to outsource this. I worked out some examples from
the orgtbljoin and orgaggregate packages with Pandas below, in case anyone
is interested in seeing how it works. A key point is using the ":colnames
no" header
Greg Minshall writes:
> John,
>
>> Is there a state of the art in using org-tables as little databases
>> with joins and stuff?
>
> i have to admit i do all that with an R code source block. (the dplyr
> package has the relevant joins, e.g. dplyr::inner_join().) and, in R,
> ":colnames yes"
John,
> Is there a state of the art in using org-tables as little databases
> with joins and stuff?
i have to admit i do all that with an R code source block. (the dplyr
package has the relevant joins, e.g. dplyr::inner_join().) and, in R,
":colnames yes" as a header argument gives you header
Is there a state of the art in using org-tables as little databases with
joins and stuff?
This package https://github.com/tbanel/orgtbljoin
seems close, but not quite what I had in mind. I don't want to modify
tables in place, or create dynamic tables. I do want to combine tables in
memory
12 matches
Mail list logo