[R] how to combine data of several csv-files
Antje
niederlein-rstat at yahoo.de
Mon Jul 30 13:09:34 CEST 2007
Hello,
sorry for this confusion but I don't know a better way to explain...
I have no problems to read in the files and to process them. I end up
with a list of results like this:
> ret
$A02.csv
[1] NA
$B02.csv
[1] 89.130435 8.695652 2.173913 0.000000 0.000000 0.000000 9.892473
$C02.csv
[1] 86.842105 10.526316 2.631579 0.000000 0.000000 0.000000 10.026385
$D02.csv
[1] 85.000000 10.000000 5.000000 0.000000 0.000000 0.000000 4.474273
$E02.csv
[1] 70.786517 13.483146 7.865169 5.617978 2.247191 0.000000 12.125341
$F02.csv
[1] 70.83333 14.16667 10.00000 2.50000 2.50000 0.00000 17.26619
$G02.csv
[1] 64.772727 13.636364 7.954545 11.363636 2.272727 0.000000 12.735166
$H02.csv
[1] NA
$A03.csv
[1] NA
and I have a matrix with categories like this:
> classmatrix
1 2
A NA NA
B NA "cat1"
C NA "cat1"
D NA "cat1"
E NA "cat2"
F NA "cat2"
G NA "cat2"
H NA NA
Now, I'm looking for a way to calculate the mean element wise for all
results coming from the same category:
in this case the mean of the elements:
$B02.csv
$C02.csv
$D02.csv
(belonging to "cat1")
I just don't know, how to combine the result list with the categories...
Does it become clearer? Probably, I try to provide a simple example but
this will take some time to prepare...
Thanks anyway!
Antje
8rino-Luca Pantani schrieb:
> I'm unclear to what it is your problem.
> Import files into data frame?
> Combine them in one dataframe?
> Some (written) examples of the files would help people to help you out.
>
> An example on how to get help better and faster
> >>>>>>>>>>>>
> I have several csv files in the following form
> V1 V2
> 1 4
> 0.3 56
> ................
> V1 V2
> 2.5 25
> 4.5 45
> .....................
>
> I would like to import them in only one dataframe, and then recode a
> column in order to get
> V1 V2 V3
> 1 4 file1
> 0.3 56 file1
> 2.5 25 file2
> 4.5 45 file2
> .....................
> >>>>>>>>>>>>
> Antje ha scritto:
>> Hello,
>>
>> I'm looking for a solution for the following problem:
>>
>> 1) I have a folder with several csv files; each contains a set of
>> measurement values
>>
>
More information about the R-help
mailing list