{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import xml.etree.ElementTree as Xet\n",
    "from typing import Dict, Any\n",
    "import os\n",
    "import csv\n",
    "from xml.dom import minidom\n",
    "import sys\n",
    "import re\n",
    "\n",
    "xml_file_name = '/Users/federicaspinelli/Google Drive/OVI-CNR/export_aspoHGeo--22_09_20_17_35-3se38108719d30be01.xml'\n",
    "tree = Xet.parse(xml_file_name)\n",
    "root = tree.getroot()\n",
    "schede = root.findall(\"xw_doc\")\n",
    "\n",
    "eac_data = open('data_eac_geo.csv', 'w')\n",
    "csvwriter = csv.writer(eac_data)\n",
    "\n",
    "params = [\"ID ASPO\", \"PLACE NAME\"]\n",
    "\n",
    "csvwriter.writerow(params)\n",
    "\n",
    "for scheda in schede:\n",
    "    ul = []\n",
    "    identifier = scheda.find(\"eac/eacheader/eacid\")\n",
    "    placeName = scheda.find(\"eac/condesc/identity/conhead/part\")\n",
    "    ul.append(identifier.text)\n",
    "    ul.append(placeName.text)\n",
    "    csvwriter.writerow(ul)\n",
    "\n",
    "\n",
    "eac_data.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "aee8b7b246df8f9039afb4144a1f6fd8d2ca17a180786b69acc140d282b71a49"
  },
  "kernelspec": {
   "display_name": "Python 3.9.0 64-bit",
   "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"
  },
  "metadata": {
   "interpreter": {
    "hash": "31f2aee4e71d21fbe5cf8b01ff0e069b9275f58929596ceb00d14d90e3e16cd6"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}