Thank you for your response, I didn't do the -7 because this is just a
small part of the dataset and the number are not all consistent (ie skip
some numbers occasionally). However, I did not think of the
as.numeric(as.factor()) sequence. That did the trick, simple lapse in my
thoughts that cost me a lot of time.
Thanks again,
Charles
On Mon, Jan 7, 2013 at 11:23 AM, Sarah Goslee <sarah.gos...@gmail.com>wrote:
> Hi,
>
> It isn't entirely clear what you want, because it seems too simple.
> And most of your sample data are irrelevant, aren't they?
>
> Why not just use:
>
> testdata$Event_name2 <- testdata$Event_name - 7
>
> Or you could try:
>
> testdata$Event_name3 <- as.numeric(as.factor(testdata$Event_name))
>
> which will make the values into consecutive integers.
> Event_name Event_name2 Event_name3
> 9 8 1 1
> 10 9 2 2
> 11 10 3 3
> 12 11 4 4
> 13 12 5 5
> 14 13 6 6
> 15 14 7 7
> 16 15 8 8
> 17 16 9 9
> 18 17 10 10
> 19 18 11 11
> 20 19 12 12
> 21 20 13 13
> 22 21 14 14
> 23 22 15 15
> 24 23 16 16
> 25 24 17 17
> 26 25 18 18
> 27 26 19 19
> 28 27 20 20
> 29 28 21 21
> 30 29 22 22
> 31 30 23 23
> 32 31 24 24
> 33 33 26 25
> 34 34 27 26
> 41 8 1 1
> 42 9 2 2
> 43 10 3 3
> 44 11 4 4
> 45 12 5 5
> 46 13 6 6
> 47 14 7 7
> 48 15 8 8
> 49 16 9 9
> 50 17 10 10
> 51 18 11 11
> 52 19 12 12
> 53 20 13 13
> 54 21 14 14
> 55 22 15 15
> 56 23 16 16
> 57 24 17 17
> 58 25 18 18
> 59 26 19 19
> 60 27 20 20
> 61 28 21 21
> 62 29 22 22
> 63 30 23 23
>
>
> On Mon, Jan 7, 2013 at 11:41 AM, Charles Determan Jr <deter...@umn.edu>
> wrote:
> > Greetings R users,
> >
> > I am trying to renumber my groups within the file shown below. The
> groups
> > are currently set as 8,9,10,etc. I would like to renumber this as
> > 1,2,3,etc. I have searched the help files and only come across using the
> > rownames to renumber the values but I need to match values. Any
> assistance
> > is always appreciated,
> >
> > Regards,
> > Charles
> >
> > structure(list(Group = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 1L,
> > 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L,
> > 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L,
> > 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L), .Label = c("NO", "YES"
> > ), class = "factor"), Event_name = c(8, 9, 10, 11, 12, 13, 14,
> > 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
> > 31, 33, 34, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
> > 21, 22, 23, 24, 25, 26, 27, 28, 29, 30), Glucose.n = c(26, 3,
> > 0, 26, 1, 25, 26, 25, 25, 26, 26, 25, 23, 23, 24, 24, 26, 26,
> > 25, 25, 26, 26, 24, 21, 7, 12, 4, 0, 0, 4, 0, 4, 4, 4, 4, 4,
> > 4, 4, 3, 4, 4, 4, 3, 3, 2, 2, 2, 1, 1), Glucose.m = c(92.5,
> > 90.3333333333333,
> > NaN, 97.2307692307692, 116, 97.84, 107.653846153846, 105.32,
> > 102.6, 94.6538461538462, 96.076923076923, 92.24, 87.5652173913043,
> > 79.3913043478261, 81.2916666666667, 77.5, 75.9230769230769,
> > 74.4615384615385,
> > 72.68, 76.32, 74.9615384615385, 72.2307692307692, 92.5416666666667,
> > 105.619047619048, 93.4285714285714, 96.5, 90, NaN, NaN, 86.5,
> > NaN, 87, 90.25, 92.5, 98.75, 95.75, 94, 88.25, 54.3333333333333,
> > 52, 74.5, 77.75, 81, 97.3333333333333, 82.5, 85, 66.5, 51, 81
> > ), Glucose.sd = c(18.9256439784753, 27.5922694487665, NA,
> 25.3050314242961,
> > NA, 17.3917605012642, 21.027491163127, 12.0094407308029,
> 28.0728219695373,
> > 17.7334538264655, 10.7700439253443, 12.7778454104490, 11.0075432274935,
> > 14.6992242542214, 12.2739709270814, 10.9266328000819, 10.4457573279225,
> > 13.1338669682033, 8.2194890352138, 19.9556174213344, 17.6079090620795,
> > 10.9299869800753, 19.3052801217623, 29.7883806046522, 17.2032665779607,
> > 18.4563366797521, 18.0554700852678, NA, NA, 19.7399763593239,
> > NA, 22.3159136044214, 28.5116935075184, 21.7638844572072,
> 12.2848144742469,
> > 12.0933866224478, 15.5777619273972, 11.842719282327, 39.1066916694999,
> > 32.0936130717624, 66.8755062286136, 53.7796429887741, 17.6918060129541,
> > 11.5902257671425, 34.6482322781408, 9.89949493661167, 26.1629509039023,
> > NA, NA), Glucose.se = c(3.71162415205983, 15.9304041937980, NA,
> > 4.96272496248326, NA, 3.47835210025284, 4.12383029856479,
> 2.40188814616057,
> > 5.61456439390745, 3.47781642709786, 2.11217938990701, 2.55556908208981,
> > 2.29523142628873, 3.06500013246251, 2.50541382409208, 2.23038958057991,
> > 2.04858155574352, 2.57576322922309, 1.64389780704276, 3.99112348426689,
> > 3.45319507311964, 2.14354680364304, 3.94067380331773, 6.50035756909396,
> > 6.50222358617618, 5.32788547515463, 9.0277350426339, NA, NA,
> > 9.86998817966195, NA, 11.1579568022107, 14.2558467537592,
> 10.8819422286036,
> > 6.14240723712346, 6.04669331122391, 7.78888096369861, 5.92135964116351,
> > 22.5782589625015, 16.0468065358812, 33.4377531143068, 26.8898214943871,
> > 10.2143689640297, 6.69161996662824, 24.5, 7, 18.5, NA, NA)), .Names =
> > c("Group",
> > "Event_name", "Glucose.n", "Glucose.m", "Glucose.sd", "Glucose.se"
> > ), row.names = c(9L, 10L, 11L, 12L, 13L, 14L, 15L, 16L, 17L,
> > 18L, 19L, 20L, 21L, 22L, 23L, 24L, 25L, 26L, 27L, 28L, 29L, 30L,
> > 31L, 32L, 33L, 34L, 41L, 42L, 43L, 44L, 45L, 46L, 47L, 48L, 49L,
> > 50L, 51L, 52L, 53L, 54L, 55L, 56L, 57L, 58L, 59L, 60L, 61L, 62L,
> > 63L), class = "data.frame")
> >
>
> --
> Sarah Goslee
> 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.
