Created
September 8, 2017 04:26
-
-
Save chrisgorgo/264b483805b5ef2bb45fadbb7db39a16 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 110, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "my_orcid = \"0000-0003-3321-7583\"" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 117, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "import requests\n", | |
| "import datetime\n", | |
| "import pandas as pd\n", | |
| "r = requests.get(url='http://pub.orcid.org/%s/orcid-works'%my_orcid, headers={\"Accept\": \"application/orcid+json\"})\n", | |
| "d = r.json()" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 147, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "def shu(x):\n", | |
| " if \",\" in x: \n", | |
| " return x\n", | |
| " elif len(x.split()[-1]) <= 2:\n", | |
| " return \", \".join(x.split())\n", | |
| " else: \n", | |
| " return x.split(\" \")[-1] + \", \" + \" \".join(x.split()[0:-1]) " | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 148, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "all_contributors = []\n", | |
| "\n", | |
| "for work in d['orcid-profile']['orcid-activities']['orcid-works']['orcid-work']:\n", | |
| " if work['work-contributors'] and work['work-contributors']['contributor']:\n", | |
| " if work['publication-date']:\n", | |
| " year = int(work['publication-date']['year']['value'])\n", | |
| " month = 1\n", | |
| " if work['publication-date']['month']:\n", | |
| " month = int(work['publication-date']['month']['value'])\n", | |
| " day = 1\n", | |
| " if work['publication-date']['day']:\n", | |
| " day = int(work['publication-date']['day']['value'])\n", | |
| " \n", | |
| " pub_date = datetime.date(year=year, \n", | |
| " month=month, \n", | |
| " day=day)\n", | |
| " # only if within last 48 months\n", | |
| " if (datetime.date.today() - pub_date) < datetime.timedelta(days=365*4):\n", | |
| " contributors = [shu(contributor['credit-name']['value']) for contributor in work['work-contributors']['contributor'] if contributor['credit-name']]\n", | |
| " all_contributors += contributors" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 150, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "def get_affiliation(name):\n", | |
| " \n", | |
| " r = requests.get(url='https://pub.orcid.org/v2.0/search?q=%s'%name, headers={\"Accept\": \"application/orcid+json\"})\n", | |
| " j = r.json()\n", | |
| " if int(j['num-found']) > 0:\n", | |
| " orcid = j['result'][0]['orcid-identifier']['path']\n", | |
| "\n", | |
| " r = requests.get(url='https://pub.orcid.org/v2.0/%s/employments'%orcid, headers={\"Accept\": \"application/orcid+json\"})\n", | |
| " employments = r.json()['employment-summary']\n", | |
| " for empl in employments:\n", | |
| " if not empl['end-date']:\n", | |
| " return empl['organization']['name']\n", | |
| "\n", | |
| " r = requests.get(url='https://pub.orcid.org/v2.0/%s/educations'%orcid, headers={\"Accept\": \"application/orcid+json\"})\n", | |
| " employments = r.json()['education-summary']\n", | |
| " for empl in employments:\n", | |
| " if not empl['end-date']:\n", | |
| " return empl['organization']['name']\n", | |
| " return \"\"" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 151, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "name": "stdout", | |
| "output_type": "stream", | |
| "text": [ | |
| " name affilation\n", | |
| "0 Adeyemo, B. University of Ilorin Teaching Hospital\n", | |
| "1 Alfaro-Almagro, Fidel University of Oxford\n", | |
| "2 Anderson, J.S. Universidade Norte do Paraná\n", | |
| "3 Arno, Klein Child Mind Institute\n", | |
| "4 Auer, Tibor \n", | |
| "5 Baird, B \n", | |
| "6 Baker, Chris I \n", | |
| "7 Bastin, M.E. \n", | |
| "8 Bazin, P.-L. Universität Osnabrück\n", | |
| "9 Bazin, Pierre-Louis Universität Osnabrück\n", | |
| "10 Belin, P. Närhälsan Åby Vårdcentral\n", | |
| "11 Belin, Pascal Närhälsan Åby Vårdcentral\n", | |
| "12 Bell, P.T. Agricultural University of Athens\n", | |
| "13 Bell, Peter T. \n", | |
| "14 Bellec, P. \n", | |
| "15 Bellec, Pierre \n", | |
| "16 Bestelmeyer, P.E.G. \n", | |
| "17 Bestelmeyer, Patricia E.G. \n", | |
| "18 Bilder, Robert \n", | |
| "19 Birman, Daniel \n", | |
| "20 Birn, R.M. \n", | |
| "21 Biswal, B.B. \n", | |
| "22 Blaise, Federick JJP Consulting\n", | |
| "23 Blangero, J. \n", | |
| "24 Blautzik, J. \n", | |
| "25 Bonnen, T. \n", | |
| "26 Bonnen, Tyler \n", | |
| "27 Bowring, Alexander \n", | |
| "28 Boyd, R.L. \n", | |
| "29 Breitner, J.C.S. \n", | |
| ".. ... ...\n", | |
| "279 Wang, Yida \n", | |
| "280 Wardlaw, J. \n", | |
| "281 Watson, R.H. Universidade Estadual de Londrina\n", | |
| "282 Watson, Rebecca H. \n", | |
| "283 Wei, D. \n", | |
| "284 Wei, G.-X. \n", | |
| "285 Weng, X.-C. \n", | |
| "286 Whittle, I. \n", | |
| "287 Wilfling, D. \n", | |
| "288 Wilfling, Domenica \n", | |
| "289 Wladimirow, E. \n", | |
| "290 Wladimirow, Elisabeth \n", | |
| "291 Wu, X. \n", | |
| "292 Xu, T. \n", | |
| "293 Yang, N. \n", | |
| "294 Yang, Z. \n", | |
| "295 Yannick, Schwartz Université de Lausanne\n", | |
| "296 Yarkoni, T. \n", | |
| "297 Yarkoni, Tal \n", | |
| "298 Yaroslav, Halchenko Dartmouth College\n", | |
| "299 Zang, Y.-F. \n", | |
| "300 Zhang, L. \n", | |
| "301 Zhang, Q. \n", | |
| "302 Zhang, Z. \n", | |
| "303 Zhao, K. \n", | |
| "304 Zhen, Z. \n", | |
| "305 Zhou, Y. \n", | |
| "306 Zhu, X.-T. Yangzhou University\n", | |
| "307 Ziad, Saad Yarmouk University\n", | |
| "308 Zuo, X.-N. \n", | |
| "\n", | |
| "[309 rows x 2 columns]\n" | |
| ] | |
| } | |
| ], | |
| "source": [ | |
| "df = pd.DataFrame(sorted(set(all_contributors)), columns=['name'])\n", | |
| "df['affilation'] = df['name'].apply(get_affiliation)\n", | |
| "print(df)" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 152, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "name": "stdout", | |
| "output_type": "stream", | |
| "text": [ | |
| "Adeyemo, B.\n", | |
| "Alfaro-Almagro, Fidel\n", | |
| "Anderson, J.S.\n", | |
| "Arno, Klein\n", | |
| "Auer, Tibor\n", | |
| "Baird, B\n", | |
| "Baker, Chris I\n", | |
| "Bastin, M.E.\n", | |
| "Bazin, P.-L.\n", | |
| "Bazin, Pierre-Louis\n", | |
| "Belin, P.\n", | |
| "Belin, Pascal\n", | |
| "Bell, P.T.\n", | |
| "Bell, Peter T.\n", | |
| "Bellec, P.\n", | |
| "Bellec, Pierre\n", | |
| "Bestelmeyer, P.E.G.\n", | |
| "Bestelmeyer, Patricia E.G.\n", | |
| "Bilder, Robert\n", | |
| "Birman, Daniel\n", | |
| "Birn, R.M.\n", | |
| "Biswal, B.B.\n", | |
| "Blaise, Federick\n", | |
| "Blangero, J.\n", | |
| "Blautzik, J.\n", | |
| "Bonnen, T.\n", | |
| "Bonnen, Tyler\n", | |
| "Bowring, Alexander\n", | |
| "Boyd, R.L.\n", | |
| "Breitner, J.C.S.\n", | |
| "Buchanan, C.R.\n", | |
| "Buckner, R.L.\n", | |
| "Calhoun, V.D.\n", | |
| "Cameron, Craddock\n", | |
| "Camille, Maumet\n", | |
| "Cannon, Tyrone\n", | |
| "Capota, Mihai\n", | |
| "Capotă, Mihai\n", | |
| "Carless, M.A.\n", | |
| "Castellanos, F.X.\n", | |
| "Caven, T.\n", | |
| "Chakravarty, M. Mallar\n", | |
| "Charest, I.\n", | |
| "Charest, Ian\n", | |
| "Chen, A.\n", | |
| "Chen, B.\n", | |
| "Chen, Gang\n", | |
| "Chen, J.\n", | |
| "Chen, M.-Y.\n", | |
| "Chen, X.\n", | |
| "Christian, Haselgrove\n", | |
| "Churchill, Nathan W.\n", | |
| "Cohen, Alexander Li\n", | |
| "Colcombe, S.J.\n", | |
| "Congdon, Eliza\n", | |
| "Courtney, W.\n", | |
| "Cozatl, R.\n", | |
| "Cozatl, Roberto\n", | |
| "Crabbe, F.\n", | |
| "Crabbe, Frances\n", | |
| "Craddock, R. Cameron\n", | |
| "Craddock, R.C.\n", | |
| "Curran, J.E.\n", | |
| "DS, Margulies\n", | |
| "Daniel, Marcus\n", | |
| "Daniel, Margulies\n", | |
| "Das, Samir\n", | |
| "David, Keator\n", | |
| "David, Kennedy\n", | |
| "Devenyi, Gabriel A.\n", | |
| "Di Martino, A.\n", | |
| "Dong, H.-M.\n", | |
| "Dougherty, R.\n", | |
| "Durnez, J.\n", | |
| "Durnez, Joke\n", | |
| "Eklund, Anders\n", | |
| "Esteban, Oscar\n", | |
| "Fariba, Fana\n", | |
| "Flandin, Guillaume\n", | |
| "Fleming, D.\n", | |
| "Fleming, David\n", | |
| "Franck, Michel\n", | |
| "Frank, Michel\n", | |
| "Freimer, Nelson\n", | |
| "Frick, L.\n", | |
| "Fu, X.\n", | |
| "Gang, Chen\n", | |
| "Gauthier, C.J.\n", | |
| "Gauthier, Claudine J\n", | |
| "Ghosh, S.S.\n", | |
| "Ghosh, Satrajit\n", | |
| "Ghosh, Satrajit S.\n", | |
| "Gilat, M.\n", | |
| "Gilat, Moran\n", | |
| "Glahn, D.C.\n", | |
| "Glatard, Tristan\n", | |
| "Gong, Q.\n", | |
| "Gordon, E.\n", | |
| "Gorgolewski, K.J.\n", | |
| "Gorgolewski, Krzysztof\n", | |
| "Gorgolewski, Krzysztof J\n", | |
| "Gorgolewski, Krzysztof J.\n", | |
| "Gregory, B.\n", | |
| "Guillaume, Flandin\n", | |
| "Gully, Burns\n", | |
| "Guntupalli, J. Swaroop\n", | |
| "Göring, H.H.H.\n", | |
| "Han, Y.\n", | |
| "Handwerker, D.A.\n", | |
| "He, Y.\n", | |
| "Helmer, Karl G.\n", | |
| "Ho, E.\n", | |
| "Holmes, A.\n", | |
| "Hou, X.-H.\n", | |
| "Hover, A.\n", | |
| "Huckins, J.\n", | |
| "Hunicke-Smith, S.\n", | |
| "JA, Kipping\n", | |
| "Jason, Steffener\n", | |
| "Jean-Baptiste, Poline\n", | |
| "Jenkinson, Mark\n", | |
| "Jessica, Turner\n", | |
| "Jiang, T.\n", | |
| "Jiang, Y.\n", | |
| "Job, D.\n", | |
| "John, Van Horn\n", | |
| "Joo, S.J.\n", | |
| "KJ, Gorgolewski\n", | |
| "Karl, Helmer\n", | |
| "Karlsgodt, Katherine\n", | |
| "Keator, David\n", | |
| "Keator, David B.\n", | |
| "Kelley, W.\n", | |
| "Kelly, C.\n", | |
| "Keshavan, Anisha\n", | |
| "Kiar, Gregory\n", | |
| "Kiebel, S.J.\n", | |
| "King, M.\n", | |
| "Kipping, J.A.\n", | |
| "Koyejo, O.\n", | |
| "Koyejo, Oluwasanmi\n", | |
| "Koyejo, Oluwasanmi O.\n", | |
| "Krzysztof, Gorgolewski\n", | |
| "LaConte, S.M.\n", | |
| "Lainhart, J.E.\n", | |
| "Latinus, M.\n", | |
| "Latinus, Marianne\n", | |
| "Laumann, T.O.\n", | |
| "Leemans, A.\n", | |
| "Lei, X.\n", | |
| "Li, H.-J.\n", | |
| "Li, K.\n", | |
| "Liem, Franziskus\n", | |
| "Lin, Q.\n", | |
| "Linda, Lanyon\n", | |
| "Liu, D.\n", | |
| "Liu, J.\n", | |
| "Liu, X.\n", | |
| "Liu, Y.\n", | |
| "Lohmann, G\n", | |
| "Lohmann, G.\n", | |
| "London, Edythe\n", | |
| "Lu, G.\n", | |
| "Lu, J.\n", | |
| "Luci, J.\n", | |
| "Luna, B.\n", | |
| "Luo, J.\n", | |
| "Lurie, D\n", | |
| "Lurie, D.\n", | |
| "MP, Milham\n", | |
| "Mao, Y.\n", | |
| "Marcotte, E.M.\n", | |
| "Margulies, D.S.\n", | |
| "Margulies, Daniel S\n", | |
| "Margulies, Daniel S.\n", | |
| "Mark, Jenkinson\n", | |
| "Matthews, Paul M\n", | |
| "Maumet, C.\n", | |
| "Maumet, Camille\n", | |
| "Mayer, A.R.\n", | |
| "McAleer, P.\n", | |
| "McAleer, Phil\n", | |
| "Mckay, D.R.\n", | |
| "Meindl, T.\n", | |
| "Mendes, N.\n", | |
| "Mendes, Natacha\n", | |
| "Meyerand, M.E.\n", | |
| "Michael, Hanke\n", | |
| "Michael, Milham\n", | |
| "Milham, M.P.\n", | |
| "Mumford, J.A.\n", | |
| "Mumford, Jeanette\n", | |
| "Munafo, Marcus\n", | |
| "Nan, W.\n", | |
| "Nichols, B\n", | |
| "Nichols, B. Nolan\n", | |
| "Nichols, Nolan Nolan\n", | |
| "Nichols, T.E.\n", | |
| "Nichols, Thomas\n", | |
| "Nichols, Thomas E.\n", | |
| "Nielsen, J.A.\n", | |
| "O'Connor, D.\n", | |
| "Paulsen, D.\n", | |
| "Pernet, C.R.\n", | |
| "Pernet, Cyril R.\n", | |
| "Petersen, S.E.\n", | |
| "Poldrack, R.A.\n", | |
| "Poldrack, Russell\n", | |
| "Poldrack, Russell A\n", | |
| "Poldrack, Russell A.\n", | |
| "Poline, J.-B.\n", | |
| "Poline, Jean-Baptiste\n", | |
| "Prabhakaran, V.\n", | |
| "Qi, Z.\n", | |
| "Qiu, J.\n", | |
| "Quirion, Pierre-Olivier\n", | |
| "RC, Craddock\n", | |
| "Raamana, Pradeep Reddy\n", | |
| "Raffelt, David\n", | |
| "Reynolds, Richard\n", | |
| "Richard, Reynolds\n", | |
| "Richard, Stoner\n", | |
| "Rivera, G.\n", | |
| "Rivera, Gabriel\n", | |
| "Rodriguez, D.\n", | |
| "Ruby, F.J.M.\n", | |
| "Ruby, Florence J.M\n", | |
| "Ruediger, Bruehl\n", | |
| "Russell, Poldrack\n", | |
| "SJ, Kiebel\n", | |
| "Sabb, Fred\n", | |
| "Samir, Das\n", | |
| "Satrajit, Ghosh\n", | |
| "Schaefer, A\n", | |
| "Schaefer, A.\n", | |
| "Schaer, Marie\n", | |
| "Schneidman, Dina\n", | |
| "Schwartz, Y.\n", | |
| "Schwartz, Yannick\n", | |
| "Schwarz, Y.\n", | |
| "Schwarz, Yannick\n", | |
| "Shao, C.\n", | |
| "Shehzad, Z.\n", | |
| "Shine, J.M.\n", | |
| "Shine, James M.\n", | |
| "Simpson, Z.B.\n", | |
| "Smallwood, J\n", | |
| "Smallwood, J.\n", | |
| "Smallwood, Jonathan\n", | |
| "Smith, Robert E.\n", | |
| "Snyder, A.Z.\n", | |
| "Sochat, V.\n", | |
| "Sochat, V.V.\n", | |
| "Sochat, Vanessa\n", | |
| "Sochat, Vanessa V.\n", | |
| "Steele, Christopher J.\n", | |
| "Storkey, A.\n", | |
| "Storkey, A.J.\n", | |
| "Strother, Stephen C.\n", | |
| "Tang, W.\n", | |
| "Tanya, Schmah\n", | |
| "Thomas, Nichols\n", | |
| "Tibor, Auer\n", | |
| "Trampel, R.\n", | |
| "Trampel, Robert\n", | |
| "Triplett, William\n", | |
| "Turner, Jessica\n", | |
| "Urchs, S\n", | |
| "Urchs, S.\n", | |
| "Valdes-Sosa, M.\n", | |
| "Valdes-Sosa, Mitchell\n", | |
| "Varoquaux, G.\n", | |
| "Varoquaux, Gael\n", | |
| "Varoquaux, Gaël\n", | |
| "Villringer, A\n", | |
| "Villringer, A.\n", | |
| "Vul, Edward\n", | |
| "Wang, H.\n", | |
| "Wang, K.\n", | |
| "Wang, Yida\n", | |
| "Wardlaw, J.\n", | |
| "Watson, R.H.\n", | |
| "Watson, Rebecca H.\n", | |
| "Wei, D.\n", | |
| "Wei, G.-X.\n", | |
| "Weng, X.-C.\n", | |
| "Whittle, I.\n", | |
| "Wilfling, D.\n", | |
| "Wilfling, Domenica\n", | |
| "Wladimirow, E.\n", | |
| "Wladimirow, Elisabeth\n", | |
| "Wu, X.\n", | |
| "Xu, T.\n", | |
| "Yang, N.\n", | |
| "Yang, Z.\n", | |
| "Yannick, Schwartz\n", | |
| "Yarkoni, T.\n", | |
| "Yarkoni, Tal\n", | |
| "Yaroslav, Halchenko\n", | |
| "Zang, Y.-F.\n", | |
| "Zhang, L.\n", | |
| "Zhang, Q.\n", | |
| "Zhang, Z.\n", | |
| "Zhao, K.\n", | |
| "Zhen, Z.\n", | |
| "Zhou, Y.\n", | |
| "Zhu, X.-T.\n", | |
| "Ziad, Saad\n", | |
| "Zuo, X.-N.\n" | |
| ] | |
| } | |
| ], | |
| "source": [ | |
| "for row in df.iterrows():\n", | |
| " print(row[1][\"name\"])" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 153, | |
| "metadata": {}, | |
| "outputs": [ | |
| { | |
| "name": "stdout", | |
| "output_type": "stream", | |
| "text": [ | |
| "University of Ilorin Teaching Hospital\n", | |
| "University of Oxford\n", | |
| "Universidade Norte do Paraná\n", | |
| "Child Mind Institute\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Universität Osnabrück\n", | |
| "Universität Osnabrück\n", | |
| "Närhälsan Åby Vårdcentral\n", | |
| "Närhälsan Åby Vårdcentral\n", | |
| "Agricultural University of Athens\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "JJP Consulting\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "University of Sydney\n", | |
| "University of California Los Angeles\n", | |
| "Annamalai University\n", | |
| "Child Mind Institute\n", | |
| "University of Oxford\n", | |
| "\n", | |
| "\n", | |
| "Intel Corporation\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "University of Birmingham\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Los Alamos National Laboratory\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Memphis Theological Seminary\n", | |
| "\n", | |
| "\n", | |
| "University of Glasgow\n", | |
| "University of Glasgow\n", | |
| "Child Mind Institute\n", | |
| "\n", | |
| "\n", | |
| "SUNY Upstate Medical University\n", | |
| "\n", | |
| "\n", | |
| "Indian Council of Agricultural Research\n", | |
| "\n", | |
| "\n", | |
| "Icahn School of Medicine at Mount Sinai\n", | |
| "LUMSA University\n", | |
| "\n", | |
| "West Chester University of Pennsylvania\n", | |
| "\n", | |
| "Stanford University\n", | |
| "Karolinska Institutet\n", | |
| "Universidad de Cádiz\n", | |
| "\n", | |
| "University College London\n", | |
| "\n", | |
| "University of Missouri Columbia\n", | |
| "Université Côte d’Azur, CNRS - I3S - UMR 7271\n", | |
| "\n", | |
| "\n", | |
| "OCLC Online Computer Library Center Inc\n", | |
| "\n", | |
| "\n", | |
| "Universitat Politécnica de Catalunya Escola Técnica Superior d'Arquitectura del Vallés\n", | |
| "\n", | |
| "Rostov State Medical University\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Hochschule für Technik und Wirtschaft\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Stanford University\n", | |
| "Stanford University\n", | |
| "Stanford University\n", | |
| "University of Maryland\n", | |
| "University College London\n", | |
| "Information Sciences Institute\n", | |
| "Dartmouth College\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "University of Rochester\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "University of Texas at Austin\n", | |
| "Hammill Institute on Disabilities\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "University of Southern California\n", | |
| "\n", | |
| "Seoul National University Hospital\n", | |
| "University of Rochester\n", | |
| "Feinstein Institute for Medical Research\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "MacEwan University\n", | |
| "Hammill Institute on Disabilities\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Stanford University\n", | |
| "Université Catholique de Louvain\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Guangzhou University of Chinese Medicine\n", | |
| "Third Institute of Oceanography SOA\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "the First Affiliated Hospital of Soochow University\n", | |
| "the First Affiliated Hospital of Soochow University\n", | |
| "\n", | |
| "Universidad de Guadalajara\n", | |
| "\n", | |
| "Zaporozhye State Medical University\n", | |
| "Zaporozhye State Medical University\n", | |
| "\n", | |
| "University of Minnesota System\n", | |
| "\n", | |
| "SUNY Upstate Medical University\n", | |
| "SUNY Upstate Medical University\n", | |
| "SUNY Upstate Medical University\n", | |
| "\n", | |
| "\n", | |
| "University of Oxford\n", | |
| "University of Oxford\n", | |
| "\n", | |
| "United States Geological Survey\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Universidade do Minho\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Washington University in Saint Louis\n", | |
| "\n", | |
| "\n", | |
| "Shanghai Jiao Tong University School of Medicine Affiliated Renji Hospital\n", | |
| "Genentech Inc\n", | |
| "Genentech Inc\n", | |
| "Genentech Inc\n", | |
| "\n", | |
| "\n", | |
| "Virginia Polytechnic Institute and State University\n", | |
| "\n", | |
| "Western Sydney University\n", | |
| "Technical University of Denmark\n", | |
| "Youth For Public Transport (Y4PT)\n", | |
| "University of Edinburgh\n", | |
| "Jørn Henrik Petersen\n", | |
| "MPUAT\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "The Adirondack Chapter of The Nature Conservancy\n", | |
| "\n", | |
| "University of Toronto\n", | |
| "Florey Institute of Neuroscience and Mental Health - Austin Campus\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Universidad de Castilla-La Mancha - Campus de Toledo\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Indian Council of Agricultural Research\n", | |
| "\n", | |
| "Charles Sturt University - Bathurst Campus\n", | |
| "Charles Sturt University - Bathurst Campus\n", | |
| "\n", | |
| "\n", | |
| "University of Applied Sciences for Health Professions Upper Austria\n", | |
| "Université de Lausanne\n", | |
| "B&G Engineering SAC\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Sugar Cane Growers Cooperative of Florida\n", | |
| "\n", | |
| "Pacific Northwest National Laboratory\n", | |
| "Pacific Northwest National Laboratory\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Stanford University School of Medicine\n", | |
| "Stanford University School of Medicine\n", | |
| "University of Alberta\n", | |
| "\n", | |
| "\n", | |
| "Pennsylvania State University\n", | |
| "Swansea University\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Stanford University\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "University of Puerto Rico\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Universidade Estadual de Londrina\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Université de Lausanne\n", | |
| "\n", | |
| "\n", | |
| "Dartmouth College\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "\n", | |
| "Yangzhou University\n", | |
| "Yarmouk University\n", | |
| "\n" | |
| ] | |
| } | |
| ], | |
| "source": [ | |
| "for row in df.iterrows():\n", | |
| " print(row[1][\"affilation\"])" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 100, | |
| "metadata": {}, | |
| "outputs": [], | |
| "source": [ | |
| "df.to_csv(\"C:/Users/filo/Downloads/contributors.csv\")" | |
| ] | |
| } | |
| ], | |
| "metadata": { | |
| "anaconda-cloud": {}, | |
| "kernelspec": { | |
| "display_name": "Python [default]", | |
| "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.5.3" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 2 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Cool idea! I gave it a try and it seems to be matching up some contributors to incorrect records... I'm also wondering if de-duplicating might be a desirable feature. Now if I could get all my contributors to update their ORCID profiles...