Re: [R] how to read this kind of csv in R?

2019-10-06 Thread Rui Barradas
Hello, It is not clear if all files have * a first block with just one data line * all other blocks with as many rows as the numbers in that first data line. If yes, maybe something like this? lns <- readLines("strange.csv") lns <- lns[sapply(lns, nchar) > 0] lns <- sub(",$", "", lns) i_title

Re: [R] how to read this kind of csv in R?

2019-10-06 Thread Duncan Murdoch
On 06/10/2019 8:23 a.m., vod vos wrote: The problem is aa, bb and cc all in a single csv file contains no blank line. So what steps do you need, and which of them do you need help with? Duncan Murdoch The single csv file like list output. aa(cm) 1, 2 , 3, bb(mm) 1, 2, 3, 4, 5, 6,

Re: [R] how to read this kind of csv in R?

2019-10-06 Thread vod vos via R-help
The problem is aa, bb and cc all in a single csv file contains no blank line. The single csv file like list output. aa(cm) 1, 2 , 3, bb(mm) 1, 2, 3, 4, 5, 6, 7, 8, 9, cc(mm) 3, 4, 5, 7, 5, 9, 6, 5, 8, 在 星期日, 06 十月 2019 05:08:41 -0700 Duncan Murdoch 撰写 > On 06/10/2019 7:

Re: [R] how to read this kind of csv in R?

2019-10-06 Thread Duncan Murdoch
On 06/10/2019 7:29 a.m., vod vos via R-help wrote: I got hundreds of csv files. The real formats in each csv file are as follows: aa(cm) 1, 2 , 3, bb(mm) 1, 2, 3, 4, 5, 6, 7, 8, 9, cc(mm) 3, 4, 5, 7, 5, 9, 6, 5, 8, How can I use read.table or read.csv to convert the csv files to a tidy data f

[R] how to read this kind of csv in R?

2019-10-06 Thread vod vos via R-help
I got hundreds of csv files. The real formats in each csv file are as follows: aa(cm) 1, 2 , 3, bb(mm) 1, 2, 3, 4, 5, 6, 7, 8, 9, cc(mm) 3, 4, 5, 7, 5, 9, 6, 5, 8, How can I use read.table or read.csv to convert the csv files to a tidy data frame format as follow: aa, bb, cc 1, 1, 3 1, 2, 4 1

Re: [R] Vargha and delaney effect size

2019-10-06 Thread Kum-Hoe Hwang
On Sun, Oct 6, 2019 at 4:24 PM Eric Berger wrote: > [Sending your follow-on question to the full R-help list] > > On Fri, Oct 4, 2019 at 7:13 PM javed khan wrote: > > > Thanks for your reply. I checked the example of treatment and control but > > I can not understand the first four lines. How ca

Re: [R] Vargha and delaney effect size

2019-10-06 Thread Eric Berger
[Sending your follow-on question to the full R-help list] On Fri, Oct 4, 2019 at 7:13 PM javed khan wrote: > Thanks for your reply. I checked the example of treatment and control but > I can not understand the first four lines. How can we do it if we have the > data (both columns) in excel and w