23-bnf.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Exploring BNF/WikiData SPARQL data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "https://www.w3.org/2009/Talks/0615-qbe/\n",
    "https://www.ibm.com/developerworks/library/j-sparql/\n",
    "https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples\n",
    "https://github.com/bobdc/misc/blob/master/JupyterSPARQL/JupyterSPARQLFun.ipynb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import json\n",
    "import SPARQLWrapper"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [],
   "source": [
    "# https://lawlesst.github.io/notebook/sparql-dataframe.html\n",
    "def get_sparql_dataframe(endpoint, query):\n",
    "    \"\"\"\n",
    "    Helper function to convert SPARQL results into a Pandas data frame.\n",
    "    \"\"\"\n",
    "    sparql = SPARQLWrapper.SPARQLWrapper(endpoint)\n",
    "    sparql.setQuery(query)\n",
    "    sparql.setReturnFormat(SPARQLWrapper.JSON)\n",
    "    result = sparql.query()\n",
    "\n",
    "    processed_results = json.load(result.response)\n",
    "    cols = processed_results['head']['vars']\n",
    "\n",
    "    out = []\n",
    "    for row in processed_results['results']['bindings']:\n",
    "        item = []\n",
    "        for c in cols:\n",
    "            item.append(row.get(c, {}).get('value'))\n",
    "        out.append(item)\n",
    "\n",
    "    return pd.DataFrame(out, columns=cols)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "prefixes = \"\"\"\n",
    "PREFIX mus: <http://data.doremus.org/ontology#>\n",
    "PREFIX ecrm: <http://erlangen-crm.org/current/>\n",
    "PREFIX efrbroo: <http://erlangen-crm.org/efrbroo/>\n",
    "PREFIX skos: <http://www.w3.org/2004/02/skos/core#>\n",
    "PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\n",
    "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\n",
    "PREFIX dcterms: <http://purl.org/dc/terms/>\n",
    "PREFIX dcmitype: <http://purl.org/dc/dcmitype/>\n",
    "PREFIX dwc: <http://rs.tdwg.org/dwc/terms/>\n",
    "PREFIX tdwg: <http://rs.tdwg.org/dwc/terms/#>\n",
    "PREFIX mrtg: <http://xxx.org/XXX/>\n",
    "PREFIX foaf: <http://xmlns.com/foaf/0.1/>\n",
    "PREFIX txn:   <http://lod.taxonconcept.org/ontology/txn.owl#>\n",
    "PREFIX dsw: <http://purl.org/dsw/>\n",
    "PREFIX mbank: <http://www.morphbank.net/schema/morphbank#>\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## WikiData"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "endpoint = 'https://query.wikidata.org/bigdata/namespace/wdq/sparql'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "query = \"\"\"\n",
    "PREFIX wikibase: <http://wikiba.se/ontology#>\n",
    "PREFIX wd: <http://www.wikidata.org/entity/>\n",
    "PREFIX wdt: <http://www.wikidata.org/prop/direct/>\n",
    "PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\n",
    "\n",
    "SELECT ?president ?cause ?dob ?dod WHERE {\n",
    "    ?pid wdt:P39 wd:Q11696 .\n",
    "    ?pid wdt:P509 ?cid .\n",
    "    ?pid wdt:P569 ?dob .\n",
    "    ?pid wdt:P570 ?dod .\n",
    "\n",
    "    OPTIONAL {\n",
    "        ?pid rdfs:label ?president filter (lang(?president) = \"en\") .\n",
    "    }\n",
    "    OPTIONAL {\n",
    "        ?cid rdfs:label ?cause filter (lang(?cause) = \"en\") .\n",
    "    }\n",
    "}\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'head': {'vars': ['president', 'cause', 'dob', 'dod']},\n",
       " 'results': {'bindings': [{'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'influenza'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Benjamin Harrison'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1901-03-13T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1833-08-20T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': \"Alzheimer's disease\"},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Ronald Reagan'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '2004-06-05T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1911-02-06T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'cholera'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Zachary Taylor'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1850-07-09T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1784-11-24T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'cholera'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'James K. Polk'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1849-06-15T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1795-11-02T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'myocardial infarction'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Calvin Coolidge'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1933-01-05T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1872-07-04T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'myocardial infarction'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Rutherford B. Hayes'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1893-01-17T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1822-10-04T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'myocardial infarction'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Warren G. Harding'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1923-08-02T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1865-11-02T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'myocardial infarction'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Grover Cleveland'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1908-06-24T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1837-03-18T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'myocardial infarction'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Lyndon B. Johnson'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1973-01-22T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1908-08-27T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'pneumonia'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Benjamin Harrison'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1901-03-13T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1833-08-20T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'pneumonia'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Martin Van Buren'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1862-07-24T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1782-12-05T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'pneumonia'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Harry S. Truman'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1972-12-26T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1884-05-08T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'pneumonia'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Ronald Reagan'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '2004-06-05T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1911-02-06T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'stroke'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Chester A. Arthur'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1886-11-18T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1829-10-05T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'stroke'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Woodrow Wilson'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1924-02-03T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1856-12-28T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'stroke'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Millard Fillmore'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1874-03-08T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1800-01-07T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'stroke'},\n",
       "    'president': {'xml:lang': 'en', 'type': 'literal', 'value': 'John Tyler'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1862-01-18T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1790-03-29T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'stroke'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Richard Nixon'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1994-04-22T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1913-01-09T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'stroke'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Andrew Johnson'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1875-07-31T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1808-12-29T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'stroke'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Franklin Delano Roosevelt'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1945-04-12T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1882-01-30T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'tuberculosis'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Andrew Jackson'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1845-06-08T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1767-03-15T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'liver cirrhosis'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Franklin Pierce'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1869-10-08T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1804-11-23T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'gastroenteritis'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Zachary Taylor'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1850-07-09T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1784-11-24T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'heart failure'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Warren G. Harding'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1923-08-02T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1865-11-02T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'heart failure'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Martin Van Buren'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1862-07-24T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1782-12-05T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'heart failure'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Dwight D. Eisenhower'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1969-03-28T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1890-10-14T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'sepsis'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'William Henry Harrison'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1841-04-04T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1773-02-09T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'arteriosclerosis'},\n",
       "    'president': {'xml:lang': 'en', 'type': 'literal', 'value': 'Gerald Ford'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '2006-12-26T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1913-07-14T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'colorectal cancer'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Herbert Hoover'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1964-10-20T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1874-08-10T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'aneurysm'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'James A. Garfield'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1881-09-19T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1831-11-19T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'bacteremia'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Thomas Jefferson'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1826-07-04T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1743-04-13T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'coronary thrombosis'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Calvin Coolidge'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1933-01-05T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1872-07-04T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'coronary thrombosis'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Theodore Roosevelt'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1919-01-06T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1858-10-27T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'respiratory failure'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'James Buchanan'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1868-06-01T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1791-04-23T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'internal bleeding'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Herbert Hoover'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1964-10-20T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1874-08-10T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'uremia'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Thomas Jefferson'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1826-07-04T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1743-04-13T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'laryngeal cancer'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Ulysses S. Grant'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1885-07-23T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1822-04-27T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'multiple organ dysfunction syndrome'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Harry S. Truman'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1972-12-26T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1884-05-08T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en', 'type': 'literal', 'value': 'epiglottitis'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'George Washington'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1799-12-14T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1732-02-22T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'ballistic trauma'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'William McKinley'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1901-09-14T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1843-01-29T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'ballistic trauma'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'James A. Garfield'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1881-09-19T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1831-11-19T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'ballistic trauma'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'John F. Kennedy'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1963-11-22T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1917-05-29T00:00:00Z'}},\n",
       "   {'cause': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'ballistic trauma'},\n",
       "    'president': {'xml:lang': 'en',\n",
       "     'type': 'literal',\n",
       "     'value': 'Abraham Lincoln'},\n",
       "    'dod': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1865-04-15T00:00:00Z'},\n",
       "    'dob': {'datatype': 'http://www.w3.org/2001/XMLSchema#dateTime',\n",
       "     'type': 'literal',\n",
       "     'value': '1809-02-12T00:00:00Z'}}]}}"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "requests.get(endpoint, params={'query': query, 'format': 'json'}).json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>president</th>\n",
       "      <th>cause</th>\n",
       "      <th>dob</th>\n",
       "      <th>dod</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Benjamin Harrison</td>\n",
       "      <td>influenza</td>\n",
       "      <td>1833-08-20T00:00:00Z</td>\n",
       "      <td>1901-03-13T00:00:00Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ronald Reagan</td>\n",
       "      <td>Alzheimer's disease</td>\n",
       "      <td>1911-02-06T00:00:00Z</td>\n",
       "      <td>2004-06-05T00:00:00Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Zachary Taylor</td>\n",
       "      <td>cholera</td>\n",
       "      <td>1784-11-24T00:00:00Z</td>\n",
       "      <td>1850-07-09T00:00:00Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>James K. Polk</td>\n",
       "      <td>cholera</td>\n",
       "      <td>1795-11-02T00:00:00Z</td>\n",
       "      <td>1849-06-15T00:00:00Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Calvin Coolidge</td>\n",
       "      <td>myocardial infarction</td>\n",
       "      <td>1872-07-04T00:00:00Z</td>\n",
       "      <td>1933-01-05T00:00:00Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           president                  cause                   dob  \\\n",
       "0  Benjamin Harrison              influenza  1833-08-20T00:00:00Z   \n",
       "1      Ronald Reagan    Alzheimer's disease  1911-02-06T00:00:00Z   \n",
       "2     Zachary Taylor                cholera  1784-11-24T00:00:00Z   \n",
       "3      James K. Polk                cholera  1795-11-02T00:00:00Z   \n",
       "4    Calvin Coolidge  myocardial infarction  1872-07-04T00:00:00Z   \n",
       "\n",
       "                    dod  \n",
       "0  1901-03-13T00:00:00Z  \n",
       "1  2004-06-05T00:00:00Z  \n",
       "2  1850-07-09T00:00:00Z  \n",
       "3  1849-06-15T00:00:00Z  \n",
       "4  1933-01-05T00:00:00Z  "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "get_sparql_dataframe(endpoint, query).head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data BNF"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "http://data.bnf.fr/fr/opendata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "endpoint = 'http://data.bnf.fr/sparql'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 125,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artist</th>\n",
       "      <th>name</th>\n",
       "      <th>bdate</th>\n",
       "      <th>ddate</th>\n",
       "      <th>wdurl</th>\n",
       "      <th>mburl</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://data.bnf.fr/ark:/12148/cb13894801b</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>http://wikidata.org/entity/Q319732</td>\n",
       "      <td>https://musicbrainz.org/artist/88b4ad33-63ba-4...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      artist  name bdate ddate  \\\n",
       "0  http://data.bnf.fr/ark:/12148/cb13894801b  None  None  None   \n",
       "\n",
       "                                wdurl  \\\n",
       "0  http://wikidata.org/entity/Q319732   \n",
       "\n",
       "                                               mburl  \n",
       "0  https://musicbrainz.org/artist/88b4ad33-63ba-4...  "
      ]
     },
     "execution_count": 125,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = \"\"\"\n",
    "SELECT ?artist ?name ?bdate ?ddate ?wdurl ?mburl\n",
    "WHERE {\n",
    "    ?artist isni:identifierValid \"0000000108935378\" .\n",
    "    ?artist owl:sameAs ?wdurl .\n",
    "    FILTER (regex (?wdurl, \"wikidata.org\"))\n",
    "    ?artist owl:sameAs ?mburl .\n",
    "    FILTER (regex (?mburl, \"musicbrainz.org\")) .\n",
    "    OPTIONAL {\n",
    "        ?artist bio:birth ?bdate .\n",
    "        ?artist bio:death ?ddate .\n",
    "        ?artist foaf:name ?name\n",
    "    }\n",
    "}\n",
    "\"\"\"\n",
    "get_sparql_dataframe(endpoint, query).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>predicate</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://www.w3.org/1999/02/22-rdf-syntax-ns#type</td>\n",
       "      <td>http://www.w3.org/2004/02/skos/core#Concept</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://purl.org/dc/terms/created</td>\n",
       "      <td>1989-06-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://purl.org/dc/terms/modified</td>\n",
       "      <td>2016-04-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://www.w3.org/2000/01/rdf-schema#seeAlso</td>\n",
       "      <td>http://catalogue.bnf.fr/ark:/12148/cb13894801b</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://www.w3.org/2002/07/owl#sameAs</td>\n",
       "      <td>http://wikidata.org/entity/Q319732</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         predicate  \\\n",
       "0  http://www.w3.org/1999/02/22-rdf-syntax-ns#type   \n",
       "1                 http://purl.org/dc/terms/created   \n",
       "2                http://purl.org/dc/terms/modified   \n",
       "3     http://www.w3.org/2000/01/rdf-schema#seeAlso   \n",
       "4             http://www.w3.org/2002/07/owl#sameAs   \n",
       "\n",
       "                                              val  \n",
       "0     http://www.w3.org/2004/02/skos/core#Concept  \n",
       "1                                      1989-06-01  \n",
       "2                                      2016-04-18  \n",
       "3  http://catalogue.bnf.fr/ark:/12148/cb13894801b  \n",
       "4              http://wikidata.org/entity/Q319732  "
      ]
     },
     "execution_count": 97,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = \"\"\"\n",
    "SELECT DISTINCT ?predicate ?val\n",
    "WHERE {\n",
    "    <http://data.bnf.fr/ark:/12148/cb13894801b> ?predicate ?val\n",
    "}\n",
    "\"\"\"\n",
    "get_sparql_dataframe(endpoint, query).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 119,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>artist</th>\n",
       "      <th>name</th>\n",
       "      <th>isni</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://data.bnf.fr/ark:/12148/cb13894801b#about</td>\n",
       "      <td>Emilʹ Grigorʹevič Gilelʹs</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            artist                       name  \\\n",
       "0  http://data.bnf.fr/ark:/12148/cb13894801b#about  Emilʹ Grigorʹevič Gilelʹs   \n",
       "\n",
       "   isni  \n",
       "0  None  "
      ]
     },
     "execution_count": 119,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = \"\"\"\n",
    "SELECT ?artist ?name ?isni\n",
    "WHERE {\n",
    "    ?artist foaf:name \"Emilʹ Grigorʹevič Gilelʹs\" ;\n",
    "            foaf:name ?name .\n",
    "    #?artist isni:identifierValid ?isni\n",
    "}\n",
    "\"\"\"\n",
    "get_sparql_dataframe(endpoint, query).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "http://data.bnf.fr/sparql?default-graph-uri=&query=PREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+rdarelationships%3A+%3Chttp%3A%2F%2Frdvocab.info%2FRDARelationshipsWEMI%2F%3E%0D%0APREFIX+dcterms%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0ASELECT+DISTINCT+%3Fedition+%3Ftitre+%3Fdate+%3Fediteur+%3FURLGallica%0D%0AWHERE+{%0D%0A%3Chttp%3A%2F%2Fdata.bnf.fr%2Fark%3A%2F12148%2Fcb12258414j%3E+foaf%3Afocus+%3Foeuvre.%0D%0A%3Fedition+rdarelationships%3AworkManifested+%3Foeuvre.%0D%0AOPTIONAL+{%0D%0A%3Fedition+dcterms%3Adate+%3Fdate.%0D%0A++}%0D%0AOPTIONAL+{%0D%0A%3Fedition+dcterms%3Atitle+%3Ftitre.+%0D%0A++}%0D%0AOPTIONAL+{%0D%0A%3Fedition+dcterms%3Apublisher+%3Fediteur.%0D%0A++}%0D%0AOPTIONAL+{%0D%0A%3Fedition+rdarelationships%3AelectronicReproduction+%3FURLGallica.%0D%0A++}%0D%0A}&format=application%2Fjson&timeout=0&should-sponge=&debug=on"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "query = \"\"\"\"\n",
    "SELECT DISTINCT ?name ?gender ?nat ?bday ?dday\n",
    "WHERE {\n",
    "    ?mbartist foaf:name ?name ;\n",
    "              foaf:gender ?gender ;\n",
    "              rdagroup2elements:dateOfBirth ?bday ;\n",
    "              rdagroup2elements:dateOfDeath ?dday .\n",
    "OPTIONAL\n",
    "  {\n",
    "    ?mbartist foaf:nationality ?nat\n",
    "  }\n",
    "}\n",
    "LIMIT 10\n",
    "\"\"\"\n",
    "get_sparql_dataframe(endpoint, query).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>auteur</th>\n",
       "      <th>jour</th>\n",
       "      <th>date1</th>\n",
       "      <th>date2</th>\n",
       "      <th>nom</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>http://data.bnf.fr/ark:/12148/cb14656286b#about</td>\n",
       "      <td>-1-8.</td>\n",
       "      <td>18..--1-8.</td>\n",
       "      <td>18..</td>\n",
       "      <td>Michel Pourchet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>http://data.bnf.fr/ark:/12148/cb16930386j#about</td>\n",
       "      <td>..-..</td>\n",
       "      <td>1890</td>\n",
       "      <td>1959-10</td>\n",
       "      <td>Walter Rossi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>http://data.bnf.fr/ark:/12148/cb16933183p#about</td>\n",
       "      <td>..-..</td>\n",
       "      <td>18..</td>\n",
       "      <td>1913-04-17</td>\n",
       "      <td>Jacques Aumont-Thiéville</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>http://data.bnf.fr/ark:/12148/cb12407363j#about</td>\n",
       "      <td>..-..</td>\n",
       "      <td>1625</td>\n",
       "      <td>1702</td>\n",
       "      <td>Diacinto Maria Marmi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>http://data.bnf.fr/ark:/12148/cb13534973q#about</td>\n",
       "      <td>..-..</td>\n",
       "      <td>1760</td>\n",
       "      <td>1793-03-31</td>\n",
       "      <td>Louis Bruneau</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            auteur   jour       date1  \\\n",
       "0  http://data.bnf.fr/ark:/12148/cb14656286b#about  -1-8.  18..--1-8.   \n",
       "1  http://data.bnf.fr/ark:/12148/cb16930386j#about  ..-..        1890   \n",
       "2  http://data.bnf.fr/ark:/12148/cb16933183p#about  ..-..        18..   \n",
       "3  http://data.bnf.fr/ark:/12148/cb12407363j#about  ..-..        1625   \n",
       "4  http://data.bnf.fr/ark:/12148/cb13534973q#about  ..-..        1760   \n",
       "\n",
       "        date2                       nom  \n",
       "0        18..           Michel Pourchet  \n",
       "1     1959-10              Walter Rossi  \n",
       "2  1913-04-17  Jacques Aumont-Thiéville  \n",
       "3        1702      Diacinto Maria Marmi  \n",
       "4  1793-03-31             Louis Bruneau  "
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = \"\"\"SELECT ?auteur ?jour ?date1 ?date2 ?nom\n",
    "WHERE {\n",
    "  ?auteur  foaf:birthday ?jour.\n",
    "  ?auteur bio:birth ?date1.\n",
    "  ?auteur bio:death ?date2.\n",
    "  OPTIONAL {\n",
    "    ?auteur foaf:name ?nom.\n",
    "  }\n",
    "} \t\n",
    "ORDER BY (?jour)\n",
    "LIMIT 10\n",
    "\"\"\"\n",
    "get_sparql_dataframe(endpoint, query).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>year</th>\n",
       "      <th>endyear</th>\n",
       "      <th>url</th>\n",
       "      <th>wikidata</th>\n",
       "      <th>gallica</th>\n",
       "      <th>gender</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [name, year, endyear, url, wikidata, gallica, gender]\n",
       "Index: []"
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query = \"\"\"\n",
    "PREFIX foaf: <http://xmlns.com/foaf/0.1/>\n",
    "PREFIX bnf-onto: <http://data.bnf.fr/ontology/bnf-onto/>\n",
    "PREFIX owl: <http://www.w3.org/2002/07/owl#>\n",
    "SELECT DISTINCT ?name ?year ?endyear ?url ?wikidata ?gallica ?gender\n",
    "WHERE {\n",
    "    <http://data.bnf.fr/ark:/12148/cb13894801b#foaf:Person> foaf:name ?name ;\n",
    "        bnf-onto:firstYear ?year ;\n",
    "        bnf-onto:lastYear ?endyear ;\n",
    "        owl:sameAs ?url ;\n",
    "        foaf:page ?wikidata ;\n",
    "        foaf:depiction ?gallica ;\n",
    "        foaf:gender ?gender .\n",
    "}\n",
    "\"\"\"\n",
    "get_sparql_dataframe(endpoint, query).head()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0b5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}