Displaying 20 results from an estimated 8000 matches similar to: "Saving tab/csv delimited data with NaN's"
2004 Jul 30
1
Three-way ANOVA?
Hi,
I'm a biologist, so please forgive me if my question sounds absurd! I have 3
parameters x1, x2, x3 and a response variable y.The sample size is 75. I tried
to do the following:
mylm<-lm(y~ x1 + x2 + x3, data="mydata")
but i can only get stats from anova for the first 2 variables. The third comes
up as NA. The degrees of freedom for the third variable are 0.
Is there
2012 Nov 08
3
problem with package development and older defs earlier in search order
Hi,
I have a problem with a package I have developed in that functions do not get loaded due to older versions of the functions being in the .GlobalEnv? fetched from .Rdata files stored from previous saved workspaces. I need to be able to fix this somehow when I load the package. I do not want to mess up the search order to fix the problem.
How I got myself into this mess is that I started
2008 May 29
1
Separator argument in read.table
Hi,
Suppose I have the following tabular data:
1729_at | TRADD | TNFRSF1A-associated via death domain | protein-coding
1773_at | FNTB | farnesyltransferase, CAAX box, beta | protein-coding
177_at | PLD1 | phospholipase D1, phosphatidylcholine-specific | protein-coding
What is the right separator used for read.table function?
I tried this:
dat <-
2008 Apr 16
1
efficiently replacing values in a matrix
Hello all,
I should probably know this by now... Anyway:
I have a large matrix (dim(data) is 3000 18000). In each element are
one of the following character strings "0/0", "1/1", "1/2", "2/2". I
wanted to replace "0/0" with NA and the other three with 0,1,2
respectively. To accomplish just the first of these four steps I did
this:
2002 Apr 04
1
PR#1132.
Just now I again had occasion to want nested describe lists in a
documentation file. I found that the bug which I reported on 18
October, 2001 still persists. I checked on the bug report at the R
web page, and found that the notes say ``Not a problem in R 1.4.0
(2001-12-08)''.
Well, it's still a problem for me --- using R 1.4.1.
(Details:
platform sparc-sun-solaris2.7
arch
2002 Nov 06
1
What else do tab-delimited and csv do differently?
Until recently, I naively believed that a csv was the same as a
tab-delimited file except commas replaced tab characters (provided
of course, the characters being separated weren't either).
Evidently, that is not the case. I tried reading a tab-delimited file
(created in Excel [2000, W2K] and ftp'd as ASCII to linux) into R
platform i686-pc-linux-gnu
arch i686
os
2010 Nov 22
3
"unexpected numeric constant" while reading tab delimited csv file
my csv file is very simple - just one line for purpose of this test:
0{TAB}0
and read function is this:
csvdata = read.csv(file="d:/s/test.csv",head=FALSE,sep="\t")
then error comes:
Error in source("d:/test.csv") :
d:/test.csv:1:9: unexpected numeric constant
1: 0 0
but when I change delimiter to ; (colon) then error not shows up anymore
--
View this
2011 Jul 19
1
"may be used in an incorrect context"
R CMD check tells me
* checking R code for possible problems ... NOTE
agexact.fit.rds: ... may be used in an incorrect context: ?optim(init,
agfitfn, ...)?
Warning: <anonymous>: ... may be used in an incorrect context: ?optim(init, agfitfn, ...)?
Can anyone tell me what this message means? My searches haven't turned
up anything useful. This is with R 2.7 and 2.9.
The message
2008 May 25
2
How to create tab-delimited text files
Hello Friends
I want to generate tab-delimited text file of my every users
information in once.
i have a button called EXPORT on my page when i clicked on this button
than i want to generate tab-delimited text file for every users
information.
can anybody give any snippet of code or any idea for this
Thanks
--
Posted via http://www.ruby-forum.com/.
2007 May 20
3
Why a multi column, tab delimited file has only one column after reading in with read.table specification sep="\t"
Dear all:
I have a tab delimited file as following
AGE WEIGHT PROTEIN ........
6 20 3 ........
8 39 4 ........
I tried to read it as following:
data <- read.table(file,sep="\t",header=T);
but there is only column for the data after reading in,:
dim(data);
[1] 200 1
the column name is "AGE...WEIGHT...........PROTEIN...."
Any quick suggestion will be appreciated.
2012 Apr 04
3
Remove carriage return in writing tab-delimited file.
Having problems with the write.table function. I can write a tab delimited
file just fine, but for each line in my matrix its inputs a carriage return
when i dont want it to.
For example my matrix might be:
ID V1 V2 V3
FARY1004 1 2 3
FARY2067 2 3 1
FARY4587 2 2 2
And I want the written File to be:
FARY1004 1 2 3FARY2067 2 3 1FARY4587 2 2
2
TIA
--
View this
2012 Jan 19
2
Reading in tab (and space) delimited data within a script XXXX
Hello everyone,
I use Bob Muenchen's approach for reading in "in-stream" (to use SAS
parlance) delimited data within a script. This works great:
mystring <-
"id,workshop,gender,q1,q2,q3,q4
1,1,f,1,1,5,1
2,2,f,2,1,4,1
3,1,f,2,2,4,3
4,2, ,3,1, ,3
5,1,m,4,5,2,4
6,2,m,5,4,5,5
7,1,m,5,3,4,4
8,2,m,4,5,5,5"
mydata <- read.table( textConnection(mystring),
2003 Mar 05
3
reading in tab delimited data in a loop
Dear all,
I need to read in 4 sets of tab delimited data in a loop. The 4 data sets are called "simu1.dat", "simu2.dat" and so on. I know what I need on the righthand side of the read.table expression but I can't the left hand side of it to work (see the line in bold below). Can you kindly help? Many thanks.
simu1 <- matrix(0,30,3)
simu2 <- matrix(0,30,3)
simu3
2009 Nov 26
1
analyse tab delimited textfile microarray data(help)
An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20091126/6366832d/attachment-0001.pl>
2007 Dec 06
1
Building package - tab delimited example data issue
Hello,
I'm trying to integrate example data in the shape of a tab delimited ASCII
file into my package and therefore dropped it into the data subdirectory.
The build works out just fine, but when I attempt to install I get:
** building package indices ...
Error in scan(file, what, nmax, sep, dec, quote, skip, nlines,
na.strings, :
line 1 did not have 500 elements
Calls: <Anonymous>
2007 Feb 26
1
Chi Square with two tab-delimited text files
Hi,
I want to do a chi square test and I have two tab delimited text files with
Expected and Observed values to compare. Each file contains only the values
and are 48 rows by 116 columns. I have managed to do something with them,
but I don't think it is right as I got a p value of 1. In this case I used
the read.table() function to read the values from the files. But I don't
know if
2008 Apr 30
1
Tab-delimited AOV summaries
Hello,
I am trying to print out ANOVA summaries --- as returned by summary
(aov(...))--- in tab-delimited format, either to a file or to the
console, but so far I haven't been able to figure out a solution. My
particular ANOVA has repeated measures, so it is an instance of class
aovlist. Can anyone offer any suggestions? I am relatively new to R,
so please forgive me if I am missing
2011 Mar 23
4
Modifying a particular column in a tab-delimited file
Hello R users,
Good day!!
I was wondering if there is a way in R to read in a particular column from a tab-delimited file, edit it and write it back into the file with all other columns intact. When I say edit I mean just replacing all the values in that column.
I know to read a particular column from a file using colClasses option in read.delim() function.
Is there any such option to write out
2010 Mar 02
1
Reading data file with both fixed and tab-delimited fields
Hello R wizards,
What is the best way to read a data file containing both fixed-width and
tab-delimited files? (More detail follows.)
_*Details:*_
The U.S. Bureau of Labor Statistics provides local area unemployment
statistics at ftp://ftp.bls.gov/pub/time.series/la/, and the data are
documented in the file la.txt
<ftp://ftp.bls.gov/pub/time.series/la/la.txt>. Each data file has five
2012 Feb 02
9
sqldf for Very Large Tab Delimited Files
Hi All,
I have a very (very) large tab-delimited text file without headers. There
are only 8 columns and millions of rows. I want to make numerous pieces of
this file by sub-setting it for individual stations. Station is given as in
the first column. I am trying to learn and use sqldf package for this but am
stuck in a couple of places.
To simulate my requirement, I have taken iris dataset as an