# Re: [R] About importing CSV file

Date: Mon 11 Apr 2005 - 20:59:18 EST

convert 15,15,24 to 15.00, 15.24 AND  convert 16,5,16,88 to 16.50, 16.88

The second conversion should be fairly easy BUT how do you expect R to know that the first conversion should produce 15.00, 15.24 and not 15.15, 24.00 ?

Without knowing which is which, it would be dangerous and hard to write any sort of automated script for this.

The best thing would be for you to go back and change your inputs manually. You can either use 15,,15,24 for consistency or better yet simply use 15.0, 15.24.

On Mon, 2005-04-11 at 12:23 +0200, Silvia Bachetti wrote:
> I have a problem for reading a data from excel (.csv) to R, because the
> numeric variables ( float) are separeted by comma (,) and not by point (.).
> And all the variables are separated by comma (,). The string variables are
> between (""). So importing to R the numeric variable (float) are reading as
> integer, and not with decimal part.
> Is there a way to solve this problem?
>
> The data set is like this:
>
> CODE,"A1","A2","A3","A4","A5","A6","A7","A8","A9","A10","A11","A12","NOTE1","A13","A14","A15","NOTE2","A16","A17","A18","A19","A20","A21","NOTE3","A22","A23","A24","A25","A26","A27","A28","NOTE4","CONCLUSION"
>
> 991,"1","14","17","TM
> LUNG","19","CARCINOMA","17",,,"14","14","14",15,57,"2","17","17",17,"3","8","14","14","14","17",13,4,"4","14","17","14","14","14","17",15,15,24
>
> 992,"1","17","17","BPCO","17","TM
> LUNG","17",,,"17","17","17",17,"2","17","17",17,"3","17","17","17","17","17",17,"4","17","17","17","14","17","17",16,5,16,88
>
> 993,"1","17","17","TM
> LUNG","17","BPCO","17",,,"17","17","17",17,"2","17","17",17,"3","14","17","17","17","17",16,4,"4","17","17","17","17","14","17",16,5,16,73
>
> 994,"1","14","14","NN","17","NN","17","NN","17","14","17","17",15,88,"2","14","14",14,"3","14","17","14","17","14",15,2,"4","14","8","17","14","14","14",13,5,14,64
>
>
> I use this command in R: read.csv(file="prova.csv" , header=TRUE , sep=","
> , dec="," , fill=TRUE).
> But for example in the first record with code 991: the last part is
> recorded in three integer variable 15 - 15 - 24 and not in two float
> variable as 15 - 15.24
> In the second record with code 992: the last part is recorded in four
> integer variable 16 - 5 - 16 - 88 and not in two float variable as 16.5 - 16.88
> In the third record with code 993: the middle part is recorded in two
> integer variable 16 - 4 and not in one float variable as 16.4. And the last
> part is recorded in four integer variable 16 - 5 - 16 - 73 and not in two
> float variable as 16.5 - 16.73
> And so on.
>
> I there a solution?
>
> Thanks.
>
> Silvia
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help