Get total of Pandas column
You should use sum: Then you use loc with Series, in that case the index should be set as the same as the specific column you need to sum: because if you pass scalar, the values of all rows will be filled: Two other solutions are with at, and ix see the applications below: Note: Since Pandas v0.20, ix has been deprecated. Use loc or iloc instead.