Convert xml to dict and group data and sum totals

[kashcode]

Hello,

I have xml file with data.
What I need to do. Group data by siteid and merchantname and sum totals from clicks, downloads, newdepositingacc, netrevenue, revsharecommission.
The result I would like to achieve could be something like this:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

[{   'name': 'http://gamblerguy.com (LeoMonaco)',   'clicks': 'sum clicks totals',   'downloads': 'sum clicks downloads',   'newdepositingacc': 'sum newdepositingacctotals',   'netrevenue': 'sum netrevenue totals',   'revsharecommission': 'sum revsharecommission totals' }, {   'name': 'casinochimp.com (LeoMonaco)',   'clicks': 'sum clicks totals',   'downloads': 'sum clicks downloads',   'newdepositingacc': 'sum newdepositingacctotals',   'netrevenue': 'sum netrevenue totals',   'revsharecommission': 'sum revsharecommission totals' }]

[ndc85430]

So, what have you done already and where are you stuck? It would be helpful to see a sample of the XML as well.

[kashcode]

In the evening (UTC +3) I will put how far I am. I've grouped the data but got stuck calculating the totals, don't know how correctly do that. Sample xml you can find here https://www.dropbox.com/s/v9avcxaq12hay5i/ocs.xml?dl=0

[kashcode]

At this moment I have something like this https://repl.it/repls/TubbyWideFactors
list of lists but in each list I want get totals

[kashcode]

I solved my problem https://repl.it/@kashcode/TubbyWideFactors

[scidam]

I suspect that Pandas would be very useful to handle the problem. Pandas comes with rich set of data processing features, e.g. grouping operations, descriptive statistics, i/o operations and much more. If this is not an assignment, I would definitely recommend Pandas to solve such a problem.