title: Python - Convert JSON key/values into key/value where value is an array
body: <p>I have a JSON file with numerous entries like this:</p>
  
  <pre><code>    {
      "area1": "California",
      "area2": "Sierra Eastside",
      "area3": "Bishop Area",
      "area4": "Volcanic Tablelands (Happy/Sad Boulders)",
      "area5": "Fish Slough Boulders",
      "grade": "V6 ",        
      "route": "The Orgasm",
      "type1": "Boulder",
      "type2": "NONE",
      "type3": "NONE",
      "type4": "NONE",
  },
  </code></pre>
  
  <p>I want to take the <code>area</code> and <code>type</code> entries and turn them into arrays:</p>
  
  <pre><code>   {
      "area": ["California","Sierra Eastside","Bishop Area","Volcanic Tablelands (Happy/Sad Boulders)","Fish Slough Boulders"]
      "grade": "V6 ",        
      "route": "The Orgasm",
      "type": ["Boulder","NONE","NONE","NONE"]
  },
  </code></pre>
  
  <p>I have this code which almost works:</p>
  
  <pre><code>json_data=open('../json/routes_test.json')
  datas = json.load(json_data)
  datas_arrays = []
  area_keys = ['area1','area2','area3','area4','area5']
  type_keys = ['type1','type2','type3','type4']
  
  for data in datas:
      areaArray = []
      typeArray = []
      deleteArray = []
      for k, v in data.iteritems():
          for area_key in area_keys:
              if (k == area_key):
                  areaArray.append(v)
                  deleteArray.append(k)
          for type_key in type_keys:
              if (k == type_key):
                  typeArray.append(v)
                  deleteArray.append(k)
      for k in deleteArray:
          del data[k]
      data['area'] = areaArray
      data['type'] = typeArray
      datas_arrays.append(data)
      print datas_arrays
      print "********"
  
  out = json.dumps(datas_arrays, sort_keys=True,indent=4, separators=(',', ': '))
  print out
  f_out= open('../json/toues_test_intoarrays.json', 'w')    
  f_out.write(out)
  f_out.close()   
  </code></pre>
  
  <p>The problem is that the <code>area</code> array is all out of order and the <code>type</code> array is backwards, which I can't have. I find it strange that one is unordered and one is ordered but backwards. To me it seems like the iteration should assure they're placed in order.</p>