Parse XML and convert to hash

Question

I have the following XML "device_google_data.xml":

I'm trying to parse it and convert it to a hash. I'm close to getting what I want with each_with_index

#Parse device_file
    device_file = File.open("device_google_data.xml")
    doc = Nokogiri::XML(device_file)
    rows = doc.css('row').map{ |row| Hash[ row.attributes.map{|n,a| [n,a.value]} ] }  
    campaigns = rows.map {|m| m["campaign"]}
    device = rows.map {|m| m["device"]}
    impressions = rows.map {|m| m["impressions"]}.map{|e| e.to_i} 
    clicks = rows.map {|m| m["clicks"]}.map {|m| m.to_i}
    conversions = rows.map {|m| m["convertedClicks"]}.map {|m| m.to_i}
    cost = rows.map {|m| m["cost"]}.map {|m| m.to_f}.map{|c| c / 1000000}

Construct Hash

device_hash = {}
    campaigns.each_with_index { |e, i|
      device_hash[e.to_sym] = {impressions: impressions[i], clicks: clicks[i], conversions: conversions[i], cost: cost[i], device: device[i]}
    }

However, it only gives me one instance each of campaign. Its similar to calling uniq on an array. I wanted all the campaign rows mapped.

device_hash = {:"The Winds at Mattern Orchard"=>{:impressions=>13, :clicks=>0, :conversions=>0, :cost=>0.0, :device=>"Tablets with full browsers"}, :"Aberdeen Crossings"=>{:impressions=>24, :clicks=>0, :conversions=>0, :cost=>0.0, :device=>"Tablets with full browsers"}, :"Hawthorne Woods"=>{:impressions=>103, :clicks=>4, :conversions=>0, :cost=>14.87, :device=>"Mobile devices with full browsers"}, :"Southwest Commons"=>{:impressions=>39, :clicks=>1, :conversions=>0, :cost=>7.32, :device=>"Computers"}, :"Westlake Woods"=>{:impressions=>54, :clicks=>0, :conversions=>0, :cost=>0.0, :device=>"Computers"}, :"Beachwood Commons"=>{:impressions=>467, :clicks=>2, :conversions=>0, :cost=>7.06, :device=>"Computers"}, :"Richland Woods"=>{:impressions=>23, :clicks=>2, :conversions=>0, :cost=>6.99, :device=>"Computers"}, :"Salida Woods"=>{:impressions=>211, :clicks=>3, :conversions=>0, :cost=>8.76, :device=>"Computers"}, :Southwoods=>{:impressions=>37, :clicks=>1, :conversions=>0, :cost=>2.98, :device=>"Mobile devices with full browsers"}, :"Beachwood Commons - BRAND"=>{:impressions=>1, :clicks=>2, :conversions=>0, :cost=>0.24, :device=>"Computers"}}

Gustavo Zago Basilio · Accepted Answer

I'm not sure I understood your question.

You got all the campaign rows mapped at this point:

campaigns = rows.map {|m| m["campaign"]}

The campaigns array has 29 elements.

But then you iterate this list and put them in a hash with the campaign name as key:

campaigns.each_with_index { |e, i|
  device_hash[e.to_sym] = {impressions: impressions[i], clicks: clicks[i], conversions: conversions[i], cost: cost[i], device: device[i]}
}

This is the point where the number of rows gets reduced as there are campaigns with the same name, thus evaluating to the same hash bucket.

If you want to have all the rows in an object you could use an array instead of a hash. Or you could use an aggregate function when building the hash, summing up values for example.

 campaigns.each_with_index { |e, i|
  prev = device_hash[e.to_sym]
  if (prev.blank?)
    device_hash[e.to_sym] = {:impressions => impressions[i], :clicks => clicks[i], :conversions => conversions[i], :cost => cost[i], :device => device[i]}
  else
    prev[:impressions] += impressions[i]
    prev[:clicks] += clicks[i]
    prev[:conversions] += conversions[i]
    prev[:cost] += cost[i]
    prev[:device] << " | #{device[i]}"
  end
}

I hope it helps.

Parse XML and convert to hash

Answers (1)

Related Questions