Documentation request: Joining datasets

[iainmwallace]

Hi,

Could you provide an example of how to annotate or join across datasets using the R client?

For example, how could I replicate something like below if I had the datasets "planes" and "flights" saved to a vault?

library(nycflights13)
library(dplyr)
planes%>%
filter(engines==2)%>%
left_join(flights)

Thanks!

Iain

[davecap]

Hi Iain,

Unfortunately there is no way to do a SQL-like join across datasets on SolveBio, but you can use our annotation system to pull data together from various datasets. There are some docs available here:

Dynamic annotation (docs are Python only but I recently added R support and will update the docs)
https://docs.solvebio.com/guides/annotations/

Dataset migrations (add/edit columns, create new datasets with annotated columns):
https://docs.solvebio.com/guides/datasets/migrations/

The expression language:
https://docs.solvebio.com/guides/expressions/

I'll make sure the docs are updated with R examples for the above.

[iainmwallace]

Thanks Dave, that sounds great.

Could you document how one could annotate the flights table with the engine count from the plane table? This dataset is widely used to demonstrate techniques in the tidy verse.

[davecap]

Ah I see what you mean now, that's a good idea I'll put something together.