{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import xml.etree.ElementTree as ET\n",
    "import os\n",
    "import csv\n",
    "from collections import OrderedDict\n",
    "import pandas as pd\n",
    "import re\n",
    "import os\n",
    "import io\n",
    "import tokenize\n",
    "import codecs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "confronto_data = open('data_lemmi_iperlemmi_codice', 'w')\n",
    "csvwriter = csv.writer(confronto_data)\n",
    "\n",
    "params = ['sigla', 'n_lemma', 'lemma', 'pos', 'iperlemma', 'n_iperlemma', 'commento', 'id']\n",
    "\n",
    "csvwriter.writerow(params)\n",
    "\n",
    "def getIdAspo(sigla_ovi):\n",
    "        link_file = open('/Users/federicaspinelli/TEAMOVI/Parser/DATA/OVI/CSV/SIGLA-IDASPO.csv')\n",
    "        reader = csv.DictReader(link_file)\n",
    "        for row in reader:\n",
    "                sigla_aspo = row['sigla']\n",
    "                sa = sigla_ovi\n",
    "                if (sigla_aspo == sa):\n",
    "                        return row['id']\n",
    "merge_file = open('/Users/federicaspinelli/TEAMOVI/Parser/DATA/OVI/CSV/LEMMI.csv')\n",
    "reader = csv.DictReader(merge_file)\n",
    "\n",
    "for row in reader:\n",
    "        line = []\n",
    "        sigla_ovi = row['sigla']\n",
    "        n_lemma = row['n_lemma']\n",
    "        lemma = row['lemma']\n",
    "        pos = row['pos']\n",
    "        iperlemma = row['iperlemma']\n",
    "        n_iperlemma = row['n_iperlemma']\n",
    "        commento = row['commento']\n",
    "        id = getIdAspo(sigla_ovi)\n",
    "\n",
    "        line.append(sigla_ovi)\n",
    "        line.append(n_lemma)\n",
    "        line.append(lemma)\n",
    "        line.append(pos)\n",
    "        line.append(iperlemma)\n",
    "        line.append(n_iperlemma)\n",
    "        line.append(commento)\n",
    "\n",
    "        if id is not None:\n",
    "            line.append(id)\n",
    "        else:\n",
    "            line.append(\"\")\n",
    "\n",
    "        csvwriter.writerow(line)\n",
    "\n",
    "confronto_data.close()"
   ]
  }
 ],
 "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.9.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}