以下のようにjupyter notebookでDBファイルを参考書の通り、読み込もうとしました。
import os import pandas as pd from urllib.request import urlopen import sqlite3 base_url = '/Users/name/Documents/python/jupyter実践入門/sample-data-master/anime' anime_db = os.path.join(base_url, 'anime.db') res = urlopen(anime_db) with open('anime.db', 'wb') as f: f.write(res.read()) with sqlite3.connect(f.name) as conn: df = pd.read_sql('SELECT * FROM anime', conn)
すると、以下のようなエラーが生じてしまいます。
--------------------------------------------------------------------------- ValueError Traceback (most recent call last) <ipython-input-5-9e7397a768cb> in <module> 7 base_url = '/Users/name/Documents/python/jupyter実践入門/sample-data-master/anime' 8 anime_db = os.path.join(base_url, 'anime.db') ----> 9 res = urlopen(anime_db) 10 with open('anime.db', 'wb') as f: 11 f.write(res.read()) /anaconda3/envs/jupyter-env/lib/python3.6/urllib/request.py in urlopen(url, data, timeout, cafile, capath, cadefault, context) 221 else: 222 opener = _opener --> 223 return opener.open(url, data, timeout) 224 225 def install_opener(opener): /anaconda3/envs/jupyter-env/lib/python3.6/urllib/request.py in open(self, fullurl, data, timeout) 509 # accept a URL or a Request object 510 if isinstance(fullurl, str): --> 511 req = Request(fullurl, data) 512 else: 513 req = fullurl /anaconda3/envs/jupyter-env/lib/python3.6/urllib/request.py in __init__(self, url, data, headers, origin_req_host, unverifiable, method) 327 origin_req_host=None, unverifiable=False, 328 method=None): --> 329 self.full_url = url 330 self.headers = {} 331 self.unredirected_hdrs = {} /anaconda3/envs/jupyter-env/lib/python3.6/urllib/request.py in full_url(self, url) 353 self._full_url = unwrap(url) 354 self._full_url, self.fragment = splittag(self._full_url) --> 355 self._parse() 356 357 @full_url.deleter /anaconda3/envs/jupyter-env/lib/python3.6/urllib/request.py in _parse(self) 382 self.type, rest = splittype(self._full_url) 383 if self.type is None: --> 384 raise ValueError("unknown url type: %r" % self.full_url) 385 self.host, self.selector = splithost(rest) 386 if self.host: ValueError: unknown url type: '/Users/name/Documents/python/jupyter実践入門/sample-data-master/anime/anime.db'
unknown urlの解決方法がググってもよくわからず、ここに質問させていただきます。
よろしくお願いします。
mac 10.14.1
jupyter notebook 5.7.4
回答1件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2019/03/15 15:19
2019/03/15 16:12
2019/03/15 16:13
2019/03/15 16:17
2019/03/15 16:18
2019/03/19 09:13
2019/03/19 12:25
2019/03/20 13:04