week    power   test     Test_end_date_time
201120   5        1       05-10-2011_16:47
201120   699      17      05-10-2011_16:48
201120   454      1       05-10-2011_16:49
201121   5687     26      12-10-2011_15:47
201121   211      1       12-10-2011_15:48
201121   1231     36      12-10-2011_15:49
201121   171      1       12-10-2011_15:50
201121   677      57      12-10-2011_15:51
201121   178      1       12-10-2011_15:52
 
if test = 1 mean pass, other than 1 is fail

I wish the output in another csv is like below, any guides for me?

week   volume    yield
201120 3         66.7%
201121 6         50.0%