如何透视/取消透视(浇铸/熔化)数据框? [英] how to pivot/unpivot (cast/melt) data frame?

问题描述

我怎样才能取消旋转"桌子?正确的技术术语是什么?

How can I 'unpivot' a table? What is the proper technical term for this?

更新:该术语称为融化

我有一个国家/地区的数据框架和每年的数据

I have a data frame for countries and data for each year

Country     2001    2002    2003
Nigeria     1       2       3
UK          2       NA       1

我想拥有

Country    Year    Value
Nigeria    2001    1
Nigeria    2002    2
Nigeria    2003    3
UK         2001    2
UK         2002    NA
UK         2003    1

推荐答案

我仍然不敢相信我以答案击败了安德里. :)

I still can't believe I beat Andrie with an answer. :)

> library(reshape)
> my.df <- read.table(text = "Country     2001    2002    2003
   + Nigeria     1       2       3
   + UK          2       NA       1", header = TRUE)
> my.result <- melt(my.df, id = c("Country"))
> my.result[order(my.result$Country),]
     Country variable value
   1 Nigeria    X2001     1
   3 Nigeria    X2002     2
   5 Nigeria    X2003     3
   2      UK    X2001     2
   4      UK    X2002    NA
   6      UK    X2003     1

这篇关于如何透视/取消透视(浇铸/熔化)数据框?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！