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