BLUE
Profile banner
MW
Matt Worthington
@mrworthington.bsky.social
Husband, parent | Policy + Data Science | Serves w/ @ATXDVCC + @DelValleISD Board | @spurs & SATX native | Used to flip @Whataburger | #rstats + #txlege 🤓
40 followers57 following22 posts
MWmrworthington.bsky.social

Like, pivoting a table in the browser and serving the output out in a nicely formatted table, *without a server*, is just so fantastically efficient and clean.

0
MWmrworthington.bsky.social

I’ve found ChatGPT to be very helpful for these kinds of tasks. Still struggling with grouped rows in a table, though!

0
MWmrworthington.bsky.social

Maaaaaannn… the combo of DuckDB, Arquero, Observable Plot, and Quarto Dashboards is ridiculously good for so many ideas. For all my #rstats peeps, I still use R in these workflows, but almost entirely for the pre-processing and data engineering side of things.

1
MWmrworthington.bsky.social

This post is has been a Rosetta Stone for me as I’ve been working in JS more and more.

0
MWmrworthington.bsky.social

Had no idea. Are there good docs for it online?

0
MWmrworthington.bsky.social

First go w/ Docker in GH Actions today + I’m sold! For anyone interested, here’s the repo I created to learn how to do it! LT goal is using GH Actions, R, + Docker to build pipelines that feed parquet files to DuckDB in quarto dashboards w/ OJS data viz. github.com/mrworthingto...

GitHub - mrworthington/irs_migration_data: This is a repo that downloads and organizes US migration data for consumption into a Quarto Dashboard
GitHub - mrworthington/irs_migration_data: This is a repo that downloads and organizes US migration data for consumption into a Quarto Dashboard

This is a repo that downloads and organizes US migration data for consumption into a Quarto Dashboard - mrworthington/irs_migration_data

0
MWmrworthington.bsky.social

Thank you x 1M, Bob. Seriously.

1
MWmrworthington.bsky.social

Just learned about tabulator right before you posted this. Gonna dig in and see what I can do! My long term goal is to be able to have apps that load millions of rows of data with DuckDB and render speedy charts, tables, and maps. Plot gets you a lot of the way there, but not every use case.

1
MWmrworthington.bsky.social

That said, I did find this notebook very interesting. It preprocesses HTML in the table and serves that up to Inputs.table(). Seems like it could be very useful in certain cases. NB: observablehq.com/@mauforonda/...

1
MWmrworthington.bsky.social

Yeah, load speed is def the first requirement but this is amazing that you can combined webR + OJS. I learned from a few of your OJS notebooks how to optimize page speeds w/ @DuckDB loaders. So, so fast. Only thing holding me up w/ ⚡️ fast page builds is building nice tables.

0
Profile banner
MW
Matt Worthington
@mrworthington.bsky.social
Husband, parent | Policy + Data Science | Serves w/ @ATXDVCC + @DelValleISD Board | @spurs & SATX native | Used to flip @Whataburger | #rstats + #txlege 🤓
40 followers57 following22 posts