Displaying 4 results from an estimated 4 matches for "count_of_b".
2016 Apr 20
2
Data reshaping with conditions
...A
167 335 sally B
18 340 susan A
56 340 susan A
22 340 susan B
53 340 susan B
135 351 lee A
114 351 lee A
84 351 lee A
80 351 lee A
19 351 lee A
8 351 lee A
21 351 lee A
88 351 lee B
111 351 lee B
46 351 lee B
108 351 lee B
>From the above data I am expecting an output like below.
id name type count_of_B Max of count B x y
335 sally B 167 167 117,19 NA
340 susan B 22,53 53 18 56
351 lee B 88,111,46,108 111 84,80,19,8,2 135,114
Where, the column x and column y are:
x = Count_A_less_than_max of (Count type B)
y = Count_A_higher_than_max of (Count type B)?.
*1...
2016 Apr 20
0
Data reshaping with conditions
...an B
> 135 351 lee A
> 114 351 lee A
> 84 351 lee A
> 80 351 lee A
> 19 351 lee A
> 8 351 lee A
> 21 351 lee A
> 88 351 lee B
> 111 351 lee B
> 46 351 lee B
> 108 351 lee B
>
> >From the above data I am expecting an output like below.
>
> id name type count_of_B Max of count B x y
> 335 sally B 167 167 117,19 NA
> 340 susan B 22,53 53 18 56
> 351 lee B 88,111,46,108 111 84,80,19,8,2 135,114
>
> Where, the column x and column y are:
>
> x = Count_A_less_than_max of (Count type B)
> y = Count_A_h...
2016 Apr 21
2
Data reshaping with conditions
...> > 80 351 lee A
> > 19 351 lee A
> > 8 351 lee A
> > 21 351 lee A
> > 88 351 lee B
> > 111 351 lee B
> > 46 351 lee B
> > 108 351 lee B
> >
> > >From the above data I am expecting an output like below.
> >
> > id name type count_of_B Max of count B x y
> > 335 sally B 167 167 117,19 NA
> > 340 susan B 22,53 53 18 56
> > 351 lee B 88,111,46,108 111 84,80,19,8,2 135,114
> >
> > Where, the column x and column y are:
> >
> > x = Count_A_less_than_max o...
2016 Apr 21
0
Data reshaping with conditions
...lee A
>> > 8 351 lee A
>> > 21 351 lee A
>> > 88 351 lee B
>> > 111 351 lee B
>> > 46 351 lee B
>> > 108 351 lee B
>> >
>> > >From the above data I am expecting an output like below.
>> >
>> > id name type count_of_B Max of count B x y
>> > 335 sally B 167 167 117,19 NA
>> > 340 susan B 22,53 53 18 56
>> > 351 lee B 88,111,46,108 111 84,80,19,8,2 135,114
>> >
>> > Where, the column x and column y are:
>> >
>> >...