Python Forum
Iterate over data and sum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Iterate over data and sum
#5
The existing datastructure (dataset?) and the objective is somewhat unclear for me, but if I would have had file named 'count_data.txt' with following content:

Output:
Name,count abc,1 ABC,2 Abc,1 abc,5 ABC,1
I would just simple brute-force:

with open('count_data.txt', 'r') as f:
    data = list(DictReader(f.readlines()))
    unique = {row['Name'] for row in data}
    for name in unique:
        print(f'{name}: {sum(int(row["count"]) for row in data if row["Name"] == name)}')
which will give:

Output:
Abc: 1 ABC: 3 abc: 6
As 'data' is list of dictionaries one can use list comprehension for whatever filtering/subtotaling needed.
I'm not 'in'-sane. Indeed, I am so far 'out' of sane that you appear a tiny blip on the distant coast of sanity. Bucky Katt, Get Fuzzy

Da Bishop: There's a dead bishop on the landing. I don't know who keeps bringing them in here. ....but society is to blame.
Reply


Messages In This Thread
Iterate over data and sum - by Madame32 - Oct-13-2019, 07:37 PM
RE: Iterate over data and sum - by ClimbAddict - Oct-13-2019, 10:11 PM
RE: Iterate over data and sum - by Malt - Oct-14-2019, 10:36 AM
RE: Iterate over data and sum - by scidam - Oct-14-2019, 11:04 AM
RE: Iterate over data and sum - by perfringo - Oct-14-2019, 11:37 AM
RE: Iterate over data and sum - by Madame32 - Oct-14-2019, 03:58 PM
RE: Iterate over data and sum - by perfringo - Oct-14-2019, 04:36 PM
RE: Iterate over data and sum - by Madame32 - Oct-14-2019, 04:54 PM
RE: Iterate over data and sum - by Madame32 - Oct-14-2019, 05:54 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Alternative approach to iterate numerous linear regressions with xlsx data? john_538 0 2,516 Apr-07-2018, 10:15 PM
Last Post: john_538

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020