Convert column counts into data frame with new columns : <p>I have a dataset of baseball play-by-play data. Here's a simplified example:</p>

<pre><code>team &lt;- c('A','A','A','A','A','A','A',
      'B','B','B','B','B','B','B',
      'C','C','C','C','C','C','C')
event &lt;- c("OUT","WALK","OUT","OUT","HR","WALK","OUT",
       "WALK","OUT","HR","WALK","OUT","OUT","WALK",
        "HR","HR","WALK","WALK","HR","OUT","WALK")
df &lt;- data.frame(team, event)
df

   team event
1     A   OUT
2     A  WALK
3     A   OUT
4     A   OUT
5     A    HR
6     A  WALK
7     A   OUT
8     B  WALK
9     B   OUT
10    B    HR
11    B  WALK
12    B   OUT
13    B   OUT
14    B  WALK
15    C    HR
16    C    HR
17    C  WALK
18    C  WALK
19    C    HR
20    C   OUT
21    C  WALK
</code></pre>

<p>I would like to create a new data frame that shows the number of times each event occurred for each team, with each event represented by a new column, like this:</p>

<pre><code>  team OUT WALK HR
1    A   4    2  1
2    B   3    3  1
3    C   1    3  3
</code></pre>

<p>I think there must be a way to do this using <code>dplyr</code>, but I haven't been able to figure it out.</p>
