title: extract information from csv file
body: <p>I have information from a csv file that was originally a json object (list of dictionaries). The information in the csv is saved in rows and it has the following structure:</p>
  
  <pre><code>{   'geometry': {   'location': {   'lat': 48.121096, 'lng': 14.868725}},
      'icon': 'http://maps.gstatic.com/mapfiles/place_api/icons/restaurant-71.png',
      'id': '322572963ad2ccd534d8a6ec3e71eba67953400c',
      'name': u"McDonald's \xd6sterreich",
      'price_level': 1,
      'reference': 'CoQBeAAAAOQrvtFrvdPFavW8IPAtNz5BqUOxB6j0dAWXZzgx673-pYV-JLzDk4q9Q1lK2e1Tmn7xiGSwrOAT27rlnr00NJvskvS7isZOIz48RWv8SZo4jbl_RiiEfpz7SpD3fQNB31aJexfB6n2SsNz6FL8StgZIdErv6u4mR-a-xCbMU5CREhBB3r-DyRrOks1EPQz22JQXGhSmPRi0Ht5k0VPTAFVefDF0HQ3xZQ',
      'types': ['restaurant', 'food', 'establishment'],
      'vicinity': u'Waidhofner Stra\xdfe 1, im City Center Amstetten'}
  </code></pre>
  
  <p>Sometimes the rows contain two or more of these list of dictionaries. The information that I am interested in extracting is the 'lat' and 'lng'. Ideally I would like to have this two coordinates in a data frame like this:</p>
  
  <pre><code>lat      lng
  48.098   5.0886
  48.110   5.1390
  48.234   5.1679
  </code></pre>
  
  <p>This is the code that I have so far: </p>
  
  <pre><code>import re
  import csv
  
  datafile = open('c:/users/J/Desktop/listaraw.csv', 'r')
  datareader = csv.reader(datafile)
  data = []
  for row in datareader:
      data.append(row)
  
  point_re = re.compile('.*lat.*;')
  point_lat = point_re.search(str(data)).group(1)
  </code></pre>
  
  <p>But I got the following message:</p>
  
  <pre><code>Traceback (most recent call last):
    File "&lt;stdin&gt;", line 1, in &lt;module&gt;
  IndexError: no such group
  </code></pre>
  
  <p>Any ideas on how to achieve this task?</p>
  
  <p>Here is the file for further reference: <a href="https://www.dropbox.com/s/6t5dgbzyu1apef2/listaraw.csv" rel="nofollow">https://www.dropbox.com/s/6t5dgbzyu1apef2/listaraw.csv</a> </p>
  
  <p>Thanks</p>