Query WikiData in plain SPARQL and display the result as a map or data frame
Project description
WikiData Plain SPARQL Client
This package allows to query the WikiData database. For example this package is intended for people who need to be able to query WikiData in plain SPARQL while staying whithin a Jupyter Notebook.
Currently data can be returned as a dataframe or as a map. See examples
Install
pip install wikidata_plain_sparql
Usage
The module only has one function which is named query
which has two parameters:
- query: a sparql query
- view: should data be displayed as a map, function will return a data frame if
view
isNone
(see examples for map use)
# import the module
import wikidata_plain_sparql as wikidata
wikidata.query(query, view=None)
Examples
The following examples are also available on Google Colab and can be executed without any additional setup: https://colab.research.google.com/github/jelleschutter/wikidata-plain-sparql/blob/assets/wikidata_plain_sparql_examples.ipynb
Data Frame
# query WikiData
wikidata.query('''
SELECT ?actor ?actorLabel
WHERE
{
# tv series "Person of Interest" has actor
wd:Q564345 wdt:P161 ?actor.
# actor has won a Golden Globe Award
?actor wdt:P166 wd:Q1011547.
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
''')
Which will result in the following pandas data frame:
actor | actorLabel |
---|---|
http://www.wikidata.org/entity/Q3295000 | Sterling K. Brown |
Map
The following query was copied from the offical WikiData Examples and shows all places within 1km of the Empire State Building:
# query WikiData
wikidata.query('''
#Places within 1km of the Empire State Building
SELECT ?place ?placeLabel ?location ?instanceLabel
WHERE
{
wd:Q9188 wdt:P625 ?loc .
SERVICE wikibase:around {
?place wdt:P625 ?location .
bd:serviceParam wikibase:center ?loc .
bd:serviceParam wikibase:radius "1" .
}
OPTIONAL { ?place wdt:P31 ?instance }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
BIND(geof:distance(?loc, ?location) as ?dist)
} ORDER BY ?dist
''', view='map')
Which will result in the following map:
Credits
- requests - used for sending query to WikiData server
- bokeh - used for displaying map data
- pandas - used for returning data as data frame
- @jelleschutter - development of this package
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for wikidata_plain_sparql-0.0.6.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | ac34a247fc4321514e39d829bcdbead0c3b1ba1a9fe059b9e2037a815bd3d904 |
|
MD5 | 99680bfe28fbb401b7815693e937fd5d |
|
BLAKE2b-256 | 70ae68a22bedd90be08c5e4571a79a1ce5fd4dc81bf48a7393c8119db17ad968 |
Hashes for wikidata_plain_sparql-0.0.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d7cdadbfe271a40bf8569366039a4f654cb329cfcf11a5537dc5d5f1fa341eb9 |
|
MD5 | 2923f9328089dd78f2508cfc97b10108 |
|
BLAKE2b-256 | 7b615912a8937b3c7e7ac51c33a5763e15e8302d9378606696cf3b72c3ebe58f |