mrworthingtonOn a related note, I’m wondering how folks make nice tables in @observablehq with similar quality to reactable or gt in #rstats? I know of tan stack table, but wondering if there’s anything similar to how Plot offers a lot of JS equivalent functionality to what ggplot2 does in #rstats?
James Goldie@mrworthington @observablehq Bit of a left-field suggestion here: if you have the data generated, you could potentially just generate the table HTML directly with Observable's HTL. So something like this: https://observablehq.com/@jimjamslam/hypertext-literal-table
@observablehq @jimjamslam not left-field and I appreciate it cause it does help me answer my question in part. I would say I’m primarily interested in interactive tables, which Inputs.table() helps with. I could be wrong, but it seems to be missing features like grouping rows by a column, column formatting, and more dataviz options for numeric columns. It may be also already be there and not well documented, but just striking out a lot and seeing if anyone else has ideas.
@mrworthington @observablehq Makes sense! This is just raw HTML, so grouping, formatting options are all possible but have to be manually written in HTML
timelyportfolio@jimjamslam @mrworthington @observablehq this example doesn’t really do tabulator justice since it is loaded with features https://observablehq.com/@fil/hello-tabulator
You can even feed it an html table. I will try to work up some examples.
@jimjamslam @mrworthington @observablehq forked example, updated to 6.2.1, and demonstrated some features
@observablehq @timelyportfolio @jimjamslam FWIW, I found this repo, which is really interesting. It uses Inputs.table(), but prestyled html in the cell. Makes me think you could do some preprocessing in R and pass to Inputs.table for *some* custom HTML output that’s programmatic.
Repo: https://observablehq.com/@mauforonda/datos-geograficos-del-gobierno-boliviano
Datos geográficos del gobierno boliviano
dependencias descarga de datos configuración por sistemas estado mapa estilo share urls Este índice de datos es actualizado cada día desde febrero de 2022. El código que lo produce es abierto. Si tienes una consulta, conoces fuentes que no estén acá o quieres hablar sobre datos abiertos, mi correo es [email protected]
@mrworthington @observablehq @timelyportfolio If you don't mind sacrificing row grouping, Inputs.table() with some custom HTML is a good compromise 😊 If you don't want to write all of the HTML in R (which could bump your data size up), you can also add it in JS between loading and rendering, using a library like Arquero (essentially a JS version of dplyr/tidyr): https://observablehq.com/@uwdata/introducing-arquero
Introducing Arquero
Arquero is a library for query processing and transformation of array-backed data tables. Following the relational algebra and inspired by the design of dplyr, Arquero provides a fluent API for manipulating column-oriented data frames. Arquero supports a range of data transformation tasks, including filter, sample, aggregation, window, join, and reshaping operations. This notebook provides a hands-on introduction to the two core abstractions in Arquero: data tables and transformation verbs. By the end, you
@jimjamslam @observablehq @timelyportfolio would be down w/ any approach to preprocessing as I’m a fan of Arquero (but mostly DuckDB)! Still do a lot of grouped tables, so I’m kind of stuck there. 😕
@mrworthington @observablehq @timelyportfolio It's not as pretty as a real grouped table, but you could group the data and make a separate table for each one 🤔