d03a-stdlib-serializacja-csv-rozwiazania.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Python Biblioteka Standardowa - serializacja CSV - zadania"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "from csv import DictReader, DictWriter, QUOTE_ALL"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Serialization CSV DictReader\n",
    "\n",
    "1. Użyj danych z sekcji \"Input\" (patrz poniżej)\n",
    "1. Pobierz plik https://python.astrotech.io/_static/iris.csv i zapisz go jako ``iris.csv`` w katalogu ze skryptami\n",
    "1. Korzystając z ``csv.DictReader`` wczytaj zawartość pliku\n",
    "1. Podaj jawnie ``encoding``, ``delimiter`` oraz ``quotechar``\n",
    "1. Podmień nazwy kolumn na ``FIELDNAMES``\n",
    "1. Pomiń pierwszą linię (nagłówek)\n",
    "1. Wypisz wiersze z danymi\n",
    "1. Porównaj wyniki z sekcją \"Output\" (patrz poniżej)\n",
    "\n",
    "Output:\n",
    "```python\n",
    "{'Sepal Length': '5.4', 'Sepal Width': '3.9', 'Petal Length': '1.3', 'Petal Width': '0.4', 'Species': 'setosa'}\n",
    "{'Sepal Length': '5.9', 'Sepal Width': '3.0', 'Petal Length': '5.1', 'Petal Width': '1.8', 'Species': 'virginica'}\n",
    "{'Sepal Length': '6.0', 'Sepal Width': '3.4', 'Petal Length': '4.5', 'Petal Width': '1.6', 'Species': 'versicolor'}\n",
    "...\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "FIELDNAMES = [\n",
    "    'Sepal Length',\n",
    "    'Sepal Width',\n",
    "    'Petal Length',\n",
    "    'Petal Width',\n",
    "    'Species',\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Sepal Length': '5.4',\n",
       "  'Sepal Width': '3.9',\n",
       "  'Petal Length': '1.3',\n",
       "  'Petal Width': '0.4',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.9',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.1',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.0',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '4.5',\n",
       "  'Petal Width': '1.6',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '7.3',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '6.3',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.6',\n",
       "  'Sepal Width': '2.5',\n",
       "  'Petal Length': '3.9',\n",
       "  'Petal Width': '1.1',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.4',\n",
       "  'Sepal Width': '3.9',\n",
       "  'Petal Length': '1.3',\n",
       "  'Petal Width': '0.4',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.5',\n",
       "  'Sepal Width': '2.6',\n",
       "  'Petal Length': '4.4',\n",
       "  'Petal Width': '1.2',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.7',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '4.2',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.9',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.1',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.7',\n",
       "  'Sepal Width': '2.5',\n",
       "  'Petal Length': '5.8',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.5',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.2',\n",
       "  'Petal Width': '2.0',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '3.3',\n",
       "  'Petal Length': '1.7',\n",
       "  'Petal Width': '0.5',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '4.6',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.3',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '7.4',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '6.1',\n",
       "  'Petal Width': '1.9',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '7.7',\n",
       "  'Sepal Width': '3.8',\n",
       "  'Petal Length': '6.7',\n",
       "  'Petal Width': '2.2',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.6',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.4',\n",
       "  'Petal Width': '1.4',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '7.2',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '6.0',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.8',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '5.1',\n",
       "  'Petal Width': '1.9',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.5',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.5',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.1',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '4.7',\n",
       "  'Petal Width': '1.4',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.2',\n",
       "  'Sepal Width': '3.5',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.9',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '4.8',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.1',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.6',\n",
       "  'Petal Width': '1.4',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.2',\n",
       "  'Sepal Width': '4.1',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.1',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '3.8',\n",
       "  'Petal Length': '1.9',\n",
       "  'Petal Width': '0.4',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '4.8',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.6',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.0',\n",
       "  'Sepal Width': '2.2',\n",
       "  'Petal Length': '5.0',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.4',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '5.3',\n",
       "  'Petal Width': '2.3',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '4.9',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '5.6',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.0',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.8',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '4.3',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '1.1',\n",
       "  'Petal Width': '0.1',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.9',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '4.9',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '2.3',\n",
       "  'Petal Length': '4.4',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.4',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '5.5',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.5',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '5.1',\n",
       "  'Petal Width': '2.0',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '3.3',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.5',\n",
       "  'Sepal Width': '2.4',\n",
       "  'Petal Length': '3.7',\n",
       "  'Petal Width': '1.0',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.1',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.9',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.4',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '4.5',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.5',\n",
       "  'Sepal Width': '2.4',\n",
       "  'Petal Length': '3.8',\n",
       "  'Petal Width': '1.1',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.2',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '4.3',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.2',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '4.8',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.7',\n",
       "  'Sepal Width': '2.5',\n",
       "  'Petal Length': '5.0',\n",
       "  'Petal Width': '2.0',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.4',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.4',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.6',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.1',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.0',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '5.1',\n",
       "  'Petal Width': '1.6',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.2',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '3.9',\n",
       "  'Petal Width': '1.4',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.7',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '4.7',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.5',\n",
       "  'Sepal Width': '2.5',\n",
       "  'Petal Length': '4.0',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.7',\n",
       "  'Sepal Width': '3.3',\n",
       "  'Petal Length': '5.7',\n",
       "  'Petal Width': '2.5',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '3.7',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.4',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '7.7',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '6.1',\n",
       "  'Petal Width': '2.3',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.6',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '4.6',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.8',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.9',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '4.8',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.1',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '4.4',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '1.3',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '3.8',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.3',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.4',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.5',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.6',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.6',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.5',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.5',\n",
       "  'Sepal Width': '3.5',\n",
       "  'Petal Length': '1.3',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.5',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '4.6',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.6',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '4.9',\n",
       "  'Petal Width': '2.0',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '3.5',\n",
       "  'Petal Length': '1.6',\n",
       "  'Petal Width': '0.6',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.7',\n",
       "  'Sepal Width': '4.4',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.4',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.4',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.7',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '4.8',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '1.6',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '3.6',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '3.5',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.3',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.7',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '4.1',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.9',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.4',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '5.3',\n",
       "  'Petal Width': '1.9',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '3.5',\n",
       "  'Petal Length': '1.3',\n",
       "  'Petal Width': '0.3',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '4.6',\n",
       "  'Sepal Width': '3.6',\n",
       "  'Petal Length': '1.0',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.7',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '4.5',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '2.5',\n",
       "  'Petal Length': '4.9',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '7.7',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '6.7',\n",
       "  'Petal Width': '2.0',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '7.2',\n",
       "  'Sepal Width': '3.6',\n",
       "  'Petal Length': '6.1',\n",
       "  'Petal Width': '2.5',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.4',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '4.3',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.9',\n",
       "  'Sepal Width': '3.6',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.1',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '7.2',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.8',\n",
       "  'Petal Width': '1.6',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '7.0',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '4.7',\n",
       "  'Petal Width': '1.4',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '3.5',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.8',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '3.9',\n",
       "  'Petal Width': '1.2',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.7',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '1.6',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.9',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '5.4',\n",
       "  'Petal Width': '2.1',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.7',\n",
       "  'Sepal Width': '2.6',\n",
       "  'Petal Length': '3.5',\n",
       "  'Petal Width': '1.0',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.7',\n",
       "  'Sepal Width': '3.8',\n",
       "  'Petal Length': '1.7',\n",
       "  'Petal Width': '0.3',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.8',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '5.1',\n",
       "  'Petal Width': '1.9',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '4.4',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.4',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '5.6',\n",
       "  'Petal Width': '2.2',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.1',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '4.7',\n",
       "  'Petal Width': '1.2',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.4',\n",
       "  'Sepal Width': '3.7',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.4',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '5.6',\n",
       "  'Petal Width': '2.1',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.7',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.0',\n",
       "  'Petal Width': '1.7',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.9',\n",
       "  'Sepal Width': '2.4',\n",
       "  'Petal Length': '3.3',\n",
       "  'Petal Width': '1.0',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.5',\n",
       "  'Sepal Width': '2.3',\n",
       "  'Petal Length': '1.3',\n",
       "  'Petal Width': '0.3',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '1.6',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '2.5',\n",
       "  'Petal Length': '3.0',\n",
       "  'Petal Width': '1.1',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '5.6',\n",
       "  'Petal Width': '2.4',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.5',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.8',\n",
       "  'Petal Width': '2.2',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.7',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.2',\n",
       "  'Petal Width': '2.3',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.2',\n",
       "  'Sepal Width': '2.2',\n",
       "  'Petal Length': '4.5',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.3',\n",
       "  'Sepal Width': '3.7',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.1',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '4.0',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '2.3',\n",
       "  'Petal Length': '3.3',\n",
       "  'Petal Width': '1.0',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.8',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '4.8',\n",
       "  'Petal Width': '1.4',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '7.1',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.9',\n",
       "  'Petal Width': '2.1',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '4.9',\n",
       "  'Petal Width': '1.8',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '3.8',\n",
       "  'Petal Length': '1.6',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '7.6',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '6.6',\n",
       "  'Petal Width': '2.1',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.9',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '5.1',\n",
       "  'Petal Width': '2.3',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.6',\n",
       "  'Petal Width': '0.4',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.7',\n",
       "  'Sepal Width': '3.3',\n",
       "  'Petal Length': '5.7',\n",
       "  'Petal Width': '2.1',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.8',\n",
       "  'Sepal Width': '2.6',\n",
       "  'Petal Length': '4.0',\n",
       "  'Petal Width': '1.2',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '7.7',\n",
       "  'Sepal Width': '2.6',\n",
       "  'Petal Length': '6.9',\n",
       "  'Petal Width': '2.3',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.8',\n",
       "  'Sepal Width': '4.0',\n",
       "  'Petal Length': '1.2',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.2',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.7',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.2',\n",
       "  'Petal Width': '1.2',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.6',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '7.9',\n",
       "  'Sepal Width': '3.8',\n",
       "  'Petal Length': '6.4',\n",
       "  'Petal Width': '2.0',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '4.8',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.3',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.7',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '5.6',\n",
       "  'Petal Width': '2.4',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.5',\n",
       "  'Sepal Width': '2.3',\n",
       "  'Petal Length': '4.0',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.2',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '5.4',\n",
       "  'Petal Width': '2.3',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '2.5',\n",
       "  'Petal Length': '5.0',\n",
       "  'Petal Width': '1.9',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '3.3',\n",
       "  'Petal Length': '6.0',\n",
       "  'Petal Width': '2.5',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.7',\n",
       "  'Sepal Width': '3.1',\n",
       "  'Petal Length': '4.4',\n",
       "  'Petal Width': '1.4',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '4.4',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '1.3',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.1',\n",
       "  'Sepal Width': '2.6',\n",
       "  'Petal Length': '5.6',\n",
       "  'Petal Width': '1.4',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.8',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '4.1',\n",
       "  'Petal Width': '1.0',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.4',\n",
       "  'Sepal Width': '3.9',\n",
       "  'Petal Length': '1.7',\n",
       "  'Petal Width': '0.4',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '1.2',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '5.8',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '5.1',\n",
       "  'Petal Width': '2.4',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '4.7',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '1.3',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.9',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '5.7',\n",
       "  'Petal Width': '2.3',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '2.0',\n",
       "  'Petal Length': '3.5',\n",
       "  'Petal Width': '1.0',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.6',\n",
       "  'Sepal Width': '2.7',\n",
       "  'Petal Length': '4.2',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.0',\n",
       "  'Sepal Width': '2.2',\n",
       "  'Petal Length': '4.0',\n",
       "  'Petal Width': '1.0',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.1',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.0',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '4.5',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.6',\n",
       "  'Sepal Width': '2.9',\n",
       "  'Petal Length': '3.6',\n",
       "  'Petal Width': '1.3',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '6.8',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '5.5',\n",
       "  'Petal Width': '2.1',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '5.5',\n",
       "  'Sepal Width': '4.2',\n",
       "  'Petal Length': '1.4',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '3.3',\n",
       "  'Petal Length': '4.7',\n",
       "  'Petal Width': '1.6',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.9',\n",
       "  'Sepal Width': '3.0',\n",
       "  'Petal Length': '4.2',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'versicolor'},\n",
       " {'Sepal Length': '5.0',\n",
       "  'Sepal Width': '3.4',\n",
       "  'Petal Length': '1.5',\n",
       "  'Petal Width': '0.2',\n",
       "  'Species': 'setosa'},\n",
       " {'Sepal Length': '4.9',\n",
       "  'Sepal Width': '2.5',\n",
       "  'Petal Length': '4.5',\n",
       "  'Petal Width': '1.7',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.3',\n",
       "  'Sepal Width': '2.8',\n",
       "  'Petal Length': '5.1',\n",
       "  'Petal Width': '1.5',\n",
       "  'Species': 'virginica'},\n",
       " {'Sepal Length': '6.8',\n",
       "  'Sepal Width': '3.2',\n",
       "  'Petal Length': '5.9',\n",
       "  'Petal Width': '2.3',\n",
       "  'Species': 'virginica'}]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "FILE = r'iris.csv'\n",
    "result = []\n",
    "\n",
    "with open(FILE, encoding='utf-8') as fp:\n",
    "    file = DictReader(fp, fieldnames=FIELDNAMES, delimiter=',', quotechar='\"')\n",
    "    _ = next(file)\n",
    "    for line in file:\n",
    "        result.append(line)\n",
    "        \n",
    "result"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Serialization CSV DictWriter\n",
    "\n",
    "1. Użyj danych z sekcji \"Input\" (patrz poniżej)\n",
    "1. Za pomocą ``csv.DictWriter()`` zapisz ``DATA`` do pliku\n",
    "1. Spróbuj otworzyć plik w arkuszu kalkulacyjnym tj. Microsoft Excel / Libre Office / Numbers itp\n",
    "1. Spróbuj otworzyć plik w IDE i prostym edytorze tekstu tj. Notepad, vim lub gedit\n",
    "1. Porównaj wyniki z sekcją \"Output\" (patrz poniżej)\n",
    "1. Wymagania niefunkcjonalne:\n",
    "\n",
    "    * Wszystkie pola muszą być otoczone znakiem cudzysłowu ``\"``\n",
    "    * Użyj ``,`` do oddzielenia kolumn\n",
    "    * Użyj kodowania ``utf-8``\n",
    "    * Użyj zakończenia linii Unix ``\\n``\n",
    "\n",
    "Output:\n",
    "```text\n",
    "\"firstname\",\"lastname\"\n",
    "\"Jan\",\"Twardowski\"\n",
    "\"José\",\"Jiménez\"\n",
    "\"Mark\",\"Watney\"\n",
    "\"Ivan\",\"Ivanovic\"\n",
    "\"Melissa\",\"Lewis\"\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "DATA = [\n",
    "    {'firstname': 'Jan',  'lastname': 'Twardowski'},\n",
    "    {'firstname': 'José', 'lastname': 'Jiménez'},\n",
    "    {'firstname': 'Mark', 'lastname': 'Watney'},\n",
    "    {'firstname': 'Ivan', 'lastname': 'Ivanovic'},\n",
    "    {'firstname': 'Melissa', 'lastname': 'Lewis'},\n",
    "]\n",
    "\n",
    "FILE = '_temporary.csv'\n",
    "\n",
    "with open(FILE, mode='w', encoding='utf-8') as file:\n",
    "    writer = DictWriter(file, fieldnames=DATA[0].keys(), quoting=QUOTE_ALL, quotechar='\"', delimiter=',', lineterminator='\\n')\n",
    "    writer.writeheader()\n",
    "    writer.writerows(DATA)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\"firstname\",\"lastname\"\r\n",
      "\"Jan\",\"Twardowski\"\r\n",
      "\"José\",\"Jiménez\"\r\n",
      "\"Mark\",\"Watney\"\r\n",
      "\"Ivan\",\"Ivanovic\"\r\n",
      "\"Melissa\",\"Lewis\"\r\n"
     ]
    }
   ],
   "source": [
    "!cat $FILE\n",
    "# !type $FILE  ## dla Windows"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Serialization CSV List of Tuples\n",
    "\n",
    "1. Użyj danych z sekcji \"Input\" (patrz poniżej)\n",
    "1. Za pomocą ``csv.DictWriter()`` zapisz ``DATA`` do pliku\n",
    "1. Porównaj wyniki z sekcją \"Output\" (patrz poniżej)\n",
    "1. Wymagania niefunkcjonalne:\n",
    "\n",
    "    * Nie używaj cudzysłowów w wynikowym pliku CSV\n",
    "    * Użyj ``,`` do oddzielenia kolumn\n",
    "    * Użyj kodowania ``utf-8``\n",
    "    * Użyj zakończenia linii Unix ``\\n``\n",
    "\n",
    "Output:\n",
    "```text\n",
    "Sepal length,Sepal width,Petal length,Petal width,Species\n",
    "5.8,2.7,5.1,1.9,virginica\n",
    "5.1,3.5,1.4,0.2,setosa\n",
    "5.7,2.8,4.1,1.3,versicolor\n",
    "6.3,2.9,5.6,1.8,virginica\n",
    "6.4,3.2,4.5,1.5,versicolor\n",
    "4.7,3.2,1.3,0.2,setosa\n",
    "7.0,3.2,4.7,1.4,versicolor\n",
    "7.6,3.0,6.6,2.1,virginica\n",
    "4.9,3.0,1.4,0.2,setosa\n",
    "4.9,2.5,4.5,1.7,virginica\n",
    "7.1,3.0,5.9,2.1,virginica\n",
    "4.6,3.4,1.4,0.3,setosa\n",
    "5.4,3.9,1.7,0.4,setosa\n",
    "5.7,2.8,4.5,1.3,versicolor\n",
    "5.0,3.6,1.4,0.3,setosa\n",
    "5.5,2.3,4.0,1.3,versicolor\n",
    "6.5,3.0,5.8,2.2,virginica\n",
    "6.5,2.8,4.6,1.5,versicolor\n",
    "6.3,3.3,6.0,2.5,virginica\n",
    "6.9,3.1,4.9,1.5,versicolor\n",
    "4.6,3.1,1.5,0.2,setosa\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "DATA = [\n",
    "    ('Sepal length', 'Sepal width', 'Petal length', 'Petal width', 'Species'),\n",
    "    (5.8, 2.7, 5.1, 1.9, 'virginica'),\n",
    "    (5.1, 3.5, 1.4, 0.2, 'setosa'),\n",
    "    (5.7, 2.8, 4.1, 1.3, 'versicolor'),\n",
    "    (6.3, 2.9, 5.6, 1.8, 'virginica'),\n",
    "    (6.4, 3.2, 4.5, 1.5, 'versicolor'),\n",
    "    (4.7, 3.2, 1.3, 0.2, 'setosa'),\n",
    "    (7.0, 3.2, 4.7, 1.4, 'versicolor'),\n",
    "    (7.6, 3.0, 6.6, 2.1, 'virginica'),\n",
    "    (4.9, 3.0, 1.4, 0.2, 'setosa'),\n",
    "    (4.9, 2.5, 4.5, 1.7, 'virginica'),\n",
    "    (7.1, 3.0, 5.9, 2.1, 'virginica'),\n",
    "    (4.6, 3.4, 1.4, 0.3, 'setosa'),\n",
    "    (5.4, 3.9, 1.7, 0.4, 'setosa'),\n",
    "    (5.7, 2.8, 4.5, 1.3, 'versicolor'),\n",
    "    (5.0, 3.6, 1.4, 0.3, 'setosa'),\n",
    "    (5.5, 2.3, 4.0, 1.3, 'versicolor'),\n",
    "    (6.5, 3.0, 5.8, 2.2, 'virginica'),\n",
    "    (6.5, 2.8, 4.6, 1.5, 'versicolor'),\n",
    "    (6.3, 3.3, 6.0, 2.5, 'virginica'),\n",
    "    (6.9, 3.1, 4.9, 1.5, 'versicolor'),\n",
    "    (4.6, 3.1, 1.5, 0.2, 'setosa'),\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "header, *data = DATA\n",
    "result = []\n",
    "\n",
    "for row in data:\n",
    "    pairs = zip(header, row)\n",
    "    result.append(dict(pairs))\n",
    "    \n",
    "\n",
    "\n",
    "FILE = '_temporary.csv'\n",
    "\n",
    "with open(FILE, mode='w', encoding='utf-8') as file:\n",
    "    writer = DictWriter(file, fieldnames=result[0].keys(), quoting=QUOTE_ALL, quotechar='\"', delimiter=',', lineterminator='\\n')\n",
    "    writer.writeheader()\n",
    "    writer.writerows(result)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\"Sepal length\",\"Sepal width\",\"Petal length\",\"Petal width\",\"Species\"\r\n",
      "\"5.8\",\"2.7\",\"5.1\",\"1.9\",\"virginica\"\r\n",
      "\"5.1\",\"3.5\",\"1.4\",\"0.2\",\"setosa\"\r\n",
      "\"5.7\",\"2.8\",\"4.1\",\"1.3\",\"versicolor\"\r\n",
      "\"6.3\",\"2.9\",\"5.6\",\"1.8\",\"virginica\"\r\n",
      "\"6.4\",\"3.2\",\"4.5\",\"1.5\",\"versicolor\"\r\n",
      "\"4.7\",\"3.2\",\"1.3\",\"0.2\",\"setosa\"\r\n",
      "\"7.0\",\"3.2\",\"4.7\",\"1.4\",\"versicolor\"\r\n",
      "\"7.6\",\"3.0\",\"6.6\",\"2.1\",\"virginica\"\r\n",
      "\"4.9\",\"3.0\",\"1.4\",\"0.2\",\"setosa\"\r\n",
      "\"4.9\",\"2.5\",\"4.5\",\"1.7\",\"virginica\"\r\n",
      "\"7.1\",\"3.0\",\"5.9\",\"2.1\",\"virginica\"\r\n",
      "\"4.6\",\"3.4\",\"1.4\",\"0.3\",\"setosa\"\r\n",
      "\"5.4\",\"3.9\",\"1.7\",\"0.4\",\"setosa\"\r\n",
      "\"5.7\",\"2.8\",\"4.5\",\"1.3\",\"versicolor\"\r\n",
      "\"5.0\",\"3.6\",\"1.4\",\"0.3\",\"setosa\"\r\n",
      "\"5.5\",\"2.3\",\"4.0\",\"1.3\",\"versicolor\"\r\n",
      "\"6.5\",\"3.0\",\"5.8\",\"2.2\",\"virginica\"\r\n",
      "\"6.5\",\"2.8\",\"4.6\",\"1.5\",\"versicolor\"\r\n",
      "\"6.3\",\"3.3\",\"6.0\",\"2.5\",\"virginica\"\r\n",
      "\"6.9\",\"3.1\",\"4.9\",\"1.5\",\"versicolor\"\r\n",
      "\"4.6\",\"3.1\",\"1.5\",\"0.2\",\"setosa\"\r\n"
     ]
    }
   ],
   "source": [
    "!cat $FILE"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Serialization CSV Schemaless\n",
    "\n",
    "1. Użyj danych z sekcji \"Input\" (patrz poniżej)\n",
    "1. Za pomocą ``csv.DictWriter()`` zapisz do pliku CSV dane o zmiennej strukturze\n",
    "1. ``fieldnames`` musi być generowane automatycznie na podstawie ``DATA``\n",
    "1. ``fieldnames`` ma być zawsze w takiej samej kolejności\n",
    "1. Porównaj wyniki z sekcją \"Output\" (patrz poniżej)\n",
    "1. Wymagania niefunkcjonalne:\n",
    "\n",
    "    * Wszystkie pola muszą być otoczone znakiem cudzysłowu ``\"``\n",
    "    * Użyj ``,`` do oddzielenia kolumn\n",
    "    * Użyj kodowania ``utf-8``\n",
    "    * Użyj zakończenia linii Unix ``\\n``\n",
    "\n",
    "Output:\n",
    "```csv\n",
    "\"Petal length\", \"Petal width\", \"Sepal length\", \"Sepal width\", \"Species\"\n",
    "\"\", \"\", \"5.1\", \"3.5\", \"setosa\"\n",
    "\"4.1\", \"1.3\", \"\", \"\", \"versicolor\"\n",
    "\"\", \"1.8\", \"6.3\", \"\", \"virginica\"\n",
    "\"\", \"0.2\", \"5.0\", \"\", \"setosa\"\n",
    "\"4.1\", \"\", \"\", \"2.8\", \"versicolor\"\n",
    "\"\", \"1.8\", \"\", \"2.9\", \"virginica\"\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "DATA = [\n",
    "    {'Sepal length': 5.1, 'Sepal width': 3.5, 'Species': 'setosa'},\n",
    "    {'Petal length': 4.1, 'Petal width': 1.3, 'Species': 'versicolor'},\n",
    "    {'Sepal length': 6.3, 'Petal width': 1.8, 'Species': 'virginica'},\n",
    "    {'Sepal length': 5.0, 'Petal width': 0.2, 'Species': 'setosa'},\n",
    "    {'Sepal width': 2.8, 'Petal length': 4.1, 'Species': 'versicolor'},\n",
    "    {'Sepal width': 2.9, 'Petal width': 1.8, 'Species': 'virginica'},\n",
    "]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.47 µs ± 330 ns per loop (mean ± std. dev. of 100 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit -r 100 -n 1000\n",
    "\n",
    "fieldnames = []\n",
    "\n",
    "for row in DATA:\n",
    "    fieldnames.extend(list(row.keys()))\n",
    "    \n",
    "fieldnames = set(fieldnames)\n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.4 µs ± 260 ns per loop (mean ± std. dev. of 100 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit -r 100 -n 1000\n",
    "\n",
    "fieldnames = []\n",
    "\n",
    "for row in DATA:\n",
    "    for key in row.keys():\n",
    "        fieldnames.append(key)\n",
    "    \n",
    "fieldnames = set(fieldnames)\n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.02 µs ± 208 ns per loop (mean ± std. dev. of 100 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit -r 100 -n 1000\n",
    "\n",
    "fieldnames = []\n",
    "\n",
    "for row in DATA:\n",
    "    for key in row.keys():\n",
    "        if key not in fieldnames:\n",
    "            fieldnames.append(key)\n",
    "    \n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.99 µs ± 230 ns per loop (mean ± std. dev. of 100 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit -r 100 -n 1000\n",
    "\n",
    "fieldnames = {key\n",
    "              for row in DATA\n",
    "              for key in row.keys()}\n",
    "    \n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "3.02 µs ± 254 ns per loop (mean ± std. dev. of 100 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit -r 100 -n 1000\n",
    "\n",
    "fieldnames = set()\n",
    "fieldnames.update(key\n",
    "              for row in DATA\n",
    "              for key in row.keys())\n",
    "    \n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2.83 µs ± 191 ns per loop (mean ± std. dev. of 100 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit -r 100 -n 1000\n",
    "\n",
    "fieldnames = set()\n",
    "\n",
    "for row in DATA:\n",
    "    for key in row.keys():\n",
    "        fieldnames.add(key)\n",
    "    \n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2.1 µs ± 181 ns per loop (mean ± std. dev. of 100 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit -r 100 -n 1000\n",
    "\n",
    "fieldnames = set()\n",
    "\n",
    "for row in DATA:\n",
    "    fieldnames.update(row.keys())\n",
    "    \n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.21 µs ± 119 ns per loop (mean ± std. dev. of 100 runs, 1000 loops each)\n"
     ]
    }
   ],
   "source": [
    "%%timeit -r 100 -n 1000\n",
    "\n",
    "fieldnames = set()\n",
    "\n",
    "for row in DATA:\n",
    "    fieldnames.update(row)\n",
    "    \n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "FILE = '_temporary.csv'\n",
    "\n",
    "with open(FILE, mode='w', encoding='utf-8') as file:\n",
    "    writer = DictWriter(file, fieldnames=fieldnames, quoting=QUOTE_ALL, quotechar='\"', delimiter=',', lineterminator='\\n')\n",
    "    writer.writeheader()\n",
    "    writer.writerows(result)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Serialization CSV Objects\n",
    "\n",
    "1. Użyj danych z sekcji \"Input\" (patrz poniżej)\n",
    "1. Za pomocą ``csv.DictWriter()`` zapisz dane do pliku CSV\n",
    "1. Wymagania niefunkcjonalne:\n",
    "\n",
    "    * Wszystkie pola muszą być otoczone znakiem cudzysłowu ``\"``\n",
    "    * Użyj ``,`` do oddzielenia kolumn\n",
    "    * Użyj kodowania ``utf-8``\n",
    "    * Użyj zakończenia linii Unix ``\\n``"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "class Iris:\n",
    "    def __init__(self, sepal_length, sepal_width,\n",
    "                 petal_length, petal_width, species):\n",
    "\n",
    "        self.sepal_length = sepal_length\n",
    "        self.sepal_width = sepal_width\n",
    "        self.petal_length = petal_length\n",
    "        self.petal_width = petal_width\n",
    "        self.species = species\n",
    "\n",
    "\n",
    "DATA = [\n",
    "    Iris(5.1, 3.5, 1.4, 0.2, 'setosa'),\n",
    "    Iris(5.8, 2.7, 5.1, 1.9, 'virginica'),\n",
    "    Iris(5.1, 3.5, 1.4, 0.2, 'setosa'),\n",
    "    Iris(5.7, 2.8, 4.1, 1.3, 'versicolor'),\n",
    "    Iris(6.3, 2.9, 5.6, 1.8, 'virginica'),\n",
    "    Iris(6.4, 3.2, 4.5, 1.5, 'versicolor'),\n",
    "]\n",
    "\n",
    "\n",
    "with open(FILE, mode='w', encoding='utf-8') as file:\n",
    "    writer = DictWriter(file,\n",
    "                        fieldnames=list(DATA[0].__dict__.keys()),\n",
    "                        quoting=QUOTE_ALL,\n",
    "                        quotechar='\"',\n",
    "                        delimiter=',',\n",
    "                        lineterminator='\\n')\n",
    "    \n",
    "    writer.writeheader()\n",
    "\n",
    "    for iris in DATA:\n",
    "        writer.writerow(iris.__dict__)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\"sepal_length\",\"sepal_width\",\"petal_length\",\"petal_width\",\"species\"\r\n",
      "\"5.1\",\"3.5\",\"1.4\",\"0.2\",\"setosa\"\r\n",
      "\"5.8\",\"2.7\",\"5.1\",\"1.9\",\"virginica\"\r\n",
      "\"5.1\",\"3.5\",\"1.4\",\"0.2\",\"setosa\"\r\n",
      "\"5.7\",\"2.8\",\"4.1\",\"1.3\",\"versicolor\"\r\n",
      "\"6.3\",\"2.9\",\"5.6\",\"1.8\",\"virginica\"\r\n",
      "\"6.4\",\"3.2\",\"4.5\",\"1.5\",\"versicolor\"\r\n"
     ]
    }
   ],
   "source": [
    "!cat $FILE"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Serialization CSV Relations\n",
    "\n",
    "1. Użyj danych z sekcji \"Input\" (patrz poniżej)\n",
    "1. Za pomocą ``csv.DictWriter()`` zapisz kontakty z książki adresowej w pliku\n",
    "1. Jak zapisać w CSV dane relacyjne (kontakt ma wiele adresów)?\n",
    "1. Odtwórz strukturę obiektów na podstawie danych odczytanych z pliku\n",
    "1. Wymagania niefunkcjonalne:\n",
    "\n",
    "    * Wszystkie pola muszą być otoczone znakiem cudzysłowu ``\"``\n",
    "    * Użyj ``;`` do oddzielenia kolumn\n",
    "    * Użyj kodowania ``utf-8``\n",
    "    * Użyj zakończenia linii Unix ``\\n``"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [],
   "source": [
    "class Contact:\n",
    "    def __init__(self, firstname, lastname, addresses=()):\n",
    "        self.firstname = firstname\n",
    "        self.lastname = lastname\n",
    "        self.addresses = addresses\n",
    "\n",
    "\n",
    "class Address:\n",
    "    def __init__(self, location, city):\n",
    "        self.location = location\n",
    "        self.city = city\n",
    "\n",
    "\n",
    "DATA = [\n",
    "    Contact(firstname='Jan', lastname='Twardowski', addresses=(\n",
    "        Address(location='Johnson Space Center', city='Houston, TX'),\n",
    "        Address(location='Kennedy Space Center', city='Merritt Island, FL'),\n",
    "        Address(location='Jet Propulsion Laboratory', city='Pasadena, CA'),\n",
    "    )),\n",
    "    Contact(firstname='Mark', lastname='Watney'),\n",
    "    Contact(firstname='Melissa', lastname='Lewis', addresses=()),\n",
    "]\n",
    "\n",
    "    \n",
    "with open(FILE, mode='w', encoding='utf-8') as file:\n",
    "    writer = DictWriter(file,\n",
    "                        fieldnames=list(DATA[0].__dict__.keys()),\n",
    "                        quoting=QUOTE_ALL,\n",
    "                        quotechar='\"',\n",
    "                        delimiter=',',\n",
    "                        lineterminator='\\n')\n",
    "    \n",
    "    writer.writeheader()\n",
    "\n",
    "    for contact in DATA:\n",
    "        contact.addresses = [', '.join(addr.__dict__.values()) for addr in contact.addresses]\n",
    "        contact.addresses = ';'.join(contact.addresses)\n",
    "        writer.writerow(contact.__dict__)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\"firstname\",\"lastname\",\"addresses\"\r\n",
      "\"Jan\",\"Twardowski\",\"Johnson Space Center, Houston, TX;Kennedy Space Center, Merritt Island, FL;Jet Propulsion Laboratory, Pasadena, CA\"\r\n",
      "\"Mark\",\"Watney\",\"\"\r\n",
      "\"Melissa\",\"Lewis\",\"\"\r\n"
     ]
    }
   ],
   "source": [
    "!cat $FILE"
   ]
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}