In [1]:

    

import pandas as pd
import numpy as np
import json
from pandas.io.json import json_normalize
import requests
from lxml import objectify

d = requests.get('http://musicbrainz.org/ws/2/recording/?query=arid:b071f9fa-14b0-4217-8e97-eb41da73f598&fmt=json')
df = pd.read_json('http://musicbrainz.org/ws/2/recording/?query=arid:b071f9fa-14b0-4217-8e97-eb41da73f598&fmt=json')


    

In [12]:

    

rec = pd.DataFrame.from_dict(df.recordings)


    

In [16]:

    

rec.iloc[2]


    

    




---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-16-ea1205cebd46> in <module>()
----> 1 rec.iloc[2].artist

/Users/maxrose/anaconda/lib/python2.7/site-packages/pandas/core/generic.pyc in __getattr__(self, name)
   2670             if name in self._info_axis:
   2671                 return self[name]
-> 2672             return object.__getattribute__(self, name)
   2673 
   2674     def __setattr__(self, name, value):

AttributeError: 'Series' object has no attribute 'artist'

In [2]:

    

path = 'recording.xml'
xml = objectify.parse(open(path))
root = xml.getroot()
root.getchildren()[0].getchildren()


    

    
Out[2]:





[<Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195440>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195320>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195248>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195200>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195170>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181950e0>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181951b8>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195950>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195680>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195560>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195998>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x118195fc8>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2050>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2098>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a20e0>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2128>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2170>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a21b8>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2200>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2248>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2290>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a22d8>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2320>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a2368>,
 <Element {http://musicbrainz.org/ns/mmd-2.0#}recording at 0x1181a23b0>]

In [ ]: