假设已有图书销售信息的数据框为books,其中包含作者(author)、年份(year)和销售份数(copies_sold)等变量。
library(dplyr)
books_sum <- books %>%
group_by(author, year) %>%
summarise(total_copies = sum(copies_sold))
books_avg <- books_sum %>%
group_by(author) %>%
summarise(avg_copies = mean(total_copies))
books_avg_sorted <- books_avg %>%
arrange(desc(avg_copies))
print(books_avg_sorted)
这样就可以将每个作者按每年销售的图书份数降序打印出来了。
上一篇:按每秒字节数排序视频