diff --git a/ScriptExample.ipynb b/ScriptExample.ipynb index f7f561e..4f7b92e 100644 --- a/ScriptExample.ipynb +++ b/ScriptExample.ipynb @@ -1,462 +1,545 @@ { "cells": [ { "cell_type": "markdown", "id": "9e398daa-fc30-4751-9203-30427137cbf6", "metadata": {}, "source": [ "## importer la bibliothèque de fonctions pandas" ] }, { "cell_type": "code", "execution_count": 1, "id": "6c9a8e07-a3c0-473b-9894-c609acde0e6b", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n" ] }, { "cell_type": "markdown", "id": "69476659-4d57-43e8-92de-d72b7ed0b8c2", - "metadata": {}, + "metadata": { + "tags": [] + }, "source": [ "## importer des données" ] }, { "cell_type": "code", "execution_count": 2, "id": "7871b62a-a016-4285-b84f-543ccbdf0c06", "metadata": {}, "outputs": [], - "source": [ - "articles_df = pd.read_csv(\"articles.csv\")" - ] + "source": [] }, { "cell_type": "markdown", "id": "15e1f2c2-46b7-4dfd-9bc2-0401b683795b", "metadata": {}, "source": [ "## afficher des données\n" ] }, { "cell_type": "code", "execution_count": 4, "id": "ddf6d34e-d629-4d26-ab80-eb928e3c9b20", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
idTitleAuthorsDOIURLSubjectsISSNsCitationLanguageIdLicenceIdAuthor_CountFirst_AuthorCitation_CountDayMonthYear
00The Fisher Thermodynamics of Quasi-ProbabilitiesFlavia Pennini|Angelo Plastino10.3390/e17127853https://doaj.org/article/b75e8d5cca3f46cbbd63e...Fisher information|quasi-probabilities|complem...1099-4300Entropy, Vol 17, Iss 12, Pp 7848-7858 (2015)112Flavia Pennini41112015
11Aflatoxin Contamination of the Milk Supply: A ...Naveed Aslam|Peter C. Wynn10.3390/agriculture5041172https://doaj.org/article/0edc5af6672641c0bd456...aflatoxins|AFM1|AFB1|milk marketing chains|hep...2077-0472Agriculture (Basel), Vol 5, Iss 4, Pp 1172-118...112Naveed Aslam51112015
22Metagenomic Analysis of Upwelling-Affected Bra...Rafael R. C. Cuadrat|Juliano C. Cury|Alberto M...10.3390/ijms161226101https://doaj.org/article/d9fe469f75a0442382b84...PKS|NRPS|metagenomics|environmental genomics|u...1422-0067International Journal of Molecular Sciences, V...113Rafael R. C. Cuadrat81112015
33Synthesis and Reactivity of a Cerium(III) Scor...Fabrizio Ortu|Hao Zhu|Marie-Emmanuelle Boulon|...10.3390/inorganics3040534https://doaj.org/article/95606ed39deb4f43b96f7...lanthanide|cerium|scorpionate|tris(pyrazolyl)b...2304-6740Inorganics (Basel), Vol 3, Iss 4, Pp 534-553 (...114Fabrizio Ortu51112015
44Performance and Uncertainty Evaluation of Snow...Magali Troin|Richard Arsenault|François Brissette10.3390/hydrology2040289https://doaj.org/article/18b1d70730d44573ab5c2...snow models|hydrological models|snowmelt|uncer...2306-5338Hydrology, Vol 2, Iss 4, Pp 289-317 (2015)113Magali Troin41112015
...................................................
996996Crystal structure of [3-(1H-benzimidazol-2-yl)...Zhimin Liu|Shengrun Zheng|Sisi Feng10.1107/S2056989014026656https://doaj.org/article/cb1912c6567f4f99aa0ff...crystal structure|3-(1H-benzimidazol-2-yl)prop...2056-9890Acta Crystallographica Section E: Crystallogra...113Zhimin Liu9112015
997997Crystal structure of bis(3-bromopyridine-κN)bi...Rajni Kant|Gurvinder Kour|Sumati Anthal|Neerup...10.1107/S2056989014027339https://doaj.org/article/004df1cd5dfd42e2b78d5...Crystal structure|nickel complex|xanthate liga...2056-9890Acta Crystallographica Section E: Crystallogra...115Rajni Kant9112015
998998Crystal structure of 4,4′-(ethane-1,2-diyl)bis...Ines Hauptvogel|Wilhelm Seichter|Edwin Weber10.1107/S2056989014027182https://doaj.org/article/4f6b74ada72746ba85bbd...crystal structure|4,4′-(ethane-1,2-diyl)bis(2,...2056-9890Acta Crystallographica Section E: Crystallogra...113Ines Hauptvogel9112015
999999Crystal structure of (Z)-4-[1-(4-acetylanilino...Refaat M. Mahfouz|Zeynep Demircioğlu|Mohamed S...10.1107/S2056989014026899https://doaj.org/article/5a5102b0e73d4f2fbc55e...crystal structure|Schiff bases|pyrazolone deri...2056-9890Acta Crystallographica Section E: Crystallogra...114Refaat M. Mahfouz9112015
10001000Metagenomic Analysis of Upwelling-Affected Bra...Rafael R. C. Cuadrat|Juliano C. Cury|Alberto M...10.3390/ijms161226101https://doaj.org/article/d9fe469f75a0442382b84...PKS|NRPS|metagenomics|environmental genomics|u...1422-0067International Journal of Molecular Sciences, V...113Rafael R. C. Cuadrat81112015
\n", "

1001 rows × 16 columns

\n", "
" ], "text/plain": [ " id Title \\\n", "0 0 The Fisher Thermodynamics of Quasi-Probabilities \n", "1 1 Aflatoxin Contamination of the Milk Supply: A ... \n", "2 2 Metagenomic Analysis of Upwelling-Affected Bra... \n", "3 3 Synthesis and Reactivity of a Cerium(III) Scor... \n", "4 4 Performance and Uncertainty Evaluation of Snow... \n", "... ... ... \n", "996 996 Crystal structure of [3-(1H-benzimidazol-2-yl)... \n", "997 997 Crystal structure of bis(3-bromopyridine-κN)bi... \n", "998 998 Crystal structure of 4,4′-(ethane-1,2-diyl)bis... \n", "999 999 Crystal structure of (Z)-4-[1-(4-acetylanilino... \n", "1000 1000 Metagenomic Analysis of Upwelling-Affected Bra... \n", "\n", " Authors \\\n", "0 Flavia Pennini|Angelo Plastino \n", "1 Naveed Aslam|Peter C. Wynn \n", "2 Rafael R. C. Cuadrat|Juliano C. Cury|Alberto M... \n", "3 Fabrizio Ortu|Hao Zhu|Marie-Emmanuelle Boulon|... \n", "4 Magali Troin|Richard Arsenault|François Brissette \n", "... ... \n", "996 Zhimin Liu|Shengrun Zheng|Sisi Feng \n", "997 Rajni Kant|Gurvinder Kour|Sumati Anthal|Neerup... \n", "998 Ines Hauptvogel|Wilhelm Seichter|Edwin Weber \n", "999 Refaat M. Mahfouz|Zeynep Demircioğlu|Mohamed S... \n", "1000 Rafael R. C. Cuadrat|Juliano C. Cury|Alberto M... \n", "\n", " DOI \\\n", "0 10.3390/e17127853 \n", "1 10.3390/agriculture5041172 \n", "2 10.3390/ijms161226101 \n", "3 10.3390/inorganics3040534 \n", "4 10.3390/hydrology2040289 \n", "... ... \n", "996 10.1107/S2056989014026656 \n", "997 10.1107/S2056989014027339 \n", "998 10.1107/S2056989014027182 \n", "999 10.1107/S2056989014026899 \n", "1000 10.3390/ijms161226101 \n", "\n", " URL \\\n", "0 https://doaj.org/article/b75e8d5cca3f46cbbd63e... \n", "1 https://doaj.org/article/0edc5af6672641c0bd456... \n", "2 https://doaj.org/article/d9fe469f75a0442382b84... \n", "3 https://doaj.org/article/95606ed39deb4f43b96f7... \n", "4 https://doaj.org/article/18b1d70730d44573ab5c2... \n", "... ... \n", "996 https://doaj.org/article/cb1912c6567f4f99aa0ff... \n", "997 https://doaj.org/article/004df1cd5dfd42e2b78d5... \n", "998 https://doaj.org/article/4f6b74ada72746ba85bbd... \n", "999 https://doaj.org/article/5a5102b0e73d4f2fbc55e... \n", "1000 https://doaj.org/article/d9fe469f75a0442382b84... \n", "\n", " Subjects ISSNs \\\n", "0 Fisher information|quasi-probabilities|complem... 1099-4300 \n", "1 aflatoxins|AFM1|AFB1|milk marketing chains|hep... 2077-0472 \n", "2 PKS|NRPS|metagenomics|environmental genomics|u... 1422-0067 \n", "3 lanthanide|cerium|scorpionate|tris(pyrazolyl)b... 2304-6740 \n", "4 snow models|hydrological models|snowmelt|uncer... 2306-5338 \n", "... ... ... \n", "996 crystal structure|3-(1H-benzimidazol-2-yl)prop... 2056-9890 \n", "997 Crystal structure|nickel complex|xanthate liga... 2056-9890 \n", "998 crystal structure|4,4′-(ethane-1,2-diyl)bis(2,... 2056-9890 \n", "999 crystal structure|Schiff bases|pyrazolone deri... 2056-9890 \n", "1000 PKS|NRPS|metagenomics|environmental genomics|u... 1422-0067 \n", "\n", " Citation LanguageId \\\n", "0 Entropy, Vol 17, Iss 12, Pp 7848-7858 (2015) 1 \n", "1 Agriculture (Basel), Vol 5, Iss 4, Pp 1172-118... 1 \n", "2 International Journal of Molecular Sciences, V... 1 \n", "3 Inorganics (Basel), Vol 3, Iss 4, Pp 534-553 (... 1 \n", "4 Hydrology, Vol 2, Iss 4, Pp 289-317 (2015) 1 \n", "... ... ... \n", "996 Acta Crystallographica Section E: Crystallogra... 1 \n", "997 Acta Crystallographica Section E: Crystallogra... 1 \n", "998 Acta Crystallographica Section E: Crystallogra... 1 \n", "999 Acta Crystallographica Section E: Crystallogra... 1 \n", "1000 International Journal of Molecular Sciences, V... 1 \n", "\n", " LicenceId Author_Count First_Author Citation_Count Day \\\n", "0 1 2 Flavia Pennini 4 1 \n", "1 1 2 Naveed Aslam 5 1 \n", "2 1 3 Rafael R. C. Cuadrat 8 1 \n", "3 1 4 Fabrizio Ortu 5 1 \n", "4 1 3 Magali Troin 4 1 \n", "... ... ... ... ... ... \n", "996 1 3 Zhimin Liu 9 1 \n", "997 1 5 Rajni Kant 9 1 \n", "998 1 3 Ines Hauptvogel 9 1 \n", "999 1 4 Refaat M. Mahfouz 9 1 \n", "1000 1 3 Rafael R. C. Cuadrat 8 1 \n", "\n", " Month Year \n", "0 11 2015 \n", "1 11 2015 \n", "2 11 2015 \n", "3 11 2015 \n", "4 11 2015 \n", "... ... ... \n", "996 1 2015 \n", "997 1 2015 \n", "998 1 2015 \n", "999 1 2015 \n", "1000 11 2015 \n", "\n", "[1001 rows x 16 columns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "pd.read_csv(\"articles.csv\")" ] }, { "cell_type": "markdown", - "id": "910383aa-1273-4f4a-8731-d0b482766981", + "id": "db6f3173-dea0-47fd-8838-13bd4dfb674a", "metadata": {}, "source": [ - "## manipuler des données" + "## assigner les données importées à une variable" ] }, { "cell_type": "code", "execution_count": null, + "id": "8a059ab4-e27d-412d-9e2f-779b785be5e1", + "metadata": {}, + "outputs": [], + "source": [ + "articles_df = pd.read_csv(\"articles.csv\")" + ] + }, + { + "cell_type": "markdown", + "id": "910383aa-1273-4f4a-8731-d0b482766981", + "metadata": {}, + "source": [ + "## manipuler des données\n", + "\n", + "Vérifier les données à disposition " + ] + }, + { + "cell_type": "code", + "execution_count": 7, "id": "b172d56f-331d-46c8-a37d-a39f571ae609", "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "array(['id', 'Title', 'Authors', 'DOI', 'URL', 'Subjects', 'ISSNs',\n", + " 'Citation', 'LanguageId', 'LicenceId', 'Author_Count',\n", + " 'First_Author', 'Citation_Count', 'Day', 'Month', 'Year'],\n", + " dtype=object)" + ] + }, + "execution_count": 7, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "\n", + "\n", + "articles_df.columns.values" + ] + }, + { + "cell_type": "markdown", + "id": "0a017afc-aa1b-445c-80e7-84f2dff1eb92", + "metadata": {}, + "source": [ + "Chercher les ISSN uniques" + ] + }, + { + "cell_type": "code", + "execution_count": 10, + "id": "adc12ee8-7ef1-484c-8359-f5b7ff2fddb0", + "metadata": {}, + "outputs": [ + { + "data": { + "text/plain": [ + "51" + ] + }, + "execution_count": 10, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "len(pd.unique(articles_df['ISSNs']))\n" + ] + }, + { + "cell_type": "code", + "execution_count": null, + "id": "4a38c392-e397-4d22-b25a-94862dc92ef5", + "metadata": {}, + "outputs": [], + "source": [] + }, + { + "cell_type": "code", + "execution_count": null, + "id": "3f55aaa9-687b-449f-b417-b2eb65e0a961", + "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python", "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.8.10" } }, "nbformat": 4, "nbformat_minor": 5 }