title: Is there a way in pandas to get the count_value of a column and then divide it by the sum of another column?
body: <p>I have a dataframe of matches of League of Legends with the champions played and which team won, and I would like to get a champion count of matches played, and divide it by how many they won to get the win ratio. I can get the amount of times the champions was played with value_count(), but I can't figure out how to sum the result columns depending on the champion played column. The dataframe looks like this.
  <a href="https://i.stack.imgur.com/BHRiD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BHRiD.png" alt="enter image description here" /></a></p>