Hi,
are you reading only one cell of your Excel file?
It seems your datalist is not numeric but text.
Try saving your Excel file as csv or text, reading in data might be much more
straightforward!
best
daniel
________________________________________
Feladó: r-help-boun...@r-project.org [r-help-boun...@r-project.org] ;
meghatalmazó: Baro [babak...@gmail.com]
Küldve: 2014. január 7. 16:01
To: PIKAL Petr
Cc: R help
Tárgy: Re: [R] NAs introduced by coercion warning, while plotting data
thank you for your answer, I am reading my Data from an excel File. This is
my R code:
srow<-2421
wb <- loadWorkbook("C:\\users\\Babak\\Desktop\\spalte205.xls")
dat <-readWorksheet(wb, sheet=getSheets(wb)[1], startRow=srow, endRow=srow,
startCol=spalte, endCol=spalte,header=FALSE)
datalist<-dat[,1]
datalist<-sub(";","",datalist)
datalist
plot(datalist,type="l",ylim=c(-1,+1))
as an output of my data, I see:
> datalist
[1] " 7.0121, -0.673354, 0.749622, -0.549641, 0.435662, -0.328995,
0.0869976, -0.0851428, -0.191019, 0.188799, -0.373707, 0.434814, -0.51979,
0.61944, -0.554766, 0.662571, -0.557779, 0.543724, -0.452397, 0.293651,
-0.248438, 0.0532787, -0.0185775, -0.176117, 0.222021, -0.34723, 0.407796,
-0.416123, 0.497159, -0.435225, 0.473375, -0.370811, 0.33683, -0.273933,
0.149871, -0.142623, -0.0253748, 0.0205145, -0.134123, 0.167995, -0.209844,
0.266891, -0.242527, 0.326598, -0.235483, 0.275738, -0.195738, 0.168225,
-0.114333, 0.0593316, -0.0583527, -0.016594, 0.0363428, -0.0533603,
0.106158, -0.129363, 0.131993, -0.134909, 0.135686, -0.125387, 0.0866545,
-0.0668686, 0.043161, -0.0229738 "
On Tue, Jan 7, 2014 at 6:54 AM, PIKAL Petr <petr.pi...@precheza.cz> wrote:
> Hi
>
> I did not get any error with your data
>
> plot(test)
>
> dput(test)
> c(7.0121, -0.673354, 0.749622, -0.549641, 0.435662, -0.328995,
> 0.0869976, -0.0851428, -0.191019, 0.188799, -0.373707, 0.434814,
> -0.51979, 0.61944, -0.554766, 0.662571, -0.557779, 0.543724,
> -0.452397, 0.293651, -0.248438, 0.0532787, -0.0185775, -0.176117,
> 0.222021, -0.34723, 0.407796, -0.416123, 0.497159, -0.435225,
> 0.473375, -0.370811, 0.33683, -0.273933, 0.149871, -0.142623,
> -0.0253748, 0.0205145, -0.134123, 0.167995, -0.209844, 0.266891,
> -0.242527, 0.326598, -0.235483, 0.275738, -0.195738, 0.168225,
> -0.114333, 0.0593316, -0.0583527, -0.016594, 0.0363428, -0.0533603,
> 0.106158, -0.129363, 0.131993, -0.134909, 0.135686, -0.125387,
> 0.0866545, -0.0668686, 0.043161, -0.0229738)
>
> You shall explain more clearly what you did (code) and what are your data
> (dput)
>
> I presume that the story is not as simple as plotting a vector as you have
> suggested.
>
> Petr
>
> > -----Original Message-----
> > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r-
> > project.org] On Behalf Of Baro
> > Sent: Tuesday, January 07, 2014 3:40 PM
> > To: R help
> > Subject: [R] NAs introduced by coercion warning, while plotting data
> >
> > Hi all
> >
> > I have such a Data and I want to plot them but I get this warning
> >
> > Warning message:
> > In xy.coords(x, y, xlabel, ylabel, log) : NAs introduced by coercion
> >
> >
> > " 7.0121, -0.673354, 0.749622, -0.549641, 0.435662, -0.328995,
> > 0.0869976, -0.0851428, -0.191019, 0.188799, -0.373707, 0.434814, -
> > 0.51979, 0.61944, -0.554766, 0.662571, -0.557779, 0.543724, -0.452397,
> > 0.293651, -0.248438, 0.0532787, -0.0185775, -0.176117, 0.222021, -
> > 0.34723, 0.407796, -0.416123, 0.497159, -0.435225, 0.473375, -0.370811,
> > 0.33683, -0.273933, 0.149871, -0.142623, -0.0253748, 0.0205145, -
> > 0.134123, 0.167995, -0.209844, 0.266891, -0.242527, 0.326598, -
> > 0.235483, 0.275738, -0.195738, 0.168225, -0.114333, 0.0593316, -
> > 0.0583527, -0.016594, 0.0363428, -0.0533603, 0.106158, -0.129363,
> > 0.131993, -0.134909, 0.135686, -0.125387, 0.0866545, -0.0668686,
> > 0.043161, -0.0229738 "
> >
> > Why do I get this warning? how can I solve it?
> >
> > [[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.
>
[[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.
______________________________________________
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.
