oreilly_exporter.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[33mDEPRECATION: Python 2.7 reached the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 is no longer maintained. pip 21.0 will drop support for Python 2.7 in January 2021. More details about Python 2 support in pip can be found at https://pip.pypa.io/en/latest/development/release-process/#python-2-support pip 21.0 will remove support for this functionality.\u001b[0m\n",
      "Defaulting to user installation because normal site-packages is not writeable\n",
      "Requirement already satisfied: pandas in /Users/ricardo.hernandez/Library/Python/2.7/lib/python/site-packages (0.24.2)\n",
      "Requirement already satisfied: python-dateutil>=2.5.0 in /Users/ricardo.hernandez/Library/Python/2.7/lib/python/site-packages (from pandas) (2.8.1)\n",
      "Requirement already satisfied: pytz>=2011k in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python (from pandas) (2013.7)\n",
      "Requirement already satisfied: numpy>=1.12.0 in /Users/ricardo.hernandez/Library/Python/2.7/lib/python/site-packages (from pandas) (1.16.6)\n",
      "Requirement already satisfied: six>=1.5 in /System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python (from python-dateutil>=2.5.0->pandas) (1.12.0)\n",
      "\u001b[33mDEPRECATION: Python 2.7 reached the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 is no longer maintained. pip 21.0 will drop support for Python 2.7 in January 2021. More details about Python 2 support in pip can be found at https://pip.pypa.io/en/latest/development/release-process/#python-2-support pip 21.0 will remove support for this functionality.\u001b[0m\n",
      "Defaulting to user installation because normal site-packages is not writeable\n",
      "Requirement already satisfied: numpy in /Users/ricardo.hernandez/Library/Python/2.7/lib/python/site-packages (1.16.6)\n"
     ]
    }
   ],
   "source": [
    "!pip install pandas\n",
    "!pip install numpy"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "pd.set_option('max_colwidth', 5000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<module 'posixpath' from '/usr/local/Cellar/python@3.8/3.8.9/Frameworks/Python.framework/Versions/3.8/lib/python3.8/posixpath.py'>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.path"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "book_title = 'Monolith to Microservices'\n",
    "f = 'oreilly-annotations.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "d = pd.read_csv(f, skip_blank_lines=True, keep_default_na=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>Book Title</th>\n",
       "      <th>Chapter Title</th>\n",
       "      <th>Date of Highlight</th>\n",
       "      <th>Book URL</th>\n",
       "      <th>Chapter URL</th>\n",
       "      <th>Annotation URL</th>\n",
       "      <th>Highlight</th>\n",
       "      <th>Personal Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Monolith to Microservices</td>\n",
       "      <td>5. Growing Pains</td>\n",
       "      <td>2021-11-17</td>\n",
       "      <td>https://learning.oreilly.com/library/view/-/9781492047834/</td>\n",
       "      <td>https://learning.oreilly.com/library/view/-/9781492047834/ch05.html</td>\n",
       "      <td>https://learning.oreilly.com/library/view/-/9781492047834/ch05.html#3c5bbfca-42c2-49c6-8981-60df37139169</td>\n",
       "      <td>Collective code ownership</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Book Title     Chapter Title Date of Highlight  \\\n",
       "0  Monolith to Microservices  5. Growing Pains        2021-11-17   \n",
       "\n",
       "                                                     Book URL  \\\n",
       "0  https://learning.oreilly.com/library/view/-/9781492047834/   \n",
       "\n",
       "                                                           Chapter URL  \\\n",
       "0  https://learning.oreilly.com/library/view/-/9781492047834/ch05.html   \n",
       "\n",
       "                                                                                             Annotation URL  \\\n",
       "0  https://learning.oreilly.com/library/view/-/9781492047834/ch05.html#3c5bbfca-42c2-49c6-8981-60df37139169   \n",
       "\n",
       "                   Highlight Personal Note  \n",
       "0  Collective code ownership                "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "n = []\n",
    "for i, row in d.iterrows():\n",
    "    if row['Book Title'] == book_title:\n",
    "        n.append(row['Highlight'] + ' ' + row['Personal Note'])\n",
    "#     else:\n",
    "#         n.append((row['Book Title'] + ' ' +\n",
    "#             row['Authors'] + ' ' + \n",
    "#             row['Chapter Title'] + ' ' + \n",
    "#             row['Date of Highlight'] + ' ' +\n",
    "#             row['Book URL'] + ' ' +\n",
    "#             row['Chapter URL'] + ' ' +\n",
    "#             row['Highlight URL'] + ' ' +\n",
    "#             row['Highlight'] + ' ' +\n",
    "#             row['Personal Note']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "notes = pd.DataFrame(n, columns=['note'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "notes.iloc[::-1].to_clipboard(index=False, sep='\\n')"
   ]
  },
  {
   "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}