我正在尝试将矩阵转换为数据框,并在数据框中使用矩阵中的列名和行名作为变量。
以下是示例:
以下是示例:
sample = matrix(c(1,NA,NA,2,NA,3,NA,NA,5,NA,NA,6,NA,NA,NA,NA,8,NA,3,1),ncol = 4)
colnames(sample) = letters[1:4]
row.names(sample) = letters[22:26]
我的数据集有很多NA
,因此我正在尝试删除数据框中的所有NA
。
因此,这是我期望得到的输出:
data.frame(col = c("v","v","w","w","y","y","y","z"),
row = c("a","b","c","c","a","b","d","d"),
value = c(1,3,6,8,2,5,3,1))