aschonfeld
commented
4 years ago So I'm not sure how you're loading your data but I was able to load it fine using the following:
import dtale
import dtale.app as dtale_app
dtale_app.USE_NGROK = True
url = 'https://raw.githubusercontent.com/srivatsan88/YouTubeLI/master/dataset/coronavirus/corona_dataset_latest.csv'
dtale.show_csv(path=url)I'm also working on adding the ability to specify the parameter index_col so you won't get you first column as "Unnamed: 0"
So then your call would be: dtale.show_csv(path=url, index_col=0)
FYI, under the hood show_csv is running this code:
import pandas as pd
import requests
from six import PY3, BytesIO, StringIO
def show_csv(**kwargs):
path = kwargs.pop("path")
if path.startswith("http://") or path.startswith(
"https://"
): # add support for URLs
proxy = kwargs.pop("proxy", None)
req_kwargs = {}
if proxy is not None:
req_kwargs["proxies"] = dict(http=proxy, https=proxy)
resp = requests.get(path, **req_kwargs)
assert resp.status_code == 200
path = BytesIO(resp.content) if PY3 else StringIO(resp.content.decode("utf-8"))
return pd.read_csv(path, **kwargs)
jainayush007
TanushGoel
Hi. I am unable to read pandas data frame into d-tale. Below is the error -
4 frames /usr/lib/python3.6/json/decoder.py in raw_decode(self, s, idx) 355 obj, end = self.scan_once(s, idx) 356 except StopIteration as err: --> 357 raise JSONDecodeError("Expecting value", s, err.value) from None 358 return obj, end
JSONDecodeError: Expecting value: line 1 column 1 (char 0)
Screenshot of error-
df was loaded from a file that can be fetched from below link - 'https://raw.githubusercontent.com/srivatsan88/YouTubeLI/master/dataset/coronavirus/corona_dataset_latest.csv'