similar to: Reading OpenOffice Calc spreadsheet into R

Displaying 20 results from an estimated 1000 matches similar to: "Reading OpenOffice Calc spreadsheet into R"

2008 Feb 13
1
Modelling disease spread
I was at a lecture the other day and I saw a presentation of very neat (short) animation modeling epidemic disease spread over a map region. When I ask what software they used they mentioned SAS. Do you know if there are equivalent resources in R to model the spread of disease with animation output? My search in R-help and google didn't lead to any document (though I found a couple of
2009 Sep 06
3
Video Analysis?
What software exists for digitizing video to quantify the motion of specific features in the image? I might be willing to use something that's NOT in R, though I'd prefer something in R (or at least with an R intereface). Thanks, Spencer Graves
2008 Aug 06
2
Statistics on raster pictures - asking for an advice
Hello, I need to do some basic statistics on raster images (tiff or png). I need only an advice where to start, which package is the most appropriate. My search attempts were without success, yet. Many thanks Tomas
2007 Sep 26
1
Calling R function from Java
Hi - I would like to have the same functionality like what R(D)COM server offers but from Java world. I have java code (on windows) and need to call some R code to run some computational job and get the result back into java code. I'm wondering if there's any direct package that offers this functionality? Thank you. - adschai
2007 Aug 23
4
Calculating diameters of cirkels in a picture.
Hi, Maybe this is more a programming questions than a specific R-project question, but maybe there is someone who can point me in the right direction. I have a picture of cirkels which I took with a digital camera. Now I want to use the diameter of the cirkels on the picture for analysis in R. I can use pixmap to import the picture, but how do I find the outside cirkels and calculate the
2009 Nov 03
1
OpenOffice Calc ODBC equivalent
Hi R users: I am using RODBC to create some new ".xls" files each with several sheets (about 100) with sqlSave() from a data.frame inside R without any problem, but on windows XP platform. I would like to know if it is posible to make a similar solution on linux with openoffice? RODBC work only (for the moment) with ".xls" on windows, via the ODBC driver. Is it posible to
2010 Aug 11
1
OpenOffice.org 3.1.1 Calc autofill does not work
Hi all, Has anyone upgraded OpenOffice.org 3.1.1 on Centos 5.3? Everything seemed fine but I have found 1 problem on Calc. The autofill does not work. Example, when I type "Jan" in cell A5 and drag the handle to cell D5, the Fill Settings dialog box pops up instead of the Feb, Mar, Apr filling in the cell automatically. When OpenOffice.org 3.1.1 from Sun is installed, it works.
2003 Oct 09
1
R-OpenOffice.org Calc
I have been very satisfied with R-Excel interface (DCOM). Few months ago I have changed my OS to Linux-Mandrake, and now I am using OpenOffice.org Calc as spreadsheet. I would like to know does exist some R-OpenOffice.org interface or how is possible to use R-functions in OpenOffice.org Calc? Thanks a lot!
2009 Jul 09
2
How to Populate List
Hi, I'm new to R and would like to know, how one can populate the list with array data. I'm reading a tab separated table in R. The data in the table looks something like this. #Table Data Comp    A    B    C Extracellular    103    268    535759 Nucleus    45603    47783    442744 #R code myData <- read.table("table.data",                 header=T,                
2007 Dec 14
1
RJDBC to OpenOffice Calc as RODBC to MS Excel
Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =
2010 Apr 03
2
(OT) OpenOffice.org calc chart strangeness.
I am attempting to create a simple line chart graphing three columns from a soffice-calc spreadsheet. I expect it to take the leftmost column as the X-Axis, plotting the others on the Y-Axis, but it always creates an X-Axis of the row number in the columns, and the first column amongst the data. I have tried this on OpenOffice.org 3.2.0, NeoOffice(R) 3.0.2 Patch 2, iWork Pages, and Excel 12.2.4
2009 Aug 06
5
Serious bug in OpenOffice.org Calc shipped with CentOS
Hi, Until now I've been a happy user of CentOS. Everything just works(tm), and I don't care if application versions are slightly outdated. Next week I have to give a series of classes for a company that recently made the switch to Linux. On schedule is a one-week course for Writer and Calc. And right now I discover that one crucial function of Calc, "fill series",
2007 Oct 02
2
Calculating proportions from a data frame rather than a table
When one has raw data it is easy to create a table of one variable against another and then calculate proportions For example a.nice.table<-table(a,b) prop.table(a.nice.table,1) However, I looked at several papers and created a data frame of the aggregate data. That means I acually created a table except it is a data frame. The first column lists the name of the first author and the year. I
2008 Apr 25
2
Differentiate alphanumeric vs numeric strings
I have a bunch of tables in a Microsoft Access database. An updated database is sent to me every week containing a new table. I know that is inefficient and weird but welcome to my life. I want to read the tables whose names are something such as "040207" but not the ones that have alphanumeric names such as "everyone". Using RODBC I am easily able to create a character vector
2006 Nov 29
2
reshape command is (stats) dropping instances
I would really appreciate it if anyone could determine what is going on with the following command. It is only half-working and is losing lots of data. For the life of me I cannot even see the pattern of what it is losing and what it is not. I am attaching the R data set which you can use with the Load Workspace menu function.
2009 Jul 19
4
space in column name
I read a table from Microsoft Access using RODBC. Some of the variables had a name with a space in it. R has no problem with it but I do. I cannot find out how to specify the space names(alltime) [1] "ID" "LVL7" "Ref Pv No" "Ref Pv Name" "DOS" "Pt Last Name" "Pt First Name" "MRN"
2008 Dec 15
3
Reading from Google Docs
I saw a thread from September 24 in which Duncan Temple Lang told us: - The package currently has no Rd files, but there is a brief "user's guide". The package is available from http://www.omegahat.org/RGoogleDocs I could not find it by using Tinn-R or RGui's package install tool. Then when I went to the website I saw that package is only available as
2009 Mar 24
2
two different date formats in the same variable
How does one convert to a date format when survey respondents have used two different date formats whilst entering their data. There were clearly told to use mm/dd/yyyy but humans being humans some entered mm/dd/yy. There was even validity checks on the forms but I allowed them to be overridden since the data is more holy than the format. The data was downloaded as a csv and read.csv was used to
2006 Nov 24
1
Sunflower plot error; how to deal with NA
I suspect the problem stems from the fact that there are a couple of NA values. > sunflowerplot(lastoto,maxear) Error in rep.int(i.multi, number[number > 1]) : invalid number of copies in rep.int() So I used the subset command to get rid of the cases with NA hell<-subset(ChinOtoMayB,is.na(lastoto)==FALSE) Then it worked perfectly sunflowerplot(hell$lastoto,hell$maxear) Is
2006 May 30
1
sib TDT transmission/disequilibrium test
Does anyone know if the sib TDT has been implemented in R 1. Spielman, R.S., and Ewens, W.J. (1998) A sibship test for linkage in the presence of association: the sib transmission/disequilibrium test. Am J Hum Genet 62, 450-458 -- Farrel Buchinsky, MD Pediatric Otolaryngologist Allegheny General Hospital Pittsburgh, PA