similar to: spreadsheet data import

Dear R-experts, It is a quite stupid question but please help me. I am very confuced. I am able to import normal txt ant mat-files to R but unable to import .xls-file I do not understand the online help. Can please anyone send me the corresponding command lines? The .xls-file is attached. In my file we use commas for the decimal format (example: 0,712), changes might be needed. Thanks, Corinna

Hi Listers, I can't seem to figure out why I loose precision when I try to import a comma delimited file using read.csv or read.table. The fields of interest are rounded to one decimal place. DataTimeStamp TerminalID Hours Minutes Latitude Longitude Status Temperature Battery BootTimes Current Google 1 2/11/2010 12:22:21 PM 4894551 12 0 45.0 -66.5 0 30

Mats, Thanks for your feedback. I guess I should elaborate on one of the features I would like to implement. In today's spreadsheets if you want to crunch a lot of data, you usually put the data in rows and put expressions in cells to the right of the data and repeat those cells for every row of the data. I would like to create a spreadsheet system that can process the same quantity of

Hello I am trying to import an *.xls spreadsheet into R. I am doing this as follows: > read.table(file("A5_DL.xls")) But obtain the error: Error in type.convert(data[[i]], as.is = as.is[i], dec = dec, na.strings = character(0)) : invalid multibyte string at '?????' So I copied it all over to a text document and tried to import that, thus: >

Hi, I understand this should be an easy task but I am still struggling a bit to read a .txt file with a date vector. My code is as below: data<-read.table(file.choose(),header=TRUE,sep="\t",dec=",",colClasses=c("Date","numeric","numeric","numeric")) But I am getting an error: Error in charToDate(x) : character string is not in a

There's a new page on the Burns Statistics website http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html that looks at spreadsheets from a quality assurance perspective. It presents R as a suitable alternative to spreadsheets. Also there are several specific problems with Excel that are highlighted, including the status of statistical functionality in Excel. Patrick Burns Burns

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 some data that was created for import into a Lotus 1-2-3 spreadsheet and on of the columns is time. The time is akin to Julian were the value 1 is mapped "01-Jan-00 12:00:00 AM" in Lotus 1-2-3. Is there a function in an R package that can convert this numeric vector to a POSIXct vector? With best wishes and kind regards I am Sincerely, Corey A. Moffet Instructor Department

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.

I have copied the R FAQ pertaining to available packages into an EXCEL file. They take the following form - Design Regression modeling, testing, estimation, validation, graphics, prediction, and typesetting by storing enhanced model design attributes in the fit. Design is a etc. Devore5 Data sets and sample analyses from "Probability and Statistics for Engineering and the Sciences (5th

In edge rails, serialized attributes are saved every time no matter they are changed or not: def update_with_dirty if partial_updates? # Serialized attributes should always be written in case they''ve been # changed in place. update_without_dirty(changed | (attributes.keys & self.class.serialized_attributes.keys)) else

Hello, What is the easiest way which enables usage of decimal comma "," instead of decimal point (".") . I would like to force all RoR views to display float numbers with comma instead of decimal point and also to allow insertion of float numbers with comma in forms. Thanks in advance, Karel -- Posted via http://www.ruby-forum.com/.

Dear all, I have some encoding problem which I'm not familiar with. Here is the case : I'm read data files which can have been generated from a computer either with global settings in french or in english. Here is an exemple ouf data file : * English output Time,Value 17,-0.0753953 17.05,-6.352454E-02 * French output. Time,Value 32,-7,183246E-02 32,05,3,469364E-02 In the first

Hi, could someone pelase help me with this? My data set's name is db1(say) and one of the variables is var1. I gave the command: hist(db1$var1). The values of Var1 are numbers. I got an error which says: 'x' must be numeric. Sometimes it works for other datasets and it's not working for this dataset. Also, does R let us import data from an excel spreadhsheet? Thanks, Radha

HI >i have a little problem please help me to solve it >this is the code in R: >> beta0 [1] 64.90614 > beta1 [1] 17.7025 > beta [1] 17 64 >her beta<- c(beta0, beta1) thank you in advance hafida -- View this message in context: http://r.789695.n4.nabble.com/Decimal-number-tp4639428.html Sent from the R help mailing list archive at Nabble.com.

Hi, after a lengthy but unsuccessfull search I couldn't come up with a solution to the following problem: I would like to have a "comma" instead of a "point" as the decimal point in my graphics, i.e. postscript and pdf files, for I write my thesis in German. My system is: OS: Debian Unstable R-Version: 2.0.1 System locale: de_DE at euro Could someone, please, help

hello, how can I do to drop decimal after the comma please for example for tthis line > print(P) [1] 62.000000 1.000000 7.661290 5.200000 17.100000 2.318801 how canI do to keep only 62 1 7.66 5.2 17.1 2.32 thanks __________________________________________________ ble contre les messages non sollicités [[alternative HTML version deleted]]

Dear all I am trying to use the ODB package to connect to an libreoffice-odb database. The libreoffice package is german, thus, decimal separator is a comma. However, I can open the database and upload a it without error, library(ODB) db <- odb.open("Test.odb") but a soon as the "odb.open" command is executed, the decimal separator in R is changed to comma. Before

Can you help me to use Sys.setlocale("LC_NUMERIC", "cs_CZ") (comma as a decimal point) in some useful way, without all the workarounds? After switching to Sys.setlocale("LC_NUMERIC", "cs_CZ"): -- How do I set attributes in read.csv2() not to get columns of real numbers (decimal point = comma, field separator = semicolon) as factors? Wokrkaround: I can go

Hi, Please help to create a spreadsheet view in rails application. Need to display the cell values from DB with manipulating option. Please specify gems/plugin if available. Thanks -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to