similar to: Multiple data frames in single csv output

Hi, I have tried to load a file originally from Excel, via csv, text and clipboard today. When I succeed I cannot change the format from "factor", and when I try to convert it to numerical it only gives the position of the "factor-group", not the real value in the column? Any quick suggestions? Andreas [[alternative HTML version deleted]]

Hi all, I tried to read data from Excel spread sheet with using read.csv(file.choose()) and read.delim(file.choose()) but its showing " *ÐÏ.à.*." and also i tried with read.table(file.choose()) then its showing " * V1 1 ÐÏ\021ࡱ* " can any one suggest how to read data from Excel Spread sheet

Dear R experts, I am trying to import some data from some Excle files into R. My Excle file contains about 50 sheets. One solution I can think about is to convert my Excle file into csv file first and then load data into R using 'read.csv'. But it seems to me that 'read.csv' only supports reading one sheet (or 'one file') each time, so that seems I have to create 50 csv

Hello I want konw that how can make a spread sheet itself as a active record model so that I build applicationd and top of that model --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com To unsubscribe from this

Hello, I have currently many of my CDs ripped to FLAC to replay them from the computer. In most cases, there are single files for each track on the CD. I like the idea to rip the CD to a single track and add a cue sheet to the metadata which was recently discussed on the list. How would I access specific tracks using this approach by means of the FLAC (or FLAC++) API in my own decoder

I read through the import/export manual a few times and did not see this mentioned and checked the archives as well. I am dealing with data sheets generated by Eprime (a software package for generating experimental psychology paradigms) that output subject responses in a proprietary Edat file format. All individual subject response spread sheets can be merged to form one long file of all

Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we get the following error, when trying to write the data frames to the excel sheets: Error in ls(envir = envir, all.names = private) : invalid 'envir' argument We figured out that

Dear R gurus, particularly those of generous M$ tolerance and diverse gifts and knowledge! I have an interesting challenge that I will end up crunching in R involving service usage by patients. Maybe I can do all of it in R but I can't see how yet. My situation is that our IT Department can give me loads of XLS files about patients one of our services have seen. The are one per patient

I have a question for our European readers: how common is it to use commas as decimal points in spread-sheet and statistics applications? Is it an inconvenience to require that all data use a period as decimal point? (i.e., 3.14159 rather than 3,14159). We're trying to make our program as foolproof as possible, and would prefer not to give users a chance to have commas as both decimal

I have been trying to open data that I have saved in an excel spread sheet. I saved it as a csv. Then I tried using the read.csv command. However, everytime I do this-- diseasedat<-read.csv("M:/sloan/R/disease/disease.csv", sep=, header = TRUE, fill= TRUE)-- I get an error message: Error in file(file, "r") : unable to open connection In addition: Warning message:

Hello Good morning to all, I am doing reports in ruby on rails,i am trying to export data throgh excel in CSV format.Now i want to set the font to the text exported to excel sheet.How can i set font..please help me regarding this ... my sample code was like this... report = StringIO.new CSV::Writer.generate(report, '','') do |csv| csv << [''Invoice History

Hi, I am using R and I want to know how data can be transferred from Excel Spread sheet to R for analyzing. I have done like this mydata<-read.table("C:\Documents and Settings\admin\Desktop\data.txt"); but its not working how can i do it regards Sarath Sankar V

Hi, I'm working with panel data from the Swiss Houshold Panel (SHP). The data i got came in the following way: 1.) 12 *different* /individual/ files - one for each year . 2.) 12 *different* /houshold/ files - again: one for each year Each file came in the SPSS format (.sav). I implemented all the files in R an managed (via rename, cbind, rbind, merge etc.) to get *two* files. The first file

Hi every one, I'm having some problems with the function read.table(clipboard). I got a spread sheet in the Excel, and than I make a command+C in the Mac, but the R returns the message that there is no object in the clipboard. What could have happened? Thanks, Diogo [[alternative HTML version deleted]]

Hey everyone When I try to 'get active dataframe' from the context menu in excel using Rcmdr menus in excel, only the header and first row of data gets copied to the excel spread sheet. No clue why this is happening. I followed the instructions from 'R through Excel' pg 25-26. I'm using excel 2010, Rcmdr v 1.6-0 and R 2.11.1. Much appreciate any help Sent via my BlackBerry

I'm not sure if this is the right place to post this, but here goes. I just put together a PDC using Samba. I have given users the ability to change their passwords (once every 7 days) if they wish. I used to keep a list of usernames and passwords in a spread-sheet, so I could keep track of the servers that I needed to update with the correct password if anything changed. That being said.

Dear friends , I am trying to perform quantile regression analysis to analyse my work. I could install the R package in windows xp. Now I am struggling for the next work.I have *marks of students at the university examinations*( say response variable Y) and their *entrance examination marks* ( Independent one variable X ).I have entered data in Excel spread sheet as records. I will be thankful

R-helpers I have 120 small Excel sheets to read and I am using library(xlsReadWrite): one example below. I had hoped to read sheets by looping over a list of numbers in their name (eg Book1.xls, Book2.xls, etc). I thought I had seen examples which used eval-parse-paste in this way. However, I have not been able to get it to work.. 1. is this a feasible approach? 2. if not

Hi list, I just installed the rcom package and tried to read/give out some values from/to Excel. Altogether it works great... but nevertheless I don't know how the syntax works or in other words: "Which command needs which parameters?" Is there somwhere a manual about this package with good examples? I've read the Package description... but there are not really good

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