{ "cells": [ { "cell_type": "markdown", "id": "8f9ea5d1-9de6-44b6-94ae-c12c0df241c5", "metadata": {}, "source": [ "# Works analysis and plot with concepts 2" ] }, { "cell_type": "markdown", "id": "c6cbc004-cd37-499b-983e-5f3d69be3a4d", "metadata": {}, "source": [ "## Basic case: count concepts presence in the dataset\n", "\n", "The dataset consists of the works of the concept \"Sustainability\" and it contains only the 10k most cited ones (default library setting).\n", "\n", "For these 10k works, we will count the number of time each concept appears. We could do the same with the references cited by these works (replace 'concept' by 'reference')" ] }, { "cell_type": "code", "execution_count": 1, "id": "37e37966-9278-4b96-a8e5-0f5c8f06ac6d", "metadata": { "ExecuteTime": { "end_time": "2024-04-22T17:14:45.566824Z", "start_time": "2024-04-22T17:14:43.757885Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", " | C66204764 Sustainability | \n", "sum_all_entities | \n", "average_all_entities | \n", "proportion_used_by_main_entity | \n", "sum_all_entities_rank | \n", "proportion_used_by_main_entity_rank | \n", "h_used_all_l_use_main | \n", "
---|---|---|---|---|---|---|---|
element | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
https://openalex.org/C18903297 | \n", "10000 | \n", "10000 | \n", "10000.0 | \n", "1.0 | \n", "0.999817 | \n", "0.500091 | \n", "0.500000 | \n", "
https://openalex.org/C66204764 | \n", "10000 | \n", "10000 | \n", "10000.0 | \n", "1.0 | \n", "0.999817 | \n", "0.500091 | \n", "0.500000 | \n", "
https://openalex.org/C86803240 | \n", "10000 | \n", "10000 | \n", "10000.0 | \n", "1.0 | \n", "0.999817 | \n", "0.500091 | \n", "0.500000 | \n", "
https://openalex.org/C144133560 | \n", "6523 | \n", "6523 | \n", "6523.0 | \n", "1.0 | \n", "0.999452 | \n", "0.500091 | \n", "0.499817 | \n", "
https://openalex.org/C162324750 | \n", "6241 | \n", "6241 | \n", "6241.0 | \n", "1.0 | \n", "0.999269 | \n", "0.500091 | \n", "0.499726 | \n", "
https://openalex.org/C127413603 | \n", "4418 | \n", "4418 | \n", "4418.0 | \n", "1.0 | \n", "0.999086 | \n", "0.500091 | \n", "0.499634 | \n", "
https://openalex.org/C41008148 | \n", "4341 | \n", "4341 | \n", "4341.0 | \n", "1.0 | \n", "0.998903 | \n", "0.500091 | \n", "0.499543 | \n", "
https://openalex.org/C17744445 | \n", "4211 | \n", "4211 | \n", "4211.0 | \n", "1.0 | \n", "0.998720 | \n", "0.500091 | \n", "0.499451 | \n", "
https://openalex.org/C199539241 | \n", "3691 | \n", "3691 | \n", "3691.0 | \n", "1.0 | \n", "0.998537 | \n", "0.500091 | \n", "0.499360 | \n", "
https://openalex.org/C39432304 | \n", "2836 | \n", "2836 | \n", "2836.0 | \n", "1.0 | \n", "0.998355 | \n", "0.500091 | \n", "0.499269 | \n", "
\n", " | \n", " | I138595864 Stockholm Resilience Centre | \n", "I140494188 Université de Technologie de Troyes | \n", "I163151358 Cyprus University of Technology | \n", "I107257983 Darmstadt University of Applied Sciences | \n", "I201787326 Riga Technical University | \n", "I4210144925 Technological University Dublin | \n", "I31151848 Technical University of Sofia | \n", "I3123212020 Universidad Politécnica de Cartagena | \n", "I158333966 Technical University of Cluj-Napoca | \n", "sum_all_entities | \n", "average_all_entities | \n", "proportion_used_by_main_entity | \n", "sum_all_entities_rank | \n", "proportion_used_by_main_entity_rank | \n", "h_used_all_l_use_main | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
element | \n", "year | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
https://openalex.org/C86803240 | \n", "2004 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "<NA> | \n", "0.0 | \n", "<NA> | \n", "0.422286 | \n", "NaN | \n", "NaN | \n", "
2005 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "<NA> | \n", "0.0 | \n", "<NA> | \n", "0.422286 | \n", "NaN | \n", "NaN | \n", "|
2006 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "2 | \n", "0.222222 | \n", "0.0 | \n", "0.949926 | \n", "0.748684 | \n", "0.711195 | \n", "|
2007 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "2 | \n", "0.222222 | \n", "0.5 | \n", "0.949926 | \n", "0.390608 | \n", "0.371048 | \n", "|
2008 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0.111111 | \n", "1.0 | \n", "0.891609 | \n", "0.148302 | \n", "0.132227 | \n", "|
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
https://openalex.org/C9682599 | \n", "2019 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "<NA> | \n", "0.0 | \n", "<NA> | \n", "0.422286 | \n", "NaN | \n", "NaN | \n", "
2020 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "<NA> | \n", "0.0 | \n", "<NA> | \n", "0.422286 | \n", "NaN | \n", "NaN | \n", "|
2021 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "<NA> | \n", "0.0 | \n", "<NA> | \n", "0.422286 | \n", "NaN | \n", "NaN | \n", "|
2022 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "<NA> | \n", "0.0 | \n", "<NA> | \n", "0.422286 | \n", "NaN | \n", "NaN | \n", "|
2023 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0.111111 | \n", "0.0 | \n", "0.891609 | \n", "0.748684 | \n", "0.667534 | \n", "
40340 rows × 15 columns
\n", "