similar to: (no subject)

Hi everyone, I have problems with a double for loop and the program response: "Error in 1:mass[j] : NA/NaN argument" I'm trying to create a very simple script to generate a vector full of objects with the value [fuel] and in the amount [mass] for a hist plot. H=1 for (j in 1:63) {for (i in 1:mass[j])

Hi everybody, I have a model that outputs 1) primary analysis results, 2) secondary analysis results and 3) model choice parameters. I would like to output them all together as one "spread sheet" to minimize my "copy paste time" since I need to run the model with at least 20-30 sets of parameters. They are all in different data.frames with different dimensions. However, I have

Hi! I have the following problem that I beleive is a bug: I have a dataframe with one categorical and one numerical vector. The categorical vector has three levels (uc, up and vc). A plot of the vectors with the categorical vector on the x-axis gives a boxplot with three boxes - exactly as expected. If I then use the subset function to make a dataset that only includes two of the levels of

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

Ein eingebundener Text mit undefiniertem Zeichensatz wurde abgetrennt. Name: nicht verf?gbar URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20110308/5fcad543/attachment.pl>

Dear , I want to import Excel data (.XLS). Can you help me to this. Best regards. Nour-Eddine HAKIM -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at

Hi! Is it possible to easily cut & paste data from an Excel spreadsheet to an R edit( ) grid or to variable? It seems that R cannot handle the cell delimiters Excel hands over. Regards, Werner

(R 1.9.1; Windows 2000;) I'm just comparing ease of use, speed, etc for methods of transferring data frames in the Excel, MySQL, R triangle. It turns out that going from Excel to R (when doing this carefully). Using the clipboard is actually quite fast and efficient (2 seconds for transferring 120 000 cells on a common desktop computer as compared to much longer for going the RODBC route,

Hello again, I my day to day calculation, I need to take lot of data from Excel and forth and generally I use 'clipboard' option with read.delim() function. However many time, the data in Excel are like '(111,000)' instead of '-111000'. Generally I convert data in the 2nd form in Excel itself and then copy to clipboard. Is there any option in R, so that I can

I remember in one slide of Prof. Ripley's presentation overhead, he said the most popular data analysis software is excel. So is there any resource or tutorial on this topic? Thank you so much!

Hello!!! I have been read a much about as read data from Excel File, but I haven?t found the necesary information to read the data. Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I don?t know as read the data?? I hope that you could help me. Thank you very much. -- View this message in context:

Folks, Two simple questions : (1) I have a data set (call it data.xls) in a folder in my hard drive. How do I perform a simple regression between two variables from that data set? After I click on 'R', what exactly do I type in? (2) Where do I get to see the complete library of packages offered by R? In particular, I am interested in quantile regression and logistic regression.

My friend sent an Excel file: http://msemac.redwoods.edu/~darnold/temp/cyu01_iqscores.xls http://msemac.redwoods.edu/~darnold/temp/cyu01_iqscores.xls I opened it in Excel, saved is as cyu01_iqscores.csv, then imported it into R with: iqscores=read.csv('cyu01_iqscores.csv',header=TRUE) The result was: > head(iqscores) IQ.Scores X 1 145 NA 2 101 NA 3 123 NA 4

How would I make a histogram using R from a table in excel that has 4 variables, but I only want to use 2 of the columns to make the histogram? [[alternative HTML version deleted]]

The following seems to be a bug when I tried to use the predict function. > forbes boil.pt pressure log.pressure [1,] 194.5 20.79 303.4472 [2,] 194.3 20.79 303.4472 [3,] 197.9 22.40 310.9061 [4,] 198.4 22.67 312.1042 [5,] 199.4 23.15 314.1995 [6,] 199.9 23.35 315.0597 [7,] 200.9 23.89 317.3460 [8,] 201.1 23.99

Last week one of our clients reported trouble with a csv file I generated with write.table. He said that columns with quotes for character variables were rejected by their data importer, which was revised to match the way Microsoft Excel uses quotation marks in character variables. I explained to them that quoted character variables are virtuous and wise, of course, but they say Microsoft Excel

Noone answered so I guess this is not possible, but can anyone definitely put me out of my misery... 'I have just begun using R 1.0.0 for Win95. Can someone please tell me how to put a data frame on the clipboard, and how to read data into a data frame from the clipboard.' Is this something that's planned? The clipboard seems pretty fundamental to Windows (and other OS?). Thanks

Hello, I am having difficulty putting a frequency table on my clipboard in R studio. I do not know what the error message is. I was thinking it might have to do with changing a setting on my clipboard but I do not know how to do this. I will copy and paste the exact command and error message: write.table(dpx,"clipboard",sep="\t") Error in file(file, ifelse(append,

Dear all, I want to import just part of an excel data file into R. I would like to have the data imported without rownames or colume names. I used read.delim("clipboard", header=F). Somehow even though I added the argument "header=F", I still have the row names V1, V2, ..., Does anyone know how to fix this? Thanks very much in advance. Hannah [[alternative

Hi I'm a mac user. I have problems loading data from mac excel in R. I'm using these script: >library(utils) >data2 <- read.table(file("clipboard"), header =T, sep ="\t") ____but this is the message that I have from R_____ Error in open.connection(file, "r") : cannot open the connection In addition: Warning message: In open.connection(file,