Displaying 20 results from an estimated 1000 matches similar to: "Printing data as a narrative or form letter rather than as a table"
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
2009 Jul 08
1
Getting value rather than formula in RGoogleDocs
Is there an easy way to read the value of the cells rather than the formula?So
for instance in a cell whose value was created by simply using the value
from the cell immediately to the left in the Google spreadsheet I would
prefer to get the value rather than =RC[-1]
When one exports with Google Spreadsheets as a csv then that does not
happen.
I am using the following line of code in R
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,
2008 Dec 10
2
converting multiple columns from POSIX* to Date
converting a POSIX class variable to a date class is easy.
dates<-as.Date(x) #where X is of class POSIX
How does one do that to all columns in a data frame that are of POSIX
class and leave all the other columns (integers, factors) as is.
Feel free to reply with just one or two buzzwords that I could then
search for to find how to do it.
Farrel Buchinsky
2006 May 07
0
How to a handle an error in a loop [Broadcast]
This ought to work:
resultdt <- lapply(PGWide[, 240:389], function(x, ...) try(tdt(x, ...)))
You can then check the class of each component to see which one failed.
Andy
From: Farrel Buchinsky
>
> "Berton Gunter" <gunter.berton at gene.com> wrote in message
> news:008601c67097$de1b46e0$5bc4fea9 at gne.windows.gene.com...
> > ?try
> >
> > as in
2006 Jan 17
2
Installing a package yet it will not work.
I want R to read my Microsoft Access database or maybe even a Sybase
database. I installed RODBC or at least thought I did. Then I issued the
following command:
library(RODBC)
And got
Error in lazyLoadDBfetch(key, datafile, compressed, envhook) :
ReadItem: unknown type 241
In addition: Warning message:
package 'RODBC' was built under R version 2.3.0
Error: package/namespace
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.
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
2008 Oct 03
1
Tinn-R explorer used to be my friend
I have upgraded everything lately and can no longer get the Tinn-R explorer
to work. I think I have had this problem before but cannot recall how I
solved it.I run Tinn-R 2.0.0.7 and Rgui version 2.7.2
When I click on the explorer button I get
> trObjList(envir='.GlobalEnv', pattern='', group='', path=.trPaths[3])
Error in trObjList(envir = ".GlobalEnv",
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 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
2007 Jan 09
3
dimensions of a all objects
Why will the following command not work
sapply(objects(),dim)
What does it say about the objects list? What does it say about the dim
command?
Likewise, the following also does not work
all<-ls()
for (f in all) print(dim(f))
--
Farrel Buchinsky
[[alternative HTML version deleted]]
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 May 19
1
RGoogleDocs: can now see documents but cannot get content.
The author of the package, Duncan Temple Lang posted an update. I have
installed it and now can list my spreadsheets but alas I cannot read the
data within any of them.
Has anybody been able to get it to work.
I would love to see a real live example of sheetAsMatrix
I am not sure how to specify sheet and con = sheet@connection. I have tried
many ways but just get:
Error in !includeEmpty : invalid
2009 Jan 23
2
forward slash vs double backslash R and Tinn-R
I installed the newest version of R and once again ran into problem
with Tinn-R failing when trying to use the R explorer. I had this
problem once before and solved it when I added the following
.trPaths = c(
'C:/Documents and Settings/fbuchins/Application Data/Tinn-R/tmp/',
'C:/Documents and Settings/fbuchins/Application Data/Tinn-R/tmp/search.txt',
'C:/Documents and
2006 Jan 25
2
Unequal sample sizes when calculating power
Power calculations two sample test for proportions is very useful. Is there
a way however, to get away from the two samples being of the same size. What
would happen if one had n=15 in the one sample and n=45 in the other sample.
Farrel Buchinsky, MD
Pediatric Otolaryngologist
Allegheny General Hospital
Pittsburgh, PA
**********************************************************************
2007 Jan 01
1
Subset by using multiple values
I have a vector containg about 20 unique values. It is called rejectrs$rs.
It is a factor
I have a data frame with about 100000 rows.
I want to exclude all rows where in variable rs the value is one of the 20
on the exclude list. I thought this would work but none did.
RawSeqBig<-subset(RawSeqBig,ASSAY_ID!=rejectrs$rs)
RawSeqBig<-subset(RawSeqBig,ASSAY_ID!=list(rejectrs$rs))
--
Farrel
2008 Oct 28
1
outputting (writing) output into a dataframe
I have solved this problem once before but don't recall exactly how.
Is there a url that shows how?
What I want to do now is quite specific but my query is actually very general
There are many functions in which one specifies several parameters and
an output is generated. Well what happens if one wants to specify a
range of parameters and have the output written to a data frame.
To
2011 Jan 26
2
applying a set of rules to each row
All,
I would like to apply a set of rules to each row of the sample data set
below. The rule sets are the guidelines for determining an individual's
date for retirement eligibility. The rules are found in this document,
http://www.opm.gov/feddata/RetirementPaperFinal_v4.pdf. I am only
interested in the top two categories for retirement eligibility, the
CSRS and FERS plans.
The data set has
2006 May 14
2
Bioconductor AND Genetics Library
I am aware of the R Genetics Project that developed the R library and
software called Bioconductor (http://www.bioconductor.org/ ) . How do the
two relate to each other? What is the one that the other is not and vice
versa? Can anybody link me to something that answers the question?
--
Farrel Buchinsky, MD
Pediatric Otolaryngologist
Allegheny General Hospital
Pittsburgh, PA