title: How to sum up all values in a row where the column contains a specific string?
body: <p>So I have a dataframe of categories of venues in each neighbourhood. It looks like:</p>
  
  <p><a href="https://i.stack.imgur.com/uesE0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uesE0.png" alt="enter image description here"></a></p>
  
  <p>The values in each row represent the no. of each venue in the specific neighbourhood. </p>
  
  <p>I want to find out the total number of restaurants in each neighbourhood. To do so, I know I have to sum up the values in a row where the column contains the string "Restaurant". </p>
  
  <p>I've tried using <code>str.contains</code> function but that sums up True cases - how many times a column containing the string <code>restaurant</code> has a value <code>&gt;0</code> in that row. But instead, what I'd like is, to sum up, the total no. of restaurants in the neighbourhood instead. </p>