title: flatten a list of nested ordered dictionaries in python
body: <p>I am a bit confused how to extract information from a nested list of ordered lists in Python. For example:</p>
  
  <pre><code>list_of_interest = [OrderedDict([('name', 'Viscozyme'), ('company', 'Roche (Chile)')]),
   [OrderedDict([('name', 'Davictrel'), ('company', None)]),
    OrderedDict([('name', 'Enbrel Sureclick'), ('company', None)]),
    OrderedDict([('name', 'Tunex'), ('company', None)])],
   OrderedDict([('name', 'Angiox'), ('company', None)]),
   [OrderedDict([('name', 'Enantone'), ('company', None)]),
    OrderedDict([('name', 'Leuplin'), ('company', 'Takeda')]),
    OrderedDict([('name', 'LeuProMaxx'), ('company', 'Baxter/Teva')]),
    OrderedDict([('name', 'Leupromer'), ('company', None)]),
    OrderedDict([('name', 'Lutrate'), ('company', None)]),
    OrderedDict([('name', 'Memryte'), ('company', 'Curaxis')]),
    OrderedDict([('name', 'Prostap 3'), ('company', 'Takeda UK')]),
    OrderedDict([('name', 'Prostap SR'), ('company', 'Takeda UK')]),
    OrderedDict([('name', 'Viadur'), ('company', 'Bayer AG')])],
   OrderedDict([('name', 'Geref'), ('company', 'Serono Pharma')])]
  </code></pre>
  
  <p>I need to extract all items under <code>'name'</code>.</p>
  
  <p>So I need a function:</p>
  
  <pre><code>get_names(list_of_interest) --&gt; ['Viscozyme', 'Davictrel', 'Enbrel Sureclick', 'Tunex', 'Angiox', 'Enantone', ..., 'Geref']
  </code></pre>
  
  <p>I honestly tried nested list comprehensions, generator expressions and even pandas data frame, but it fails, as some sublists are single values.</p>