[R] using read.csv2()

[ruipbarradas at sapo.pt]

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) <NordlDJ at 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-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.
>
> ______________________________________________
> 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.