{ "cells": [ { "cell_type": "markdown", "id": "c63fc66e-2e1a-4972-a030-c67660757990", "metadata": {}, "source": [ "# Create a Gannt chart of Australian government departments\n", "\n", "This notebook creates a Gannt-style chart showing the creation and dissolution dates of Australian government departments.\n", "\n", "You can [view the Wikidata SPARQL query](https://w.wiki/5tXN) used for this visualisation using the Wikidata Query Service." ] }, { "cell_type": "code", "execution_count": 8, "id": "9b657cfd-13ec-4436-9011-b10fb7da5b0f", "metadata": {}, "outputs": [], "source": [ "import altair as alt\n", "import pandas as pd\n", "from SPARQLWrapper import JSON, SPARQLWrapper" ] }, { "cell_type": "code", "execution_count": 9, "id": "1b9ac56f-dc6e-4fef-9571-16f77b2a6971", "metadata": {}, "outputs": [], "source": [ "sparql = SPARQLWrapper(\"https://query.wikidata.org/sparql\")" ] }, { "cell_type": "code", "execution_count": 10, "id": "df1f92d9-a13d-4b90-95ed-0f19bcd83313", "metadata": {}, "outputs": [], "source": [ "sparql.setQuery(\n", " \"\"\"\n", "SELECT\n", " ?agency ?agencyLabel\n", " ?naa_id ?start_date ?end_date\n", "WHERE {\n", " ?agency wdt:P31 wd:Q57605562;\n", " wdt:P10856 ?naa_id;\n", " wdt:P571 ?start_date;\n", " OPTIONAL { ?agency wdt:P576 ?end_date. }\n", " SERVICE wikibase:label { bd:serviceParam wikibase:language \"[AUTO_LANGUAGE],en\". }\n", "} ORDER BY ?start_date\n", "\"\"\"\n", ")\n", "sparql.setReturnFormat(JSON)\n", "results = sparql.query().convert()" ] }, { "cell_type": "code", "execution_count": 11, "id": "015d67c9-8f81-45a3-98e8-429db105036f", "metadata": {}, "outputs": [], "source": [ "df = pd.json_normalize(results[\"results\"][\"bindings\"], sep=\"_\")" ] }, { "cell_type": "code", "execution_count": 12, "id": "ff5f5424-90e8-46ab-88be-421a38a2db59", "metadata": { "tags": [ "hide_cell" ] }, "outputs": [ { "data": { "text/html": [ "
\n", " | agency_type | \n", "agency_value | \n", "naa_id_type | \n", "naa_id_value | \n", "start_date_datatype | \n", "start_date_type | \n", "start_date_value | \n", "end_date_datatype | \n", "end_date_type | \n", "end_date_value | \n", "agencyLabel_xml:lang | \n", "agencyLabel_type | \n", "agencyLabel_value | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "uri | \n", "http://www.wikidata.org/entity/Q113757341 | \n", "literal | \n", "CA 11 | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1901-01-01T00:00:00Z | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1976-12-07T00:00:00Z | \n", "en | \n", "literal | \n", "Department of the Treasury | \n", "
1 | \n", "uri | \n", "http://www.wikidata.org/entity/Q16959680 | \n", "literal | \n", "CA 6 | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1901-01-01T00:00:00Z | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1921-12-21T00:00:00Z | \n", "en | \n", "literal | \n", "Department of Defence | \n", "
2 | \n", "uri | \n", "http://www.wikidata.org/entity/Q16959770 | \n", "literal | \n", "CA 10 | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1901-01-01T00:00:00Z | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1956-01-11T00:00:00Z | \n", "en | \n", "literal | \n", "Department of Trade and Customs | \n", "
3 | \n", "uri | \n", "http://www.wikidata.org/entity/Q3044789 | \n", "literal | \n", "CA 5 | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1901-01-01T00:00:00Z | \n", "NaN | \n", "NaN | \n", "NaN | \n", "en | \n", "literal | \n", "Attorney-General's Department | \n", "
4 | \n", "uri | \n", "http://www.wikidata.org/entity/Q7234360 | \n", "literal | \n", "CA 9 | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1901-01-01T00:00:00Z | \n", "http://www.w3.org/2001/XMLSchema#dateTime | \n", "literal | \n", "1975-12-22T00:00:00Z | \n", "en | \n", "literal | \n", "Postmaster-General's Department | \n", "