ERC_start_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "grantees = pd.read_csv('ERC_grantees_career_state.csv', sep=',', \n",
    "                       skipinitialspace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>position</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Johannes Albrecht</td>\n",
       "      <td>Emmy-Noether group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Kerstin Bartscherer</td>\n",
       "      <td>MPI group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Til Birnstiel</td>\n",
       "      <td>MPI postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bonafede Annalisa</td>\n",
       "      <td>Juniorprofessor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Davide Cantoni</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Marco Caracciolo</td>\n",
       "      <td>Postdoc + Humboldt-Fellow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Tim Czopka</td>\n",
       "      <td>Emmy-Noether group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mark Dawson</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fei Ding</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Knut Drescher</td>\n",
       "      <td>Professor + MPI group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Martin Eckstein</td>\n",
       "      <td>Professor + MPI group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Gustavo Fernández</td>\n",
       "      <td>Professor + Humboldt-Fellow + group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Irene Fernandez-Cuesta</td>\n",
       "      <td>Postdoc??</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Nicola Gagliani</td>\n",
       "      <td>Postdoc??</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Gaetano Gargiulo</td>\n",
       "      <td>Max-Delbrück group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Gregor Gassner</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Elena Giannoulis</td>\n",
       "      <td>Juniorprofessor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Andreas Grüneis</td>\n",
       "      <td>MPI group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Corinna Hoose</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Johannes Hunger</td>\n",
       "      <td>MPI group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Frank Hutter</td>\n",
       "      <td>Emmy-Noether group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Matt Ikari</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Radu Iovita</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Annika Jahnke</td>\n",
       "      <td>Postdoc / group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Benjamin Judkewitz</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Jan Philipp Junker</td>\n",
       "      <td>Max-Delbrück group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Ville R. I. Kaila</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Jan-Henning Klusmann</td>\n",
       "      <td>Emmy-Noether group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Clemens Kroneberg</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Diederik Kruijssen</td>\n",
       "      <td>group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Kristin Lohwasser</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Axel Lubk</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Thomas Magauer</td>\n",
       "      <td>Emmy-Noether group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Philip Moll</td>\n",
       "      <td>MPI group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Andreas Müller</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Michael Nash</td>\n",
       "      <td>group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Petr Neugebauer</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Aloisia Nuijens</td>\n",
       "      <td>??</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Christof Osman</td>\n",
       "      <td>Postdoc + high impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Frederic W. Patureau</td>\n",
       "      <td>Juniorprofessor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Nicolas Plumeré</td>\n",
       "      <td>group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Arezoo Pooresmaeili</td>\n",
       "      <td>group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Christoph Rademacher</td>\n",
       "      <td>MPI group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Thomas Reiner</td>\n",
       "      <td>??</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Markus Retsch</td>\n",
       "      <td>Juniorprofessor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Barbara Schraml</td>\n",
       "      <td>Emmy-Noether group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Alexander Shapiro</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>T. Nicolai Siegel</td>\n",
       "      <td>group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Marion Silies</td>\n",
       "      <td>Emmy-Noether group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Gabriel Singer</td>\n",
       "      <td>group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Jürgen Steimle</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Konrad Tiefenbacher</td>\n",
       "      <td>Juniorprofessor</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Alexander Titz</td>\n",
       "      <td>group leader</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Sahana Udupa</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>Alyson van Raalte</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Franco Vazza</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Eva von Contzen</td>\n",
       "      <td>Postdoc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Rhîannan H. Williams</td>\n",
       "      <td>Postdoc??</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Agnieszka Wykowska</td>\n",
       "      <td>group leader + PD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Xiaoxiang Zhu</td>\n",
       "      <td>Professor</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      name                                    position\n",
       "0        Johannes Albrecht                   Emmy-Noether group leader\n",
       "1      Kerstin Bartscherer                            MPI group leader\n",
       "2            Til Birnstiel                                 MPI postdoc\n",
       "3        Bonafede Annalisa                             Juniorprofessor\n",
       "4           Davide Cantoni                                   Professor\n",
       "5         Marco Caracciolo                   Postdoc + Humboldt-Fellow\n",
       "6               Tim Czopka                   Emmy-Noether group leader\n",
       "7              Mark Dawson                                   Professor\n",
       "8                 Fei Ding                                   Professor\n",
       "9            Knut Drescher                Professor + MPI group leader\n",
       "10         Martin Eckstein                Professor + MPI group leader\n",
       "11       Gustavo Fernández  Professor + Humboldt-Fellow + group leader\n",
       "12  Irene Fernandez-Cuesta                                   Postdoc??\n",
       "13         Nicola Gagliani                                   Postdoc??\n",
       "14        Gaetano Gargiulo                   Max-Delbrück group leader\n",
       "15          Gregor Gassner                                   Professor\n",
       "16        Elena Giannoulis                             Juniorprofessor\n",
       "17         Andreas Grüneis                            MPI group leader\n",
       "18           Corinna Hoose                                   Professor\n",
       "19         Johannes Hunger                            MPI group leader\n",
       "20            Frank Hutter                   Emmy-Noether group leader\n",
       "21              Matt Ikari                                     Postdoc\n",
       "22             Radu Iovita                                     Postdoc\n",
       "23           Annika Jahnke                      Postdoc / group leader\n",
       "24      Benjamin Judkewitz                                   Professor\n",
       "25      Jan Philipp Junker                   Max-Delbrück group leader\n",
       "26       Ville R. I. Kaila                                   Professor\n",
       "27    Jan-Henning Klusmann                   Emmy-Noether group leader\n",
       "28       Clemens Kroneberg                                   Professor\n",
       "29      Diederik Kruijssen                                group leader\n",
       "..                     ...                                         ...\n",
       "31       Kristin Lohwasser                                     Postdoc\n",
       "32               Axel Lubk                                     Postdoc\n",
       "33          Thomas Magauer                   Emmy-Noether group leader\n",
       "34             Philip Moll                            MPI group leader\n",
       "35          Andreas Müller                                   Professor\n",
       "36            Michael Nash                                group leader\n",
       "37         Petr Neugebauer                                     Postdoc\n",
       "38         Aloisia Nuijens                                          ??\n",
       "39          Christof Osman                       Postdoc + high impact\n",
       "40    Frederic W. Patureau                             Juniorprofessor\n",
       "41         Nicolas Plumeré                                group leader\n",
       "42     Arezoo Pooresmaeili                                group leader\n",
       "43    Christoph Rademacher                            MPI group leader\n",
       "44           Thomas Reiner                                          ??\n",
       "45           Markus Retsch                             Juniorprofessor\n",
       "46         Barbara Schraml                   Emmy-Noether group leader\n",
       "47       Alexander Shapiro                                    Postdoc \n",
       "48       T. Nicolai Siegel                                group leader\n",
       "49           Marion Silies                   Emmy-Noether group leader\n",
       "50          Gabriel Singer                                group leader\n",
       "51          Jürgen Steimle                                   Professor\n",
       "52     Konrad Tiefenbacher                             Juniorprofessor\n",
       "53          Alexander Titz                                group leader\n",
       "54            Sahana Udupa                                     Postdoc\n",
       "55       Alyson van Raalte                                     Postdoc\n",
       "56            Franco Vazza                                     Postdoc\n",
       "57         Eva von Contzen                                     Postdoc\n",
       "58    Rhîannan H. Williams                                   Postdoc??\n",
       "59      Agnieszka Wykowska                           group leader + PD\n",
       "60           Xiaoxiang Zhu                                   Professor\n",
       "\n",
       "[61 rows x 2 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "grantees"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "number of postdocs: 16\n"
     ]
    }
   ],
   "source": [
    "# group leaders are postdocs which are no group leaders\n",
    "ispostdoc = grantees['position'].str.contains(r'[pP]ostdoc')\n",
    "isgrplead = grantees['position'].str.contains(r'[gG]roup leader')\n",
    "ispostdoc = ispostdoc & ~isgrplead\n",
    "print('number of postdocs: %d' % ispostdoc.sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "number of full professors: 14\n"
     ]
    }
   ],
   "source": [
    "# separate Juniorprofessors and full professors\n",
    "isprof = grantees['position'].str.contains(r'[pP]rofessor')\n",
    "isjunprof = grantees['position'].str.contains(r'[jJ]uniorprofessor')\n",
    "isfullprof = isprof & ~isjunprof\n",
    "print('number of full professors: %d' % isfullprof.sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "number of junior research group leaders: 29\n"
     ]
    }
   ],
   "source": [
    "# full professors are no junior group leaders, but Juniorprofs are\n",
    "isjuniorgrplead = (isgrplead & ~isfullprof) | isjunprof\n",
    "print('number of junior research group leaders: %d' % isjuniorgrplead.sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "percentage postdocs: 27.1%\n"
     ]
    }
   ],
   "source": [
    "# account for missing entries by summing only over identified positions\n",
    "print('percentage postdocs: %4.1f%%' % (ispostdoc.sum() / float(\n",
    "    ispostdoc.sum() + isfullprof.sum() + isjuniorgrplead.sum()) * 100))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}