ibis-datasette provides a datasette backend for ibis. This lets you query
any datasette server using a familiar dataframe-like API (rather than SQL).
ibis-datasette is available on pypi:
$ pip install ibis-datasette
Once installed, you can connect to any datasette server using the
ibis.datasette.connect function. This takes the full URL to a database
For example, to connect to the legislators database.
In [1]: import ibis
In [2]: con = ibis.datasette.connect("https://congress-legislators.datasettes.com/legislators")Once connected, you can interact with tables using ibis just as you would a
local sqlite database:
In [3]: ibis.options.interactive = True # enable interactive mode
In [4]: con.list_tables()
Out[4]:
['executive_terms',
'executives',
'legislator_terms',
'legislators',
'offices',
'social_media']
In [5]: t = con.tables.legislators # access the `legislators` table
In [6]: t.name_first.topk(5) # top 5 first names for legislators
Out[6]:
name_first count
0 John 1273
1 William 1024
2 James 721
3 Thomas 457
4 Charles 442New BSD. See the License File.