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？提前感谢！

dplyr
tidyr
r
广告

DNS解析特惠

DNS解析提供智能解析、流量调度、安全防护等服务
EN

回答 1

Stack Overflow用户

回答已采纳

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

对于year和site的每种组合，您可能都需要一个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

复制
相关文章
java – 为什么InputStream#read()返回一个int而不是一个字节？
java编程算法
首先字节正好是8位，所以使用8位的char类型数据来与字节数据相互一一对应是最好的选择？但是为何方法InputStream#read()需要返回int类型值呢？
Fisherman渔夫
2020/02/19
1.2K0
springcloud 返回的数据为XML 而不是JSON
xmlspring cloud
本人的原因是因为引入了jackson-dataformat-xml依赖导致的，下面查看自己项目是否包含此依赖，如果包含的话，可以去掉。 有的人添加了下面注解后可以解决，不过我这里没有解决。还是依靠上图
qubianzhong
2019/04/01
2.3K0
springcloud 返回的数据为XML 而不是JSON
为什么 useState 返回的是 array 而不是 object？
javascriptreact
这里可以看到 useState 返回的是一个数组，那么为什么是返回数组而不是返回对象呢？我们在自定义 hook 时应该返回什么类型呢？
小鑫
2022/04/26
2.3K0
js如何返回异步函数结果
javascript
假设您有这样一个问题:您正在进行一个异步调用，并且需要从原始函数返回该调用的结果。
IT工作者
2022/01/01
6.4K0
DevOps是一个接口，而不是一个类
devops
职位通常定义一个人需要执行的任务。“软件开发人员”开发软件，“系统管理员”管理系统，“团队负责人”领导团队。他们执行任务的质量可以用来评估他们的绩效。
DevOps云学堂
2021/05/11
1.1K0
DevOps是一个接口，而不是一个类
JS如何返回异步调用的结果？
javascriptnode.jsjquery编程算法ajax
这个问题作者认为是所有从后端转向前端开发的程序员，都会遇到的第一问题。JS前端编程与后端编程最大的不同，就是它的异步机制，同时这也是它的核心机制。
LIYI
2023/03/06
5.6K0
JS如何返回异步调用的结果？
去解决更多的问题，而不是如何最好地解决一个问题
其他
有些人非常勤奋，别人休息和娱乐的时候，都在工作学习。但是努力了一辈子，人生也没有显著的提升，就像报道里经常说的："某某在平凡的岗位上，勤勤恳恳工作了一辈子"。
春哥大魔王
2018/09/21
7570
去解决更多的问题，而不是如何最好地解决一个问题
mybatis返回结果处理
mybatismap对象集合接口
当查询的记录条数是多条的时候，必须使用集合接收。如果使用单个实体类接收会出现异常。如果返回的是一条记录可以用集合接收
一个风轻云淡
2023/10/15
2500
mybatis返回结果处理
C++核心准则编译边学-F.20 输出结果时更应该使用返回值而不是输出参数
c++
A return value is self-documenting, whereas a & could be either in-out or out-only and is liable to be misused.
面向对象思考
2020/03/25
1.4K0
Java 日期类型比较没有返回正确的结果
数据库debugequals
最近在数据库处理的时候发现日期对比的时候没有返回正确的结果。 但是保存的时间实际上是相同的。 代码如下： if (!mlsPhoto.getDateUpdate().equals(photo.getDateUpdate())) { } 因为这里使用了 equals 方法。 问题解决 经过 Debug 后，这 2 个日期的纳秒数是不同的，查看下对象如下。 我们会发现其中一个对象有纳秒，一个对象没有。 但是 fastTime 是相同的。 如果使用 equals 那么这个方法比较的是毫秒，所以是不相等的。
HoneyMoose
2021/12/21
3.5K0
java 查看进程状态_java执行shell命令并返回结果
javahttps网络安全
发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/172503.html原文链接：https://javaforall.cn
全栈程序员站长
2022/09/22
8990
java 查看进程状态_java执行shell命令并返回结果
【说站】Python如何用下标取得列表的单个值
python
1、使用的下标超出了列表中值的个数，Python 将给出 IndexError 出错信息。
很酷的站长
2022/11/24
1.3K0
【说站】Python如何用下标取得列表的单个值
一文读懂《Effective Java》第43条：返回零长度的数组或集合，而不是null
编程算法
对于一个返回null 而不是零长度数组或者集合的方法，客户端几乎每次用到该方法都可能会忘记写专门处理null 返回值的代码，进而导致NPE。
后台技术汇
2022/05/28
1.6K0
Feign配置微服务间调用返回XML而不是Json的解决方案
json微服务xml
springcloud中的微服务之间通过网关的api调用时，返回的是xml格式，而不是相应的json串，如果想要返回json格式如何处理呢
在水一方
2022/06/14
1.6K0
Feign配置微服务间调用返回XML而不是Json的解决方案
2022-12-15：寻找用户推荐人。写一个查询语句，返回一个客户列表，列表中客户的推荐人的编号都 不是 2。对于示例数据，结果
sql语句数据
2022-12-15：寻找用户推荐人。写一个查询语句，返回一个客户列表，列表中客户的推荐人的编号都 不是 2。
福大大架构师每日一题
2023/02/01
8020
更聪明地学习，而不是苦读——《如何高效学习》
https网络安全
所以，需要持续大量学习的童鞋，比方说我等程序员们，除了要从知识的海洋中精挑细选出我们想要的内容，挑完了还得高效学习，不然成长的速度可能远远赶不上脱发的速度，沦落到「他变秃了，也没变强」的尴尬境地。
mzlogin
2020/05/21
6710
mybatis返回结果类型(resulttype返回list)
编程算法https网络安全java
这样设置返回类型为resultClass=”java.util.HashMap”，查询时执行queryForList
全栈程序员站长
2022/08/01
5.7K0
何时使用MongoDB而不是MySql
mongodbmysql
MySQL 和 MongoDB 是两个可用于存储和管理数据的数据库管理系统。MySQL 是一个关系数据库系统，以结构化表格格式存储数据。相比之下，MongoDB 以更灵活的格式将数据存储为 JSON 文档。两者都提供性能和可扩展性，但它们为不同的应用场景提供了更好的性能。
wayn
2023/08/09
1.1K0
何时使用MongoDB而不是MySql
SpringBoot统一返回结果
java腾讯云测试服务
在后台开发时，控制台得到的数据格式会有不同，这时我们需要设置统一返回结果，方便我们分析数据以及对数据进行管理。
算法与编程之美
2022/05/23
9480
SpringBoot统一返回结果
何时使用Kafka而不是RabbitMQ
消息队列kafkarabbitmq
Kafka 和 RabbitMQ 都是流行的开源消息系统，它们可以在分布式系统中实现数据的可靠传输和处理。Kafka 和 RabbitMQ 有各自的优势和特点，它们适用于不同的场景和需求。本文将比较 Kafka 和 RabbitMQ 的主要区别，并分析何时使用 Kafka 而不是 RabbitMQ。
wayn
2023/06/26
3940
何时使用Kafka而不是RabbitMQ

相似问题

Java XPath返回单个结果而不是NodeSet

11

findById返回文档列表，而不是单个结果

21

Java LDAP总是返回单个值，而不是列表

10

获取列表中的结果，而不是单个列表

129

Swift NSPredicate正在返回所有结果，而不是单个结果。

10
添加站长 进交流群

领取专属 10元无门槛券

AI混元助手 在线答疑

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

洞察 腾讯核心技术

剖析业界实践案例

扫码关注腾讯云开发者公众号
领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2025 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 深公网安备号 44030502008569

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号 | 京公网安备号11010802020287

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档