2
I have the following basis:
cidade a b c
AGRONOMICA CRESO NA NA
AGRONOMICA NA SICOOB NA
ALFREDO CREDIVERTENTES NA NA
ALMIRANTE SICOPER NA NA
ALMIRANTE NA SICRED NA
ALTO SICOPER NA NA
ALTO NA SICOOB NA
ALTO NA NA SICRED
The idea is to aggregate the basis so that it stays that way:
cidade a b c
AGRONOMICA CRESO SICOOB NA
ALFREDO CREDIVERTENTES NA NA
ALMIRANTE SICOPER SICRED NA
ALTO SICOPER SICOOB SICRED
Aggregate requires the values to be numerical. How to do this with these nominal variables?
Why the
ALMIRANTE
does not appear in the desired result?– Victor Stafusa
It was supposed to show up. It was a mistake to put the answer
– T. Veiga
Why is it that in the result the line
ALFREDO
has the spineb
equal toSICRED
if in the input table isNA
?– Rui Barradas
Another mistake. It’s been fixed
– T. Veiga