Convert table into matrix by column names
r, statistics
Solution
Check method cast from reshape package
# generate test data
x <- read.table(textConnection('
models cores time
4 1 0.000365
4 2 0.000259
4 3 0.000239
4 4 0.000220
8 1 0.000259
8 2 0.000249
8 3 0.000251
8 4 0.000258'
), header=TRUE)
library(reshape)
cast(x, models ~ cores)
results:
models 1 2 3 4
1 4 0.000365 0.000259 0.000239 0.000220
2 8 0.000259 0.000249 0.000251 0.000258
Problem
I have data frame that looks like the following ``` models cores time 1 4 1 0.000365 2 4 2 0.000259 3 4 3 0.000239 4 4 4 0.000220 5 8 1 0.000259 6 8 2 0.000249 7 8 3 0.000251 8 8 4 0.000258 ``` ... etc I would like to convert it into a table/matrix with #models for rows labels, the #cores for the columns labels and time as the data entries e.g. ``` 1 2 3 4 5 6 7 8 1 time data 4 time data ``` currently I'm using for loops to convert it into this structure, though I am wondering if there was a better method?