Building Arquero on top of a table UI #335
Unanswered
scrapeable
asked this question in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am terrible at JS, but I am trying to build an interface that uses what I guess could be any table UI. I'm opting to use handsontable, with the power to manipulate tabular data using Arquero.
If anyone has ever seen exploratory.io I'm pretty much trying to build the data manipulation part of that.
I think it'd be cool, could work in the browser (exploratory is a desktop app), and probably quite a bit faster (exploratory uses R as it's backend). With Arquero I could use node or just do everything client side, which is my current plan.
Pic of my current bare bones attempt without any Arquero functionality
If not familiar with exploratory it's pretty much just a table with a dropdown menu above columns. The user makes selections from the drop down and depending on the dplyr / tidyr function you want to apply it is either applied right away (sorts) or a modal appears if more inputs are needed by the user (custom calc, window calcs...etc). It's much like radiant, if anyone is familiar that R Shiny app. I find both super useful to quickly test ideas and manipulate data, without needing to write any R code. Both track all of the data manipulation steps so it can be reproducible to other users given the same dataset.
I'm hoping Arquero can be my first good start to finish project I create in JS, with the dplyr type syntax hopefully making things easier. I also think this could be pretty handy if I can figure a way to track all the steps (data manipulations) a user makes so things can be reproducible, even edits made by hand in handsontable, which is unrelated and probably going to be a pain.
Any idea how I could go about tracking or piping together no code steps that a user enters? Right now I'm thinking of just having one object which as a user selects various steps (select, filter, groupby...etc) on the UI I just append them all one after the other with the object being in an evaluate() block. Then when the user clicks a button all of the steps are evaluated. Some of this functionality already exists in handsontable like sorting and filtering but I'm ignoring that for now, I'd rather just try and do it all in Arquero.
Not sure if there are any good examples of someone trying to build a no code type UI with Arquero but if there is that'd be super helpful to look at.
Beta Was this translation helpful? Give feedback.
All reactions