looping over rows, columns, and perform operations on the columns using pandas

Question

showing list of animals - each row represents a location

I want to loop through a 761,000 rows by 25 columns excel document, for the each row

1. count columns with values>0 and store in a column called count
2. for the values > 0, add them and store in a new column called animals_per_location
3. return the names of the column title that has values greater than zero

sample output