similar to: missing values

In R, How to read Excel file and access the data item? Thank you. --------------------------------- [[alternative HTML version deleted]]

Hello, I was trying to import data from an Excel file. After I imported the data, I was trying to make a scatter plot. The X axes variable is a time variable, which occupies two columns, one is date, another one is time. Example 21-Apr-03, 4:10 PM. My qestion is: 1. How can I access the data of certain column? I mean how can I refer it in R? 2. How can I make the two column character

if I want to specify y-coordinates for the heights of horizontal lines to go across a plot. x <- c(1,2,3,6,4,8,4,7) y <- c(3,2,7,4,5,4,5,6) h <- c(3,5,7) plot(x,y) abline(y=h) However I got error message: Warning message: parameter "y" couldn't be set in high-level plot() function (I tried abline(h=y) , it;s not what I want also) Do u know why?

Dear All, I've been using R for windows for a while, without too many problems. However, I'm forced to use the MAC OS system for teaching, because our teaching labs are mac only (not my idea!!). I have a very basic problem, but one that doesn't appear on the FAQs. I simply want to import data from a spreadsheet. I'm using exactly what works fine on Windows, namely: 1 save

I started to learn the R language, but I didn't suceed to use an external file. Let say that I have an excel file called "test1.xls" in the directory "C:/program files/R/rw2000/external_files" that looks like that: name mark yair 80 yosi 70 ... In the appropriate directory I wrote this: x<-read.delim("test1.xls") or this:

ABCD are four matrix. A * Inverse((Transpose(A)*Tranpose(B)*B*A+C)) * Transpose(A) * Transpose(B) * D how to write in R in an efficient way? --------------------------------- [[alternative HTML version deleted]]

*I am a very new user of R. I've spent several hours trying to import data, so I feel okay asking the list for help. * *I had an Excel file, then I turned it into a "tab-delimited" file, as instructed by directions My filename is "lahore.txt" I amusing the following commands for read.delim but i am getting following mesages. Sir i am sending you my excel data file i

I have a question about how to save the output of a logistic regression model in some format (delimited, preferably) so that I can manipulate it to make nice tables in excel. I have tried print, save, write, none seem to do what I want them to. Does anyone have any ideas? Lynn D. Disney, Ph.D., J.D., M.P.H. Research Analyst SEIU 1199 1771 E. 30th Street Cleveland, Ohio 44114 Telephone:

Hey there, I apologize if this is an irritatingly simple question ... I'm a new user. I can't understand why R flips the sign of all data values when reading in external text files (tab delimited or csv) with the read.delim or read.csv functions. The signs of data values also seem to be flipped after assigning a new data.frame from within R (xnew <-- edit(data.frame()). What am

Hi, I am trying to calculate correlation coefficient for gene expression data. Tab delimited file looks like this Id v1 v2 v3 df 56 90 45 gh 87 98 78 ty 89 78 67 I used this code [code] gse20437 <- read.csv("C:/Users//Desktop/data/GSE20437_matrix.txt",header = TRUE, sep = ",", strip.white = TRUE) gsecor <- cor(gse20437, method

Full_Name: Liam Gretton Version: 2.9.2 OS: openSUSE 11.1 (x86_64) Submission from: (NULL) (143.210.13.77) Reading a large number of rows of delimited data via the clipboard results in a segfault or double free error. I've tested copying from various applications, but gedit will do. This problem exists in the openSUSE-supplied 2.8.1, I've just built 2.9.2 to see if it's still there,

Hi, It would be great if someone would add write.delim() as an adjunct to write.table(), just as with write.csv(). I store a lot of data in tab-delimited files and can read it in easily with: read.delim("text.txt", as.is=TRUE) and would love to be able to write it out as easily when I create these files. The obvious setting needed for write.delim() is sep = "\t", but in

Hi I am a beginner with R. I have been trying to import a tab delimited excel file but i get the following error message > file.show('C:\Documents and Settings\stats\Desktop\SUMI\plasma2.txt') Warning message: file.show(): file 'C:Documents and SettingsstatsDesktopSUMIplasma2.txt' does not exist I have understood the programming part but i cannot go ahead unless i have

I am trying to import a permanent SAS data set using read.ssd in the foreign library. I get the following error: > list.files("C:/temp") [1] "newdat1.sas7bdat" "snpm1.sas7bdat" "test1.sas" > library(foreign) > newdat1 <- read.ssd("C:/temp","newdat1") SAS failed. SAS program at

Dear List: I had some strange experience in importing data. I wonder if anyone of you had the same problem before and would greatly appreciate your suggestion in advance. The original data set in excel format. Here is a brief summary of the procedure I did: 1. I saved the original excel data as csv and txt formats, separately. 2. I imported two data using the following codes. There were no

Hello, R users, I am a very beginner of R and tried read.csv to import an excel file after saving an excel file as csv. But it added alternating rows of fictitious NA values after row number 16. When I applied read.delim, there were trailing several commas at the end of each row after row number 16 instead of NA values. Appreciate your help. Kyong [[alternative HTML version deleted]]

Dear R helpers, I am trying to read a CSV file in R called EUROPE (originally an Excel file which I have saved as a CSV file) using the command EUROPEDATA <- read.csv("EUROPE.csv") EUROPE.csv is basically a matrix of dimension 440*44, and has a line of headers, i.e. each column has a name. Using read.csv I can't load the data into R properly. Although the first 20 columns or

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

I have a commonly recurring problem and wondered if folks would share tips. I routinely get tab-delimited text files that I need to read in. In very many cases, I get: > a <- read.table('junk.txt.txt',header=T,skip=10,sep="\t") Error in scan(file = file, what = what, sep = sep, quote = quote, dec = dec, : line 67 did not have 88 elements I am typically able to go

I'm trying to read a comma delimited dataset that uses '.' for NA. I found that if the last field on a line was a missing '.' it was not read as NA, but just a '.', and the life variable was made a factor. The data looks like this, income,imr,region,oilexprt,imr80,gnp80,life Afghanistan,75,400.0,4,0,185.0,.,37.5 Algeria,400,86.3,2,1,20.5,1920,50.7