R dataframe create

Question

I have a data frame in R, say f1. I want to create another data frame f2 which has the column names(header) in f1 as f2's row names. I know there are 300 names in f1, and want to assign color "#ff0000" to the first 200 and color "#0000ff" to the last 100. How can I do this? The result should looks like,

name1   "#ff0000"
name2   "#ff0000"
...
name201 "#0000ff"
name202 "#0000ff"
...

Metrics · Answer 1 · 2013-09-04T16:56:09.550

1

mydata<-mtcars
mydata1<-data.frame(names(mydata))
mydata1$col<-c(rep("col1",7),rep("col2",4))
rownames(mydata1)<-mydata1$names.mydata
mydata1$names.mydata.<-NULL

> mydata1
      col
mpg  col1
cyl  col1
disp col1
hp   col1
drat col1
wt   col1
qsec col1
vs   col2
am   col2
gear col2
carb col2

edited Sep 04 '13 at 16:56

answered Sep 04 '13 at 16:30

Metrics

15,172
7
54
83

score 1 · Accepted Answer · answered Sep 04 '13 at 16:44

1

The rbinds and cbinds in your answer are unnecessary. This is a one-liner, using data.frame.

f2 = data.frame(color = c(rep("#ff0000", 200), rep("#0000ff", 100)),
    row.names = names(f1),
    stringsAsFactors = FALSE)

answered Sep 04 '13 at 16:44

Gregor Thomas

136,190
20
167
294

score -1 · Answer 3 · answered Sep 04 '13 at 16:36

-1

I have figured it out myself. First get the f1's names out, name=col.names(f1)

Then prepare the color structure, color=rbind(cbind(rep("#ff0000",200)),cbind(rep("#0000ff",100)))

Finally create the data frame, final=data.frame(color,row.names=name)

answered Sep 04 '13 at 16:36

lolibility

2,187
6
25
45

R dataframe create

3 Answers3