Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_wos = pd.read_excel(\"webofscience.xls\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "dic_names = {\"Authors\": \"AF/AU\", \n",
    "            \"Addresses\": \"C1\", \n",
    "             \"Cited References\": \"CR\",\n",
    "             \"Author Keywords\": \"DE\",\n",
    "             \"Keywords Plus\": \"ID\"\n",
    "            }"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "field_tags = \"\"\"FN \t\n",
    "\n",
    "File Name\n",
    "VR \t\n",
    "\n",
    "Version Number\n",
    "PT \t\n",
    "\n",
    "Publication Type (J=Journal; B=Book; S=Series; P=Patent)\n",
    "AU \t\n",
    "\n",
    "Authors\n",
    "AF \t\n",
    "\n",
    "Author Full Name\n",
    "BA \t\n",
    "\n",
    "Book Authors\n",
    "BF \t\n",
    "\n",
    "Book Authors Full Name\n",
    "CA \t\n",
    "\n",
    "Group Authors\n",
    "GP \t\n",
    "\n",
    "Book Group Authors\n",
    "BE \t\n",
    "\n",
    "Editors\n",
    "TI \t\n",
    "\n",
    "Document Title\n",
    "SO \t\n",
    "\n",
    "Publication Name\n",
    "SE \t\n",
    "\n",
    "Book Series Title\n",
    "BS \t\n",
    "\n",
    "Book Series Subtitle\n",
    "LA \t\n",
    "\n",
    "Language\n",
    "DT \t\n",
    "\n",
    "Document Type\n",
    "CT \t\n",
    "\n",
    "Conference Title\n",
    "CY \t\n",
    "\n",
    "Conference Date\n",
    "CL \t\n",
    "\n",
    "Conference Location\n",
    "SP \t\n",
    "\n",
    "Conference Sponsors\n",
    "HO \t\n",
    "\n",
    "Conference Host\n",
    "DE \t\n",
    "\n",
    "Author Keywords\n",
    "ID \t\n",
    "\n",
    "Keywords Plus®\n",
    "AB \t\n",
    "\n",
    "Abstract\n",
    "C1 \t\n",
    "\n",
    "Author Address\n",
    "RP \t\n",
    "\n",
    "Reprint Address\n",
    "EM \t\n",
    "\n",
    "E-mail Address\n",
    "RI \t\n",
    "\n",
    "ResearcherID Number\n",
    "OI \t\n",
    "\n",
    "ORCID Identifier (Open Researcher and Contributor ID)\n",
    "FU \t\n",
    "\n",
    "Funding Agency and Grant Number\n",
    "FX \t\n",
    "\n",
    "Funding Text\n",
    "CR \t\n",
    "\n",
    "Cited References\n",
    "NR \t\n",
    "\n",
    "Cited Reference Count\n",
    "TC \t\n",
    "\n",
    "Web of Science Core Collection Times Cited Count\n",
    "Z9 \t\n",
    "\n",
    "Total Times Cited Count (Web of Science Core Collection, Arabic Citation Index, BIOSIS Citation Index, Chinese Science Citation Database, Data Citation Index, Russian Science Citation Index, SciELO Citation Index)\n",
    "U1 \t\n",
    "\n",
    "Usage Count (Last 180 Days)\n",
    "U2 \t\n",
    "\n",
    "Usage Count (Since 2013)\n",
    "PU \t\n",
    "\n",
    "Publisher\n",
    "PI \t\n",
    "\n",
    "Publisher City\n",
    "PA \t\n",
    "\n",
    "Publisher Address\n",
    "SN \t\n",
    "\n",
    "International Standard Serial Number (ISSN)\n",
    "EI \t\n",
    "\n",
    "Electronic International Standard Serial Number (eISSN)\n",
    "BN \t\n",
    "\n",
    "International Standard Book Number (ISBN)\n",
    "J9 \t\n",
    "\n",
    "29-Character Source Abbreviation\n",
    "JI \t\n",
    "\n",
    "ISO Source Abbreviation\n",
    "PD \t\n",
    "\n",
    "Publication Date\n",
    "PY \t\n",
    "\n",
    "Year Published\n",
    "VL \t\n",
    "\n",
    "Volume\n",
    "IS \t\n",
    "\n",
    "Issue\n",
    "SI \t\n",
    "\n",
    "Special Issue\n",
    "PN \t\n",
    "\n",
    "Part Number\n",
    "SU \t\n",
    "\n",
    "Supplement\n",
    "MA \t\n",
    "\n",
    "Meeting Abstract\n",
    "BP \t\n",
    "\n",
    "Beginning Page\n",
    "EP \t\n",
    "\n",
    "Ending Page\n",
    "AR \t\n",
    "\n",
    "Article Number\n",
    "DI \t\n",
    "\n",
    "Digital Object Identifier (DOI)\n",
    "D2 \t\n",
    "\n",
    "Book Digital Object Identifier (DOI)\n",
    "EA \t\n",
    "\n",
    "Early access date\n",
    "EY \t\n",
    "\n",
    "Early access year\n",
    "PG \t\n",
    "\n",
    "Page Count\n",
    "P2 \t\n",
    "\n",
    "Chapter Count (Book Citation Index)\n",
    "WC \t\n",
    "\n",
    "Web of Science Categories\n",
    "SC \t\n",
    "\n",
    "Research Areas\n",
    "GA \t\n",
    "\n",
    "Document Delivery Number\n",
    "PM \t\n",
    "\n",
    "PubMed ID\n",
    "UT \t\n",
    "\n",
    "Accession Number\n",
    "OA \t\n",
    "\n",
    "Open Access Indicator\n",
    "HP \t\n",
    "\n",
    "ESI Hot Paper. Note that this field is valued only for ESI subscribers.\n",
    "HC \t\n",
    "\n",
    "ESI Highly Cited Paper. Note that this field is valued only for ESI subscribers.\n",
    "DA \t\n",
    "\n",
    "Date this report was generated.\n",
    "ER \t\n",
    "\n",
    "End of Record\n",
    "EF \t\n",
    "\n",
    "End of File\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "i = 0\n",
    "dic_field_tags = {}\n",
    "tag = \"\"\n",
    "field = \"\"\n",
    "for l in field_tags.split(\"\\n\"):\n",
    "    if i==0:\n",
    "        tag=l.replace(\" \\t\", \"\")\n",
    "    if i==2:\n",
    "        i=-1\n",
    "        field=l\n",
    "        if field in df_wos.columns:\n",
    "            dic_field_tags[field] = tag\n",
    "    i+=1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Authors': 'AU',\n",
       " 'Book Authors': 'BA',\n",
       " 'Group Authors': 'CA',\n",
       " 'Book Group Authors': 'GP',\n",
       " 'Book Series Title': 'SE',\n",
       " 'Book Series Subtitle': 'BS',\n",
       " 'Language': 'LA',\n",
       " 'Document Type': 'DT',\n",
       " 'Conference Title': 'CT',\n",
       " 'Conference Date': 'CY',\n",
       " 'Conference Location': 'CL',\n",
       " 'Conference Host': 'HO',\n",
       " 'Author Keywords': 'DE',\n",
       " 'Abstract': 'AB',\n",
       " 'Funding Text': 'FX',\n",
       " 'Cited References': 'CR',\n",
       " 'Cited Reference Count': 'NR',\n",
       " 'Publisher': 'PU',\n",
       " 'Publisher City': 'PI',\n",
       " 'Publisher Address': 'PA',\n",
       " 'Publication Date': 'PD',\n",
       " 'Volume': 'VL',\n",
       " 'Issue': 'IS',\n",
       " 'Special Issue': 'SI',\n",
       " 'Part Number': 'PN',\n",
       " 'Supplement': 'SU',\n",
       " 'Meeting Abstract': 'MA',\n",
       " 'Article Number': 'AR',\n",
       " 'Research Areas': 'SC'}"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dic_field_tags"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_wos_rename = df_wos.rename(columns=dic_field_tags)\n",
    "df_wos_rename.to_csv('webofscience.csv', encoding='utf-8', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(412, 70)"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_wos_rename.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(908, 23)"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv(\"scopus.csv\").shape"
   ]
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}