Create dataframe from a matrix

by

If you change your time column into row names, then you can use as.data.frame(as.table(mat)) for simple cases like this.

Example:

data <- c(0.1, 0.2, 0.3, 0.3, 0.4, 0.5)
dimnames <- list(time=c(0, 0.5, 1), name=c("C_0", "C_1"))
mat <- matrix(data, ncol=2, nrow=3, dimnames=dimnames)
as.data.frame(as.table(mat))
  time name Freq
1    0  C_0  0.1
2  0.5  C_0  0.2
3    1  C_0  0.3
4    0  C_1  0.3
5  0.5  C_1  0.4
6    1  C_1  0.5

In this case time and name are both factors. You may want to convert time back to numeric, or it may not matter.

More Related Contents:

  1. Reshape three column data frame to matrix (“long” to “wide” format) [duplicate]
  2. Split a large dataframe into a list of data frames based on common value in column
  3. Sum rows in data.frame or matrix
  4. Change row order in a matrix/dataframe
  5. Last Observation Carried Forward In a data frame? [duplicate]
  6. Should I use a data.frame or a matrix?
  7. Loop through a R matrix row-wise and print elements [duplicate]
  8. Quickly reading very large tables as dataframes
  9. Convert a list to a data frame
  10. Splitting a dataframe string column into multiple different columns [duplicate]
  11. Conditional replacement of values in a data.frame
  12. Multiply rows of matrix by vector?
  13. All Levels of a Factor in a Model Matrix in R
  14. How do I combine two data-frames based on two columns? [duplicate]
  15. R Apply() function on specific dataframe columns
  16. Count NAs per row in dataframe [duplicate]
  17. Add (insert) a column between two columns in a data.frame
  18. Add a prefix to column names
  19. Create a Data Frame of Unequal Lengths
  20. R: Assign variable labels of data frame columns
  21. How `poly()` generates orthogonal polynomials? How to understand the “coefs” returned?
  22. Read and rbind multiple csv files
  23. Count number of zeros per row, and remove rows with more than n zeros
  24. How I can select rows from a dataframe that do not match?
  25. Select last non-NA value in a row, by row
  26. Join two data frames in R based on closest timestamp
  27. Convert a data frame to a data.table without copy
  28. Shifting a column down by one
  29. How to calculate adjacency matrices in R
  30. What is the first column in R’s mtcars dataset?

Leave a Comment