Re: [R] [R-sig-DB] Reading data from a worksheet on the Internet

2012-02-12 Thread Nilza BARROS
I had written the one related to only worksheet (PLANILHA2) when I copy it to my browse it is showed the link with both worksheets. I am going to read about Rcurl and XML libraries but I hope you can help me too. Thanks in advance Nilza Barros On Sun, Feb 12, 2012 at 10:42 AM, CIURANA EUGENE (R)

[R] Reading data from a worksheet on the Internet

2012-02-11 Thread Nilza BARROS
ne can see the from where I am trying to export the data: dados<-url(" http://www.mar.mil.br/dhn/chm/meteo/prev/dados/pnboia/sc1201_arquivos/sheet002.htm","r ") I am looking forward any help. Thanks in advance , Nilza Barros [

Re: [R] File to MYSQL

2011-05-16 Thread Nilza BARROS
01 PM, Nilza BARROS wrote: > Hi, Jerome > > I was trying to use RMYSQL > > for (i in length(Query)) { > rs1<-dbSendQuery(con,Query[i]) > } > > But although the Query have several lines the command above just feed my > database with the first one. > >

Re: [R] File to MYSQL

2011-05-16 Thread Nilza BARROS
OBS (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL,Station_NO) VALUES (2011051312,21.6,NULL,18.1,19.7,1003,1.94,140,0.00,2,836950);" Thanks, On Mon, May 16, 2011 at 4:46 PM, Jerome Asselin < jerome.asselin.s...@gmail.com> wrote: > On Mon, 2011-05-16 at 14:

[R] File to MYSQL

2011-05-16 Thread Nilza BARROS
or the right syntax to use near '"INSERT INTO OBS (date,T_2M,TMAX_2M,TMIN_2M,TD_2M,PS,FF_10M,DD_10M,TOT_PRCP,CLCL' at line 1 "INSERT INTO OBS (date,TMAX_2M,TMIN_2M,TD_2M,PS,Station_NO) VALUES (2011051312, NULL, 20.6,19.4,1014.8,836490)" "INSERT INTO OBS (date,TMAX_2M,TM

Re: [R] Using NULL to my data?

2011-05-09 Thread Nilza BARROS
011042912, 23.3, NULL, 22.8,821810)" On Mon, May 9, 2011 at 2:05 PM, Gabor Grothendieck wrote: > On Mon, May 9, 2011 at 12:59 PM, Nilza BARROS > wrote: > > Hi, Thanks for your attentio. > > > > I have the data frame below: > > > >> head(Alldado

Re: [R] Using NULL to my data?

2011-05-09 Thread Nilza BARROS
is in terms of a very > small self contained example explaining what you get and what you > expected to get. > > Regards. > > On Mon, May 9, 2011 at 12:40 PM, Nilza BARROS > wrote: > > Dear Ruser, > > > > Thank for your help. > > I've just tried the

Re: [R] Using NULL to my data?

2011-05-09 Thread Nilza BARROS
be numeric or character. How can I use the format command above the allow it. I really appreciate any help. Nilza On Mon, May 9, 2011 at 12:55 PM, David Winsemius wrote: > > On May 9, 2011, at 10:07 AM, Nilza BARROS wrote: > > Dear R users, >> >> I am reading da

[R] Using NULL to my data?

2011-05-09 Thread Nilza BARROS
e original data : which(is.na(Alldados),arr.ind=TRUE) But I don't know how to replace each NA with NULL. I tried using as.null but NA is not replace at all. I hope someone could help me. Best Wishes, Nilza Barros [[alternative HTML version deleted]]

Re: [R] R-sig-DB Digest, Vol 74, Issue 2

2010-12-18 Thread Nilza BARROS
for (i in 1:n) { > bases <- read.table(n) > bases[i]<-read.table(mysites[[i]], sep=";", header=TRUE, > fileEncoding="windows-1252") > tudo <- rbind(myresult, bases) > } > > Error in read.table(n) : 'file' must be a character string or connection &

Re: [R] [R-sig-DB] Rmysql - dbWritetable

2010-10-16 Thread Nilza BARROS
> helps me pose the question in a way more likely to generate an answer that > actually helps me solve the problem. > > > I'm sorry if this is not any more helpful than my previous reply. > Spencer Graves > > > On 10/15/2010 7:39 PM, Nilza BARROS wrote:

[R] Rmysql - dbWritetable

2010-10-12 Thread Nilza BARROS
1017207 7.2 297.1 -.0 5 00859 2010 10 09 23 50 -41.51 6.81 - 1015 - -.0 -.0 -.0 6 5 2010 10 09 23 00 -34.69 -18.89 - 1017207 7.2 297.1 -.0 7 00617 2010 10 09 23 20 -18.43 -23.09 - 1023 - -.0 -9

Re: [R] Read file

2010-10-05 Thread Nilza BARROS
Dear Gabor and Jim You both gave me amazing solutions. I will use. Thanks! Nilza On Tue, Oct 5, 2010 at 2:11 AM, Gabor Grothendieck wrote: > On Sat, Oct 2, 2010 at 11:31 PM, Nilza BARROS > wrote: > > Dear R-users, > > > > I would like to know how could I read a f

Re: [R] Read file

2010-10-04 Thread Nilza BARROS
st column values for the lines you earlier selected*. ## It gave me all the station that started with `873`. I did it just because I needed to know how many station there was in the file. But it is not helping me to solve the problem. Thanks in Advanced Nilza Barros On Sun, Oct 3, 2010 at 11:05 PM,

Re: [R] Read file

2010-10-03 Thread Nilza BARROS
epl... > > start.pos <- which(indata, grepl("^\\s*\\*", indata) > > When you're finished reading the file... > close(fcon) > > Hope this helps, > > Michael > > > On 3 October 2010 13:31, Nilza BARROS wrote: > > Dear R-users, > > &

Re: [R] Output Graphics GIF

2010-10-03 Thread Nilza BARROS
cs.co.il (Hebrew) | > www.r-statistics.com (English) > > ---------- > > > > > On Mon, Sep 27, 2010 at 2:39 PM, Nilza BARROS wrote: > >> Dear R users, >> >> How could I managed graphics in GIF format? What I have been doing is >> graphics i

[R] Read file

2010-10-02 Thread Nilza BARROS
28523.7 267.1 232.1 32 400.0 755025535.5 255.4 231.4 32 300.0 964026537.0 242.2 216.2 32 Best Regards, -- Abraço, Nilza Barros [[alternative HTML version deleted]] __ R-help@r-project.org mai

Re: [R] Output Graphics GIF

2010-10-02 Thread Nilza BARROS
Dear R users, Thanks!. After reading the suggestions I have decided to choose png format Bye and Best Regards, Nilza On Mon, Sep 27, 2010 at 11:18 AM, Barry Rowlingson < b.rowling...@lancaster.ac.uk> wrote: > On Mon, Sep 27, 2010 at 1:39 PM, Nilza BARROS > wrote: >

[R] Output Graphics GIF

2010-09-27 Thread Nilza BARROS
really appreciate any help, -- Abraço, Nilza Barros -- Abraço, Nilza Barros [[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

[R] Output Graphics GIF

2010-09-27 Thread Nilza BARROS
really appreciate any help, -- Abraço, Nilza Barros [[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

[R] legend problem

2010-04-22 Thread Nilza BARROS
Something like I've done with title. You can see one figure an attached file. I really appreciate any help. Nilza Barros -- Abraço, Nilza Barros __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the

[R] error in map library

2010-03-20 Thread Nilza BARROS
1.0007824726 >> par('usr')[1] -320 320 -320 320 >> List of 4 >> $ : num 40.7 >> $ : num -74 >> $ : num 15 >> $ : int [1:640, 1:640] 683 683 683 683 683 683 683 683 683 683 ... >> ..- attr(*, "COL")= chr

[R] error in map library

2010-03-18 Thread Nilza BARROS
Dear Ruser, > > > I am trying to use the map library. But unfortunately I am facing the > warning message above: > Warning message: > *In readGDAL(destfile, silent = TRUE) : GeoTransform values not available > * I want to use that library because I intend to plot some station in a Brazilian map.

[R] In readGDAL(destfile, silent = TRUE) : GeoTransform values not available

2010-03-16 Thread Nilza BARROS
4 $ : num 40.7 $ : num -74 $ : num 15 $ : int [1:640, 1:640] 683 683 683 683 683 683 683 683 683 683 ... ..- attr(*, "COL")= chr [1:1047] "#00" "#0044DF" "#004EF4" "#0052FF" ... ..- attr(*, "type")= c

Re: [R] Form using R

2010-03-15 Thread Nilza BARROS
r-easily-collecting-and-importing-data-for-analysis/> > > on Fri, Mar 12, 2010 at 4:49 PM, Nilza BARROS gmail.com> > wrote: > > > > > Hi, R users > > > > > > We can create a form using R? > > > I would like to create a form where the information

Re: [R] Form using R

2010-03-12 Thread Nilza BARROS
the graphs created. I wish the print was not necessary. Furthermore, the reasons would be tabulated automatically. Please let me know if I were clear. Thanks for you attention Nilza Barros On Fri, Mar 12, 2010 at 2:21 PM, Ista Zahn wrote: > HI Nilza, > I don't think this quest

[R] Form using R

2010-03-12 Thread Nilza BARROS
Hi, R users We can create a form using R? I would like to create a form where the information can be read by R. Itneeds to be updated daily because I have to tabulate the reasons for delays in the generation of numerical models products. I really appreciate any help, Thanks in advance, Nilza

Re: [R] manipulate missing dates in a graphics a vector

2010-02-10 Thread Nilza BARROS
Thank you !! That's exactly what I need. Nilza Barros On Tue, Feb 9, 2010 at 10:50 PM, Dennis Murphy wrote: > Hi: > > # Create a sequence of consecutive dates and assign to a data frame > > dates <- data.frame(day = seq(as.Date('2009-12-01'), by = 'days&#

[R] manipulate missing dates in a graphics a vector

2010-02-09 Thread Nilza BARROS
5 20.8 2009-12-06 NA 2009-12-07 NA 2009-12-08 20.8 Bye and Best Regards Nilza Barros [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posti