Hello,
No one mentioned that read.csv2 and read.csv are particular cases of
read.table.
read.table(text = "
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
", header = TRUE, sep = ";", dec = ".") -> don
str(don)
Rui Barradas
Citando Nordlund, Dan (DSHS/RDA) <nord...@dshs.wa.gov>:
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-boun...@r-project.org] On Behalf Of Alain
Guillet
Sent: Thursday, September 29, 2016 2:42 AM
To: r-help@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@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@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.
______________________________________________
R-help@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.
______________________________________________
R-help@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.
