Message-ID: <1385060911.77793.YahooMailNeo@web142603.mail.bf1.yahoo.com>
Date: 2013-11-21T19:08:31Z
From: arun
Subject: Datatable manipulation
In-Reply-To: <CAOdnBQe-oSCqC5gd4OzbSo6Ti=xp+vV6PEDPSpPE6idQV3dN5w@mail.gmail.com>
Hi,
Try:
dat1 <- read.table(text="a ??? b ??? c ??? d?????? e
1 ??? 2 ??? 3 ??? 4 ??? 5
10 ??? 9 ??? 8 ??? 7 ??? 6",sep="",header=TRUE)
Names1<- read.table(text="Original? ??? New???
e ??? ee
b ??? bb???
a ??? aa
c ??? cc
d ??? dd",sep="",header=TRUE,stringsAsFactors=FALSE)
It is better to dput() your dataset.? For example:
?dput(Names1)
structure(list(Original = c("e", "b", "a", "c", "d"), New = c("ee",
"bb", "aa", "cc", "dd")), .Names = c("Original", "New"), class = "data.frame", row.names = c(NA,
-5L))
?names(dat1) <- Names1[,2][match(names(dat1), Names1[,1])] ##
?dat1
#? aa bb cc dd ee
#1? 1? 2? 3? 4? 5
#2 10? 9? 8? 7? 6
A.K.
On Thursday, November 21, 2013 1:45 PM, Nitisha jha <nitisha999 at gmail.com> wrote:
Hi,
Thanks. I used as.character() and got the right strings.
Btw, I have lots of handicaps regarding R.
I have to rename the columns(I have 22 columns here). I have the new names along with the original names in another dataset. Right now, I am going hardcoding all the? 19 name changes(tedious and not optimum). 1st 3 names remain the same. I will give u a sample dataset. Let me know if there is any easy way of doing this.? Pardon the displaced column labels.
Original dataset.
?? a b c d??????????? ?
e
1 2 3 4 5
10 9 8 7 6
Dataset for name change
Original? New
e ee
b bb
a aa
c cc
d dd
I want my final dataset to be like this:
aa bb cc dd ee
1 2 3 4 5
10 9 8 7 6
?Could u tell me an optimal way to do it. My method is tedious and not good.
Also, is there a way to import .xls without perl (windows)?
Thanks for being patient. :)