How do you sum up with Pandas?

Question

How do you sum up only the steel with Pandas?

Date                   Material         Quantity
10-12-2020             steel            2
12-12-2020             steel            5
13-12-2020             steel            6
14-12-2020             glass            1
15-12-2020             glass            2
16-12-2020             plastic          10

So, far I have done this, which displays only the 'steel' material, but I have difficulties to sum them:

import pandas as pd
df= pd.read_csv('materials.cvs')
total_materials = df.groupby('material')
materials = total_materials.get_group('steel')
print(materials)

Looks like someone has already answered this question. https://stackoverflow.com/questions/48133983/sum-a-range-of-cells-in-a-single-column-in-pandas-dataframe — Jay Lynch, Dec 30 '20 at 20:30

Ignacio Alorre · Answer 1 · 2020-12-30T20:43:10.460

0

Try this

steel = df.loc[df['Material'] == 'steel']
total = steel['Quantity'].sum()
print("Result: "+str(total))

edited Dec 30 '20 at 20:43

answered Dec 30 '20 at 20:26

Ignacio Alorre

7,307
8
57
94

ValueError: No axis named Quantity for object type DataFrame – Antoan Miroslavov Dec 30 '20 at 20:32
TypeError: can only concatenate str (not "float") to str – Antoan Miroslavov Dec 30 '20 at 20:38
That is because you are trying to print it out along with some text or simiar. Then you need to wrap the numeric value between str(). Check the upate – Ignacio Alorre Dec 30 '20 at 20:42
1

Thank you for your promp response. – Antoan Miroslavov Dec 30 '20 at 20:43

How do you sum up with Pandas?

1 Answers1