similar to: reading table

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.

Hi R, I have a seemingly simple problem. I have a table in following format (tab seperated) Njets NBjets NElec NMuon Meff HT HT3j HE Aplan Plan 1 4 3 2 0 366.278 253.642 87.7473 1385 0.0124566 0.376712 2 3 1 1 0 235.19 157.688 18.2852 574.253 0.00064187 0.00528814 I read in with: >

I'm using read.delim to successfully read in tab delimited data, but some columns' values are comma seperated, reflecting the fact that user chose a few answers on a multi-select question. I understand that each answer is its own category and so could be represented as a seperate column in the data set, but I'd like the option of reading in the data column, and converting it to a

Dear R users and Helpers I am beginner with using R and interested in carrying out certain task for my statistical research. I am reading data for a text file, which could contain data in following pattern x y 8 10 11 14 16 16 18 15 6 20 4 4 20 18 As per the example I have two columns and 7 rows of data in each. However is real life data situation I may not know how many columns are present

Hi, I am trying to read a tab-delimited file that has trailing tab delimiters. It's a simple file with two legitimate fields. I'm using the first as row.names, and the second should be the only column in the resulting data frame. Initially, R was filling the last column with NA's, but I was able to stop that by setting

Hello, I'm receiving an error on attempting to use the read.table() function to read in data from a tab-delimited file. The file has more than 60,000 rows with 94 tab-delimited columns. However, the error occurs on row 3 of the file: > wl <-read.table("sr003lines.tab", header=T, sep="\t") Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :

Hello, all. I am working on a project with a large (~350Mb, about 5800 rows) insurance claims dataset. It was supplied in a tilde(~)-delimited format. I imported it into a data frame in R by setting memory.limit to maximum (4Gb) for my computer and using read.table. The resulting data frame had 10 bad rows. The errors appear due to read.table missing delimiter characters, with multiple data

Hello everybody, I'm a new user and I'm trying to use read.table with a tab delimited file but the system tells me (i) that there are more columns than column names, and (ii) that headers and col.names are of different lengths. I have already checked my variable names and there's no blank spaces. However, some variables have quite long names such as

HI all, This is probably simple, but I haven't been able to locate the answer either in the Import Manual or from searching the listserve. I have tab-delimited data with different numbers of elements in each row. I want to read it into R, such that R fills in "NA" in elements that have no data. How do I accomplish this? Example: DATA on disk: 1 -0.068191 -0.050729

I'm trying to get started with R, on Ubuntu. I worked through the tutorial, and have made a small tab-delimited subset of my data to try out (10 cases with about a dozens variables). But I can't seem to figure out how to actually refer to variables. I presume I'm missing something very simple, but quite a while searching the doc and the FAQ haven't helped me. I'm loading the

Dear R useRs, I have big (23000 rows), vertical bar delimited file: e.g. A00001|Text a,Text b, Text c|345 A00002|Text bla|456 ... .. . Try using A <- read.table('filename.txt', header=FALSE,sep='\|') process stop at line 11975 with warning message: number of items read is not a multiple of the number of columns I have no problems with processing similar file, which is

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

Hi everyone, I am trying to read in a tab delimited data file to R that has outliers marked by blank spaces. I would like to be able to tag those as "NA" when the data is read in. I cannot figure out how to do this using the read.table() options. Everything I have tried either puts all the NA on the end of the row when there are missing values instead of on their appropiate columns

Upon upgrading to R 2.2.0 on my Windows box, I found that one of my packages no longer compiled, giving this error: Error in read.table(zfile, header =3D TRUE) : more columns than column names Execution halted After removing every line of code from my package and still not being able to compile it, I found the error to be related to a .txt file in my data directory. I reduced my data file to a

> Hi, > I recently downloaded R on window and running Rgui on NT. I have never use > R before and trying to learn R by following An introduction to R. > I generated a table of 900x5 in excel and saved as tab delimited txt file. > I then do read.table but I keeping getting the following message > > data <- read.table("ML4mm25.txt", header=T, sep=" ")

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

Full_Name: George W. Gilchrist Version: 1.6.2 OS: OS X Submission from: (NULL) (128.239.124.126) Start with a tab-delimited or comma-delimited text file created on the Mac and use read.table("filename.txt", header=T) to read it in. When the first column of the file contains a character vector, and there is a header line, the first letter of the first column of the fifth row is appended

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),

Hi- I'm trying to read data into R that was exported from Excel, as tab-delimited text. There are some empty cells in the spreadsheet, which I'd like to treat as missing values. I'd like to specify to read.table to use a *single* tab character as the record separator, but I can't seem to do this. First of all, how can I get a tab character in R? Second, is it possible to force

Hi All, I wonder if there should be one character for quote= in read.table, i.e., > args(read.table) function (file, header = FALSE, sep = "", quote = "\"'", dec = ".", ... I have a file containing the following lines, 08248-GOTERM 3'-phosphoadenosine 5'-phosphosulfate biosynthetic process 08279-GOTERM 3'-phosphoadenosine