how to sum calc values for each name and report if = 100.0000?
output:
name "a" is not 100
Asked
Active
Viewed 51 times
-2
-
please don't send images of things that would be necessary on the process of recreating the issue. – XxJames07- Aug 03 '22 at 18:01
-
1Does this answer your question? [How do I Pandas group-by to get sum?](https://stackoverflow.com/questions/39922986/how-do-i-pandas-group-by-to-get-sum) – srinath Aug 03 '22 at 18:01
1 Answers
0
df[['name', 'calc']].groupby('name').sum()
should give you the sums for each name, should return the output you were looking for
to report which names arent equal to 100, try
df1=(df[['name', 'calc']].groupby('name').sum()!=100)
for name in df1.index[df1['calc']==True].to_list():
print(f'calc of name:{name} does not match target')
Christian Trujillo
- 482
- 1
- 8
-
Thanks. That works. I would like to report the name of for which calc does not match 100.00. Currently my for loop is not working. Do you know how to do that? – baputhewisemonkey Aug 03 '22 at 19:26
-
-
Thank you. This is great although it does not fully resolve the issue. I would like to report the sentence " calc of name a does not match target". This is true for all the potential names that there could be for which calc != 100.0 The code above reports a list of names, rather than a sentence with the name for each potential names for which calc !=100.0. What would you modify? – baputhewisemonkey Aug 03 '22 at 20:18
-
-
1