How to update table rows based on another table?

[ericemc3]

As an extension to the join functions,
i find these tidyverse functions really useful : https://dplyr.tidyverse.org/reference/rows.html

Especially 2 of them:
rows_update : like SQL UPDATE
rows_upsert : UPDATE and also INSERT missing rows

[jheer]

Thanks! Arquero does not provide these methods, but the included verbs can be used to perform nearly identical operations. To demonstrate, here is a notebook that mirrors the dplyr row manipulation documentation examples: https://observablehq.com/@uwdata/arquero-row-manipulation

And, of course, the standard concat and union verbs can also perform "inserts".

[ericemc3]

Thank you once again for the examples and the great documentation effort.

Here is my own exploitation of these examples :
https://observablehq.com/@ericmauviere/arquero-table-utils

By the way, i find your edge, hconcat methods truly expressive!