This data should be pulled live from the AirTable base, but I ain’t trying to mess with that API right now, so I’m just working from a CSV export.

Project frequency by industry focus

Try it as a pie chart

And as a waffle chart

Pretty colors, but too many categories for it to work

Same chart, faceted by funding method. Include the compound group of ICO + Professional

This collapsed view highlights: projects that received professional investment

Sources of funding

Sunburst chart

inner circle = FUNCTION outer circle = INDUSTRY.FOCUS

Visually this is a pretty cool way to capture both of our ‘lenses’: industry and function. But as a dataviz I don’t think it illuminates much. Might be worth a little more exploration to see if we can make it useful (e.g. better labels)

x = df %>% 
  group_by(FUNCTION, INDUSTRY.FOCUS) %>% 
  summarise(count = n()) %>% 
  mutate(path = paste(FUNCTION, INDUSTRY.FOCUS, sep='-')) %>% 
  ungroup() %>% 
  select(path, count)

 sunburst(x)
Legend