similar to: Reading data from a worksheet on the Internet

Displaying 20 results from an estimated 100 matches similar to: "Reading data from a worksheet on the Internet"

2010 Mar 12
4
Form using R
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 Barros [[alternative HTML version deleted]]
2010 Apr 22
2
legend problem
Dear R users, I have been plotting several graphics in only one page. I intend to plot only one legend in each page. Since the graphics are inside a loop I have to do it automatically. The main problem is that inside the loop I work with differente types of variables, I mean , the range is different for each one. I have already tried : par(xpd=TRUE) pos<-par("usr")
2010 Sep 27
3
Output Graphics GIF
Dear R users, How could I managed graphics in GIF format? What I have been doing is graphics in *.ps or *.eps and after I convert them using CONVERT (from ImageMagick) but the output quality is not good. Since these graphics will be use for other users they must have a better image quality. I really appreciate any help, -- Abraço, Nilza Barros [[alternative HTML version deleted]]
2010 Feb 10
2
manipulate missing dates in a graphics a vector
Dear all, I am trying to identify the days absent in a vector so as to be able to display missing data in the graphics in .It should be done automatically since the graphics will be generated for different periods of the year. I have been trying to do a function below but it did not work. I really appreciate any help ordados <- function(datas,var) { ind <- !datas %in% var # find the
2010 Oct 03
2
Read file
Dear R-users, I would like to know how could I read a file with different lines lengths. I need read this file and create an output to feed my database. So after reading I'll need create an output like this "INSERT INTO TEMP (DATA,STATION,VAR1,VAR2) VALUES (20100910,837460, 39,390)" I mean, each line should be read. But I don`t how to do this when these lines have different
2010 Oct 13
2
Rmysql - dbWritetable
Dear Rusers, I am trying to feed my database with data from a file. But since my file (2010101000.txt) there`s no headers I am facing problem because the result data.frame is not separated my columns. How could I set variables names for each columns in *dbWriteTable*? I have tried the command below but I don`t know how to fill the *field.type*option. dbWriteTable(con, "b20101010",
2011 May 09
2
Using NULL to my data?
Dear R users, I am reading data from a file where there are some missing that are represented by -9999.00. I am using the command below. =====My original data =========== PARM = TMPC;T12X;T12N;DWPC;PALT;SKNT;DRCT;P24M;CLCL STN YYMMDD/HHMM TMPC T12X T12N DWPC PALT SKNT DRCT P24M CLCL 820420 110429/1200 22.50 -9999.00
2011 May 16
2
File to MYSQL
Dear R-user, I have to feed my database using some SQL commands. I have already read a data frame with the data I need but after that these data should be write in a file wtih SQL commands. 1) My dataframe: dput(Alldados) structure(list(Station_NO = c(836490, 836920, 836950, 836980, 837380, 837460), TMAX_2M = c("NULL", "NULL", "NULL", "NULL",
1999 Sep 07
1
Eudora problems
Hi, I recently had problems setting up Eudora to store its data on a network share. The problem was that while it did work, it was incredibly slow, I would estimate about 10 times slower than it should be. I did some experimentation and found that it worked properly if the client was running Windows 98, but not if the client was running Windows 95. I could also get rid of the problem by turning
2010 Mar 19
1
error in map library
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. I really appreciate any help. > > ===here what I was testing========
2007 Feb 09
1
append within worksheet in write.xls
I can currently append an entire worksheet with write.xls, but would also like to be able to append within the same worksheet. Is this possible? It doesn't seem to work if I use append = T Thanks, Mark -- Mark W. Kimpel MD Neuroinformatics Department of Psychiatry Indiana University School of Medicine
2007 Feb 09
1
newline with cell of Excel worksheet created with write.xls
As part of my project to put different types of results into worksheets, I would like to be able to put an auto-generated methods section. If I compose in RWinEdt, read into R, and use write.table with a .txt file extension, what I get out has line-breaks that correspond to those I put in in the first place. If I do the same thing but write.xls with .xls extention, I get an Excel worksheet
2011 Jun 24
3
extract worksheet names from an Excel file
Hi list, Is there a R function I can use to extract the worksheet names from an Excel file?? If no, any other automatic ways (not using R) to do this? thanks! ...Tao
2009 Mar 12
1
read.xls and name of worksheet
Hi, I would like to some excel files with some worksheets. I tried this with the following R script: library(gdata) i<-1 rc<-0 while(rc != "try-error") { wksh<-try(read.xls("cluster-microarray-FW.xls",sheet=i,verbose=TRUE,perl="perl")) rc<-class(wksh) print(sprintf("------- i=%2d rc=%s ---------------",i,rc)) if (rc !=
2013 Oct 11
1
behaviour of read.xls (gdata package) when worksheet usesuser-defined cells formats
(I'm afraid this post didn't reach the list on last Wednesday, here it is again ) hi R-list, And sorry for my frenglish ! I am running R < Good Sport > release ( i386-w64-mingw32/i386 (32-bit) ) ) under Windows 7 Professional, Service Pack 1. My perl executable is ActivePerl build 817 [257965] (i.e. version 5.8.8.817). Usually it is working fine. Using the gdata ::read.xls
2010 Nov 12
3
Replicate Excel's LOGEST worksheet function in R
Hi - I have a dataframe of (x,y) values. I'd like to fit an exponential curve to the data for further statistical analysis (pretty much the same functionality provided by Excel's LOGEST worksheet array function). Can someone point me to the (set of) functions/ package that is best suited to provide this functionality? Admittedly, I am a novice in the use of R statistical functions,
2010 Dec 18
0
R-sig-DB Digest, Vol 74, Issue 2
Hi, Your mistake is related with "read.table(n)". I haven`t got what you want but I put an example below (where I used loop to read many files). Hope it helps. Anyway, I thougth should have sent your question to <r-help@r-project.org>. Bye Nilza =====example ==================== nomesout <- dir(dat.dir,pattern="^[s]") #obtem no diretorio de atual todos arquivo
2007 Mar 23
6
Updating a worksheet in Excel file using RODBC
Hello! I have no problem reading Excel files (each worksheet in the file is a "table" which can be read - at least in my case). What I would like to do is to read such a table, change it (just the contents, not the format) and write it back, and this I can not do. I am getting the following error messages (3 slightly different attempts): > sqlSave(con, x, tablename =
2010 Mar 17
0
In readGDAL(destfile, silent = TRUE) : GeoTransform values not available
Dear Ruser, I am trying to use the map library. But I have been problem the follow message. Warning message: *In readGDAL(destfile, silent = TRUE) : GeoTransform values not available * library(rgdal) library(RgoogleMaps) > GetMap(markers = '40.702147,-74.015794,blues%7C40.711614,-74.012318,greeng%7C40.718217,-73.998284,redc', destfile = "MyTile1.png"); Read 1 item [1]
2018 May 14
9
[Bug 106512] New: Fatal: NVIDIA GEFORCE 320M MCP89: Can't start X on kernel 4.15
https://bugs.freedesktop.org/show_bug.cgi?id=106512 Bug ID: 106512 Summary: Fatal: NVIDIA GEFORCE 320M MCP89: Can't start X on kernel 4.15 Product: Mesa Version: unspecified Hardware: Other OS: All Status: NEW Severity: normal Priority: medium Component: