我有一个类似于这样的数据框:
df1:
我正在尝试获得一种输出,该输出将类型列中的行转换为单独的列。
期望的输出:
我尝试使用melt(df1),但是做错了,因为行中的值是 NUM 值而不是点。请告诉我如何解决这个问题。
NUM <- c("45", "45", "45", "45", "48", "50", "66", "66", "66", "68")
Type <- c("A", "F", "C", "B", "D", "A", "E", "C", "F", "D")
Points <- c(9.2,60.8,22.9,1012.7,18.7,11.1,67.2,63.1,16.7,58.4)
df1 <- data.frame(NUM,Type,Points)
df1:
+-----+------+--------+
| NUM | TYPE | Points |
+-----+------+--------+
| 45 | A | 9.2 |
| 45 | F | 60.8 |
| 45 | C | 22.9 |
| 45 | B | 1012.7 |
| 48 | D | 18.7 |
| 50 | A | 11.1 |
| 66 | E | 67.2 |
| 66 | C | 63.1 |
| 66 | F | 16.7 |
| 65 | D | 58.4 |
+-----+------+--------+
我正在尝试获得一种输出,该输出将类型列中的行转换为单独的列。
期望的输出:
+-----+----------+----------+----------+----------+----------+----------+
| NUM | Points.A | Points.B | Points.C | Points.D | Points.E | Points.F |
+-----+----------+----------+----------+----------+----------+----------+
| 45 | 9.2 | 1012.7 | 22.9 | N/A | N/A | 60.8 |
| 48 | N/A | N/A | N/A | 18.7 | N/A | N/A |
| 50 | 11.1 | N/A | N/A | N/A | N/A | N/A |
| 66 | N/A | N/A | 63.1 | N/A | 67.2 | 16.7 |
| 65 | N/A | N/A | N/A | N/A | 58.4 | N/A |
+-----+----------+----------+----------+----------+----------+----------+
我尝试使用melt(df1),但是做错了,因为行中的值是 NUM 值而不是点。请告诉我如何解决这个问题。
melt
可以使数据变得更长,dcast
可以使数据变得更宽(同时还能进行聚合操作)。 - A5C1D2H2I1M1N2O1R2T1library(tidyr) ; spread(df1, Type, Points)
- David Arenburg