[R] About importing CSV file

[Adaikalavan Ramasamy]

So you expect R to do the following :

 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.

Regards, Adai



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 at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>