Loading [MathJax]/jax/output/CommonHTML/config.js
首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
社区首页 >问答首页 >R中从长到宽的格式

R中从长到宽的格式
EN

Stack Overflow用户
提问于 2021-11-11 06:19:00
回答 1查看 39关注 0票数 1

我有一个1992年在不同地点收集的幼鱼长度的数据集。我还为每个值分配了一个uniqueID (由于之前使用pivot_wider函数时出现的错误)。数据如下:

代码语言:javascript
运行
AI代码解释
复制
df<-structure(list(year = c(92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 
92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L, 92L
), site = structure(c(5L, 5L, 5L, 5L, 5L, 5L, 5L, 5L, 5L, 3L, 
3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 3L, 4L, 
4L, 6L, 6L, 6L, 7L, 7L, 7L, 7L, 13L, 13L, 13L, 13L, 13L, 13L, 
13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 12L, 
12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 
12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 
12L, 12L, 12L, 12L, 12L, 12L, 12L, 12L, 15L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 18L, 
18L, 18L, 18L, 18L, 18L, 19L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 
20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 
20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 
20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 
20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 
20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 
20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 20L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 
21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 21L, 22L, 22L, 22L, 
22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 
22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 
22L, 22L, 22L, 22L, 22L, 22L, 22L, 22L, 23L, 23L, 23L, 23L, 23L, 
23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 
23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 23L, 
23L, 23L, 23L, 23L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 
24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 
24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 
24L, 24L, 24L, 24L, 24L, 24L, 24L, 24L, 25L, 25L, 25L, 25L, 25L, 
25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 
25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 
25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 25L, 
26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 
26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 
26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 
26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 
26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 
26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 
26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 26L, 27L, 28L, 28L, 
28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 
28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 
28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 28L, 
28L, 28L, 28L, 29L, 29L, 29L, 29L, 29L, 29L, 29L, 29L, 29L, 29L, 
29L, 29L, 30L, 30L, 30L, 31L, 31L, 31L, 31L, 31L, 31L, 31L, 31L, 
31L, 31L, 31L, 32L, 32L, 32L, 32L, 33L, 33L, 33L, 33L, 33L, 33L, 
33L, 33L, 33L, 34L, 35L, 35L, 35L, 35L, 35L, 35L, 35L, 35L, 35L, 
35L, 35L, 35L, 35L, 35L, 35L, 36L, 36L, 36L, 36L, 36L, 37L, 37L, 
37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 
37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 
37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 37L, 38L, 38L, 
38L, 38L, 38L, 38L, 38L, 39L, 39L, 39L, 39L, 40L, 40L, 40L, 41L, 
41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 
41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 
41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 
41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 
41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 
41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 
41L, 41L, 41L, 41L, 41L, 41L, 41L, 41L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 42L, 
42L, 42L, 42L, 42L, 43L, 43L, 43L, 43L, 43L, 44L, 44L, 44L, 44L, 
44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 
44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 
44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 
44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 44L, 
44L, 44L, 44L, 44L, 44L, 44L, 44L), .Label = c("1", "2", "3", 
"5", "10", "16", "17", "18", "19", "20", "26", "27", "28", "29", 
"30", "32", "33", "34", "35", "40", "41", "46", "50", "51", "52", 
"53", "57", "58", "65", "67", "68", "69", "70", "71", "72", "75", 
"76", "77", "78", "79", "80", "81", "84", "85"), class = "factor"), 
    length = c(64L, 71L, 70L, 64L, 53L, 55L, 53L, 61L, 74L, 62L, 
    66L, 65L, 57L, 66L, 71L, 65L, 74L, 68L, 70L, 67L, 73L, 67L, 
    71L, 45L, 50L, 60L, 70L, 96L, 133L, 72L, 127L, 69L, 66L, 
    68L, 142L, 52L, 68L, 62L, 67L, 65L, 147L, 167L, 157L, 145L, 
    136L, 128L, 146L, 144L, 129L, 121L, 130L, 129L, 200L, 124L, 
    101L, 86L, 83L, 90L, 59L, 61L, 88L, 57L, 56L, 59L, 67L, 58L, 
    47L, 59L, 43L, 89L, 65L, 71L, 71L, 69L, 62L, 68L, 65L, 60L, 
    61L, 63L, 62L, 61L, 43L, 64L, 67L, 85L, 35L, 176L, 197L, 
    66L, 46L, 44L, 43L, 42L, 45L, 45L, 178L, 77L, 40L, 66L, 42L, 
    62L, 47L, 71L, 42L, 74L, 60L, 58L, 45L, 49L, 50L, 65L, 46L, 
    60L, 48L, 36L, 40L, 46L, 38L, 46L, 43L, 37L, 46L, 51L, 57L, 
    69L, 69L, 41L, 44L, 42L, 63L, 47L, 44L, 43L, 47L, 49L, 37L, 
    47L, 46L, 40L, 44L, 45L, 38L, 41L, 47L, 47L, 54L, 37L, 43L, 
    47L, 42L, 39L, 39L, 44L, 39L, 45L, 47L, 38L, 42L, 65L, 41L, 
    44L, 38L, 42L, 42L, 42L, 42L, 42L, 42L, 45L, 36L, 43L, 48L, 
    44L, 40L, 44L, 44L, 41L, 39L, 40L, 36L, 42L, 41L, 43L, 38L, 
    39L, 44L, 40L, 47L, 43L, 50L, 44L, 45L, 36L, 46L, 43L, 46L, 
    38L, 39L, 49L, 40L, 232L, 222L, 131L, 154L, 151L, 75L, 44L, 
    40L, 44L, 44L, 43L, 46L, 223L, 198L, 167L, 146L, 84L, 45L, 
    50L, 42L, 40L, 47L, 40L, 45L, 55L, 40L, 51L, 42L, 46L, 43L, 
    46L, 40L, 42L, 45L, 50L, 40L, 44L, 48L, 44L, 42L, 56L, 43L, 
    46L, 39L, 40L, 46L, 41L, 40L, 37L, 49L, 46L, 40L, 43L, 42L, 
    43L, 46L, 40L, 42L, 45L, 50L, 40L, 44L, 48L, 44L, 42L, 56L, 
    43L, 46L, 39L, 40L, 46L, 41L, 40L, 37L, 49L, 46L, 40L, 43L, 
    42L, 45L, 44L, 40L, 44L, 34L, 220L, 184L, 155L, 152L, 167L, 
    163L, 157L, 138L, 130L, 98L, 98L, 137L, 92L, 85L, 82L, 89L, 
    85L, 216L, 220L, 205L, 143L, 147L, 150L, 152L, 163L, 132L, 
    156L, 157L, 147L, 145L, 132L, 91L, 90L, 81L, 86L, 89L, 84L, 
    84L, 134L, 45L, 205L, 157L, 163L, 166L, 134L, 140L, 87L, 
    66L, 95L, 85L, 89L, 90L, 96L, 91L, 87L, 83L, 91L, 80L, 88L, 
    88L, 82L, 60L, 43L, 37L, 43L, 176L, 182L, 142L, 146L, 147L, 
    92L, 97L, 140L, 100L, 94L, 91L, 90L, 87L, 92L, 92L, 86L, 
    84L, 89L, 51L, 48L, 49L, 42L, 90L, 145L, 87L, 93L, 135L, 
    92L, 90L, 83L, 87L, 86L, 89L, 79L, 95L, 91L, 96L, 93L, 84L, 
    47L, 45L, 37L, 89L, 102L, 89L, 84L, 163L, 131L, 94L, 95L, 
    93L, 80L, 87L, 75L, 46L, 50L, 82L, 96L, 68L, 46L, 41L, 51L, 
    36L, 48L, 94L, 87L, 82L, 66L, 95L, 82L, 67L, 46L, 40L, 64L, 
    46L, 41L, 45L, 41L, 232L, 150L, 173L, 155L, 152L, 155L, 96L, 
    141L, 132L, 93L, 48L, 90L, 174L, 152L, 152L, 133L, 158L, 
    139L, 93L, 90L, 77L, 73L, 155L, 97L, 75L, 77L, 78L, 73L, 
    79L, 67L, 65L, 74L, 46L, 79L, 75L, 88L, 75L, 90L, 47L, 51L, 
    49L, 81L, 78L, 71L, 83L, 74L, 82L, 85L, 80L, 77L, 81L, 77L, 
    80L, 68L, 80L, 91L, 82L, 75L, 84L, 79L, 42L, 83L, 90L, 89L, 
    88L, 85L, 95L, 87L, 92L, 83L, 90L, 88L, 85L, 78L, 79L, 88L, 
    76L, 84L, 87L, 79L, 82L, 90L, 67L, 83L, 80L, 84L, 88L, 84L, 
    90L, 86L, 85L, 79L, 81L, 80L, 82L, 84L, 77L, 92L, 88L, 90L, 
    88L, 81L, 91L, 87L, 88L, 80L, 90L, 91L, 87L, 84L, 87L, 82L, 
    76L, 85L, 75L, 73L, 87L, 89L, 77L, 96L, 82L, 82L, 89L, 86L, 
    84L, 84L, 92L, 91L, 86L, 87L, 93L, 77L, 83L, 82L, 93L, 87L, 
    86L, 76L, 82L, 68L, 91L, 92L, 76L, 94L, 88L, 86L, 98L, 91L, 
    84L, 83L, 100L, 95L, 79L, 98L, 89L, 88L, 79L, 84L, 93L, 87L, 
    103L, 92L, 85L, 94L, 83L, 97L, 96L, 83L, 91L, 73L, 84L, 87L, 
    96L, 79L, 96L, 69L, 85L, 95L, 91L, 89L, 86L, 77L, 80L, 54L, 
    153L, 90L, 80L, 139L, 94L, 89L, 91L, 98L, 95L, 87L, 91L, 
    86L, 94L, 86L, 92L, 92L, 98L, 82L, 85L, 87L, 87L, 87L, 84L, 
    86L, 85L, 96L, 83L, 83L, 139L, 97L, 80L, 85L, 86L, 150L, 
    89L, 78L, 85L, 80L, 93L, 95L, 93L, 92L, 79L, 168L, 96L, 98L, 
    87L, 91L, 103L, 86L, 93L, 90L, 80L, 84L, 84L, 41L, 152L, 
    85L, 91L, 89L, 83L, 87L, 87L, 89L, 84L, 64L, 89L, 83L, 90L, 
    84L, 90L, 94L, 87L, 78L, 83L, 99L, 95L, 90L, 89L, 96L, 96L, 
    92L, 99L, 82L, 80L, 84L, 94L, 74L, 70L, 111L, 129L, 141L, 
    135L, 88L, 78L, 64L, 68L, 58L, 67L, 50L, 57L, 50L, 170L, 
    139L, 172L, 142L, 121L, 121L, 144L, 155L, 136L, 131L, 125L, 
    127L, 133L, 124L, 73L, 83L, 44L, 52L, 44L, 39L, 43L, 48L, 
    47L, 52L, 46L, 47L, 50L, 172L, 133L, 93L, 128L, 244L, 252L, 
    150L, 162L, 150L, 106L, 95L, 98L, 84L, 108L, 48L, 47L, 84L, 
    136L, 49L, 47L, 131L, 73L, 70L, 54L, 59L, 52L, 55L, 48L, 
    55L, 45L, 222L, 238L, 40L, 40L, 43L, 45L, 67L, 47L, 50L, 
    41L, 61L, 54L, 43L, 42L, 89L, 43L, 42L, 48L, 64L, 55L, 40L, 
    52L, 46L, 49L, 46L, 49L, 45L, 45L, 42L, 176L, 154L, 97L, 
    83L, 97L, 132L, 88L, 95L, 98L, 82L, 81L, 92L, 96L, 89L, 63L, 
    90L, 93L, 82L, 97L, 93L, 100L, 85L, 78L, 85L, 72L, 73L, 62L, 
    62L, 60L, 58L, 128L, 98L, 87L, 96L, 56L, 86L, 87L, 78L, 58L, 
    73L, 55L, 54L, 62L, 46L, 85L, 193L, 140L, 97L, 95L, 87L, 
    40L, 208L, 210L, 146L, 46L, 206L, 40L, 262L, 145L, 52L, 72L, 
    49L, 85L, 70L, 47L, 93L, 69L, 65L, 54L, 60L, 46L, 44L, 48L, 
    56L, 58L, 49L, 42L, 52L, 42L, 50L, 51L, 50L, 53L, 42L, 48L, 
    49L, 45L, 45L, 49L, 42L, 47L, 60L, 51L, 53L, 46L, 49L, 46L, 
    56L, 57L, 57L, 48L, 52L, 49L, 50L, 46L, 56L, 62L, 51L, 46L, 
    50L, 46L, 49L, 50L, 51L, 52L, 46L, 51L, 48L, 42L, 48L, 42L, 
    47L, 43L, 55L, 50L, 44L, 46L, 52L, 46L, 44L, 45L, 53L, 53L, 
    56L, 57L, 45L, 42L, 41L, 55L, 50L, 51L, 50L, 47L, 51L, 45L, 
    280L, 192L, 185L, 150L, 183L, 150L, 189L, 211L, 159L, 134L, 
    134L, 138L, 132L, 136L, 145L, 125L, 147L, 149L, 161L, 126L, 
    44L, 142L, 148L, 138L, 154L, 135L, 150L, 134L, 152L, 128L, 
    233L, 188L, 155L, 137L, 121L, 148L, 138L, 240L, 214L, 163L, 
    143L, 149L, 127L, 115L, 156L, 124L, 132L, 166L, 159L, 152L, 
    95L, 171L, 154L, 142L, 170L, 155L, 140L, 163L, 123L, 139L, 
    111L, 148L, 142L, 149L, 137L, 154L, 183L, 136L, 207L, 138L, 
    155L, 160L, 148L, 150L, 141L, 137L, 210L, 198L, 149L, 212L, 
    240L, 222L, 171L, 165L, 187L, 177L, 167L, 139L, 137L, 103L, 
    122L, 127L, 149L, 154L, 156L, 137L, 145L, 174L, 144L, 127L, 
    124L, 96L, 168L, 163L, 136L, 136L, 124L, 128L, 192L, 169L, 
    192L, 163L, 177L, 133L, 155L, 169L, 135L, 158L, 145L, 154L, 
    132L, 152L, 136L, 126L, 116L, 183L, 157L, 155L, 141L, 145L, 
    203L, 160L, 146L, 152L, 182L, 157L, 149L, 164L, 142L, 160L, 
    183L, 127L, 150L, 123L, 128L, 154L, 126L, 127L, 133L, 105L, 
    135L, 117L, 131L, 150L, 121L, 258L, 278L, 243L, 241L, 222L, 
    110L, 155L, 149L, 159L, 155L, 159L, 152L, 134L, 133L, 198L, 
    164L, 138L, 127L, 156L, 141L, 129L, 135L, 153L, 148L, 136L, 
    133L, 158L, 137L, 133L, 132L, 117L, 134L, 150L, 145L, 145L, 
    135L, 150L, 157L, 145L, 136L, 127L, 133L, 121L, 143L, 134L, 
    255L, 126L, 137L, 201L, 182L, 150L, 118L, 157L, 160L, 143L, 
    150L, 142L, 194L, 186L, 156L, 151L, 177L, 155L, 128L, 128L, 
    145L, 133L, 130L, 121L, 125L, 135L, 147L, 121L, 135L, 167L, 
    155L, 148L, 144L, 137L, 135L, 150L, 162L, 151L, 156L, 151L, 
    160L, 166L, 150L, 122L, 146L, 152L, 162L, 162L, 122L, 144L, 
    147L, 145L, 142L, 150L, 145L, 121L, 137L, 117L, 140L, 142L, 
    134L, 140L, 134L, 131L, 136L, 116L, 135L, 127L, 129L, 185L, 
    46L, 220L, 142L, 152L, 127L, 45L, 47L, 45L, 54L, 51L, 56L, 
    49L, 49L, 58L, 49L, 51L, 45L, 47L, 44L, 69L, 57L, 48L, 52L, 
    60L, 40L, 51L, 46L, 43L, 49L, 43L, 47L, 45L, 56L, 46L, 48L, 
    46L, 49L, 48L, 50L, 66L, 49L, 59L, 47L, 59L, 50L, 43L, 53L, 
    48L, 56L, 44L, 52L, 42L, 51L, 44L, 51L, 53L, 40L, 50L, 50L, 
    34L, 48L, 51L, 51L, 46L, 47L, 53L, 32L), uniqueID = 1:1282), row.names = c(NA, 
-1282L), class = "data.frame")

我正在尝试将这些数据从长格式转换为宽格式。我一直在尝试使用以下命令来实现此目的:

代码语言:javascript
运行
AI代码解释
复制
df1<- df %>% group_by(length) %>% pivot_wider(names_from=site, values_from=length) %>% select(-uniqueID)

它给了我一个输出,但它有很多NA,我如何让它看起来像table 1而不是table 2?提前感谢!

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2021-11-11 06:44:47

对于yearsite的每种组合,您可能都需要一个ID。请测试以下内容,看看这是否是您所需要的。

代码语言:javascript
运行
AI代码解释
复制
library(tidyverse)

df1 <- df %>% 
  select(-uniqueID) %>%
  group_by(year, site) %>%
  mutate(ID = 1:n()) %>%
  pivot_wider(names_from=site, values_from=length) 
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/69929838

复制
相关文章
(译) 如何使用 React hooks 获取 api 接口数据
在本教程中,我想向你展示如何使用 state 和 effect 钩子在React中获取数据。 你还将实现自定义的 hooks 来获取数据,可以在应用程序的任何位置重用,也可以作为独立节点包在npm上发布。
Nealyang
2019/09/29
28.7K0
通过Zabbix API获取历史监控数据
Zabbix API可以通过JSON RPC协议来获取历史数据。 可以采用脚本或者任何支持JSON RPC的工具来使用API。
星哥玩云
2022/06/30
2.3K0
ABAP随笔-通过api获取新冠数据
Title Fiori获取新冠病毒API数据 突发奇想想要使用abap去获取个网站上公布的api,然后显示一下 就当最近学习NEPTUNE的小练习吧 百度一下获取疫情的网站API,也可以自己去ti
Tab Zhu
2022/06/27
1.1K0
ABAP随笔-通过api获取新冠数据
React通过jsonp来请求接口获取数据渲染数据
Fetch-jsonp https://github.com/camsong/fetch-jsonp
王小婷
2019/11/10
3K0
react: 怎么优雅使用获取数据
note: 如果你想了解最新的 react hooks 来获取处理数据的方法:https://www.robinwieruch.de/react-hooks-fetch-data/
西南_张家辉
2021/02/02
1.6K0
【React Native实战教程】GitHub Trending API数据的获取
GitHub Popular中有个treding模块,该模块是GitHub的treding的手机版,在这个模块中你可以使用只有在PC上才能使用的功能。为了开发这个treding模块我们需要获取GitHub的treding的API数据。不过不幸的的是GitHub并没有开放有关trending的API,所以想调GitHub的treding的API已经是不现实的了。
CrazyCodeBoy
2018/05/07
2.3K0
【React Native实战教程】GitHub Trending API数据的获取
ApplicationContext可以同时获取多个Bean吗?
在实际场景中提供了N个接口给第三方,常规情况下是不会同时调用的,如果N个接口同时调用,随着接口的数量和业务场景逻辑增加,将会给服务带来很不好的体验,但恰恰业务就是如此,面对同一类型的业务查询场景,我将策略模式应用到此接口上来应对。关于实际设计的demo可参考往期文章炫技?No.
疯狂的KK
2023/01/12
1.1K0
ApplicationContext可以同时获取多个Bean吗?
API网关怎么部署 不用api网关可以吗?
许多在互联网公司工作的人都了解api网关。所谓的api网关,就是一个统一的微服务应用访问入口。由于现在许多企业的应用APP功能繁多,种类交叉,所以一个统一的api网关入口可以帮助用户通过一个入口顺利的直达不同的微服务当中。不仅给用户访问带来方便,对于服务端的运维工作也会带来极大的方便,下面来看一看API网关怎么部署?
用户8715145
2021/12/21
2.6K0
通过Java API获取Hive Metastore中的元数据信息
在文章中,我们说到Hive 3.0.0版本开始,其单独提供了standalone metastore服务以作为像presto等处理引擎的元数据管理中心。
从大数据到人工智能
2022/01/19
2.9K0
怎样使用React Context API [每日前端夜话0x26]
React Context API 【https://reactjs.org/docs/context.html】现在已经成为一个实验性功能,但是只有在 React 16.3.0 【https://reactjs.org/blog/2018/03/29/react-v-16-3.html】中才能用在生产中。本文将向你展示两个基本的 Web 商店应用程序,一个使用了 Context API 进行构建,另一个则不用。
疯狂的技术宅
2019/03/27
9920
怎样使用React Context API [每日前端夜话0x26]
如何通过CM API优雅的获取元数据库密码
人啊,上了年纪了,总容易忘记一些事情,比如你一不小心就忘记了CDH集群Hive,Hue和Sentry服务的元数据库密码,对于数据库(MySQL/Oracle/PostgreSQL)管理员来说,可能有自己独特的一些奇技淫巧来找回密码。但对于咱普通人,其实Cloudera Manger提供了一种很优雅的方式让你找回元数据库密码,那就是神奇的Cloudera Manager API。
Fayson
2018/03/29
3.2K0
如何通过CM API优雅的获取元数据库密码
2021年50个酷炫的Web和移动项目创意
当想到项目创意时,很多人都在挣扎。这里列出了50个您可以在2021年完成的很棒的项目构想。我将以下列的技术栈为例,以便您弄清楚自己也可以做到这一点。这些应用程序可以在Web,移动和桌面上。您可以使用无数种工具,技术和编程语言来构建它们,我仅在此处显示一些用例。每个项目的编程级别均为初学者,中级或高级。这些应用程序可以创建为前端,后端或全栈。
海拥
2021/08/23
4.4K0
2021年50个酷炫的Web和移动项目创意
通过 Drone Rest API 获取构建记录日志
Drone是一款CICD工具,提供rest API,简单介绍下如何使用API 获取构建日志。
JadePeng
2020/02/18
1.2K0
通过post请求api获取土味情话
用的ALAPI,自己申请token填上即可。 <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title>
岳泽以
2022/10/26
7660
前端小白躺平摆烂可以吗
这几年毕业的大学生有多苦都不必我们说了。大学才4年,疫情占3年,好不容易熬到毕业,找工作又进入了炼狱模式。
物立
2022/08/30
4460
设计通过 POST 获取数据的 API 时需要注意的问题
现代网站越来越多的使用前后端分离架构,先用前端 MVC 框架快速堆砌出 SPA,再用 API 获取动态数据也已经成为日常的开发内容;而用来连接前后端的 API,其重要性也自然言而喻。做为一个前端码农,认识后端的 API 设计方式也是很重要的,今天让我们针对 API 设计来一探究竟。
疯狂的技术宅
2020/11/03
1.7K0
设计通过 POST 获取数据的 API 时需要注意的问题
Google JavaScript API 的使用
您可以使用JavaScript客户端库与Web应用程序中的Google API(例如,人物,日历和云端硬盘)进行交互。请按照此页面上的说明进行操作。
拿我格子衫来
2022/01/24
3.1K0
React Native迎来重大架构升级,性能将大幅提升
作者 | 郭蕾 7 月 14 日,React Native 核心团队的 Joshua Gross 在 Twitter 说,RN 的新架构已经在 Facebook 内部落地了,并且 99% 的代码已经开源。这次的架构升级“蓄谋已久”,Joshua 说他们从 2018 年 1 月就开始规划了。 Facebook 曾在 2018 年 6 月宣布了大规模 重构 RN 的计划和路线图,整个的重构目的是为了让 RN 更轻量化、更适应混合开发,接近甚至达到原生的体验。具体包括以下几个方面: 改变线程模型。UI 更新不再
深度学习与Python
2023/04/01
1.6K0
React Native迎来重大架构升级,性能将大幅提升
JQuery JavaScript常用API整理(前端入门必学)
现在MVVM框架逐渐占据了主要市场,很多老项目也逐渐的从jQuery转向了MVVM架构!JQuery还有必要学吗? 我的答案是jQuery必须学! JavaScript是基础,JQuery能让DOM操作更方便,哪怕用vue react当操作dom的时候 还是离不开的,只是说可以不用学的那么深。
鱼找水需要时间
2023/02/16
7140
点击加载更多

相似问题

如何通过javascript使用twitter API

11

是否可以通过Facebook API (比如通过Twitter API?)获取@提及

11

通过Twitter API javascript从时间线获取Twitter状态

11

REST Api:无法在前端获取数据(NodeJS/React)

13

React:无法通过API获取数据

119
添加站长 进交流群

领取专属 10元无门槛券

AI混元助手 在线答疑

扫码加入开发者社群
关注 腾讯云开发者公众号

洞察 腾讯核心技术

剖析业界实践案例

扫码关注腾讯云开发者公众号
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档