CODEWITHSUNDEEP
pythonwikidata
anavarro
anavarro

Reputation: 35

given a name of a person, how to query wikidata properties about this person?

i am doing a mall project in python. i have a table with the columns: "author", "title", "text".

What i need is: for a given author name, i want somehow to get a table with the columns: "property", "value", containing the information (rows) about the properties "occupation" and "sex or gender" from Wiki-data.

*EDIT: the type of the table doesn't really matter. a dataframe would be great, but every other type that works is just fine!

Example: for the author name- David David, i want to get the following table:

thanks :-)

Upvotes: 0

Views: 1896

Answers (1)

anavarro
anavarro

Reputation: 35

ok, so here is a way (that i've seen) to do so:

using requests and json. for example: if i want to get the birthday, occupation and gender of Donald Trump, i should first import requests package, and define my SPARQL query. (WikiData database can be queried using SPARQL query language)

import requests

sparql_query = """
        prefix schema: <http://schema.org/>
        SELECT ?item ?occupation ?genderLabel ?bdayLabel
        WHERE {
            <https://en.wikipedia.org/wiki/Eric_P._Schmitt> schema:about ?item .
            ?item wdt:P106 ?occupation .
            ?item wdt:P21 ?gender .
            ?item wdt:P569 ?bday .
            SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
        }
    """

(doesn't matter who Eric P. Schmitt really is..) then, i need to make the request and apply and query using the request.get method:

url = 'https://query.wikidata.org/sparql'

# sleep(2)
r = requests.get(url, params={'format': 'json', 'query': sparql_query})

and final step, get the results as a json and access to the wanted information from it's structure:

url = 'https://query.wikidata.org/sparql'

r = requests.get(url, params={'format': 'json', 'query': sparql_query})
data = r.json()

print(data['results']['bindings'])
>>>> [{'item': {'type': 'uri', 'value': 'http://www.wikidata.org/entity/Q5387230'}, 'genderLabel': {'xml:lang': 'en', 'type': 'literal', 'value': 'male'}, 'bdayLabel': {'type': 'literal', 'value': '1959-11-02T00:00:00Z'}, 'occupation': {'type': 'uri', 'value': 'http://www.wikidata.org/entity/Q1930187'}}]

Upvotes: 2

Related Questions