what's the best "thing" you have seen/read to turn...
# thinking-togetherm
Mariano Guerra
01/31/2022, 7:24 PM
what's the best "thing" you have seen/read to turn a tree into a table? something like jq
visual things more than welcome
m
Matthew Linkous
01/31/2022, 10:13 PMTrusty
console.tablem
Mariano Guerra
01/31/2022, 10:17 PM
data already has to have a tabular structure
Mariano Guerra
01/31/2022, 10:17 PM
I mean flatten a subset of a deeply nested tree into a table
m
Matthew Linkous
01/31/2022, 10:22 PMyeah for some reason I thought it did by concatenating key names as it recursed down an arbitrary but that must’ve been a different tool
t
Tom Larkworthy
02/01/2022, 2:22 PMunderscore flatten or d3 merge ?
quite often I just use reduce tho
m
Mariano Guerra
02/01/2022, 2:44 PM
not generic enough, I mean something like a graphql result or an ast
t
Tom Larkworthy
02/01/2022, 2:54 PMliek XPATH kinda thing
Tom Larkworthy
02/01/2022, 2:58 PMOh I have used this one before https://www.npmjs.com/package/jsonpath, though I later found I could get away with underscores _.get(object, path, [default]) for my application
Tom Larkworthy
02/01/2022, 2:59 PMif you are doing complex queries it might be worth loading sqlite.js
Tom Larkworthy
02/01/2022, 4:23 PMor by table are you asking for a dataframe type thingy? https://github.com/uwdata/arquero I guess I am confused by what you are looking for. The term 'table' is ambiguous (SQL table, HTML Table, Mathematical Table) and hardly relates to jq in my world.
t
Tony O'Dell
02/03/2022, 2:46 AM@dnmfarrell has a jq like module written in bash if you're using it in the command line. https://github.com/dnmfarrell/jp/
2 Views