title: How to get.dummies and count at the same time
body: <p>I have a large dataset that I had to clean. Now, simplifying, I have this:</p>
  
  <pre><code>   A  B  C  D
  1  1  5  2  2
  4  2  5  3  1
  5  3  3  2  1
  8  4  1  4  4
  </code></pre>
  
  <p>So, the values for each column goes from 1 to 5.
  Now I want to transform this 4 columns in 5 dummy columns and count at the same time the amount of "values" for each row of each value, in order to have that:</p>
  
  <pre><code>   S_1 S_2 S_3 S_4 S_5
  1   1   2   0   0   1
  4   1   1   1   0   1
  5   1   1   2   0   0
  8   1   0   0   3   0
  </code></pre>
  
  <p>So "S_1" represents the amount of "1" for each row, "S_2" the amount of "2" of each row, and so on.</p>
  
  <p>I guess this is possible with a pivot table, but I can't do it. Can anybody help me, please?</p>