Hierarchical data representation for sunburst/treemaps/radial tree

[barveaditya]

Hello,

I have been trying to plot my data using sunburst in a Shiny app, however the example (below) has a manually specified structure, which is not possible for me to code as part of a shiny visualisation. I have to do it programmatically, but even using tidyr::nest does not help as it does not allow the same name to multiple hierarchies. Is there another data format that I could use.

The example is below:

df <- tibble(
  name = c("earth", "mars", "venus"), value = c(30, 40, 30),        # 1st level
  itemStyle = tibble(color = c(NA, 'red', 'blue')),     # embedded styles, optional
  children = list(
    tibble(name = c("land", "ocean"), value = c(10,20),             # 2nd level
           children = list(
             tibble(name = c("forest", "river"), value = c(3,7)),   # 3rd level 
             tibble(name = c("fish", "kelp"), value = c(10,5),
                    children = list(
                      tibble(name = c("shark", "tuna"), value = c(2,6)),  # 4th level 
                      NULL  # kelp
                    ))
           )),
    tibble(name = c("crater", "valley"), value = c(20,20)),
    NULL  # venus
  )
)

for example, how would one convert the following data frame in a data structure accepted by e_sunburst programmatically?

df = data.frame(labels = c("Eve", "Cain", "Seth", "Enos", "Noam", "Abel", "Awan", "Enoch", "Azura"),
                parents = c("", "Eve", "Eve", "Seth", "Seth", "Eve", "Eve", "Awan", "Eve"),
                values = c(10, 14, 12, 10, 2, 6, 6, 4, 4))

This issue is as important as e_sunburst as one cannot use these great visualisations otherwise!

[JohnCoene]

I know, it's an absolute pain.

In a previous version it accepted a data.frame but was limited to one level of nesting. It's due to the underlying structure that echarts expects here it's rather convoluted

Ideally we'd have a recursive function go over the data.frame to produce the list but multiple attempts of mine have all ended failures.

[barveaditya]

Hi John,

Thank you for the reply. 👍 I have posted the question on stackoverflow [https://stackoverflow.com/questions/64240732/is-there-a-programmatic-way-to-create-in-r-create-a-nested-list-of-tibbles
], but nothing yet. Will keep trying and update if I get it! :)

[helgasoft]

@barveaditya - try this with library data.tree

library(echarts4r)
df <- data.frame(parents = c("","earth", "earth", "mars", "mars", "land", "land", "ocean", "ocean", "fish", "fish", "Everything", "Everything", "Everything"),
                 labels = c("Everything", "land", "ocean", "valley", "crater", "forest", "river", "kelp", "fish", "shark", "tuna", "venus","earth", "mars"),
                 value = c(0, 30, 40, 10, 10, 20, 10, 20, 20, 8, 12, 10, 70, 20))
library(data.tree)
universe <- FromDataFrameNetwork(df)
jsonl <- ToListExplicit(universe, unname=TRUE)
jsonl$children[[1]]$children %>% e_charts() %>% e_sunburst()

[JohnCoene]

Thanks @helgasoft, I'll see if I can bring support for this in the package (passing {data.tree} Node to e_charts)

[barveaditya]

oh this is brilliant @helgasoft Fantastic. I am very happy! :) @JohnCoene - thanks in advance for bringing in support.
Cheers,
Adi

[JohnCoene]

I just pushed a change to the e_charts so it supports these objects out-of-the box.

df <- data.frame(parents = c("","earth", "earth", "mars", "mars", "land", "land", "ocean", "ocean", "fish", "fish", "Everything", "Everything", "Everything"),
                 labels = c("Everything", "land", "ocean", "valley", "crater", "forest", "river", "kelp", "fish", "shark", "tuna", "venus","earth", "mars"),
                 value = c(0, 30, 40, 10, 10, 20, 10, 20, 20, 8, 12, 10, 70, 20))

# create a tree object
universe <- data.tree::FromDataFrameNetwork(df)

# use it in echarts4r
universe %>% 
  e_charts() %>% 
  e_sunburst()

[barveaditya]

Brilliant. I tested it too. All good. Thank you for making this simpler @JohnCoene @helgasoft

[barveaditya]

@JohnCoene while you fixed the above for e_sunburst, the same doesn't work for e_tree

universe %>% e_charts() %>% e_tree() just shows me venus. Any ideas?

[helgasoft]

Yes, e_tree is a little different

library(echarts4r)
library(data.tree)
df <- data.frame(parents = c("","earth", "earth", "mars", "mars", "land", "land", "ocean", "ocean", "fish", "fish", "Everything", "Everything", "Everything"),
                 labels = c("Everything", "land", "ocean", "valley", "crater", "forest", "river", "kelp", "fish", "shark", "tuna", "venus","earth", "mars"),
                 value = c(0, 30, 40, 10, 10, 20, 10, 20, 20, 8, 12, 10, 70, 20))
universe <- FromDataFrameNetwork(df)
jsonl <- ToListExplicit(universe, unname=TRUE)
jsonl$children %>% e_charts() %>% e_tree()

[helgasoft]

Did you check the help '?e_tree'

e_tree(label = list(offset = c(0, -11)))  # works

[barveaditya]

@helgasoft Yes, unfortunately right after I put it in here. :) which is why I deleted it, but I guess you already got an email! :) Thank you for getting back nonetheless. I am trying to look at echarts doc to enable some very cool looking features. :)
Now that I have you here, how would I scale the size of each node in the tree dependent on their value?