search for: count_a_less_than_max

Displaying 4 results from an estimated 4 matches for "count_a_less_than_max".

2016 Apr 20
0
Data reshaping with conditions
...ng 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)* I tried with dplyr with the following code for the initial step to get > the values for each column. > *2)* I thought to transpose the columns which has the unique ID alone. > > I tried with the follow...
2016 Apr 20
2
Data reshaping with conditions
...ee 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)* I tried with dplyr with the following code for the initial step to get the values for each column. *2)* I thought to transpose the columns which has the unique ID alone. I tried with the following code and I am struck with th...
2016 Apr 21
2
Data reshaping with conditions
...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)* I tried with dplyr with the following code for the initial step to > get > > the values for each column. > > *2)* I thought to transpose the columns which has the unique ID alone. &gt...
2016 Apr 21
0
Data reshaping with conditions
Hi sri, I think that I see what you mean. Your statements: x = Count_A_less_than_max of (Count type B) y = Count_A_higher_than_max of (Count type B). I took to mean that you wanted a logical value for x and y. Looking more closely at your initial message, I see that you wanted _all_ values of A with respect to maxB in x and y. The error with maximum values was due to a typo. Perha...