I came to know this source to import data. I tried but not successful in importing the data
https://public.opendatasoft.com/explore/embed/dataset/us-zip-code-latitude-and-longitude/table/
my code:
JavaScript
x
12
12
1
from urllib.request import urlopen, Request2
### Import USA ZIP codes,counties, latitudes3
usurl = 'https://public.opendatasoft.com//explore//embed//dataset//us-zip-code-latitude-and-longitude//table//'4
query_url = Request(usurl)5
url_response = urlopen(query_url)6
read_response = url_response.read()7
8
print (read_response)9
b'n<!DOCTYPE html>n<html lang="en">n <head>n n nn n 10
<title>Opendatasoft</title>n <link rel="stylesheet"11
type="text/css" href="/static/vendor/font-awesome-4.7.0/css/font-awesome.min.css">n <link rel="styleshe....12
Presently I see no data but a string text.
Table on the data:
Advertisement
Answer
JS is creating the table and rendering of javascript in a request does not work. a workaround can be:
JavaScript
1
3
1
url='https://public.opendatasoft.com/explore/dataset/us-zip-code-latitude-and-longitude/download/?format=csv&timezone=America/New_York&lang=en&use_labels_for_header=true&csv_separator=%3B' 2
df=pd.read_csv(url,sep=";")3