try this:
> match(x$Name> x <- read.table(text = "Name - Value
+ A - 400
+ A - 300
+ B - 200
+ B - 350
+ C - 500
+ C - 350
+ D - 450
+ D - 600
+ E - 700
+ E - 750
+ F - 630
+ F - 650", header = TRUE, as.is = TRUE)
> map <- data.frame(key = c("A", "B", "C", "D", "E", "F")
+ , value = c( 1, 1, 2, 2, 3, 3)
+ , stringsAsFactors = FALSE
+ )
> x$ID <- map$value[match(x$Name, map$key)]
> x
Name X. Value ID
1 A - 400 1
2 A - 300 1
3 B - 200 1
4 B - 350 1
5 C - 500 2
6 C - 350 2
7 D - 450 2
8 D - 600 2
9 E - 700 3
10 E - 750 3
11 F - 630 3
12 F - 650 3
On Sat, Dec 3, 2011 at 7:06 AM, Sarah Goslee <sarah.gos...@gmail.com> wrote:
> I doubt your data frame looks like that, with all the -, but regardless you
> can use ifelse() to construct your column.
>
> Sarah
>
> On Saturday, December 3, 2011, syrvn <ment...@gmx.net> wrote:
>> Hello!
>>
>> I have a data.frame which looks like:
>>
>> Name - Value
>> A - 400
>> A - 300
>> B - 200
>> B - 350
>> C - 500
>> C - 350
>> D - 450
>> D - 600
>> E - 700
>> E - 750
>> F - 630
>> F - 650
>>
>> I want to add another column where all A,B should get an index 1, all C,D
> an
>> index of 2 and all E,F an index of 3 so that the data.frame looks like:
>>
>> ID - Name - Value
>> 1 - A - 400
>> 1 - A - 300
>> 1 - B - 200
>> 1 - B - 350
>> 2 - C - 500
>> 2 - C - 350
>> 2 - D - 450
>> 2 - D - 600
>> 3 - E - 700
>> 3 - E - 750
>> 3 - F - 630
>> 3 - F - 650
>>
>> My data.frame is quite big so I cannot add all values by hand.
>>
>>
>> Cheers
>>
>>
>>
>>
>> --
>> View this message in context:
> http://r.789695.n4.nabble.com/Data-alignment-tp4153024p4153024.html
>> Sent from the R help mailing list archive at Nabble.com.
>>
>> ______________________________________________
>> R-help@r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
> --
> Sarah Goslee
> http://www.stringpage.com
> http://www.sarahgoslee.com
> http://www.functionaldiversity.org
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
--
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
