Skip to content

IDEA: Parallel Coordinates and Parallel Sets mixed to interactively filter tables with, creating SQL simultaneously

Notifications You must be signed in to change notification settings

steltenpower/query-by-viz

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 

Repository files navigation

Query by viz


All ingredients needed exist in some shape or form. I just haven't seen them combined. I see it as a general table filtering tool.

Parallel Sets recalculated into Parallel Coordinates is a good start. Let's try:

n1, n2, n3, etc., parallel_sets mapped on 0-1 parallel_coordinates
N=sum(n1,n2,n3,..)
stroke-width = 1/N
y= (i-1/2) * (1/N)

Within the set keep the same order as in the neighboring coordinates, or if you have coordinates on both sides, take a sort of average.

If built, it would help many more people from a proper home, therefore I suggested it to GGally: ggobi/ggally#473

JMP software does ParallelCoordinates and ParallelSets chart types combined in one chart

https://vizhub.com/curran/parallel-coordinates-with-brushing

Here you see the chart types coupled, but below each other, interacted with: Parallel coordinates and parallel sets together seems like a great exploratory data analysis tool

To be reproducible (or replayable on a different data set) you need the GUI-actions captured and possible to replay: shinymeta, making GUI-actions reproducible

https://plotly.com/python/parallel-coordinates-plot/

Now if you could turn your shinyGUI-actions into the more generally used SQL, it would make it awesome power tool. (tidyverse<>SQL things exist, e.g. https://dbplyr.tidyverse.org/articles/translation-verb.html ), would be close to perfect

Quak: https://github.com/manzt/quak

Possible application:

For material properties: Ashby plots, also see https://www.ansys.com/products/materials/granta-edupack (Nog in Blackboard onder "Start" in lijst?)

other exploratory data visualization:

DataExplorer create_report() function in R

About

IDEA: Parallel Coordinates and Parallel Sets mixed to interactively filter tables with, creating SQL simultaneously

Topics

Resources

Stars

Watchers

Forks