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:

[{
  '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.