你怎样从一个矩阵（2D数组）中获取一个数据框？

huangapple
go评论96阅读模式
英文:

How can I obtain a dataframe from a matrix (2D-array)?

问题

Trend Cluster
1 5
2 4
3 2
4 1
5 2
6 4
7 1
8 2
9 2
10 5
11 1

英文:

I'd like to transform my array into a dataframe, with the column "Cluster" where there will be the numbers 5,4,2,1, ... and "Trend" with numbers 1,2,3,4,...

  1.            [,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10] [,11] 
  2.   cluster    5    4    2    1    2    4    1    2    2     5     1

What I expect :

  1.                Trend               Cluster
  2.                1                   5
  3.                2                   4
  4.                3                   2
  5.                4                   1
  6.                ...

答案1

得分: 1

With data.frame:

  1. data.frame(Trend = seq_along(mat), t(mat))
  3. #   Trend cluster
  4. # 1     1       5
  5. # 2     2       4
  6. # 3     3       2

Reproducible data:

  1. mat <- t(c(5, 4, 2))
  2. rownames(mat) <- "cluster"
英文:

With data.frame:

  1. data.frame(Trend = seq_along(mat), t(mat))
  3. #   Trend cluster
  4. # 1     1       5
  5. # 2     2       4
  6. # 3     3       2

Reproducible data:

  1. mat &lt;- t(c(5, 4, 2))
  2. rownames(mat) &lt;- &quot;cluster&quot;

答案2

得分: 0

  1. cluster &lt;- c(5,4,2,1,2,4,1,2,2,5,1);
  2. data.frame('trend' = seq_len(length(cluster)), cluster)

An example: data.frame example

英文: 
  1. cluster &lt;- c(5,4,2,1,2,4,1,2,2,5,1);
  2. data.frame(&#39;trend&#39; = seq_len(length(cluster)), cluster)

An example: data.frame example

huangapple
  • 本文由 发表于 2023年4月10日 22:42:52
  • 转载请务必保留本文链接：https://go.coder-hub.com/75978065.html
  • dataframe
  • matrix
  • r
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定