[R] converting commas to points

Eik Vettorazzi E.Vettorazzi at uke.de
Thu Oct 6 17:50:59 CEST 2011


Hi Anna,
have a look at ?write.csv2, which deals with the Excel conventions for
CSV in German locale.

cheers


Am 06.10.2011 17:39, schrieb Anna Lee:
> Hello everyone!
> 
> I work with a german excell version which uses commas instead of
> points for seperating decimal places. R work with points so in order
> to be able to save my excell tables without changing the commas to
> points, whenever I load a table I type in: read.table(..., dec = ",")
> only R puts the points into the wron places. For excample excell has a
> cell with the number: 0,09 so what R does, it writes the number as 0.9
> which is wrong and makes my calculations become useless.
> 
> Does anyone know this problem? Maby I made a mistake somewhere?
> 
> I would be glad about your answers!
> 
> Cheers, Anna
> 


-- 
Eik Vettorazzi
Institut für Medizinische Biometrie und Epidemiologie
Universitätsklinikum Hamburg-Eppendorf

Martinistr. 52
20246 Hamburg

T ++49/40/7410-58243
F ++49/40/7410-57790

--
Pflichtangaben gemäß Gesetz über elektronische Handelsregister und Genossenschaftsregister sowie das Unternehmensregister (EHUG):

Universitätsklinikum Hamburg-Eppendorf; Körperschaft des öffentlichen Rechts; Gerichtsstand: Hamburg

Vorstandsmitglieder: Prof. Dr. Guido Sauter (Vertreter des Vorsitzenden), Dr. Alexander Kirstein, Joachim Prölß, Prof. Dr. Dr. Uwe Koch-Gromus 



More information about the R-help mailing list