similar to: column names in write.table

I've always been frustrated that R never puts a label on the column name for a column of row names. This is usually the "key" in a database table, and it sure would be nice to carry a "key" name along with the data instead of the field being blank. So, why is it a good idea for it to be blank? ?write.csv says this: CSV files By default there is no column

When using the write.table (say for a tab delimited file) command on a matrix with Row and Columns, the column headers are always being left shifted into the column where the row numbers are being placed. One can see this when you open up the tab delimited file in excel. Is there a better command for this, or is this supposed to be a 'feature'. Peter

Ooops, I missed that one, sorry. I'll see if it helps. Thx. Nick Nick (Gunnar) Bluth Linux Systems Administrator Dresdner Kleinwort Wasserstein Dresdner Bank AG Global Business Services <mailto: gunnar.bluth at DrKW.com> IT Operational Integrity Voice: +49 69 263 57913 (97000 - 57913) J?rgen-Ponto-Platz 1 Fax: +49 69 263 16994 (97000 - 16994) D-60301

Hi everyone, I want to write some data to file, for example a = c(1,2,3,4,5) b = c(5,6,7,8,9) write.table(cbind(a,b), file = "R output.csv", sep = ",") The result is this: a b 1 1 5 2 2 6 3 3 7 4 4 8 5 5 9 It added an index and shifted the column names by one, b is above a, and a is above the added index. Does anybody know a way to prevent this shift from happening?

Hi all! Doing my first steps with OCFS (1.0.9), I ran across a nifty little "feature".... We've been trying if DMP with QLogic 2300 HBAs works without having DMP activated (ok, blame on me...). ocfstool allows you to mount different partitions on the same mountpoint, but after we tried that, everything went to state "D" and we chose to reboot the whole cluster (4

Dear Friends. Greetings! This should be a very common operation and I believe there should be a nice way in R to handle it. I couldn't find it in the manual or by searching on line. I am wondering if I could ask for some help in this community. I am trying to record the results of my program to a csv file in the hard drive so as to save memory space and also to read the results in excel

In the following data.frame there are 6 columns, but 7 are written to the CSV file. install.packages("pmlr") library(pmlr) data(enzymes) write.table(enzymes, sep=",", eol="\n",file="albert.csv")

Dear friends. Every loop of my program will result in a list that is very long, with a structure similar to the one below: Lst <- list(name="Fred", wife="Mary", daily.incomes=c(1:850)) Please notice the large size of "daily.incomes". I need to store all such lists in a csv file so that I can easily view them in Excel. Excel cannot display a row of more than 300

Dear R-list member, an update of package 'urca' has been uploaded to CRAN (Mirror: Austria). In the updated release unit root and cointegration tests encountered in applied econometric analysis are implemented. The package is written in 'pure' R and utilises S4 classes. In particular, the Johansen procedure with likelihood ratio tests for the inclusion of a linear trend,

I want to write following data frame into a CSV file: Col1 Col2 Col3 Row1 1 1 1 Row2 2 2 2 where Row1, Row2 are the row names and Col1, Col2, Col3 are the column names. The correct CSV file should be: ,"Col1","Col2","Col3" Row1,1,1,1 Row2,2,2,2 However, the one generated by R using write.table(x, file="xyz.csv",

Let me firstly thank the R Core Team for their tremendous efforts in providing R 1.8.0. My following comment should therefore be understood as an "fyi-only". I source compiled R 1.8.0 for windows with ATLAS (source compiled, too). Everything works fine and R is running flawlessly! However, running "make check" stops during processing "internet.R". I checked the

Hi Roscoe, I couldn't make it though that excel worksheet without my eyes glazing over... but do you want something like data(mtcars) tab <- xtabs(~cyl + gear, data=mtcars) tab/sum(tab) ? Best, Isat On Mon, May 3, 2010 at 10:08 PM, Roscoe <Roscoe at exemail.com.au> wrote: > Dear R-Help, > > First post, be gentle... > > I am new to R: I can perform basic functions

Hi, I'm using RGoogleDocs/RCurl to update a Google Spreadsheet. Everything worked OK until this morning, when my ability to write into spreadsheet cells went away. I get the following weird error: Error in els[[type + 1]] : subscript out of bounds Looking at the Google Docs API changelog, I see the following: http://code.google.com/apis/spreadsheets/changelog.html Release 2010-01 (July 14,

I'm running R 2.15.2 on Max OS X 10.6.8 If I write a simple file Data1<-1 DF<-data.frame(Data1) colnames(DF)<-"Col1" and write to a csv file write.table(DF,file="Data.csv",sep=",",row.names=FALSE,col.names=TRUE) I can then append to it no problem Data2<-2 Data3<-4 DF2<-data.frame(Data2) DF3<-data.frame(Data3)

Hey, I just googled my error and many things came up. I followed the leads and read the ?read.delim page; I tried changing header = TRUE, and row.names = TRUE-- but I've still been having trouble fixing it, so I would greatly appreciate any help you can provide. Here is my code: rm(list=ls()) source("../../functions.R") uncurated <-

This code opens a CSV file from the working directory set by wd. I copy 2 or more columns in the spreadsheet and then close it. What I need help with is setting the first row as the column names in clipboardTextAsDF. There is probably a simple or better way to do this but I have been away from R for awhile now. I just be over-thinking this. I tried read.DIF to read the clipboard but that

I unfortunately haven't received any responses about this problem. We (the company I work for) are willing to discuss payment to someone who is willing to quickly contribute a fix to the RGoogleDocs/RCurl toolchain that will restore write access. Please contact me directly if you're interested. Thank you, -Harlan Harris On Tue, Jul 20, 2010 at 10:19 AM, Harlan Harris

[message bounced because of "octet-stream" attachment which are not allowed in our mailing lists; manually fixed and approved, MM] Dear R-list, R: 1.5.1 OS: Windows NT additional packages needed: tseries for those of you who are interested, pls. find attached a function for estimating VECM's by employing the method of Johansen (see for example: Hamilton,

We're experiencing weird problems here: The Solaris guys have user-packages, so we had to do this too for the Linux boxes (7.0, 7.1). Since some of the accounts get "easy" passwords set at install time, they are expired at once: /usr/bin/chage -m 7 -M 84 -W 14 <user> Now, at login, the user is prompted: You are required to change your password immediately (root enforced)

Full_Name: Wolfgang Huber Version: 1.6.2 OS: DEC OSF, Win, Linux Submission from: (NULL) (155.52.45.139) When data.frames are written to a file using write.table and with row.names and col.names, then the colnames are displaced by 1 with respect to column content. Example: > x = data.frame( > obscht=c("chriesi", "bire"), >