[R] using read.csv2()

[Nordlund, Dan (DSHS/RDA)]

Or, you can just use read.csv with sep=';'

read.csv("test.csv", sep=';') -> don


Dan

Daniel Nordlund, PhD
Research and Data Analysis Division
Services & Enterprise Support Administration
Washington State Department of Social and Health Services


> -----Original Message-----
> From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Alain
> Guillet
> Sent: Thursday, September 29, 2016 2:42 AM
> To: r-help at r-project.org
> Subject: Re: [R] using read.csv2()
> 
> Hello,
> 
> The defaults in read.csv2 are ";" as the separator and "," as the decimal
> symbol. It seems that the file you import is not a true csv since it mixes up
> two norms.
> 
> You can solve your problem in defining the dec option equals to ".":
> 
> read.csv2("test.csv",dec=".")->don
> 
> 
> Alain
> 
> On 29/09/16 10:59, Voirin Pascale wrote:
> > Hello,
> >
> > I have a problem with the variable type defined by reading a csv file with
> read.csv2.
> >
> > Here is a test file saved as < test.csv > :
> > var1;var2;var3
> > TI;1995;4.5
> > VD;1990;4.8
> > FR;1994;3.9
> > VS;1993;5.1
> > FR;1995;4.7
> > FR;1992;5.8
> >
> > That  I read in R with :
> > read.csv2("test.csv")->don;don
> > don$var3
> > ## [1] 4.5 4.8 3.9 5.1 4.7 5.8
> > ## Levels: 3.9 4.5 4.7 4.8 5.1 5.8
> >
> > as.double(don$var3)
> > ## [1] 2 4 1 5 3 6
> >
> > Why is it by default a <levels> type ? And how can I get  the decimal
> > value for var3
> >
> > Thanks a lot for your answer.
> > With my best regards,
> >
> > Pascale Voirin
> >
> > 	[[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> > http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
> > .
> >
> 
> --
> Alain Guillet
> Statistician and Computer Scientist
> 
> SMCS - IMMAQ - Université catholique de Louvain
> http://www.uclouvain.be/smcs
> 
> Bureau c.316
> Voie du Roman Pays, 20 (bte L1.04.01)
> B-1348 Louvain-la-Neuve
> Belgium
> 
> Tel: +32 10 47 30 50
> 
> Accès: http://www.uclouvain.be/323631.html
> 
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-
> guide.html
> and provide commented, minimal, self-contained, reproducible code.