![](\"example_plot.png\")
\n",
"- Plot a pie chart of the number of outputs per license type;\n",
"- Plot an interactive stacked bar plot showing the proportion of outputs of each type issued under a given license type."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Install libraries and prepare GraphQL client"
]
},
{
"cell_type": "code",
"execution_count": 29,
"metadata": {},
"outputs": [],
"source": [
"%%capture\n",
"# Install required Python packages\n",
"!pip install gql requests chord==0.0.17 numpy"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {},
"outputs": [],
"source": [
"# Prepare the GraphQL client\n",
"import requests\n",
"from IPython.display import display, Markdown\n",
"from gql import gql, Client\n",
"from gql.transport.requests import RequestsHTTPTransport\n",
"\n",
"_transport = RequestsHTTPTransport(\n",
" url='https://api.datacite.org/graphql',\n",
" use_json=True,\n",
")\n",
"\n",
"client = Client(\n",
" transport=_transport,\n",
" fetch_schema_from_transport=True,\n",
")"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Define and run GraphQL query\n",
"Define the GraphQL query to find all outputs of [FREYA grant award](https://cordis.europa.eu/project/id/777523) from [European Union](https://doi.org/10.13039/501100000780) to date."
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [],
"source": [
"# Generate the GraphQL query: find all outputs of FREYA grant award (https://cordis.europa.eu/project/id/777523) from funder (EU) to date\n",
"query_params = {\n",
" \"funderId\" : \"https://doi.org/10.13039/501100000780\",\n",
" \"funderAwardQuery\" : \"fundingReferences.awardNumber:777523\",\n",
" \"maxWorks\" : 200\n",
"}\n",
"\n",
"query = gql(\"\"\"query getGrantOutputsForFunderAndAward($funderId: ID!, $funderAwardQuery: String!, $maxWorks: Int!)\n",
"{\n",
"funder(id: $funderId) {\n",
" name\n",
" works(query: $funderAwardQuery, first: $maxWorks) {\n",
" totalCount\n",
" nodes {\n",
" id\n",
" formattedCitation(style: \"vancouver\")\n",
" titles {\n",
" title\n",
" }\n",
" descriptions {\n",
" description\n",
" } \n",
" types {\n",
" resourceType\n",
" }\n",
" dates {\n",
" date\n",
" dateType\n",
" }\n",
" versionOfCount\n",
" rights {\n",
" rights\n",
" rightsIdentifier\n",
" rightsUri\n",
" } \n",
" creators {\n",
" id\n",
" name\n",
" }\n",
" fundingReferences {\n",
" funderIdentifier\n",
" funderName\n",
" awardNumber\n",
" awardTitle\n",
" }\n",
" citationCount\n",
" viewCount\n",
" downloadCount\n",
" }\n",
" }\n",
" }\n",
"}\n",
"\"\"\")"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Run the above query via the GraphQL client"
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {},
"outputs": [],
"source": [
"import json\n",
"data = client.execute(query, variable_values=json.dumps(query_params))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Display total number of works \n",
"Display the total number of [FREYA grant award](https://cordis.europa.eu/project/id/777523) outputs to date."
]
},
{
"cell_type": "code",
"execution_count": 33,
"metadata": {},
"outputs": [
{
"data": {
"text/markdown": [
"92"
],
"text/plain": [
"| ID | Type | Publication Date | Formatted Citation | Descriptions | Number of Citations | Number of Views | Number of Downloads |
|---|---|---|---|---|---|---|---|
| 10.5281/zenodo.1202173 | General | 2018-03-17 | Fenner, Martin; Crosas, Merce; Durand, Gustavo; Wimalaratne, Sarala; Gräf, Florian; Hallett, Richard; Bernal Llinares, Manuel; Schindler, Uwe; Clark, Tim. Listing of data repositories that embed schema.org metadata in dataset landing pages. 2018-03-17; Available from: 10.5281/zenodo.1202173 |