{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "%run notebook_setup.ipynb" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Science Citation Index Expanded (SCIE)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Web of Science Core Collection, Last Updated: June 18, 2020, downloaded from https://mjl.clarivate.com/collection-list-downloads on 2020-06-23" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "from pandas import read_csv, DataFrame\n", "\n", "web_of_science_journals = read_csv('data/wos-core_SCIE.csv')" ] }, { "cell_type": "code", "execution_count": 3, "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", "
Journal titleISSNeISSNPublisher namePublisher addressLanguagesWeb of Science Categories
02D MATERIALS2053-15832053-1583IOP PUBLISHING LTDTEMPLE CIRCUS, TEMPLE WAY, BRISTOL, ENGLAND, B...EnglishMaterials Science, Multidisciplinary
13 BIOTECH2190-572X2190-5738SPRINGER HEIDELBERGTIERGARTENSTRASSE 17, HEIDELBERG, GERMANY, D-6...EnglishBiotechnology & Applied Microbiology
23D PRINTING AND ADDITIVE MANUFACTURING2329-76622329-7670MARY ANN LIEBERT, INC140 HUGUENOT STREET, 3RD FL, NEW ROCHELLE, USA...EnglishMaterials Science, Multidisciplinary | Enginee...
34OR-A QUARTERLY JOURNAL OF OPERATIONS RESEARCH1619-45001614-2411SPRINGER HEIDELBERGTIERGARTENSTRASSE 17, HEIDELBERG, GERMANY, D-6...EnglishOperations Research & Management Science
4AAPG BULLETIN0149-14231558-9153AMER ASSOC PETROLEUM GEOLOGIST1444 S BOULDER AVE, PO BOX 979, TULSA, USA, OK...EnglishGeosciences, Multidisciplinary
........................
9388ZOOSYSTEMA1280-95511638-9387PUBLICATIONS SCIENTIFIQUES DU MUSEUM, PARISCP 39-57, RUE CUVIER, PARIS CEDEX 05, FRANCE, ...EnglishZoology
9389ZOOSYSTEMATICS AND EVOLUTION1860-07431860-0743PENSOFT PUBLISHERS12 PROF GEORGI ZLATARSKI ST, SOFIA, BULGARIA, ...EnglishZoology
9390ZOOTAXA1175-53261175-5334MAGNOLIA PRESSPO BOX 41383, AUCKLAND, NEW ZEALAND, ST LUKES,...EnglishZoology
9391ZUCHTUNGSKUNDE0044-54011867-4518EUGEN ULMER GMBH COPOSTFACH 700561 WOLLGRASWEG 41, STUTTGART, GER...GermanAgriculture, Dairy & Animal Science
9392ZYGOTE0967-19941469-8730CAMBRIDGE UNIV PRESS32 AVENUE OF THE AMERICAS, NEW YORK, USA, NY, ...EnglishDevelopmental Biology | Cell Biology | Reprodu...
\n", "

9393 rows × 7 columns

\n", "
" ], "text/plain": [ " Journal title ISSN eISSN \\\n", "0 2D MATERIALS 2053-1583 2053-1583 \n", "1 3 BIOTECH 2190-572X 2190-5738 \n", "2 3D PRINTING AND ADDITIVE MANUFACTURING 2329-7662 2329-7670 \n", "3 4OR-A QUARTERLY JOURNAL OF OPERATIONS RESEARCH 1619-4500 1614-2411 \n", "4 AAPG BULLETIN 0149-1423 1558-9153 \n", "... ... ... ... \n", "9388 ZOOSYSTEMA 1280-9551 1638-9387 \n", "9389 ZOOSYSTEMATICS AND EVOLUTION 1860-0743 1860-0743 \n", "9390 ZOOTAXA 1175-5326 1175-5334 \n", "9391 ZUCHTUNGSKUNDE 0044-5401 1867-4518 \n", "9392 ZYGOTE 0967-1994 1469-8730 \n", "\n", " Publisher name \\\n", "0 IOP PUBLISHING LTD \n", "1 SPRINGER HEIDELBERG \n", "2 MARY ANN LIEBERT, INC \n", "3 SPRINGER HEIDELBERG \n", "4 AMER ASSOC PETROLEUM GEOLOGIST \n", "... ... \n", "9388 PUBLICATIONS SCIENTIFIQUES DU MUSEUM, PARIS \n", "9389 PENSOFT PUBLISHERS \n", "9390 MAGNOLIA PRESS \n", "9391 EUGEN ULMER GMBH CO \n", "9392 CAMBRIDGE UNIV PRESS \n", "\n", " Publisher address Languages \\\n", "0 TEMPLE CIRCUS, TEMPLE WAY, BRISTOL, ENGLAND, B... English \n", "1 TIERGARTENSTRASSE 17, HEIDELBERG, GERMANY, D-6... English \n", "2 140 HUGUENOT STREET, 3RD FL, NEW ROCHELLE, USA... English \n", "3 TIERGARTENSTRASSE 17, HEIDELBERG, GERMANY, D-6... English \n", "4 1444 S BOULDER AVE, PO BOX 979, TULSA, USA, OK... English \n", "... ... ... \n", "9388 CP 39-57, RUE CUVIER, PARIS CEDEX 05, FRANCE, ... English \n", "9389 12 PROF GEORGI ZLATARSKI ST, SOFIA, BULGARIA, ... English \n", "9390 PO BOX 41383, AUCKLAND, NEW ZEALAND, ST LUKES,... English \n", "9391 POSTFACH 700561 WOLLGRASWEG 41, STUTTGART, GER... German \n", "9392 32 AVENUE OF THE AMERICAS, NEW YORK, USA, NY, ... English \n", "\n", " Web of Science Categories \n", "0 Materials Science, Multidisciplinary \n", "1 Biotechnology & Applied Microbiology \n", "2 Materials Science, Multidisciplinary | Enginee... \n", "3 Operations Research & Management Science \n", "4 Geosciences, Multidisciplinary \n", "... ... \n", "9388 Zoology \n", "9389 Zoology \n", "9390 Zoology \n", "9391 Agriculture, Dairy & Animal Science \n", "9392 Developmental Biology | Cell Biology | Reprodu... \n", "\n", "[9393 rows x 7 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "web_of_science_journals" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### SCImago Journal Rank" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Downloaded from https://www.scimagojr.com/journalrank.php?out=xls on 2020-06-23" ] }, { "cell_type": "code", "execution_count": 4, "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", " \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", "
RankSourceidTitleTypeIssnSJRSJR Best QuartileH indexTotal Docs. (2019)Total Docs. (3years)Total Refs.Total Cites (3years)Citable Docs. (3years)Cites / Doc. (2years)Ref. / Doc.CountryRegionPublisherCoverageCategories
0128773CA - A Cancer Journal for Cliniciansjournal15424863, 0007923588,192Q11563612929242264489255,7381,22United StatesNorthern AmericaWiley-Blackwell1950-2020Hematology (Q1); Oncology (Q1)
1219434MMWR. Recommendations and reports : Morbidity ...journal10575987, 1545860141,022Q11384111448981152,0036,00United StatesNorthern AmericaCenters for Disease Control and Prevention (CDC)1990-2020Epidemiology (Q1); Health Information Manageme...
2321100812243Nature Reviews Materialsjournal2058843736,691Q1808528885341256915168,34100,40United KingdomWestern EuropeNature Publishing Group2016-2020Biomaterials (Q1); Electronic, Optical and Mag...
3429431Quarterly Journal of Economicsjournal00335533, 1531465036,220Q1246301231909202011912,6563,63United KingdomWestern EuropeOxford University Press1886-2020Economics and Econometrics (Q1)
4520315Nature Reviews Molecular Cell Biologyjournal14710072, 1471008029,997Q14111153829251807418247,7080,44United KingdomWestern EuropeNature Publishing Group2000-2020Cell Biology (Q1); Molecular Biology (Q1)
5658530National vital statistics reports : from the C...book series15518922, 1551893029,810Q195143037910593041,6127,07United StatesNorthern AmericaPublic Health Services, US Dept of Health and ...1998-2020Life-span and Life-course Studies (Q1)
6718991Nature Reviews Geneticsjournal14710056, 1471006428,619Q13451133768586641615432,2175,98United KingdomWestern EuropeNature Publishing Group2000-2020Genetics (Q1); Genetics (clinical) (Q1); Molec...
7818434Celljournal00928674, 1097417224,698Q174758118813492449252163030,1660,11United StatesNorthern AmericaCell Press1974-2020Biochemistry, Genetics and Molecular Biology (...
8929719Reviews of Modern Physicsjournal00346861, 1539075621,938Q13164013111080558312145,73277,00United StatesNorthern AmericaAmerican Physical Society1929-2019Physics and Astronomy (miscellaneous) (Q1)
91012464Nature Reviews Cancerjournal1474175X, 1474176821,287Q14181383667641853220437,7755,37United KingdomWestern EuropeNature Publishing Group2001-2020Cancer Research (Q1); Oncology (Q1)
\n", "
" ], "text/plain": [ " Rank Sourceid Title \\\n", "0 1 28773 CA - A Cancer Journal for Clinicians \n", "1 2 19434 MMWR. Recommendations and reports : Morbidity ... \n", "2 3 21100812243 Nature Reviews Materials \n", "3 4 29431 Quarterly Journal of Economics \n", "4 5 20315 Nature Reviews Molecular Cell Biology \n", "5 6 58530 National vital statistics reports : from the C... \n", "6 7 18991 Nature Reviews Genetics \n", "7 8 18434 Cell \n", "8 9 29719 Reviews of Modern Physics \n", "9 10 12464 Nature Reviews Cancer \n", "\n", " Type Issn SJR SJR Best Quartile H index \\\n", "0 journal 15424863, 00079235 88,192 Q1 156 \n", "1 journal 10575987, 15458601 41,022 Q1 138 \n", "2 journal 20588437 36,691 Q1 80 \n", "3 journal 00335533, 15314650 36,220 Q1 246 \n", "4 journal 14710072, 14710080 29,997 Q1 411 \n", "5 book series 15518922, 15518930 29,810 Q1 95 \n", "6 journal 14710056, 14710064 28,619 Q1 345 \n", "7 journal 00928674, 10974172 24,698 Q1 747 \n", "8 journal 00346861, 15390756 21,938 Q1 316 \n", "9 journal 1474175X, 14741768 21,287 Q1 418 \n", "\n", " Total Docs. (2019) Total Docs. (3years) Total Refs. \\\n", "0 36 129 2924 \n", "1 4 11 144 \n", "2 85 288 8534 \n", "3 30 123 1909 \n", "4 115 382 9251 \n", "5 14 30 379 \n", "6 113 376 8586 \n", "7 581 1881 34924 \n", "8 40 131 11080 \n", "9 138 366 7641 \n", "\n", " Total Cites (3years) Citable Docs. (3years) Cites / Doc. (2years) \\\n", "0 22644 89 255,73 \n", "1 898 11 52,00 \n", "2 12569 151 68,34 \n", "3 2020 119 12,65 \n", "4 8074 182 47,70 \n", "5 1059 30 41,61 \n", "6 6416 154 32,21 \n", "7 49252 1630 30,16 \n", "8 5583 121 45,73 \n", "9 8532 204 37,77 \n", "\n", " Ref. / Doc. Country Region \\\n", "0 81,22 United States Northern America \n", "1 36,00 United States Northern America \n", "2 100,40 United Kingdom Western Europe \n", "3 63,63 United Kingdom Western Europe \n", "4 80,44 United Kingdom Western Europe \n", "5 27,07 United States Northern America \n", "6 75,98 United Kingdom Western Europe \n", "7 60,11 United States Northern America \n", "8 277,00 United States Northern America \n", "9 55,37 United Kingdom Western Europe \n", "\n", " Publisher Coverage \\\n", "0 Wiley-Blackwell 1950-2020 \n", "1 Centers for Disease Control and Prevention (CDC) 1990-2020 \n", "2 Nature Publishing Group 2016-2020 \n", "3 Oxford University Press 1886-2020 \n", "4 Nature Publishing Group 2000-2020 \n", "5 Public Health Services, US Dept of Health and ... 1998-2020 \n", "6 Nature Publishing Group 2000-2020 \n", "7 Cell Press 1974-2020 \n", "8 American Physical Society 1929-2019 \n", "9 Nature Publishing Group 2001-2020 \n", "\n", " Categories \n", "0 Hematology (Q1); Oncology (Q1) \n", "1 Epidemiology (Q1); Health Information Manageme... \n", "2 Biomaterials (Q1); Electronic, Optical and Mag... \n", "3 Economics and Econometrics (Q1) \n", "4 Cell Biology (Q1); Molecular Biology (Q1) \n", "5 Life-span and Life-course Studies (Q1) \n", "6 Genetics (Q1); Genetics (clinical) (Q1); Molec... \n", "7 Biochemistry, Genetics and Molecular Biology (... \n", "8 Physics and Astronomy (miscellaneous) (Q1) \n", "9 Cancer Research (Q1); Oncology (Q1) " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "scimago = read_csv('data/scimagojr 2019.csv', sep=';')\n", "scimago.head(10)" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "True" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "scimago.Title.duplicated().any()" ] }, { "cell_type": "code", "execution_count": 6, "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", " \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", "
Duplicate Pair IDTitleIssnSJRH indexCountryPublisherchosen
00Proceedings - Annual IEEE Symposium on Foundat...027254283,20389FranceNaNTrue
10Proceedings - Annual IEEE Symposium on Foundat...027254282,44481United StatesNaNFalse
21Neurosurgery15244040, 0148396X1,530192United StatesLippincott Williams and Wilkins Ltd.True
31Clinical Neurosurgery0148396X, 006948271,16931United StatesLippincott Williams and Wilkins Ltd.False
42Australian Journal of Psychology00049530, 174295360,47738United StatesWiley-BlackwellTrue
52Australian Journal of Political Science10361146, 174295360,42335United KingdomRoutledgeFalse
63Journal of Neuropathology and Experimental Neu...15546578, 002230691,366159United KingdomOxford University PressTrue
73American Journal of Psychotherapy15546578, 000295640,32635United StatesAssociation for the Advancement of Psychothera...False
84International Review of Aerospace Engineering19737459, 253322790,61814ItalyPraise Worthy Prize S.r.lTrue
94Chinese Journal of Physiology03044920, 253322790,28930TaiwanChinese Physiological SocietyFalse
105International Journal of Engineering, Transact...17359244, 172814310,39515IranMaterials and Energy Research CenterTrue
115International Journal of Engineering, Transact...1728144X, 173592440,26516IranMaterials and Energy Research CenterFalse
126Smart Innovation, Systems and Technologies21903026, 219030180,18018GermanySpringer VerlagTrue
1366th International Conference on Research into ...21903026, 219030180,1674GermanySpringer NatureFalse
147Smart Innovation, Systems and Technologies21903026, 219030180,18018GermanySpringer VerlagTrue
1576th International Conference on Research into ...21903026, 219030180,1674GermanySpringer NatureFalse
168Proceedings of IEEE Sensors193003950,1739United KingdomNaNTrue
178Proceedings of IEEE Sensors193003950,16038United StatesNaNFalse
189Korean Journal of Microbiology and Biotechnology22347305, 1598642X0,16216South KoreaKorean Society for Microbiolog and BiotechnologyTrue
199Microbiology and Biotechnology Letters1598642X, 223473050,1494South KoreaKorean Society for Microbiolog and BiotechnologyFalse
2010Korean Journal of Microbiology and Biotechnology22347305, 1598642X0,16216South KoreaKorean Society for Microbiolog and BiotechnologyTrue
2110Microbiology and Biotechnology Letters1598642X, 223473050,1494South KoreaKorean Society for Microbiolog and BiotechnologyFalse
2211Papers Presented at the Annual Conference - Ru...073474640,13512United StatesNaNTrue
2311Papers - Rural Electric Power Conference073474640,12512United StatesNaNFalse
2412Lloyd's Maritime Asia021711200,1130Hong KongLloyd's of London PressTrue
2512MARIT. ASIA021711200,1080ChinaLloyd's of London PressFalse
2613Clinical and Experimental Optometry14440938, 081646220,75251United StatesWiley-BlackwellTrue
2713The Australasian journal of optometry0817881X, 144409380,1081AustraliaOptometrists Association AustraliaFalse
2814Journal fur Pharmakologie und Therapie143243340,1012GermanyVerlag Perfusion GmbHTrue
2914Perfusion (Germany)14324334, 093500200,1007GermanyVerlag Perfusion GmbHFalse
\n", "
" ], "text/plain": [ " Duplicate Pair ID Title \\\n", "0 0 Proceedings - Annual IEEE Symposium on Foundat... \n", "1 0 Proceedings - Annual IEEE Symposium on Foundat... \n", "2 1 Neurosurgery \n", "3 1 Clinical Neurosurgery \n", "4 2 Australian Journal of Psychology \n", "5 2 Australian Journal of Political Science \n", "6 3 Journal of Neuropathology and Experimental Neu... \n", "7 3 American Journal of Psychotherapy \n", "8 4 International Review of Aerospace Engineering \n", "9 4 Chinese Journal of Physiology \n", "10 5 International Journal of Engineering, Transact... \n", "11 5 International Journal of Engineering, Transact... \n", "12 6 Smart Innovation, Systems and Technologies \n", "13 6 6th International Conference on Research into ... \n", "14 7 Smart Innovation, Systems and Technologies \n", "15 7 6th International Conference on Research into ... \n", "16 8 Proceedings of IEEE Sensors \n", "17 8 Proceedings of IEEE Sensors \n", "18 9 Korean Journal of Microbiology and Biotechnology \n", "19 9 Microbiology and Biotechnology Letters \n", "20 10 Korean Journal of Microbiology and Biotechnology \n", "21 10 Microbiology and Biotechnology Letters \n", "22 11 Papers Presented at the Annual Conference - Ru... \n", "23 11 Papers - Rural Electric Power Conference \n", "24 12 Lloyd's Maritime Asia \n", "25 12 MARIT. ASIA \n", "26 13 Clinical and Experimental Optometry \n", "27 13 The Australasian journal of optometry \n", "28 14 Journal fur Pharmakologie und Therapie \n", "29 14 Perfusion (Germany) \n", "\n", " Issn SJR H index Country \\\n", "0 02725428 3,203 89 France \n", "1 02725428 2,444 81 United States \n", "2 15244040, 0148396X 1,530 192 United States \n", "3 0148396X, 00694827 1,169 31 United States \n", "4 00049530, 17429536 0,477 38 United States \n", "5 10361146, 17429536 0,423 35 United Kingdom \n", "6 15546578, 00223069 1,366 159 United Kingdom \n", "7 15546578, 00029564 0,326 35 United States \n", "8 19737459, 25332279 0,618 14 Italy \n", "9 03044920, 25332279 0,289 30 Taiwan \n", "10 17359244, 17281431 0,395 15 Iran \n", "11 1728144X, 17359244 0,265 16 Iran \n", "12 21903026, 21903018 0,180 18 Germany \n", "13 21903026, 21903018 0,167 4 Germany \n", "14 21903026, 21903018 0,180 18 Germany \n", "15 21903026, 21903018 0,167 4 Germany \n", "16 19300395 0,173 9 United Kingdom \n", "17 19300395 0,160 38 United States \n", "18 22347305, 1598642X 0,162 16 South Korea \n", "19 1598642X, 22347305 0,149 4 South Korea \n", "20 22347305, 1598642X 0,162 16 South Korea \n", "21 1598642X, 22347305 0,149 4 South Korea \n", "22 07347464 0,135 12 United States \n", "23 07347464 0,125 12 United States \n", "24 02171120 0,113 0 Hong Kong \n", "25 02171120 0,108 0 China \n", "26 14440938, 08164622 0,752 51 United States \n", "27 0817881X, 14440938 0,108 1 Australia \n", "28 14324334 0,101 2 Germany \n", "29 14324334, 09350020 0,100 7 Germany \n", "\n", " Publisher chosen \n", "0 NaN True \n", "1 NaN False \n", "2 Lippincott Williams and Wilkins Ltd. True \n", "3 Lippincott Williams and Wilkins Ltd. False \n", "4 Wiley-Blackwell True \n", "5 Routledge False \n", "6 Oxford University Press True \n", "7 Association for the Advancement of Psychothera... False \n", "8 Praise Worthy Prize S.r.l True \n", "9 Chinese Physiological Society False \n", "10 Materials and Energy Research Center True \n", "11 Materials and Energy Research Center False \n", "12 Springer Verlag True \n", "13 Springer Nature False \n", "14 Springer Verlag True \n", "15 Springer Nature False \n", "16 NaN True \n", "17 NaN False \n", "18 Korean Society for Microbiolog and Biotechnology True \n", "19 Korean Society for Microbiolog and Biotechnology False \n", "20 Korean Society for Microbiolog and Biotechnology True \n", "21 Korean Society for Microbiolog and Biotechnology False \n", "22 NaN True \n", "23 NaN False \n", "24 Lloyd's of London Press True \n", "25 Lloyd's of London Press False \n", "26 Wiley-Blackwell True \n", "27 Optometrists Association Australia False \n", "28 Verlag Perfusion GmbH True \n", "29 Verlag Perfusion GmbH False " ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "index_by_issn = {}\n", "to_highlight = ['Title', 'Issn', 'SJR', 'H index', 'Country', 'Publisher']\n", "\n", "scimago_by_issn = []\n", "indexed_twice = []\n", "\n", "for index, issns in scimago.Issn.str.split(', ').iteritems():\n", " for issn in issns:\n", " if issn == '-':\n", " continue\n", " if issn in index_by_issn:\n", " old_index = index_by_issn[issn]\n", " old = scimago.iloc[old_index][to_highlight].to_dict()\n", " new = scimago.iloc[index][to_highlight].to_dict()\n", " duplicate_pair_id = len(indexed_twice) // 2\n", " indexed_twice.append({'Duplicate Pair ID': duplicate_pair_id, **old, 'chosen': True})\n", " indexed_twice.append({'Duplicate Pair ID': duplicate_pair_id, **new, 'chosen': False})\n", " else:\n", " index_by_issn[issn] = index\n", " scimago_by_issn.append({'atomic_issn': issn, **scimago.iloc[index].to_dict()})\n", "\n", "scimago_by_issn = DataFrame(scimago_by_issn).set_index('atomic_issn').rename(columns={'Issn': 'All ISSNs'})\n", "indexed_twice = DataFrame(indexed_twice)\n", "indexed_twice" ] }, { "cell_type": "code", "execution_count": 7, "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", " \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", "
RankSourceidTitleTypeAll ISSNsSJRSJR Best QuartileH indexTotal Docs. (2019)Total Docs. (3years)Total Refs.Total Cites (3years)Citable Docs. (3years)Cites / Doc. (2years)Ref. / Doc.CountryRegionPublisherCoverageCategories
atomic_issn
15424863128773CA - A Cancer Journal for Cliniciansjournal15424863, 0007923588,192Q11563612929242264489255,7381,22United StatesNorthern AmericaWiley-Blackwell1950-2020Hematology (Q1); Oncology (Q1)
00079235128773CA - A Cancer Journal for Cliniciansjournal15424863, 0007923588,192Q11563612929242264489255,7381,22United StatesNorthern AmericaWiley-Blackwell1950-2020Hematology (Q1); Oncology (Q1)
10575987219434MMWR. Recommendations and reports : Morbidity ...journal10575987, 1545860141,022Q11384111448981152,0036,00United StatesNorthern AmericaCenters for Disease Control and Prevention (CDC)1990-2020Epidemiology (Q1); Health Information Manageme...
15458601219434MMWR. Recommendations and reports : Morbidity ...journal10575987, 1545860141,022Q11384111448981152,0036,00United StatesNorthern AmericaCenters for Disease Control and Prevention (CDC)1990-2020Epidemiology (Q1); Health Information Manageme...
20588437321100812243Nature Reviews Materialsjournal2058843736,691Q1808528885341256915168,34100,40United KingdomWestern EuropeNature Publishing Group2016-2020Biomaterials (Q1); Electronic, Optical and Mag...
...............................................................
074194573088022852Yale journal on regulationjournal07419457NaN-21501126000,0075,07United StatesNorthern AmericaYale Journal on Regulation1991, 1994, 1998, 2019-2020Law; Public Administration
035250073088121100932639Zbornik Matice Srpske za Slavistikujournal03525007NaN-02408000,000,33SerbiaEastern EuropeMatica Srpska2019Language and Linguistics; Linguistics and Lang...
0044197X3088219509Zdravookhranenie Rossiiskoi Federatsii / Minis...journal0044197XNaN-1380745000,0019,61Russian FederationEastern EuropeIzdatel'stvo Meditsina1965-1980, 2019Health Policy; Public Health, Environmental an...
264449093088321100945707Zdravotnicke Listyjournal26444909, 13393022NaN-0300517000,0017,23SlovakiaEastern EuropeFaculty of Healthcare, Alexander Dubcek Univer...2019Nursing (miscellaneous); Occupational Therapy;...
133930223088321100945707Zdravotnicke Listyjournal26444909, 13393022NaN-0300517000,0017,23SlovakiaEastern EuropeFaculty of Healthcare, Alexander Dubcek Univer...2019Nursing (miscellaneous); Occupational Therapy;...
\n", "

43260 rows × 20 columns

\n", "
" ], "text/plain": [ " Rank Sourceid \\\n", "atomic_issn \n", "15424863 1 28773 \n", "00079235 1 28773 \n", "10575987 2 19434 \n", "15458601 2 19434 \n", "20588437 3 21100812243 \n", "... ... ... \n", "07419457 30880 22852 \n", "03525007 30881 21100932639 \n", "0044197X 30882 19509 \n", "26444909 30883 21100945707 \n", "13393022 30883 21100945707 \n", "\n", " Title Type \\\n", "atomic_issn \n", "15424863 CA - A Cancer Journal for Clinicians journal \n", "00079235 CA - A Cancer Journal for Clinicians journal \n", "10575987 MMWR. Recommendations and reports : Morbidity ... journal \n", "15458601 MMWR. Recommendations and reports : Morbidity ... journal \n", "20588437 Nature Reviews Materials journal \n", "... ... ... \n", "07419457 Yale journal on regulation journal \n", "03525007 Zbornik Matice Srpske za Slavistiku journal \n", "0044197X Zdravookhranenie Rossiiskoi Federatsii / Minis... journal \n", "26444909 Zdravotnicke Listy journal \n", "13393022 Zdravotnicke Listy journal \n", "\n", " All ISSNs SJR SJR Best Quartile H index \\\n", "atomic_issn \n", "15424863 15424863, 00079235 88,192 Q1 156 \n", "00079235 15424863, 00079235 88,192 Q1 156 \n", "10575987 10575987, 15458601 41,022 Q1 138 \n", "15458601 10575987, 15458601 41,022 Q1 138 \n", "20588437 20588437 36,691 Q1 80 \n", "... ... ... ... ... \n", "07419457 07419457 NaN - 2 \n", "03525007 03525007 NaN - 0 \n", "0044197X 0044197X NaN - 1 \n", "26444909 26444909, 13393022 NaN - 0 \n", "13393022 26444909, 13393022 NaN - 0 \n", "\n", " Total Docs. (2019) Total Docs. (3years) Total Refs. \\\n", "atomic_issn \n", "15424863 36 129 2924 \n", "00079235 36 129 2924 \n", "10575987 4 11 144 \n", "15458601 4 11 144 \n", "20588437 85 288 8534 \n", "... ... ... ... \n", "07419457 15 0 1126 \n", "03525007 24 0 8 \n", "0044197X 38 0 745 \n", "26444909 30 0 517 \n", "13393022 30 0 517 \n", "\n", " Total Cites (3years) Citable Docs. (3years) \\\n", "atomic_issn \n", "15424863 22644 89 \n", "00079235 22644 89 \n", "10575987 898 11 \n", "15458601 898 11 \n", "20588437 12569 151 \n", "... ... ... \n", "07419457 0 0 \n", "03525007 0 0 \n", "0044197X 0 0 \n", "26444909 0 0 \n", "13393022 0 0 \n", "\n", " Cites / Doc. (2years) Ref. / Doc. Country \\\n", "atomic_issn \n", "15424863 255,73 81,22 United States \n", "00079235 255,73 81,22 United States \n", "10575987 52,00 36,00 United States \n", "15458601 52,00 36,00 United States \n", "20588437 68,34 100,40 United Kingdom \n", "... ... ... ... \n", "07419457 0,00 75,07 United States \n", "03525007 0,00 0,33 Serbia \n", "0044197X 0,00 19,61 Russian Federation \n", "26444909 0,00 17,23 Slovakia \n", "13393022 0,00 17,23 Slovakia \n", "\n", " Region \\\n", "atomic_issn \n", "15424863 Northern America \n", "00079235 Northern America \n", "10575987 Northern America \n", "15458601 Northern America \n", "20588437 Western Europe \n", "... ... \n", "07419457 Northern America \n", "03525007 Eastern Europe \n", "0044197X Eastern Europe \n", "26444909 Eastern Europe \n", "13393022 Eastern Europe \n", "\n", " Publisher \\\n", "atomic_issn \n", "15424863 Wiley-Blackwell \n", "00079235 Wiley-Blackwell \n", "10575987 Centers for Disease Control and Prevention (CDC) \n", "15458601 Centers for Disease Control and Prevention (CDC) \n", "20588437 Nature Publishing Group \n", "... ... \n", "07419457 Yale Journal on Regulation \n", "03525007 Matica Srpska \n", "0044197X Izdatel'stvo Meditsina \n", "26444909 Faculty of Healthcare, Alexander Dubcek Univer... \n", "13393022 Faculty of Healthcare, Alexander Dubcek Univer... \n", "\n", " Coverage \\\n", "atomic_issn \n", "15424863 1950-2020 \n", "00079235 1950-2020 \n", "10575987 1990-2020 \n", "15458601 1990-2020 \n", "20588437 2016-2020 \n", "... ... \n", "07419457 1991, 1994, 1998, 2019-2020 \n", "03525007 2019 \n", "0044197X 1965-1980, 2019 \n", "26444909 2019 \n", "13393022 2019 \n", "\n", " Categories \n", "atomic_issn \n", "15424863 Hematology (Q1); Oncology (Q1) \n", "00079235 Hematology (Q1); Oncology (Q1) \n", "10575987 Epidemiology (Q1); Health Information Manageme... \n", "15458601 Epidemiology (Q1); Health Information Manageme... \n", "20588437 Biomaterials (Q1); Electronic, Optical and Mag... \n", "... ... \n", "07419457 Law; Public Administration \n", "03525007 Language and Linguistics; Linguistics and Lang... \n", "0044197X Health Policy; Public Health, Environmental an... \n", "26444909 Nursing (miscellaneous); Occupational Therapy;... \n", "13393022 Nursing (miscellaneous); Occupational Therapy;... \n", "\n", "[43260 rows x 20 columns]" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "scimago_by_issn" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/markdown": [ "Stored:\n", "\n", " - `scimago_by_issn` (693288F1 → DDCBFB24)\n", " - `web_of_science_journals` (E95CE31E → E95CE31E)\n", "\n", "at Sunday, 12. Jul 2020 21:35" ], "text/plain": [ "" ] }, "metadata": { "text/markdown": { "action": "store", "command": "store scimago_by_issn, web_of_science_journals in journals_data", "finished": "2020-07-12T21:35:17.563956", "finished_human_readable": "Sunday, 12. Jul 2020 21:35", "result": [ { "new_file": { "crc32": "DDCBFB24", "sha256": "B16E18A78F3247A03950A39AB7B64E92EAFA747074BB6B2DBFEBDA7DCA5902D3" }, "old_file": { "crc32": "693288F1", "sha256": "CF064354E0069A8CE7192536730A786720DE65970D447D38B754F04D76CD9E8C" }, "subject": "scimago_by_issn" }, { "new_file": { "crc32": "E95CE31E", "sha256": "55F51248C28FEEC07B4E5A98AD3660519AD3566DC9B61985279E6D4C9B374BF8" }, "old_file": { "crc32": "E95CE31E", "sha256": "55F51248C28FEEC07B4E5A98AD3660519AD3566DC9B61985279E6D4C9B374BF8" }, "subject": "web_of_science_journals" } ], "started": "2020-07-12T21:35:13.616123" } }, "output_type": "display_data" } ], "source": [ "%vault store scimago_by_issn, web_of_science_journals in journals_data" ] } ], "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.8.3" } }, "nbformat": 4, "nbformat_minor": 4 }