用R（或Python）創建帶漸進細分的矩形樹狀圖

Question

我想知道如何处理这个有趣的问题（至少对我来说）。假设我有一个总体，有3个不同的特征变量和一些定量的人口评级。一个例子如下：

df

   income expense education gender residence
1   153      2989 NoCollege      F       Own
2   289       872   College      F      Rent
3   551        98 NoCollege      M      Rent
4   286       320   College      M      Rent
5   259       372 NoCollege      M      Rent
6   631       221 NoCollege      M       Own
7   729       105   College      M      Rent
8   582       450 NoCollege      M       Own
9   570       253   College      F      Rent
10 1380       635 NoCollege      F      Rent
11  409       425 NoCollege      M      Rent
12  569       232 NoCollege      F       Own
13  317       856   College      M      Rent
14  199       283   College      F       Own
15  624       564 NoCollege      M       Own
16 1064       504 NoCollege      M       Own
17  821       169 NoCollege      F      Rent
18  402       175   College      M       Own
19  602       285   College      M      Rent
20  433       264   College      M      Rent
21  670       985 NoCollege      F       Own

我可以计算由三个特征变量定义的支出收入比（SIR）：教育、性别和居住。因此，在第一级，不进行细分，SIR是：

^{pr2}$

然后我把人群分成男性和女性两组，得到：

df %>% group_by(gender) %>% summarise(count=n(), spending_ratio=sum(expense)/sum(income)*100) 
>>   gender count spending_ratio
   1      F     8          138.0
   2      M    13           67.3

我们通过引入教育来继续这一过程：

df %>% group_by(gender, education) %>% summarise(count=n(), spending_ratio=sum(expense)/sum(income)*100)
>>   gender education count spending_ratio
   1      F   College     3          133.1
   2      F NoCollege     5          139.4
   3      M   College     6           72.4
   4      M NoCollege     7           63.9

最后加上residence：

df %>% group_by(gender, education, residence) %>% summarise(count=n(), spending_ratio=sum(expense)/sum(income)*100)
>>  gender education residence count spending_ratio
  1      F   College       Own     1          142.2
  2      F   College      Rent     2          131.0
  3      F NoCollege       Own     3          302.2
  4      F NoCollege      Rent     2           36.5
  5      M   College       Own     1           43.5
  6      M   College      Rent     5           77.3
  7      M NoCollege       Own     4           59.9
  8      M NoCollege      Rent     3           73.4

我想实现的是生成一个包含所有上述信息的treemap-like plot。但正如你所看到的，树状图离我想要的还很远。我想得到的是一个类似于顶部图像的地图，每个矩形的大小代表计数，颜色代表SIR，树的所有级别都包括在内。在

任何帮助我们都深表感激。在

Answer 1

您可以使用treemap包在不同的级别进行聚合，但是输出需要格式化很多。当treemap进行连续聚合时，它将删除数据表. 因此，由于聚合函数需要额外的变量，所以我创建了一些虚拟变量。变量“index”用于索引每个子集的“expense”和“income”。这是你可以做的

library(treemap)
library(data.table)

## Some dummy variables to aggregate by: ALL, i, and index
dat <- as.data.table(df)[, `:=`(total = factor("ALL"), i = 1, index = 1:.N)][]
indexList <- c('total', 'gender', 'education', 'residence')  # order or aggregation

## Function to aggregate at each grouping level (SIR)
agg <- function(index, ...) {
    dots <- list(...)
    expense <- dots[["expense"]][index]
    income <- dots[["income"]][index]
    sum(expense) / sum(income) * 100
}

## Get treemap data
res <- treemap(dat, index=indexList, vSize='i', vColor='index',
               type="value", fun.aggregate = "agg",
               palette = 'RdYlBu',
               income=dat[["income"]],
               expense=dat[["expense"]])  # ... args get passed to fun.aggregate

## The useful variables: level (corresponds to indexList), vSize (bar size), vColor(SIR)
## Create a label variable that is the value of the variable in indexList at each level
out <- res$tm
out$label <- out[cbind(1:nrow(out), out$level)]
out$label <- with(out, ifelse(level==4, substring(label, 1, 1), label))  # shorten labels
out$level <- factor(out$level, levels=sort(unique(out$level), TRUE))     # factor levels

## Time to find label positions, scale to [0, 1] first
## x-value is cumsum by group,  y will just be the level
out$xlab <- out$vSize / max(aggregate(vSize ~ level, data=out, sum)$vSize)
split(out$xlab, out$level) <- lapply(split(out$xlab, out$level), function(x) cumsum(x) - x/2)

## Make plot
library(ggplot2)
ggplot(out, aes(x=level, y=vSize, fill=color, group=interaction(level, label))) +
  geom_bar(stat='identity', position='fill') +  # add another for black rectangles but not legend
  geom_bar(stat='identity', position='fill', color="black", show_guide=FALSE) +
  geom_text(data=out, aes(x=level, y=xlab, label=label, ymin=0, ymax=1), size=6, font=2,
            inherit.aes=FALSE) +
  coord_flip() +
  scale_fill_discrete('SIR', breaks=out$color, labels = round(out$vColor)) +
  theme_minimal() +  # Then just some formatting 
  xlab("") + ylab("") +
  theme(axis.text.x = element_blank(),
        axis.ticks.x = element_blank(),
        axis.text.y = element_blank(),
        axis.ticks.y = element_blank())

编辑

先生，我觉得渐变色效果更好。为此，您只需将fill=color替换为fill=vColor，并通过某种渐变来缩放填充。在

^{pr2}$