title: How can I access particular column values?
body: <pre><code>cname,query,status
  a,aaa,c
  a,aaa,c
  a,aaa,c
  a,aaa,p
  a,aaa,a
  b,bbb,c
  b,bbb,c
  b,bbb,a
  b,bbb,a
  b,bbb,c
  </code></pre>
  
  <p>This is my dataframe. I have to access status column and find how many c, p, a in status column based on <code>cname</code>.</p>
  
  <p>I need output like following format</p>
  
  <pre><code>cname,query,c,p,a
  a,5,3,1,1
  b,5,3,0,2
  </code></pre>