title: Python Read Website Table Data into Dataframe
body: <p>I came to know this source to import data. I tried but not successful in importing the data</p>
  <p><a href="https://public.opendatasoft.com/explore/embed/dataset/us-zip-code-latitude-and-longitude/table/" rel="nofollow noreferrer">https://public.opendatasoft.com/explore/embed/dataset/us-zip-code-latitude-and-longitude/table/</a></p>
  <p>my code:</p>
  <pre><code>from urllib.request import urlopen, Request
  ### Import USA ZIP codes,counties, latitudes
  usurl = 'https://public.opendatasoft.com//explore//embed//dataset//us-zip-code-latitude-and-longitude//table//'
  query_url = Request(usurl)
  url_response = urlopen(query_url)
  read_response = url_response.read()
  
  print (read_response)
  b'\n&lt;!DOCTYPE html&gt;\n&lt;html lang=&quot;en&quot;&gt;\n    &lt;head&gt;\n    \n    \n\n    \n    
      &lt;title&gt;Opendatasoft&lt;/title&gt;\n        &lt;link rel=&quot;stylesheet&quot;
   type=&quot;text/css&quot; href=&quot;/static/vendor/font-awesome-4.7.0/css/font-awesome.min.css&quot;&gt;\n        &lt;link rel=&quot;styleshe....
  </code></pre>
  <p>Presently I see no data but a string text.</p>
  <p>Table on the data:
  <a href="https://i.stack.imgur.com/AVGTC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AVGTC.png" alt="enter image description here" /></a></p>