MakeAuthorLists.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from collections import defaultdict\n",
    "import pylatexenc\n",
    "from pylatexenc.latex2text import LatexNodes2Text\n",
    "import string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "dat=pd.read_excel(\"./AuthorList.xlsx\",engine='openpyxl')\n",
    "dat.index=dat.index+2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>LastName</th>\n",
       "      <th>Initial</th>\n",
       "      <th>Footnote</th>\n",
       "      <th>ListOrder</th>\n",
       "      <th>Email</th>\n",
       "      <th>Institution1</th>\n",
       "      <th>Address1</th>\n",
       "      <th>Institution2</th>\n",
       "      <th>Address2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Adams</td>\n",
       "      <td>C.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>corey.adams@anl.gov</td>\n",
       "      <td>Argonne National Laboratory</td>\n",
       "      <td>Argonne, IL 60439, USA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Almaz\\'an</td>\n",
       "      <td>H.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>helena.almazanmolina@manchester.ac.uk</td>\n",
       "      <td>Department of Physics and Astronomy, Mancheste...</td>\n",
       "      <td>Manchester. M13 9PL, United Kingdom</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\\'Alvarez</td>\n",
       "      <td>V.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>vicente.alvarez@ific.uv.es</td>\n",
       "      <td>Instituto de Instrumentaci\\'on para Imagen Mol...</td>\n",
       "      <td>Valencia, E-46022, Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Aparicio</td>\n",
       "      <td>B.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>borja.aparicio@usc.es</td>\n",
       "      <td>Department of Organic Chemistry I, University ...</td>\n",
       "      <td>San Sebasti\\'an / Donostia, E-20018, Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Aranburu</td>\n",
       "      <td>A.I.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>aneiaranburu.94@gmail.com</td>\n",
       "      <td>Donostia International Physics Center, BERC Ba...</td>\n",
       "      <td>San Sebasti\\'an / Donostia, E-20018, Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Us\\'on</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ausonandres@gmail.com</td>\n",
       "      <td>Instituto de F\\'isica Corpuscular (IFIC), CSIC...</td>\n",
       "      <td>Paterna, E-46980, Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>Valle</td>\n",
       "      <td>P.R.G.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>pablo.garcia@dipc.org</td>\n",
       "      <td>Donostia International Physics Center, BERC Ba...</td>\n",
       "      <td>San Sebasti\\'an / Donostia, E-20018, Spain</td>\n",
       "      <td>Department of Applied Chemistry, Universidad d...</td>\n",
       "      <td>San Sebasti\\'an / Donostia, E-20018, Spain</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>Veloso</td>\n",
       "      <td>J.F.C.A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>joao.veloso@ua.pt</td>\n",
       "      <td>Institute of Nanostructures, Nanomodelling and...</td>\n",
       "      <td>Aveiro, 3810-193, Portugal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>Waiton</td>\n",
       "      <td>J.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>john.waiton@postgrad.manchester.ac.uk</td>\n",
       "      <td>Department of Physics and Astronomy, Mancheste...</td>\n",
       "      <td>Manchester. M13 9PL, United Kingdom</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>Yubero-Navarro</td>\n",
       "      <td>A.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>alfonso.yubero@dipc.org</td>\n",
       "      <td>Donostia International Physics Center, BERC Ba...</td>\n",
       "      <td>San Sebasti\\'an / Donostia, E-20018, Spain</td>\n",
       "      <td>Department of Physics, University of the Basqu...</td>\n",
       "      <td>Bilbao, E-48080, Spain</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>112 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          LastName      Initial Footnote  ListOrder  \\\n",
       "2                            Adams           C.      NaN        NaN   \n",
       "3                        Almaz\\'an           H.      NaN        NaN   \n",
       "4    \\'Alvarez                      V.               NaN        NaN   \n",
       "5                         Aparicio           B.      NaN        NaN   \n",
       "6                         Aranburu         A.I.      NaN        NaN   \n",
       "..                             ...          ...      ...        ...   \n",
       "109   Us\\'on                         A.              NaN        NaN   \n",
       "110                          Valle       P.R.G.      NaN        NaN   \n",
       "111   Veloso                         J.F.C.A.        NaN        NaN   \n",
       "112                         Waiton          J.       NaN        NaN   \n",
       "113                 Yubero-Navarro           A.      NaN        NaN   \n",
       "\n",
       "                                     Email  \\\n",
       "2                      corey.adams@anl.gov   \n",
       "3    helena.almazanmolina@manchester.ac.uk   \n",
       "4               vicente.alvarez@ific.uv.es   \n",
       "5                    borja.aparicio@usc.es   \n",
       "6                aneiaranburu.94@gmail.com   \n",
       "..                                     ...   \n",
       "109                  ausonandres@gmail.com   \n",
       "110                  pablo.garcia@dipc.org   \n",
       "111                      joao.veloso@ua.pt   \n",
       "112  john.waiton@postgrad.manchester.ac.uk   \n",
       "113                alfonso.yubero@dipc.org   \n",
       "\n",
       "                                          Institution1  \\\n",
       "2                         Argonne National Laboratory    \n",
       "3    Department of Physics and Astronomy, Mancheste...   \n",
       "4    Instituto de Instrumentaci\\'on para Imagen Mol...   \n",
       "5    Department of Organic Chemistry I, University ...   \n",
       "6    Donostia International Physics Center, BERC Ba...   \n",
       "..                                                 ...   \n",
       "109  Instituto de F\\'isica Corpuscular (IFIC), CSIC...   \n",
       "110  Donostia International Physics Center, BERC Ba...   \n",
       "111  Institute of Nanostructures, Nanomodelling and...   \n",
       "112  Department of Physics and Astronomy, Mancheste...   \n",
       "113  Donostia International Physics Center, BERC Ba...   \n",
       "\n",
       "                                       Address1  \\\n",
       "2                        Argonne, IL 60439, USA   \n",
       "3           Manchester. M13 9PL, United Kingdom   \n",
       "4                      Valencia, E-46022, Spain   \n",
       "5    San Sebasti\\'an / Donostia, E-20018, Spain   \n",
       "6    San Sebasti\\'an / Donostia, E-20018, Spain   \n",
       "..                                          ...   \n",
       "109                     Paterna, E-46980, Spain   \n",
       "110  San Sebasti\\'an / Donostia, E-20018, Spain   \n",
       "111                  Aveiro, 3810-193, Portugal   \n",
       "112         Manchester. M13 9PL, United Kingdom   \n",
       "113  San Sebasti\\'an / Donostia, E-20018, Spain   \n",
       "\n",
       "                                          Institution2  \\\n",
       "2                                                  NaN   \n",
       "3                                                  NaN   \n",
       "4                                                  NaN   \n",
       "5                                                  NaN   \n",
       "6                                                  NaN   \n",
       "..                                                 ...   \n",
       "109                                                NaN   \n",
       "110  Department of Applied Chemistry, Universidad d...   \n",
       "111                                                NaN   \n",
       "112                                                NaN   \n",
       "113  Department of Physics, University of the Basqu...   \n",
       "\n",
       "                                       Address2  \n",
       "2                                           NaN  \n",
       "3                                           NaN  \n",
       "4                                           NaN  \n",
       "5                                           NaN  \n",
       "6                                           NaN  \n",
       "..                                          ...  \n",
       "109                                         NaN  \n",
       "110  San Sebasti\\'an / Donostia, E-20018, Spain  \n",
       "111                                         NaN  \n",
       "112                                         NaN  \n",
       "113                      Bilbao, E-48080, Spain  \n",
       "\n",
       "[112 rows x 9 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# To add a corresponding author, use this format, indexed by excel sheet rows\n",
    "#CorrespondingAuthorIDs=[54,109]\n",
    "#CorrespondingEmails=['ben.jones@uta.edu','katherine.woodruff@uta.edu']\n",
    "CorrespondingAuthorIDs=[]\n",
    "CorrespondingEmails=[]\n",
    "\n",
    "# For institution ordering, choose: \n",
    "#    1. to order institutions by author list appearance, or \n",
    "#    2. to order them alphabetically.\n",
    "InstitutionOrderingScheme=2\n",
    "\n",
    "# Author ordering determined is by ListOrder column in excel. All 1's, followed by all the 2's, \n",
    "# followed by [...] followed by everyone else, in excel sheet order."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Lift from excel sheet which columns are institutions and addresses.\n",
    "# Anything labeled \"Institution\" is an institution column and the one to its\n",
    "# right is an address column.\n",
    "ar=[\"Institution\" in i for i in dat.columns]\n",
    "InstColumns=np.array(dat.columns)[ar]\n",
    "AddrColumns=np.array(dat.columns)[np.concatenate([[False],ar[:-1]])]\n",
    "AddrDict={InstColumns[i]:AddrColumns[i] for i in range(0,len(InstColumns))}\n",
    "for i in InstColumns:\n",
    "    dat.loc[:,i]=dat.loc[:,i].str.strip()\n",
    "    dat.loc[:,AddrDict[i]]=dat.loc[:,AddrDict[i]].str.strip()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Put the author list and list of institutions in the correct order\n",
    "OrderOfAuthors=[]\n",
    "UniqueInstitutions=[]\n",
    "Addresses=[]\n",
    "\n",
    "UniqAuthorPositions=sorted(dat[dat.ListOrder.notna()].ListOrder.unique())\n",
    "for j in UniqAuthorPositions:\n",
    "    for i in list(dat[dat.ListOrder==j].index):\n",
    "        OrderOfAuthors.append(i)\n",
    "        for InstCol in InstColumns:\n",
    "            if(dat.loc[i].notna()[InstCol] and not dat.loc[i][InstCol] in UniqueInstitutions):\n",
    "                UniqueInstitutions.append(dat.loc[i][InstCol])\n",
    "                Addresses.append(dat.loc[i][AddrDict[InstCol]])\n",
    "for i in dat.index:\n",
    "    if i not in OrderOfAuthors:\n",
    "        OrderOfAuthors.append(i)\n",
    "        for InstCol in InstColumns:\n",
    "            if(dat.loc[i].notna()[InstCol] and not dat.loc[i][InstCol] in UniqueInstitutions):\n",
    "                UniqueInstitutions.append(dat.loc[i][InstCol])\n",
    "                Addresses.append(dat.loc[i][AddrDict[InstCol]])\n",
    "                \n",
    "UniqueInstitutions=np.array(UniqueInstitutions)\n",
    "Addresses=np.array(Addresses)\n",
    "\n",
    " \n",
    "if(InstitutionOrderingScheme==2):\n",
    "    Order=np.argsort(Addresses)\n",
    "    Addresses=Addresses[Order]\n",
    "    UniqueInstitutions=UniqueInstitutions[Order]\n",
    "\n",
    "def InstitutionID(Name):\n",
    "    return str(np.where(UniqueInstitutions==Name)[0][0]+1)\n",
    "\n",
    "ordered=dat.loc[OrderOfAuthors]\n",
    "UniqueNotes=ordered[ordered.Footnote.notnull()].Footnote.unique()\n",
    "\n",
    "def NoteID(Name):\n",
    "    return str(num2alpha[np.where(UniqueNotes==Name)[0][0]+1])\n",
    "\n",
    "\n",
    "num2alpha = dict(zip(range(1, 27), string.ascii_lowercase))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to make the author list for IOP journals (JCAP, JHEP, JINST...)\n",
    "\n",
    "def MakeIOPAuthorList():\n",
    "\n",
    "    authorlist=str()\n",
    "    UsedNotes=defaultdict(int)\n",
    "    for a in OrderOfAuthors:\n",
    "        entry=dat.loc[a]\n",
    "        instids=\"\"\n",
    "        noteids=\"\"\n",
    "        notestring=\"\"\n",
    "        for InstCol in InstColumns:\n",
    "            if(entry.notna()[InstCol]):\n",
    "                instids+=InstitutionID(entry[InstCol])+\",\"\n",
    "        if(len(str(entry.Footnote))>5):\n",
    "            nid=NoteID(entry.Footnote)\n",
    "            noteids+=\",\"+nid\n",
    "            if(UsedNotes[nid]==False):\n",
    "                notestring+=\"\\\\note[\"+nid+\"]{\" + entry.Footnote + \"}\"\n",
    "            UsedNotes[nid]=UsedNotes[nid]+1\n",
    "                \n",
    "        authorlist+=(\"\\\\author[\"+instids[:-1]+noteids+\"]{\"+entry.Initial.strip()+\"~\"+entry.LastName.strip()+notestring+\",}\\n\")\n",
    "        authorlist+=(\"%\\n\")\n",
    "    authorlist+=(\"%\\n\")\n",
    "\n",
    "    authorlist+=(\"%\\n\")\n",
    "    for i in range(0,len(UniqueInstitutions)):\n",
    "        authorlist+=\"\\\\affiliation[\" + str(InstitutionID(UniqueInstitutions[i])) + ']{\\n' + UniqueInstitutions[i].replace('\\\\\\\\','\\\\\\\\\\n')+\", \"+Addresses[i]+\"}\\n\"\n",
    "        authorlist+=(\"%\\n\")\n",
    "    for email in CorrespondingEmails:\n",
    "        authorlist+=\"\\emailAdd{\"+email+\"}\\n\"\n",
    "\n",
    "    return authorlist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to make the author list for IOP journals (JCAP, JHEP, JINST...)\n",
    "\n",
    "def MakeSpringerNatureAuthorList():\n",
    "\n",
    "    authorlist=str()\n",
    "    UsedNotes=defaultdict(int)\n",
    "    for a in OrderOfAuthors:\n",
    "        entry=dat.loc[a]\n",
    "        instids=\"\"\n",
    "        noteids=\"\"\n",
    "        notestring=\"\"\n",
    "        for InstCol in InstColumns:\n",
    "            if(entry.notna()[InstCol]):\n",
    "                instids+=InstitutionID(entry[InstCol])+\",\"\n",
    "        if(len(str(entry.Footnote))>5):\n",
    "            nid=NoteID(entry.Footnote)\n",
    "            noteids+=\",\"+nid\n",
    "            if(UsedNotes[nid]==False):\n",
    "                notestring+=\"\\\\note[\"+nid+\"]{\" + entry.Footnote + \"}\"\n",
    "            UsedNotes[nid]=UsedNotes[nid]+1\n",
    "        authorlist+=(\"\\\\author[\"+instids[:-1]+noteids+\"]{\"+entry.Initial.strip()+\"~\"+entry.LastName.strip()+notestring+\",}\\n\")\n",
    "        authorlist+=(\"%\\n\")\n",
    "    authorlist+=(\"%\\n\")\n",
    "\n",
    "    authorlist+=(\"%\\n\")\n",
    "    for i in range(0,len(UniqueInstitutions)):\n",
    "        authorlist+=\"\\\\affil[\" + str(InstitutionID(UniqueInstitutions[i])) + ']{\\n' + UniqueInstitutions[i].replace('\\\\\\\\','\\\\\\\\\\n')+\", \"+Addresses[i]+\"}\\n\"\n",
    "        authorlist+=(\"%\\n\")\n",
    "\n",
    "\n",
    "    return authorlist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to make the author list for Elsevier journals (NIM...)\n",
    "\n",
    "def MakeElsevierAuthorList():\n",
    "    authorlist=str()\n",
    "    UsedNotes=defaultdict(int)\n",
    "    for a in OrderOfAuthors:\n",
    "        entry=dat.loc[a]\n",
    "        instids=\"\"\n",
    "        for InstCol in InstColumns:\n",
    "            if(entry.notna()[InstCol]):\n",
    "                instids+=InstitutionID(entry[InstCol])+\",\"\n",
    "        NotesText=\"\"\n",
    "        if(len(str(entry.Footnote))>5):\n",
    "            NotesText+=\"\\\\fnref{\"+NoteID(entry.Footnote)+\"}\"\n",
    "            nid=NoteID(entry.Footnote)\n",
    "            if(UsedNotes[nid]==0):\n",
    "                authorlist+=('\\\\fntext['+NoteID(entry.Footnote)+']{' + entry.Footnote.strip() + '}\\n')\n",
    "            UsedNotes[nid]=UsedNotes[nid]+1\n",
    "        if(a in CorrespondingAuthorIDs):\n",
    "            NotesText+=\"\\\\corref{cor}\"\n",
    "        authorlist+=(\"\\\\author[\"+instids[:-1]+\"]{\"+entry.Initial.strip()+\"~\"+entry.LastName.strip()+NotesText+\"}\\n\")\n",
    "        authorlist+=(\"%\\n\")\n",
    "    authorlist+=(\"%\\n\")\n",
    "    for i in range(0,len(UniqueInstitutions)):\n",
    "        authorlist+=\"\\\\address[\" + InstitutionID(UniqueInstitutions[i]) + ']{\\n' + UniqueInstitutions[i].replace('\\\\\\\\','\\\\\\\\\\n')+\", \"+ Addresses[i].strip()+\"}\\n\"\n",
    "        authorlist+=(\"%\\n\")\n",
    "    if(len(CorrespondingAuthorIDs)>0):\n",
    "        authorlist+=\"\\\\cortext[cor]{Corresponding Authors}\"\n",
    "    return authorlist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to make the author list for APS journals (PRD, PRL...)\n",
    "\n",
    "def MakeAPSAuthorList():\n",
    "    authorlist=str()\n",
    "    for a in OrderOfAuthors:\n",
    "        entry=dat.loc[a]\n",
    "        authorlist+=\"\\\\author{\"+entry.Initial.strip()+\"~\"+entry.LastName.strip()+\",}\\n\"\n",
    "        for InstCol in InstColumns:\n",
    "            if(entry.notna()[InstCol]):\n",
    "                authorlist+=\"\\\\affiliation{\"+entry[InstCol].replace('\\\\\\\\','\\\\\\\\\\n')+\", \"+entry[AddrDict[InstCol]]+\"}\\n\"\n",
    "        if(len(str(entry.Footnote))>5):\n",
    "            authorlist+=('\\\\thanks{' + entry.Footnote.strip() + '}\\n')\n",
    "        if(a in CorrespondingAuthorIDs):\n",
    "            authorlist+=('\\\\thanks{Corresponding Author}\\n')\n",
    "\n",
    "\n",
    "        authorlist+=(\"%\\n\")\n",
    "    return authorlist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Function to make the author list for arXiv\n",
    "\n",
    "def MakeArXivAuthorList():\n",
    "    authorlist=str(\"NEXT Collaboration: \")\n",
    "    for a in OrderOfAuthors[:-1]:\n",
    "        entry=dat.loc[a]\n",
    "        authorlist+=entry.Initial.strip()+\" \"+entry.LastName.strip()+\", \"\n",
    "    entry=dat.loc[OrderOfAuthors[-1]]\n",
    "    authorlist=authorlist[:-2]+\" and \" + entry.Initial.strip()+\" \"+entry.LastName.strip()\n",
    "    return authorlist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Function to make the author list in plain text\n",
    "\n",
    "def MakeHTMLAuthorList():\n",
    "    authorlist=\"\"\n",
    "    for i in range(0,len(UniqueInstitutions)):\n",
    "        #authorlist+=\"#\"+latex2text.latex2text(Addresses[i])+\"\\n\\n \"\n",
    "        ThisInst=dat[dat.Institution1==UniqueInstitutions[i]]\n",
    "        if(len(ThisInst)>0):\n",
    "            authorlist+=\"<b>\"+(LatexNodes2Text().latex_to_text(UniqueInstitutions[i]))+\"</b><br>\\n\"\n",
    "            for i in range(0,len(ThisInst)):\n",
    "                authorlist+=LatexNodes2Text().latex_to_text(ThisInst.iloc[i].Initial.strip())+\" \"+LatexNodes2Text().latex_to_text(ThisInst.iloc[i].LastName.strip())+\", \"\n",
    "            authorlist=authorlist[:-2]+\"<br><br>\\n  \"\n",
    "            authorlist+=\"\\n\"\n",
    "    return authorlist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Make author lists and store to .tex\n",
    "\n",
    "f=open(\"authors_elsevier.tex\",'w')\n",
    "f.write(MakeElsevierAuthorList())\n",
    "f.close()\n",
    "\n",
    "f=open(\"authors_iop.tex\",'w')\n",
    "f.write(MakeIOPAuthorList())\n",
    "f.close()\n",
    "\n",
    "f=open(\"authors_aps.tex\",'w')\n",
    "f.write(MakeAPSAuthorList())\n",
    "f.close()\n",
    "\n",
    "f=open(\"authors_springernature.tex\",'w')\n",
    "f.write(MakeSpringerNatureAuthorList())\n",
    "f.close()\n",
    "\n",
    "f=open(\"authors_arxiv.tex\",'w')\n",
    "f.write(MakeArXivAuthorList())\n",
    "f.close()\n",
    "\n",
    "\n",
    "f=open(\"authors_html.html\",'w')\n",
    "f.write(MakeHTMLAuthorList())\n",
    "f.close()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "authorlist=str()\n",
    "UsedNotes=defaultdict(int)\n",
    "for a in OrderOfAuthors:\n",
    "    entry=dat.loc[a]\n",
    "    instids=\"\"\n",
    "    for InstCol in InstColumns:\n",
    "        if(entry.notna()[InstCol]):\n",
    "            instids+=InstitutionID(entry[InstCol])+\",\"\n",
    "    NotesText=\"\"\n",
    "    if(len(str(entry.Footnote))>5):\n",
    "        NotesText+=\"\\\\fnref{\"+NoteID(entry.Footnote)+\"}\"\n",
    "        nid=NoteID(entry.Footnote)\n",
    "        if(UsedNotes[nid]==0):\n",
    "            authorlist+=('\\\\fntext['+NoteID(entry.Footnote)+']{' + entry.Footnote.strip() + '}\\n')\n",
    "        UsedNotes[nid]=UsedNotes[nid]+1\n",
    "    if(a in CorrespondingAuthorIDs):\n",
    "        NotesText+=\"\\\\corref{cor}\"\n",
    "    authorlist+=(\"\\\\author[\"+instids[:-1]+\"]{\"+entry.Initial.strip()+\"~\"+entry.LastName.strip()+NotesText+\"}\\n\")\n",
    "    authorlist+=(\"%\\n\")\n",
    "authorlist+=(\"%\\n\")\n",
    "for i in range(0,len(UniqueInstitutions)):\n",
    "    authorlist+=\"\\\\address[\" + InstitutionID(UniqueInstitutions[i]) + ']{\\n' + UniqueInstitutions[i].replace('\\\\\\\\','\\\\\\\\\\n')+\", \"+ Addresses[i].strip()+\"}\\n\"\n",
    "    authorlist+=(\"%\\n\")\n",
    "if(len(CorrespondingAuthorIDs)>0):\n",
    "    authorlist+=\"\\\\cortext[cor]{Corresponding Authors}\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "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.7.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}