document_generator.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import math"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>...</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "      <th>30</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>1</td>\n",
       "      <td>眼鏡</td>\n",
       "      <td>めがね</td>\n",
       "      <td>Noun</td>\n",
       "      <td>1.-glasses; eyeglasses; spectacles</td>\n",
       "      <td>2.-judgment; judgement; discrimination; discer...</td>\n",
       "      <td>3.-Megane</td>\n",
       "      <td>4.-Glasses</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>2</td>\n",
       "      <td>煙草</td>\n",
       "      <td>たばこ</td>\n",
       "      <td>Noun</td>\n",
       "      <td>1.-tobacco; cigarette; cigaret; cigar</td>\n",
       "      <td>2.-tobacco plant (Nicotiana tabacum)</td>\n",
       "      <td>3.-Tabaco</td>\n",
       "      <td>4.-Tobacco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>3</td>\n",
       "      <td>塩</td>\n",
       "      <td>しお</td>\n",
       "      <td>Noun</td>\n",
       "      <td>1.-salt (i.e. sodium chloride); common salt; t...</td>\n",
       "      <td>2.-salt (e.g. sodium chloride, calcium sulfate...</td>\n",
       "      <td>3.-hardship; toil; trouble</td>\n",
       "      <td>4.-saltiness</td>\n",
       "      <td>5.-Salt</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>4</td>\n",
       "      <td>黄色</td>\n",
       "      <td>きいろ</td>\n",
       "      <td>Na-adjective, Noun</td>\n",
       "      <td>1.-yellow; amber</td>\n",
       "      <td>2.-Yellow</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>5</td>\n",
       "      <td>灰皿</td>\n",
       "      <td>はいざら</td>\n",
       "      <td>Noun</td>\n",
       "      <td>1.-ashtray</td>\n",
       "      <td>2.-Ashtray</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         0  1   2     3                   4  \\\n",
       "0  JLPT-N1  1  眼鏡   めがね                Noun   \n",
       "1  JLPT-N1  2  煙草   たばこ                Noun   \n",
       "2  JLPT-N1  3   塩    しお                Noun   \n",
       "3  JLPT-N1  4  黄色   きいろ  Na-adjective, Noun   \n",
       "4  JLPT-N1  5  灰皿  はいざら                Noun   \n",
       "\n",
       "                                                   5  \\\n",
       "0                 1.-glasses; eyeglasses; spectacles   \n",
       "1              1.-tobacco; cigarette; cigaret; cigar   \n",
       "2  1.-salt (i.e. sodium chloride); common salt; t...   \n",
       "3                                   1.-yellow; amber   \n",
       "4                                         1.-ashtray   \n",
       "\n",
       "                                                   6  \\\n",
       "0  2.-judgment; judgement; discrimination; discer...   \n",
       "1               2.-tobacco plant (Nicotiana tabacum)   \n",
       "2  2.-salt (e.g. sodium chloride, calcium sulfate...   \n",
       "3                                          2.-Yellow   \n",
       "4                                         2.-Ashtray   \n",
       "\n",
       "                            7             8        9  ...   21   22   23   24  \\\n",
       "0                   3.-Megane    4.-Glasses      NaN  ...  NaN  NaN  NaN  NaN   \n",
       "1                   3.-Tabaco    4.-Tobacco      NaN  ...  NaN  NaN  NaN  NaN   \n",
       "2  3.-hardship; toil; trouble  4.-saltiness  5.-Salt  ...  NaN  NaN  NaN  NaN   \n",
       "3                         NaN           NaN      NaN  ...  NaN  NaN  NaN  NaN   \n",
       "4                         NaN           NaN      NaN  ...  NaN  NaN  NaN  NaN   \n",
       "\n",
       "    25   26   27   28   29   30  \n",
       "0  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "1  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "2  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "3  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "4  NaN  NaN  NaN  NaN  NaN  NaN  \n",
       "\n",
       "[5 rows x 31 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "level = 'N1'\n",
    "file = pd.read_csv('csv/{}.txt'.format(level), sep = '\\t')\n",
    "file.head()"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "\\card{\n",
    "     1. River;Stream \\\\ 2. River; the ...river \\\\ 3. Gawa \\\\ 4. River\n",
    "}{ \\large{かわ} \\\\ \\Huge{川}}"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Nos quedamos solamente con las 9 primeras columnas (5 primeras definiciones)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "file = file[file.columns[0:10]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": true
   },
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>1</td>\n",
       "      <td>眼鏡</td>\n",
       "      <td>めがね</td>\n",
       "      <td>Noun</td>\n",
       "      <td>1.-glasses; eyeglasses; spectacles</td>\n",
       "      <td>2.-judgment; judgement; discrimination; discer...</td>\n",
       "      <td>3.-Megane</td>\n",
       "      <td>4.-Glasses</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>2</td>\n",
       "      <td>煙草</td>\n",
       "      <td>たばこ</td>\n",
       "      <td>Noun</td>\n",
       "      <td>1.-tobacco; cigarette; cigaret; cigar</td>\n",
       "      <td>2.-tobacco plant (Nicotiana tabacum)</td>\n",
       "      <td>3.-Tabaco</td>\n",
       "      <td>4.-Tobacco</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>3</td>\n",
       "      <td>塩</td>\n",
       "      <td>しお</td>\n",
       "      <td>Noun</td>\n",
       "      <td>1.-salt (i.e. sodium chloride); common salt; t...</td>\n",
       "      <td>2.-salt (e.g. sodium chloride, calcium sulfate...</td>\n",
       "      <td>3.-hardship; toil; trouble</td>\n",
       "      <td>4.-saltiness</td>\n",
       "      <td>5.-Salt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>4</td>\n",
       "      <td>黄色</td>\n",
       "      <td>きいろ</td>\n",
       "      <td>Na-adjective, Noun</td>\n",
       "      <td>1.-yellow; amber</td>\n",
       "      <td>2.-Yellow</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JLPT-N1</td>\n",
       "      <td>5</td>\n",
       "      <td>灰皿</td>\n",
       "      <td>はいざら</td>\n",
       "      <td>Noun</td>\n",
       "      <td>1.-ashtray</td>\n",
       "      <td>2.-Ashtray</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         0  1   2     3                   4  \\\n",
       "0  JLPT-N1  1  眼鏡   めがね                Noun   \n",
       "1  JLPT-N1  2  煙草   たばこ                Noun   \n",
       "2  JLPT-N1  3   塩    しお                Noun   \n",
       "3  JLPT-N1  4  黄色   きいろ  Na-adjective, Noun   \n",
       "4  JLPT-N1  5  灰皿  はいざら                Noun   \n",
       "\n",
       "                                                   5  \\\n",
       "0                 1.-glasses; eyeglasses; spectacles   \n",
       "1              1.-tobacco; cigarette; cigaret; cigar   \n",
       "2  1.-salt (i.e. sodium chloride); common salt; t...   \n",
       "3                                   1.-yellow; amber   \n",
       "4                                         1.-ashtray   \n",
       "\n",
       "                                                   6  \\\n",
       "0  2.-judgment; judgement; discrimination; discer...   \n",
       "1               2.-tobacco plant (Nicotiana tabacum)   \n",
       "2  2.-salt (e.g. sodium chloride, calcium sulfate...   \n",
       "3                                          2.-Yellow   \n",
       "4                                         2.-Ashtray   \n",
       "\n",
       "                            7             8        9  \n",
       "0                   3.-Megane    4.-Glasses      NaN  \n",
       "1                   3.-Tabaco    4.-Tobacco      NaN  \n",
       "2  3.-hardship; toil; trouble  4.-saltiness  5.-Salt  \n",
       "3                         NaN           NaN      NaN  \n",
       "4                         NaN           NaN      NaN  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "file.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Generamos un string que pasará a archivo latex, la plantilla a seguir es:\n",
    "\n",
    "\\card{\n",
    "     **0:8**\n",
    "}{ \\large{**3**} \\\\ \\Huge{**2**}}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "first_part = \"\"\"\n",
    "\\\\documentclass[frontgrid,backgrid,a4paper,11pt]{flacards}\n",
    "\\\\usepackage{etoolbox}\n",
    "\\\\pretocmd{\\\\card}{\\\\def\\\\curhint{#1}}{}{}\n",
    "\n",
    "\\\\pagesetup{3}{7}\n",
    "\n",
    "\\\\usepackage{xeCJK}\n",
    "\\\\setCJKmainfont{IPAMincho}\n",
    "\\\\setmainfont{Linux Libertine O}\n",
    "\n",
    "\\\\renewcommand{\\\\cardtextstylef}{\\\\small}\n",
    "\\\\renewcommand{\\\\brfoot}{JLPT-N%d}\n",
    "\n",
    "\n",
    "\\\\renewcommand{\\\\flhead}{\\\\footnotesize\\\\thecardno}\n",
    "\\\\renewcommand{\\\\brhead}{\\\\footnotesize\\\\thecardno}\n",
    "\n",
    "\\\\begin{document}\n",
    "\"\"\" % (int(level[1]))\n",
    "\n",
    "last_part = \"\\end{document}\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "cards = []"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "En str \\\\ = \\ y \\\\\\\\ = \\\\"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Haciendo print: \n",
      "\\card{DEFINICIONES SEPARADAS POR  } {\\large{FURIGANA} \\\\ \\Huge{KANJI}}\n",
      "\n",
      "Mencionando al final: \n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'\\\\card{DEFINICIONES SEPARADAS POR  } {\\\\large{FURIGANA} \\\\\\\\ \\\\Huge{KANJI}}'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s1 = \"\\card{\" + str(\"DEFINICIONES SEPARADAS POR  \") + \"} {\\large{\" + str(\"FURIGANA\") + \"} \\\\\\\\ \" + \"\\Huge{\" + \"KANJI\" + \"}}\" \n",
    "print('Haciendo print: \\n' + s1 + '\\n\\nMencionando al final: ')\n",
    "s1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index, row in file.iterrows():\n",
    "    # access data using column names\n",
    "    definitions = row['4'] # De 5 a 8\n",
    "    for i in range(5, 10):\n",
    "        if type(row[str(i)]) is str:\n",
    "            definitions = definitions + ' \\\\\\\\ ' + row[str(i)]\n",
    "    \n",
    "    # For words in katakana\n",
    "    furigana = ''\n",
    "    if type(row['3']) is str:\n",
    "        furigana = row['3']\n",
    "    \n",
    "    si = \"\\card{\" + definitions + \"} {\\large{\" + furigana + \"} \\\\\\\\ \" + \"\\Huge{\" + str(row['2']) + \"}}\"\n",
    "    cards.append(si)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\\card{Noun \\\\ 1.-glasses; eyeglasses; spectacles \\\\ 2.-judgment; judgement; discrimination; discernment; insight \\\\ 3.-Megane \\\\ 4.-Glasses} {\\large{めがね} \\\\ \\Huge{眼鏡}}\n",
      "\\card{Noun \\\\ 1.-tobacco; cigarette; cigaret; cigar \\\\ 2.-tobacco plant (Nicotiana tabacum) \\\\ 3.-Tabaco \\\\ 4.-Tobacco} {\\large{たばこ} \\\\ \\Huge{煙草}}\n",
      "\\card{Noun \\\\ 1.-salt (i.e. sodium chloride); common salt; table salt \\\\ 2.-salt (e.g. sodium chloride, calcium sulfate, etc.) \\\\ 3.-hardship; toil; trouble \\\\ 4.-saltiness \\\\ 5.-Salt} {\\large{しお} \\\\ \\Huge{塩}}\n",
      "\\card{Na-adjective, Noun \\\\ 1.-yellow; amber \\\\ 2.-Yellow} {\\large{きいろ} \\\\ \\Huge{黄色}}\n",
      "\\card{Noun \\\\ 1.-ashtray \\\\ 2.-Ashtray} {\\large{はいざら} \\\\ \\Huge{灰皿}}\n"
     ]
    }
   ],
   "source": [
    "for i in range(5):\n",
    "    print(cards[i])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "f = open(\"wild_cards/{}_cards.txt\".format(level), \"a\",  encoding=\"utf-8\")\n",
    "f.write(first_part)\n",
    "\n",
    "f.write('\\n')\n",
    "\n",
    "for card in cards:\n",
    "    f.write(card)\n",
    "    f.write(' \\n')\n",
    "\n",
    "f.write('\\n')    \n",
    "\n",
    "f.write(last_part)\n",
    "f.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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}