Just a quick note to self about a couple of tricks for loading data files into pandas in JupyterLite. At the moment, a simple
pandas.read_csv() is unlikely to work, but there a couple of workarounds have been posted over the last couple of months so I’ve wrapped them into a simple package until such a time as everything works “properly” –
Install the package in
import micropip package_url = "https://raw.githubusercontent.com/innovationOUtside/ouseful_jupyterlite_utils/main/ouseful_jupyterlite_utils-0.0.1-py3-none-any.whl" await micropip.install(package_url)
And then load data into pandas as per:
from ouseful_jupyterlite_utils import pandas_utils as pdu # Load CSV from URL # Via @jtpio URL = "https://support.staffbase.com/hc/en-us/article_attachments/360009197031/username.csv" df = await pdu.read_csv_url(URL, "\t") # Load CSV from local browser storage # Via @bollwyvl df = await pdu.read_csv_local("iris.csv", "\t") df
I’ll add more workarouds to the package as I find them (working with SQLite files is next on my to do list…) and then remove items as they (hopefully) become natively supported.