1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to you create a table of counts between two columns without having to list every column...

Discussão em 'Outras Linguagens' iniciado por Stack, Abril 23, 2021.

  1. Stack

    Stack Membro Participativo

    For example, this is the part of my data set I'm interested in:

    EventID​
    Action​
    Actor
    EventID1​
    ActionB​
    ActorX
    EventID2​
    ActionB​
    ActorZ
    EventID1​
    ActionA​
    ActorY
    EventID2​
    ActionC​
    ActorZ
    EventID3​
    ActionA​
    ActorX
    EventID3​
    ActionB​
    ActorZ
    EventID2​
    ActionB​
    ActorZ
    EventID2​
    ActionA​
    ActorY​

    I Want:

    ActorX​
    ActorY​
    ActorZ
    ActionA​
    1​
    2​
    0
    ActionB​
    1​
    0​
    3
    ActionC​
    0​
    0​
    1​

    The problem is I have LOTS of actors and actions--so I need a way of doing this without listing each one.

    Continue reading...

Compartilhe esta Página