title: How to fill missing geo location in datasets?
body: <p>I have a set of dataset with missing geo location names and coordinates at same time. I want to fill in the gaps so that I can proceed with the future analysis of the data. The data set is harvested from twitter so it is not a created data but this is how the data has come and I need to fill in the gaps somehow and continue with future analysis. </p>
  
  <p>Option 1: I can use either of the <code>userLocation</code> and <code>userTimezone</code> to find the <code>coordinates</code> </p>
  
  <p>Input:</p>
  
  <pre><code>userLocation,   userTimezone,   Coordinates,
  India,          Hawaii,    {u'type': u'Point', u'coordinates': [73.8567, 18.5203]}
  California,     USA     
            ,     New Delhi,  
  Ft. Sam Houston,Mountain Time (US &amp; Canada),{u'type': u'Point', u'coordinates': [86.99643, 23.68088]}
  Kathmandu,Nepal, Kathmandu, {u'type': u'Point', u'coordinates': [85.3248024, 27.69765658]}
  </code></pre>
  
  <p>Expected Output</p>
  
  <pre><code>userLocation,  userTimezone,   Coordinates_one, Coordinates_two
      India,          Hawaii,         73.8567,         18.5203
      California,     USA,            [fill this]      [fill this]
      [Fill this],    New Delhi,      [fill this]      [fill this]
      Ft. Sam Houston,Mountain Time (US &amp; Canada), 86.99643, 23.68088
      Kathmandu,      Kathmandu,      85.3248024,      27.69765658
  </code></pre>
  
  <p>Is it possible to write a script in Python or pandas to fill in the missing location names and coordinates at same time with formatting the output properly?</p>
  
  <p>I understand Python or Pandas does not have any magic package but something to start with would be helpful.</p>
  
  <p>I have asked this question on <a href="https://gis.stackexchange.com/questions/193574/how-to-fill-missing-geo-location-in-datasets">GIS</a> section but no much help over there. This is the first time ever I am working with Geo location data set and I have no clue how to start with. If the question is not suitable then please comment to delete it instead of down voting. </p>