Data Analysis of Top 100 NIRF Ranked Universities using Kz Score.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "fdf8e696",
   "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>Authors</th>\n",
       "      <th>Author full names</th>\n",
       "      <th>Author(s) ID</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Source title</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Issue</th>\n",
       "      <th>Art. No.</th>\n",
       "      <th>Page start</th>\n",
       "      <th>...</th>\n",
       "      <th>Link</th>\n",
       "      <th>Affiliations</th>\n",
       "      <th>Authors with affiliations</th>\n",
       "      <th>Document Type</th>\n",
       "      <th>Publication Stage</th>\n",
       "      <th>Open Access</th>\n",
       "      <th>Source</th>\n",
       "      <th>EID</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>h</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ma G.; Ma C.; Yang P.; Zhang B.; Zhang R.; Yan...</td>\n",
       "      <td>Ma, Guangju (58601176700); Ma, Chen (572045740...</td>\n",
       "      <td>58601176700; 57204574070; 57890592500; 5721190...</td>\n",
       "      <td>Distributed activation energy model of pyrolys...</td>\n",
       "      <td>2024</td>\n",
       "      <td>Fuel</td>\n",
       "      <td>357</td>\n",
       "      <td>NaN</td>\n",
       "      <td>129836</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>Shaanxi Key Laboratory of Energy Chemical Proc...</td>\n",
       "      <td>Ma G., Shaanxi Key Laboratory of Energy Chemic...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85171992802</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Li J.; Zhang H.; Liu W.; Yang X.; Zhu L.; Wu G...</td>\n",
       "      <td>Li, Jinxin (57553188400); Zhang, Hao (55706844...</td>\n",
       "      <td>57553188400; 55706844600; 55751951400; 5719164...</td>\n",
       "      <td>Methylglyoxal scavenging capacity of fiber-bou...</td>\n",
       "      <td>2024</td>\n",
       "      <td>Food Chemistry</td>\n",
       "      <td>434</td>\n",
       "      <td>NaN</td>\n",
       "      <td>137409</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>National Engineering Research Center for Funct...</td>\n",
       "      <td>Li J., National Engineering Research Center fo...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85170645783</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Li B.; Wu W.; Lin J.-M.; Wang T.; Hu Conceptua...</td>\n",
       "      <td>Li, Benyou (57247098400); Wu, Wenli (555879131...</td>\n",
       "      <td>57247098400; 55587913100; 36078549300; 5864864...</td>\n",
       "      <td>Water in liquid crystal emulsion-based sensing...</td>\n",
       "      <td>2024</td>\n",
       "      <td>Food Chemistry</td>\n",
       "      <td>436</td>\n",
       "      <td>NaN</td>\n",
       "      <td>137732</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>Key Laboratory of Colloid and Interface Chemis...</td>\n",
       "      <td>Li B., Key Laboratory of Colloid and Interface...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85174180964</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Wang D.; Xu D.; Wang B.; Yan C.; Wang S.; Xu X...</td>\n",
       "      <td>Wang, Dongliang (57907647800); Xu, Daokui (295...</td>\n",
       "      <td>57907647800; 29567623400; 55562259400; 5719198...</td>\n",
       "      <td>Effect of cross rolling on the microstructure ...</td>\n",
       "      <td>2024</td>\n",
       "      <td>Journal of Materials Science and Technology</td>\n",
       "      <td>176</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>132</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>Key Laboratory of Nuclear Materials and Safety...</td>\n",
       "      <td>Wang D., Key Laboratory of Nuclear Materials a...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85171745123</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alva S.; Utami R.S.; Andrian M.; Widinugroho A...</td>\n",
       "      <td>Alva, Sagir (6603670880); Utami, Rika S. (5719...</td>\n",
       "      <td>6603670880; 57190061003; 58635014000; 57212173...</td>\n",
       "      <td>New Acrylate Co-Polymer Membrane Synthetized b...</td>\n",
       "      <td>2024</td>\n",
       "      <td>Portugaliae Electrochimica Acta</td>\n",
       "      <td>42</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>337</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>Mechanical Engineering Department, University ...</td>\n",
       "      <td>Alva S., Mechanical Engineering Department, Un...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85173428598</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</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",
       "      <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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19995</th>\n",
       "      <td>Guo J.; Abdinejad M.; Farzi A.; Salehi M.; Sei...</td>\n",
       "      <td>Guo, Jiaxun (57216652359); Abdinejad, Maryam (...</td>\n",
       "      <td>57216652359; 57160473900; 57773598900; 5722064...</td>\n",
       "      <td>Effective electro-oxidation of hydroxymethylfu...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Energy Advances</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>877</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>Department of Chemical Engineering, McGill Uni...</td>\n",
       "      <td>Guo J., Department of Chemical Engineering, Mc...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>All Open Access; Gold Open Access</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85159373585</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19996</th>\n",
       "      <td>Biroun M.H.; Haworth L.; Abdolnezhad H.; Khosr...</td>\n",
       "      <td>Biroun, Mehdi H. (57211060508); Haworth, Luke ...</td>\n",
       "      <td>57211060508; 57222204301; 57207567080; 5818622...</td>\n",
       "      <td>Impact Dynamics of Non-Newtonian Droplets on S...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Langmuir</td>\n",
       "      <td>39</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5793</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>Department of Chemical Engineering, University...</td>\n",
       "      <td>Biroun M.H., Department of Chemical Engineerin...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>All Open Access; Green Open Access; Hybrid Gol...</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85152711053</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19997</th>\n",
       "      <td>Geng Z.; Bo T.; Zhou W.; Tan X.; Ye J.; Yu T.</td>\n",
       "      <td>Geng, Zikang (57274988500); Bo, Tingting (5721...</td>\n",
       "      <td>57274988500; 57212529969; 56567078600; 1264775...</td>\n",
       "      <td>Deciphering the Superior Electronic Transmissi...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Small</td>\n",
       "      <td>19</td>\n",
       "      <td>17</td>\n",
       "      <td>2206673</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>School of Chemical Engineering and Technology,...</td>\n",
       "      <td>Geng Z., School of Chemical Engineering and Te...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85147265518</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19998</th>\n",
       "      <td>Li L.; Ma C.; Lu C.; Yu W.; Shi N.; Jin J.; Zh...</td>\n",
       "      <td>Li, Ling (55631185000); Ma, Chaofeng (58250087...</td>\n",
       "      <td>55631185000; 58250087100; 8682389400; 25229127...</td>\n",
       "      <td>Progress on the synthesis of 1, 1, 2-trifluoro...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Huagong Jinzhan/Chemical Industry and Engineer...</td>\n",
       "      <td>42</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1822</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>State Key Laboratory of Fluorinated Greenhouse...</td>\n",
       "      <td>Li L., State Key Laboratory of Fluorinated Gre...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85159272715</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19999</th>\n",
       "      <td>Lomeli-Martin A.; Ernst O.D.; Cardenas-Benitez...</td>\n",
       "      <td>Lomeli-Martin, Adrian (57223136917); Ernst, Ol...</td>\n",
       "      <td>57223136917; 58056123900; 57193169275; 5721056...</td>\n",
       "      <td>Characterization of the Nonlinear Electrophore...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Analytical Chemistry</td>\n",
       "      <td>95</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6740</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.scopus.com/inward/record.uri?eid=2...</td>\n",
       "      <td>Microscale Bioseparations Laboratory and Biome...</td>\n",
       "      <td>Lomeli-Martin A., Microscale Bioseparations La...</td>\n",
       "      <td>Article</td>\n",
       "      <td>Final</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Scopus</td>\n",
       "      <td>2-s2.0-85152661374</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20000 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 Authors  \\\n",
       "0      Ma G.; Ma C.; Yang P.; Zhang B.; Zhang R.; Yan...   \n",
       "1      Li J.; Zhang H.; Liu W.; Yang X.; Zhu L.; Wu G...   \n",
       "2      Li B.; Wu W.; Lin J.-M.; Wang T.; Hu Conceptua...   \n",
       "3      Wang D.; Xu D.; Wang B.; Yan C.; Wang S.; Xu X...   \n",
       "4      Alva S.; Utami R.S.; Andrian M.; Widinugroho A...   \n",
       "...                                                  ...   \n",
       "19995  Guo J.; Abdinejad M.; Farzi A.; Salehi M.; Sei...   \n",
       "19996  Biroun M.H.; Haworth L.; Abdolnezhad H.; Khosr...   \n",
       "19997      Geng Z.; Bo T.; Zhou W.; Tan X.; Ye J.; Yu T.   \n",
       "19998  Li L.; Ma C.; Lu C.; Yu W.; Shi N.; Jin J.; Zh...   \n",
       "19999  Lomeli-Martin A.; Ernst O.D.; Cardenas-Benitez...   \n",
       "\n",
       "                                       Author full names  \\\n",
       "0      Ma, Guangju (58601176700); Ma, Chen (572045740...   \n",
       "1      Li, Jinxin (57553188400); Zhang, Hao (55706844...   \n",
       "2      Li, Benyou (57247098400); Wu, Wenli (555879131...   \n",
       "3      Wang, Dongliang (57907647800); Xu, Daokui (295...   \n",
       "4      Alva, Sagir (6603670880); Utami, Rika S. (5719...   \n",
       "...                                                  ...   \n",
       "19995  Guo, Jiaxun (57216652359); Abdinejad, Maryam (...   \n",
       "19996  Biroun, Mehdi H. (57211060508); Haworth, Luke ...   \n",
       "19997  Geng, Zikang (57274988500); Bo, Tingting (5721...   \n",
       "19998  Li, Ling (55631185000); Ma, Chaofeng (58250087...   \n",
       "19999  Lomeli-Martin, Adrian (57223136917); Ernst, Ol...   \n",
       "\n",
       "                                            Author(s) ID  \\\n",
       "0      58601176700; 57204574070; 57890592500; 5721190...   \n",
       "1      57553188400; 55706844600; 55751951400; 5719164...   \n",
       "2      57247098400; 55587913100; 36078549300; 5864864...   \n",
       "3      57907647800; 29567623400; 55562259400; 5719198...   \n",
       "4      6603670880; 57190061003; 58635014000; 57212173...   \n",
       "...                                                  ...   \n",
       "19995  57216652359; 57160473900; 57773598900; 5722064...   \n",
       "19996  57211060508; 57222204301; 57207567080; 5818622...   \n",
       "19997  57274988500; 57212529969; 56567078600; 1264775...   \n",
       "19998  55631185000; 58250087100; 8682389400; 25229127...   \n",
       "19999  57223136917; 58056123900; 57193169275; 5721056...   \n",
       "\n",
       "                                                   Title  Year  \\\n",
       "0      Distributed activation energy model of pyrolys...  2024   \n",
       "1      Methylglyoxal scavenging capacity of fiber-bou...  2024   \n",
       "2      Water in liquid crystal emulsion-based sensing...  2024   \n",
       "3      Effect of cross rolling on the microstructure ...  2024   \n",
       "4      New Acrylate Co-Polymer Membrane Synthetized b...  2024   \n",
       "...                                                  ...   ...   \n",
       "19995  Effective electro-oxidation of hydroxymethylfu...  2023   \n",
       "19996  Impact Dynamics of Non-Newtonian Droplets on S...  2023   \n",
       "19997  Deciphering the Superior Electronic Transmissi...  2023   \n",
       "19998  Progress on the synthesis of 1, 1, 2-trifluoro...  2023   \n",
       "19999  Characterization of the Nonlinear Electrophore...  2023   \n",
       "\n",
       "                                            Source title Volume Issue  \\\n",
       "0                                                   Fuel    357   NaN   \n",
       "1                                         Food Chemistry    434   NaN   \n",
       "2                                         Food Chemistry    436   NaN   \n",
       "3            Journal of Materials Science and Technology    176   NaN   \n",
       "4                        Portugaliae Electrochimica Acta     42     5   \n",
       "...                                                  ...    ...   ...   \n",
       "19995                                    Energy Advances      2     6   \n",
       "19996                                           Langmuir     39    16   \n",
       "19997                                              Small     19    17   \n",
       "19998  Huagong Jinzhan/Chemical Industry and Engineer...     42     4   \n",
       "19999                               Analytical Chemistry     95    16   \n",
       "\n",
       "      Art. No. Page start  ...  \\\n",
       "0       129836        NaN  ...   \n",
       "1       137409        NaN  ...   \n",
       "2       137732        NaN  ...   \n",
       "3          NaN        132  ...   \n",
       "4          NaN        337  ...   \n",
       "...        ...        ...  ...   \n",
       "19995      NaN        877  ...   \n",
       "19996      NaN       5793  ...   \n",
       "19997  2206673        NaN  ...   \n",
       "19998      NaN       1822  ...   \n",
       "19999      NaN       6740  ...   \n",
       "\n",
       "                                                    Link  \\\n",
       "0      https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "1      https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "2      https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "3      https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "4      https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "...                                                  ...   \n",
       "19995  https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "19996  https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "19997  https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "19998  https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "19999  https://www.scopus.com/inward/record.uri?eid=2...   \n",
       "\n",
       "                                            Affiliations  \\\n",
       "0      Shaanxi Key Laboratory of Energy Chemical Proc...   \n",
       "1      National Engineering Research Center for Funct...   \n",
       "2      Key Laboratory of Colloid and Interface Chemis...   \n",
       "3      Key Laboratory of Nuclear Materials and Safety...   \n",
       "4      Mechanical Engineering Department, University ...   \n",
       "...                                                  ...   \n",
       "19995  Department of Chemical Engineering, McGill Uni...   \n",
       "19996  Department of Chemical Engineering, University...   \n",
       "19997  School of Chemical Engineering and Technology,...   \n",
       "19998  State Key Laboratory of Fluorinated Greenhouse...   \n",
       "19999  Microscale Bioseparations Laboratory and Biome...   \n",
       "\n",
       "                               Authors with affiliations Document Type  \\\n",
       "0      Ma G., Shaanxi Key Laboratory of Energy Chemic...       Article   \n",
       "1      Li J., National Engineering Research Center fo...       Article   \n",
       "2      Li B., Key Laboratory of Colloid and Interface...       Article   \n",
       "3      Wang D., Key Laboratory of Nuclear Materials a...       Article   \n",
       "4      Alva S., Mechanical Engineering Department, Un...       Article   \n",
       "...                                                  ...           ...   \n",
       "19995  Guo J., Department of Chemical Engineering, Mc...       Article   \n",
       "19996  Biroun M.H., Department of Chemical Engineerin...       Article   \n",
       "19997  Geng Z., School of Chemical Engineering and Te...       Article   \n",
       "19998  Li L., State Key Laboratory of Fluorinated Gre...       Article   \n",
       "19999  Lomeli-Martin A., Microscale Bioseparations La...       Article   \n",
       "\n",
       "      Publication Stage                                        Open Access  \\\n",
       "0                 Final                                                NaN   \n",
       "1                 Final                                                NaN   \n",
       "2                 Final                                                NaN   \n",
       "3                 Final                                                NaN   \n",
       "4                 Final                                                NaN   \n",
       "...                 ...                                                ...   \n",
       "19995             Final                  All Open Access; Gold Open Access   \n",
       "19996             Final  All Open Access; Green Open Access; Hybrid Gol...   \n",
       "19997             Final                                                NaN   \n",
       "19998             Final                                                NaN   \n",
       "19999             Final                                                NaN   \n",
       "\n",
       "       Source                 EID Unnamed: 22   h  \n",
       "0      Scopus  2-s2.0-85171992802         NaN  29  \n",
       "1      Scopus  2-s2.0-85170645783         NaN  29  \n",
       "2      Scopus  2-s2.0-85174180964         NaN  29  \n",
       "3      Scopus  2-s2.0-85171745123         NaN  29  \n",
       "4      Scopus  2-s2.0-85173428598         NaN  29  \n",
       "...       ...                 ...         ...  ..  \n",
       "19995  Scopus  2-s2.0-85159373585         NaN  29  \n",
       "19996  Scopus  2-s2.0-85152711053         NaN  29  \n",
       "19997  Scopus  2-s2.0-85147265518         NaN  29  \n",
       "19998  Scopus  2-s2.0-85159272715         NaN  29  \n",
       "19999  Scopus  2-s2.0-85152661374         NaN  29  \n",
       "\n",
       "[20000 rows x 24 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "df = pd.read_csv(\"C:/Users/91897/Desktop/PRJ 1/Institute of Chemical Technology.csv\")\n",
    "df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "375eb9be",
   "metadata": {},
   "outputs": [],
   "source": [
    "FIN=df.drop(['Authors','Author(s) ID','Volume','Issue','Art. No.','Page start','Page end','Page count','DOI','Link','Document Type','Publication Stage','Open Access','Source','EID'],axis=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "6841869d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                       Author full names  \\\n",
      "401    Jaffur, Bibi Nausheen (58627176500); Kumar, Go...   \n",
      "402    Azelee, Nur Izyan Wan (57209683067); Dahiya, D...   \n",
      "410    Qiu, Shouji (58563922000); Du, Juan (564338839...   \n",
      "412    Zaer, Mohammad (58106454100); Moeinzadeh, Alaa...   \n",
      "414    Mondal, Susmita (57639112700); Agrawal, Shivan...   \n",
      "...                                                  ...   \n",
      "19995  Guo, Jiaxun (57216652359); Abdinejad, Maryam (...   \n",
      "19996  Biroun, Mehdi H. (57211060508); Haworth, Luke ...   \n",
      "19997  Geng, Zikang (57274988500); Bo, Tingting (5721...   \n",
      "19998  Li, Ling (55631185000); Ma, Chaofeng (58250087...   \n",
      "19999  Lomeli-Martin, Adrian (57223136917); Ernst, Ol...   \n",
      "\n",
      "                                                   Title  Year  \\\n",
      "401    Current advances and emerging trends in sustai...  2023   \n",
      "402    Sustainable valorization approaches on crustac...  2023   \n",
      "410    Electrospun compliant heparinized elastic vasc...  2023   \n",
      "412    Doxorubicin-loaded Niosomes functionalized wit...  2023   \n",
      "414    Structural analysis of a water insoluble polys...  2023   \n",
      "...                                                  ...   ...   \n",
      "19995  Effective electro-oxidation of hydroxymethylfu...  2023   \n",
      "19996  Impact Dynamics of Non-Newtonian Droplets on S...  2023   \n",
      "19997  Deciphering the Superior Electronic Transmissi...  2023   \n",
      "19998  Progress on the synthesis of 1, 1, 2-trifluoro...  2023   \n",
      "19999  Characterization of the Nonlinear Electrophore...  2023   \n",
      "\n",
      "                                            Source title  C  \\\n",
      "401    International Journal of Biological Macromolec...  1   \n",
      "402    International Journal of Biological Macromolec...  0   \n",
      "410    International Journal of Biological Macromolec...  0   \n",
      "412    International Journal of Biological Macromolec...  0   \n",
      "414    International Journal of Biological Macromolec...  0   \n",
      "...                                                  ... ..   \n",
      "19995                                    Energy Advances  0   \n",
      "19996                                           Langmuir  0   \n",
      "19997                                              Small  0   \n",
      "19998  Huagong Jinzhan/Chemical Industry and Engineer...  0   \n",
      "19999                               Analytical Chemistry  1   \n",
      "\n",
      "                                            Affiliations  \\\n",
      "401    Department of Chemical and Environmental Engin...   \n",
      "402    Faculty of Chemical and Energy Engineering, Un...   \n",
      "410    Department of Cardiovascular Surgery, Zhongsha...   \n",
      "412    Biomedical Engineering Department, Faculty of ...   \n",
      "414    Department of Biotechnology, Indian Institute ...   \n",
      "...                                                  ...   \n",
      "19995  Department of Chemical Engineering, McGill Uni...   \n",
      "19996  Department of Chemical Engineering, University...   \n",
      "19997  School of Chemical Engineering and Technology,...   \n",
      "19998  State Key Laboratory of Fluorinated Greenhouse...   \n",
      "19999  Microscale Bioseparations Laboratory and Biome...   \n",
      "\n",
      "                               Authors with affiliations  Unnamed: 22   h  \n",
      "401    Jaffur B.N., Department of Chemical and Enviro...          NaN  29  \n",
      "402    Azelee N.I.W., Faculty of Chemical and Energy ...          NaN  29  \n",
      "410    Qiu S., Department of Cardiovascular Surgery, ...          NaN  29  \n",
      "412    Zaer M., Biomedical Engineering Department, Fa...          NaN  29  \n",
      "414    Mondal S., Department of Biotechnology, Indian...          NaN  29  \n",
      "...                                                  ...          ...  ..  \n",
      "19995  Guo J., Department of Chemical Engineering, Mc...          NaN  29  \n",
      "19996  Biroun M.H., Department of Chemical Engineerin...          NaN  29  \n",
      "19997  Geng Z., School of Chemical Engineering and Te...          NaN  29  \n",
      "19998  Li L., State Key Laboratory of Fluorinated Gre...          NaN  29  \n",
      "19999  Lomeli-Martin A., Microscale Bioseparations La...          NaN  29  \n",
      "\n",
      "[19542 rows x 9 columns]\n"
     ]
    }
   ],
   "source": [
    "FIN.rename(columns = {'Cited by':'C'}, inplace = True)\n",
    "FIN['C'].replace(np.nan,0,inplace=True)\n",
    "FIN.drop(FIN[FIN['Year'] == 2024].index, inplace=True)\n",
    "print(FIN)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "6ffba477",
   "metadata": {},
   "outputs": [],
   "source": [
    "def impact(C, h, Year):\n",
    "    k = 0.001  # Initial value of k\n",
    "    while C >= (h + 1) ** k:\n",
    "        k += 0.00001  # Increment 'k' by 0.01 (you can adjust this increment)\n",
    "    return k\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "0b12025d",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Apply the impact function to the DataFrame\n",
    "FIN['k'] = FIN.apply(lambda row: impact(row['C'], row['h'], row['Year']), axis=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "ed3709db",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                       Author full names  \\\n",
      "401    Jaffur, Bibi Nausheen (58627176500); Kumar, Go...   \n",
      "402    Azelee, Nur Izyan Wan (57209683067); Dahiya, D...   \n",
      "410    Qiu, Shouji (58563922000); Du, Juan (564338839...   \n",
      "412    Zaer, Mohammad (58106454100); Moeinzadeh, Alaa...   \n",
      "414    Mondal, Susmita (57639112700); Agrawal, Shivan...   \n",
      "...                                                  ...   \n",
      "19995  Guo, Jiaxun (57216652359); Abdinejad, Maryam (...   \n",
      "19996  Biroun, Mehdi H. (57211060508); Haworth, Luke ...   \n",
      "19997  Geng, Zikang (57274988500); Bo, Tingting (5721...   \n",
      "19998  Li, Ling (55631185000); Ma, Chaofeng (58250087...   \n",
      "19999  Lomeli-Martin, Adrian (57223136917); Ernst, Ol...   \n",
      "\n",
      "                                                   Title  Year  \\\n",
      "401    Current advances and emerging trends in sustai...  2023   \n",
      "402    Sustainable valorization approaches on crustac...  2023   \n",
      "410    Electrospun compliant heparinized elastic vasc...  2023   \n",
      "412    Doxorubicin-loaded Niosomes functionalized wit...  2023   \n",
      "414    Structural analysis of a water insoluble polys...  2023   \n",
      "...                                                  ...   ...   \n",
      "19995  Effective electro-oxidation of hydroxymethylfu...  2023   \n",
      "19996  Impact Dynamics of Non-Newtonian Droplets on S...  2023   \n",
      "19997  Deciphering the Superior Electronic Transmissi...  2023   \n",
      "19998  Progress on the synthesis of 1, 1, 2-trifluoro...  2023   \n",
      "19999  Characterization of the Nonlinear Electrophore...  2023   \n",
      "\n",
      "                                            Source title  C  \\\n",
      "401    International Journal of Biological Macromolec...  1   \n",
      "402    International Journal of Biological Macromolec...  0   \n",
      "410    International Journal of Biological Macromolec...  0   \n",
      "412    International Journal of Biological Macromolec...  0   \n",
      "414    International Journal of Biological Macromolec...  0   \n",
      "...                                                  ... ..   \n",
      "19995                                    Energy Advances  0   \n",
      "19996                                           Langmuir  0   \n",
      "19997                                              Small  0   \n",
      "19998  Huagong Jinzhan/Chemical Industry and Engineer...  0   \n",
      "19999                               Analytical Chemistry  1   \n",
      "\n",
      "                                            Affiliations  \\\n",
      "401    Department of Chemical and Environmental Engin...   \n",
      "402    Faculty of Chemical and Energy Engineering, Un...   \n",
      "410    Department of Cardiovascular Surgery, Zhongsha...   \n",
      "412    Biomedical Engineering Department, Faculty of ...   \n",
      "414    Department of Biotechnology, Indian Institute ...   \n",
      "...                                                  ...   \n",
      "19995  Department of Chemical Engineering, McGill Uni...   \n",
      "19996  Department of Chemical Engineering, University...   \n",
      "19997  School of Chemical Engineering and Technology,...   \n",
      "19998  State Key Laboratory of Fluorinated Greenhouse...   \n",
      "19999  Microscale Bioseparations Laboratory and Biome...   \n",
      "\n",
      "                               Authors with affiliations  Unnamed: 22   h  \\\n",
      "401    Jaffur B.N., Department of Chemical and Enviro...          NaN  29   \n",
      "402    Azelee N.I.W., Faculty of Chemical and Energy ...          NaN  29   \n",
      "410    Qiu S., Department of Cardiovascular Surgery, ...          NaN  29   \n",
      "412    Zaer M., Biomedical Engineering Department, Fa...          NaN  29   \n",
      "414    Mondal S., Department of Biotechnology, Indian...          NaN  29   \n",
      "...                                                  ...          ...  ..   \n",
      "19995  Guo J., Department of Chemical Engineering, Mc...          NaN  29   \n",
      "19996  Biroun M.H., Department of Chemical Engineerin...          NaN  29   \n",
      "19997  Geng Z., School of Chemical Engineering and Te...          NaN  29   \n",
      "19998  Li L., State Key Laboratory of Fluorinated Gre...          NaN  29   \n",
      "19999  Lomeli-Martin A., Microscale Bioseparations La...          NaN  29   \n",
      "\n",
      "           k  date  kprime  \n",
      "401    0.001     0     inf  \n",
      "402    0.001     0     inf  \n",
      "410    0.001     0     inf  \n",
      "412    0.001     0     inf  \n",
      "414    0.001     0     inf  \n",
      "...      ...   ...     ...  \n",
      "19995  0.001     0     inf  \n",
      "19996  0.001     0     inf  \n",
      "19997  0.001     0     inf  \n",
      "19998  0.001     0     inf  \n",
      "19999  0.001     0     inf  \n",
      "\n",
      "[19542 rows x 12 columns]\n"
     ]
    }
   ],
   "source": [
    "# Calculate 'date' and 'kprime'\n",
    "FIN['date'] = 2023 - FIN['Year']\n",
    "FIN['kprime'] = FIN['k'] / FIN['date']\n",
    "# Print the resulting DataFrame\n",
    "print(FIN)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "cca574f6",
   "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>Author full names</th>\n",
       "      <th>Title</th>\n",
       "      <th>Year</th>\n",
       "      <th>Source title</th>\n",
       "      <th>C</th>\n",
       "      <th>Affiliations</th>\n",
       "      <th>Authors with affiliations</th>\n",
       "      <th>Unnamed: 22</th>\n",
       "      <th>h</th>\n",
       "      <th>k</th>\n",
       "      <th>date</th>\n",
       "      <th>kprime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>Jaffur, Bibi Nausheen (58627176500); Kumar, Go...</td>\n",
       "      <td>Current advances and emerging trends in sustai...</td>\n",
       "      <td>2023</td>\n",
       "      <td>International Journal of Biological Macromolec...</td>\n",
       "      <td>1</td>\n",
       "      <td>Department of Chemical and Environmental Engin...</td>\n",
       "      <td>Jaffur B.N., Department of Chemical and Enviro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>Azelee, Nur Izyan Wan (57209683067); Dahiya, D...</td>\n",
       "      <td>Sustainable valorization approaches on crustac...</td>\n",
       "      <td>2023</td>\n",
       "      <td>International Journal of Biological Macromolec...</td>\n",
       "      <td>0</td>\n",
       "      <td>Faculty of Chemical and Energy Engineering, Un...</td>\n",
       "      <td>Azelee N.I.W., Faculty of Chemical and Energy ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>Qiu, Shouji (58563922000); Du, Juan (564338839...</td>\n",
       "      <td>Electrospun compliant heparinized elastic vasc...</td>\n",
       "      <td>2023</td>\n",
       "      <td>International Journal of Biological Macromolec...</td>\n",
       "      <td>0</td>\n",
       "      <td>Department of Cardiovascular Surgery, Zhongsha...</td>\n",
       "      <td>Qiu S., Department of Cardiovascular Surgery, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>Zaer, Mohammad (58106454100); Moeinzadeh, Alaa...</td>\n",
       "      <td>Doxorubicin-loaded Niosomes functionalized wit...</td>\n",
       "      <td>2023</td>\n",
       "      <td>International Journal of Biological Macromolec...</td>\n",
       "      <td>0</td>\n",
       "      <td>Biomedical Engineering Department, Faculty of ...</td>\n",
       "      <td>Zaer M., Biomedical Engineering Department, Fa...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>Mondal, Susmita (57639112700); Agrawal, Shivan...</td>\n",
       "      <td>Structural analysis of a water insoluble polys...</td>\n",
       "      <td>2023</td>\n",
       "      <td>International Journal of Biological Macromolec...</td>\n",
       "      <td>0</td>\n",
       "      <td>Department of Biotechnology, Indian Institute ...</td>\n",
       "      <td>Mondal S., Department of Biotechnology, Indian...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19995</th>\n",
       "      <td>Guo, Jiaxun (57216652359); Abdinejad, Maryam (...</td>\n",
       "      <td>Effective electro-oxidation of hydroxymethylfu...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Energy Advances</td>\n",
       "      <td>0</td>\n",
       "      <td>Department of Chemical Engineering, McGill Uni...</td>\n",
       "      <td>Guo J., Department of Chemical Engineering, Mc...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19996</th>\n",
       "      <td>Biroun, Mehdi H. (57211060508); Haworth, Luke ...</td>\n",
       "      <td>Impact Dynamics of Non-Newtonian Droplets on S...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Langmuir</td>\n",
       "      <td>0</td>\n",
       "      <td>Department of Chemical Engineering, University...</td>\n",
       "      <td>Biroun M.H., Department of Chemical Engineerin...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19997</th>\n",
       "      <td>Geng, Zikang (57274988500); Bo, Tingting (5721...</td>\n",
       "      <td>Deciphering the Superior Electronic Transmissi...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Small</td>\n",
       "      <td>0</td>\n",
       "      <td>School of Chemical Engineering and Technology,...</td>\n",
       "      <td>Geng Z., School of Chemical Engineering and Te...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19998</th>\n",
       "      <td>Li, Ling (55631185000); Ma, Chaofeng (58250087...</td>\n",
       "      <td>Progress on the synthesis of 1, 1, 2-trifluoro...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Huagong Jinzhan/Chemical Industry and Engineer...</td>\n",
       "      <td>0</td>\n",
       "      <td>State Key Laboratory of Fluorinated Greenhouse...</td>\n",
       "      <td>Li L., State Key Laboratory of Fluorinated Gre...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19999</th>\n",
       "      <td>Lomeli-Martin, Adrian (57223136917); Ernst, Ol...</td>\n",
       "      <td>Characterization of the Nonlinear Electrophore...</td>\n",
       "      <td>2023</td>\n",
       "      <td>Analytical Chemistry</td>\n",
       "      <td>1</td>\n",
       "      <td>Microscale Bioseparations Laboratory and Biome...</td>\n",
       "      <td>Lomeli-Martin A., Microscale Bioseparations La...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>29</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>19542 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Author full names  \\\n",
       "401    Jaffur, Bibi Nausheen (58627176500); Kumar, Go...   \n",
       "402    Azelee, Nur Izyan Wan (57209683067); Dahiya, D...   \n",
       "410    Qiu, Shouji (58563922000); Du, Juan (564338839...   \n",
       "412    Zaer, Mohammad (58106454100); Moeinzadeh, Alaa...   \n",
       "414    Mondal, Susmita (57639112700); Agrawal, Shivan...   \n",
       "...                                                  ...   \n",
       "19995  Guo, Jiaxun (57216652359); Abdinejad, Maryam (...   \n",
       "19996  Biroun, Mehdi H. (57211060508); Haworth, Luke ...   \n",
       "19997  Geng, Zikang (57274988500); Bo, Tingting (5721...   \n",
       "19998  Li, Ling (55631185000); Ma, Chaofeng (58250087...   \n",
       "19999  Lomeli-Martin, Adrian (57223136917); Ernst, Ol...   \n",
       "\n",
       "                                                   Title  Year  \\\n",
       "401    Current advances and emerging trends in sustai...  2023   \n",
       "402    Sustainable valorization approaches on crustac...  2023   \n",
       "410    Electrospun compliant heparinized elastic vasc...  2023   \n",
       "412    Doxorubicin-loaded Niosomes functionalized wit...  2023   \n",
       "414    Structural analysis of a water insoluble polys...  2023   \n",
       "...                                                  ...   ...   \n",
       "19995  Effective electro-oxidation of hydroxymethylfu...  2023   \n",
       "19996  Impact Dynamics of Non-Newtonian Droplets on S...  2023   \n",
       "19997  Deciphering the Superior Electronic Transmissi...  2023   \n",
       "19998  Progress on the synthesis of 1, 1, 2-trifluoro...  2023   \n",
       "19999  Characterization of the Nonlinear Electrophore...  2023   \n",
       "\n",
       "                                            Source title  C  \\\n",
       "401    International Journal of Biological Macromolec...  1   \n",
       "402    International Journal of Biological Macromolec...  0   \n",
       "410    International Journal of Biological Macromolec...  0   \n",
       "412    International Journal of Biological Macromolec...  0   \n",
       "414    International Journal of Biological Macromolec...  0   \n",
       "...                                                  ... ..   \n",
       "19995                                    Energy Advances  0   \n",
       "19996                                           Langmuir  0   \n",
       "19997                                              Small  0   \n",
       "19998  Huagong Jinzhan/Chemical Industry and Engineer...  0   \n",
       "19999                               Analytical Chemistry  1   \n",
       "\n",
       "                                            Affiliations  \\\n",
       "401    Department of Chemical and Environmental Engin...   \n",
       "402    Faculty of Chemical and Energy Engineering, Un...   \n",
       "410    Department of Cardiovascular Surgery, Zhongsha...   \n",
       "412    Biomedical Engineering Department, Faculty of ...   \n",
       "414    Department of Biotechnology, Indian Institute ...   \n",
       "...                                                  ...   \n",
       "19995  Department of Chemical Engineering, McGill Uni...   \n",
       "19996  Department of Chemical Engineering, University...   \n",
       "19997  School of Chemical Engineering and Technology,...   \n",
       "19998  State Key Laboratory of Fluorinated Greenhouse...   \n",
       "19999  Microscale Bioseparations Laboratory and Biome...   \n",
       "\n",
       "                               Authors with affiliations  Unnamed: 22   h  \\\n",
       "401    Jaffur B.N., Department of Chemical and Enviro...          NaN  29   \n",
       "402    Azelee N.I.W., Faculty of Chemical and Energy ...          NaN  29   \n",
       "410    Qiu S., Department of Cardiovascular Surgery, ...          NaN  29   \n",
       "412    Zaer M., Biomedical Engineering Department, Fa...          NaN  29   \n",
       "414    Mondal S., Department of Biotechnology, Indian...          NaN  29   \n",
       "...                                                  ...          ...  ..   \n",
       "19995  Guo J., Department of Chemical Engineering, Mc...          NaN  29   \n",
       "19996  Biroun M.H., Department of Chemical Engineerin...          NaN  29   \n",
       "19997  Geng Z., School of Chemical Engineering and Te...          NaN  29   \n",
       "19998  Li L., State Key Laboratory of Fluorinated Gre...          NaN  29   \n",
       "19999  Lomeli-Martin A., Microscale Bioseparations La...          NaN  29   \n",
       "\n",
       "           k  date  kprime  \n",
       "401    0.001     0     0.0  \n",
       "402    0.001     0     0.0  \n",
       "410    0.001     0     0.0  \n",
       "412    0.001     0     0.0  \n",
       "414    0.001     0     0.0  \n",
       "...      ...   ...     ...  \n",
       "19995  0.001     0     0.0  \n",
       "19996  0.001     0     0.0  \n",
       "19997  0.001     0     0.0  \n",
       "19998  0.001     0     0.0  \n",
       "19999  0.001     0     0.0  \n",
       "\n",
       "[19542 rows x 12 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "FIN['kprime'].replace(np.inf, 0, inplace=True)\n",
    "FIN\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "3e3e7244",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.0"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "FIN['kprime'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fee3e6a0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}