Hi Friends,
I have a data frame X, and I want to add ?%? & ?$? in row 4 and 5
respectively. when I?m trying using below logic, I?m getting warning
message.
Can anyone help me out on this.
X:
Summary G Y R T
Accts 582 644 0 1226
AcctCov 230 165 0 395
Cov% 40 26 0 32
UnCov% 60 74 0 68
EqVol11$MM8.5 10.6 0 19.1
Using this logic:
Z16[5,2:5]<-paste("$",Z16[5,2:5],sep="")
Z16[3,2:5]<-paste(Z16[3,2:5],"%",sep="")
Z16[4,2:5]<-paste(Z16[4,2:5],"%",sep="")
Getting this Warning: In `[<-.factor`(`*tmp*`, iseq, value = c(3L, 1L, 2L,
4L, NA))
invalid factor level, NAs
generate
Final result:
Summary G Y R T
Accts 582 644 0 1226
AcctCov 230 165 0 395
Cov% 40% 26% 0% 32%
UnCov% 60% 74% 0% 68%
EqVol11$MM$8.50 $10.60 $0 $19.10
Thanks in Advance.
Thanks,
Namit
--
View this message in context:
http://r.789695.n4.nabble.com/Getting-warning-message-tp4637928.html
Sent from the R help mailing list archive at Nabble.com.
HI,
I posted reply in nabble.
One more comment regarding your code.? If your dataset is X.? I wonder how it
changed to Z16.? Probably, you have to use X[5,2:5]....
A.K.
----- Original Message -----
From: namit <saileshchowdary at gmail.com>
To: r-help at r-project.org
Cc:
Sent: Thursday, July 26, 2012 9:23 AM
Subject: [R] Getting warning message
Hi Friends,
I? have? a data frame X, and I want to add ?%? & ?$? in row? 4 and 5
respectively. when I?m trying using below logic, I?m getting warning
message.
Can anyone? help me out on this.
X:
Summary??? ? ? ? G??? Y??? R??? T
Accts??? ? ? 582??? 644??? 0??? 1226
AcctCov??? ? ? 230??? 165??? 0??? 395
Cov%??? ? ? ? 40??? 26??? 0??? 32
UnCov%??? ? ? 60??? 74??? 0??? 68
EqVol11$MM8.5??? 10.6??? 0??? 19.1
Using this logic:
Z16[5,2:5]<-paste("$",Z16[5,2:5],sep="")
Z16[3,2:5]<-paste(Z16[3,2:5],"%",sep="")
Z16[4,2:5]<-paste(Z16[4,2:5],"%",sep="")
Getting this Warning: In `[<-.factor`(`*tmp*`, iseq, value = c(3L, 1L, 2L,
4L, NA))
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? invalid factor level, NAs
generate
Final result:
Summary? G??? Y??? R??? T
Accts??? 582??? 644??? 0??? 1226
AcctCov??? 230??? 165??? 0??? 395
Cov%??? 40%??? 26%??? 0%??? 32%
UnCov%??? 60%??? 74%??? 0%??? 68%
EqVol11$MM$8.50 ??? $10.60 ??? $0 ??? $19.10
Thanks in Advance.
Thanks,
Namit
--
View this message in context:
http://r.789695.n4.nabble.com/Getting-warning-message-tp4637928.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help at 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.
Hi. I don't know how did you create data frame X but if you check str(X) you will see that you have one or more factors inside. Try using stringsAsFactors=FALSE options while creating data frame. Hope this helps. Andrija On Thu, Jul 26, 2012 at 3:23 PM, namit <saileshchowdary@gmail.com> wrote:> Hi Friends, > > > I have a data frame X, and I want to add “%” & “$” in row 4 and 5 > respectively. when I’m trying using below logic, I’m getting warning > message. > Can anyone help me out on this. > > > X: > Summary G Y R T > Accts 582 644 0 1226 > AcctCov 230 165 0 395 > Cov% 40 26 0 32 > UnCov% 60 74 0 68 > EqVol11$MM8.5 10.6 0 19.1 > > Using this logic: > > Z16[5,2:5]<-paste("$",Z16[5,2:5],sep="") > Z16[3,2:5]<-paste(Z16[3,2:5],"%",sep="") > Z16[4,2:5]<-paste(Z16[4,2:5],"%",sep="") > > Getting this Warning: In `[<-.factor`(`*tmp*`, iseq, value = c(3L, 1L, 2L, > 4L, NA)) > invalid factor level, NAs > generate > > > Final result: > > Summary G Y R T > Accts 582 644 0 1226 > AcctCov 230 165 0 395 > Cov% 40% 26% 0% 32% > UnCov% 60% 74% 0% 68% > EqVol11$MM$8.50 $10.60 $0 $19.10 > > > Thanks in Advance. > > Thanks, > Namit > > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/Getting-warning-message-tp4637928.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. >[[alternative HTML version deleted]]
Hi Arun, Bymistake it kept X instead of Z16. -- View this message in context: http://r.789695.n4.nabble.com/Getting-warning-message-tp4637928p4637983.html Sent from the R help mailing list archive at Nabble.com.
Hi Arun, when i'm using the logic which you mention....I'm getting error..can you please help me on this.> Z16<-str(Z16)'data.frame': 5 obs. of 5 variables: $ Summary: chr "Accts" "AcctCov" "Cov%" "UnCov%" ... $ G : Factor w/ 5 levels "224","39","568",..: 3 1 2 4 5 $ Y : Factor w/ 5 levels "10.6","158","25",..: 4 2 3 5 1 $ R : Factor w/ 1 level "0": 1 1 1 1 1 $ T : Factor w/ 5 levels "1196","19.1",..: 1 4 3 5 2> Z16[5,2:5]<-paste("$",Z16[5,2:5],sep="")Error in Z16[5, 2:5] <- paste("$", Z16[5, 2:5], sep = "") : incorrect number of subscripts on matrix Thanks in Advance. Thanks, Namit -- View this message in context: http://r.789695.n4.nabble.com/Getting-warning-message-tp4637928p4638426.html Sent from the R help mailing list archive at Nabble.com.
Hello,
Your str() is different from mine.? It has G,Y,R, and T as factors.? You can do
one thing, add stringsAsFactors=FALSE in read.table().? Even without it, I
don't have any problems as this will only affect the Summary column.?
Z16<-read.table(text="
?Summary???? G???? Y R????? T
????? Accts 582.0 644.0 0 1226.0
??? AcctCov 230.0 165.0 0? 395.0
?????? Cov%? 40.0? 26.0 0?? 32.0
???? UnCov%? 60.0? 74.0 0?? 68.0
?EqVol11$MM?? 8.5? 10.6 0?? 19.1
",header=TRUE,sep="",stringsAsFactors=FALSE)
str(Z16)
#'data.frame':??? 5 obs. of? 5 variables:
# $ Summary: chr? "Accts" "AcctCov" "Cov%"
"UnCov%" ...
# $ G????? : num? 582 230 40 60 8.5
# $ Y????? : num? 644 165 26 74 10.6
# $ R????? : int? 0 0 0 0 0
# $ T????? : num? 1226 395 32 68 19.1
?Z16[5,2:5]<-paste("$",Z16[5,2:5],sep="")
?? Z16[3,2:5]<-paste(Z16[3,2:5],"%",sep="")
?? Z16[4,2:5]<-paste(Z16[4,2:5],"%",sep="")
?Z16
#???? Summary???? G????? Y?? R????? T
#1????? Accts?? 582??? 644?? 0?? 1226
#2??? AcctCov?? 230??? 165?? 0??? 395
#3?????? Cov%?? 40%??? 26%? 0%??? 32%
#4???? UnCov%?? 60%??? 74%? 0%??? 68%
#5 EqVol11$MM $$8.5 $$10.6 $$0 $$19.1
A.K.
----- Original Message -----
From: arun <smartpink111 at yahoo.com>
To: namit <saileshchowdary at gmail.com>
Cc:
Sent: Thursday, July 26, 2012 5:52 PM
Subject: Re: [R] Getting warning message
HI Namit,
Have you looked into str()?? It might give more information regaring the
problem.?
A.K.
----- Original Message -----
From: namit <saileshchowdary at gmail.com>
To: r-help at r-project.org
Cc:
Sent: Thursday, July 26, 2012 1:27 PM
Subject: Re: [R] Getting warning message
Hi Arun,
Bymistake it kept X instead of Z16.
--
View this message in context:
http://r.789695.n4.nabble.com/Getting-warning-message-tp4637928p4637983.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help at 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.