analyzing_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 303,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 304,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['id', 'title', 'description', 'is_premium', 'difficulty',\n",
      "       'solution_link', 'acceptance_rate', 'frequency', 'url', 'discuss_count',\n",
      "       'accepted', 'submissions', 'companies', 'related_topics', 'likes',\n",
      "       'dislikes', 'rating', 'asked_by_faang', 'similar_questions'],\n",
      "      dtype='object')\n",
      "Index(['Question ID', 'Question Title', 'Question Slug', 'Question Text',\n",
      "       'Topic Tagged text', 'Difficulty Level', 'Success Rate',\n",
      "       'total submission', 'total accepted', 'Likes', 'Dislikes', 'Hints',\n",
      "       'Similar Questions ID', 'Similar Questions Text'],\n",
      "      dtype='object')\n",
      "Index(['ID', 'Problem'], dtype='object')\n"
     ]
    }
   ],
   "source": [
    "ds1 = pd.read_csv(\"leetcode_ds1.csv\")\n",
    "ds2 = pd.read_csv(\"leetcode_ds2.csv\")\n",
    "df_map_to_problem = pd.read_csv(\"table_df.csv\")\n",
    "print(ds1.columns)\n",
    "print(ds2.columns)\n",
    "print(df_map.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 305,
   "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>Unnamed: 0</th>\n",
       "      <th>#</th>\n",
       "      <th>Problem</th>\n",
       "      <th>Solution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>----</td>\n",
       "      <td>---------------------------------------------...</td>\n",
       "      <td>---------------------------------------------...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[Two Sum](https://leetcode.com/problems/two-s...</td>\n",
       "      <td>[python3](https://github.com/cnkyrpsgl/leetco...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>[Add Two Numbers](https://leetcode.com/proble...</td>\n",
       "      <td>[python3](https://github.com/cnkyrpsgl/leetco...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>[Longest Substring Without Repeating Characte...</td>\n",
       "      <td>[python3](https://github.com/cnkyrpsgl/leetco...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>[Median of Two Sorted Arrays](https://leetcod...</td>\n",
       "      <td>[python3](https://github.com/cnkyrpsgl/leetco...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0   #      \\\n",
       "0           0   ----    \n",
       "1           1   1       \n",
       "2           2   2       \n",
       "3           3   3       \n",
       "4           4   4       \n",
       "\n",
       "   Problem                                                                                                                                                           \\\n",
       "0   ---------------------------------------------...                                                                                                                  \n",
       "1   [Two Sum](https://leetcode.com/problems/two-s...                                                                                                                  \n",
       "2   [Add Two Numbers](https://leetcode.com/proble...                                                                                                                  \n",
       "3   [Longest Substring Without Repeating Characte...                                                                                                                  \n",
       "4   [Median of Two Sorted Arrays](https://leetcod...                                                                                                                  \n",
       "\n",
       "   Solution                                                                                 \n",
       "0   ---------------------------------------------...                                        \n",
       "1   [python3](https://github.com/cnkyrpsgl/leetco...                                        \n",
       "2   [python3](https://github.com/cnkyrpsgl/leetco...                                        \n",
       "3   [python3](https://github.com/cnkyrpsgl/leetco...                                        \n",
       "4   [python3](https://github.com/cnkyrpsgl/leetco...                                        "
      ]
     },
     "execution_count": 305,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_map_to_problem.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 306,
   "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>ID</th>\n",
       "      <th>Problem</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Two Sum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Add Two Numbers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Longest Substring Without Repeating Characters</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Median of Two Sorted Arrays</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Longest Palindromic Substring</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       ID                                         Problem\n",
       "1   1                                             Two Sum\n",
       "2   2                                     Add Two Numbers\n",
       "3   3      Longest Substring Without Repeating Characters\n",
       "4   4                         Median of Two Sorted Arrays\n",
       "5   5                       Longest Palindromic Substring"
      ]
     },
     "execution_count": 306,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_map = df_map_to_problem.iloc[:, 1:]\n",
    "df_map = df_map.rename(columns={df_map.columns[0]:\"ID\", df_map.columns[1]: \"Problem\", df_map.columns[2]: \"Solution\"})\n",
    "df_map = df_map.drop(columns={\"Solution\"})\n",
    "df_map = df_map.iloc[1:, :]\n",
    "df_map.Problem = df_map.Problem.apply(lambda x: x.strip().split(']')[0].replace('[', ''))\n",
    "df_map.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 307,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1       None\n",
       "2       None\n",
       "3       None\n",
       "4       None\n",
       "5       None\n",
       "        ... \n",
       "1154    None\n",
       "1155    None\n",
       "1156    None\n",
       "1157    None\n",
       "1158    None\n",
       "Name: ID, Length: 1158, dtype: object"
      ]
     },
     "execution_count": 307,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Changing all file names to the problem instead of ID\n",
    "root_path = \"./leetcode/solutions/python3/\"\n",
    "def change_file_name(path, df):\n",
    "    full_path = root_path + str(path).strip() +\".py\"\n",
    "    if os.path.exists(full_path):\n",
    "        new_full_path = \"-\".join(str(df[df[\"ID\"]==path].Problem).lower().split('name:')[0].split()[1:]).replace(\"(\", \"\").replace(\")\", \"\")\n",
    "        new_full_path = root_path + new_full_path + \".py\"\n",
    "        os.rename(full_path, new_full_path)\n",
    "\n",
    "df_map['ID'].apply(lambda x: change_file_name(x, df_map))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 308,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1825 entries, 0 to 1824\n",
      "Data columns (total 19 columns):\n",
      " #   Column             Non-Null Count  Dtype  \n",
      "---  ------             --------------  -----  \n",
      " 0   id                 1825 non-null   int64  \n",
      " 1   title              1825 non-null   object \n",
      " 2   description        1825 non-null   object \n",
      " 3   is_premium         1825 non-null   int64  \n",
      " 4   difficulty         1825 non-null   object \n",
      " 5   solution_link      987 non-null    object \n",
      " 6   acceptance_rate    1825 non-null   float64\n",
      " 7   frequency          1825 non-null   float64\n",
      " 8   url                1825 non-null   object \n",
      " 9   discuss_count      1825 non-null   int64  \n",
      " 10  accepted           1825 non-null   object \n",
      " 11  submissions        1825 non-null   object \n",
      " 12  companies          1749 non-null   object \n",
      " 13  related_topics     1571 non-null   object \n",
      " 14  likes              1825 non-null   int64  \n",
      " 15  dislikes           1825 non-null   int64  \n",
      " 16  rating             1825 non-null   int64  \n",
      " 17  asked_by_faang     1825 non-null   int64  \n",
      " 18  similar_questions  745 non-null    object \n",
      "dtypes: float64(2), int64(7), object(10)\n",
      "memory usage: 271.0+ KB\n",
      "None \n",
      "\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2238 entries, 0 to 2237\n",
      "Data columns (total 14 columns):\n",
      " #   Column                  Non-Null Count  Dtype  \n",
      "---  ------                  --------------  -----  \n",
      " 0   Question ID             2238 non-null   int64  \n",
      " 1   Question Title          2238 non-null   object \n",
      " 2   Question Slug           2238 non-null   object \n",
      " 3   Question Text           1758 non-null   object \n",
      " 4   Topic Tagged text       2236 non-null   object \n",
      " 5   Difficulty Level        2238 non-null   object \n",
      " 6   Success Rate            2238 non-null   float64\n",
      " 7   total submission        2238 non-null   int64  \n",
      " 8   total accepted          2238 non-null   int64  \n",
      " 9   Likes                   2238 non-null   int64  \n",
      " 10  Dislikes                2238 non-null   int64  \n",
      " 11  Hints                   1235 non-null   object \n",
      " 12  Similar Questions ID    1256 non-null   object \n",
      " 13  Similar Questions Text  1256 non-null   object \n",
      "dtypes: float64(1), int64(5), object(8)\n",
      "memory usage: 244.9+ KB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "print(ds1.info(), \"\\n\")\n",
    "print(ds2.info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 309,
   "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>Question Title</th>\n",
       "      <th>Difficulty Level</th>\n",
       "      <th>Similar Questions Text</th>\n",
       "      <th>Solution Link</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Question ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Two Sum</td>\n",
       "      <td>Easy</td>\n",
       "      <td>[3Sum, /problems/3sum/, Medium], [4Sum, /probl...</td>\n",
       "      <td>/articles/two-sum</td>\n",
       "      <td>https://leetcode.com/problems/two-sum</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Add Two Numbers</td>\n",
       "      <td>Medium</td>\n",
       "      <td>[Multiply Strings, /problems/multiply-strings/...</td>\n",
       "      <td>/articles/add-two-numbers</td>\n",
       "      <td>https://leetcode.com/problems/add-two-numbers</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Longest Substring Without Repeating Characters</td>\n",
       "      <td>Medium</td>\n",
       "      <td>[Longest Substring with At Most Two Distinct C...</td>\n",
       "      <td>/articles/longest-substring-without-repeating-...</td>\n",
       "      <td>https://leetcode.com/problems/longest-substrin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Median of Two Sorted Arrays</td>\n",
       "      <td>Hard</td>\n",
       "      <td>NaN</td>\n",
       "      <td>/articles/median-of-two-sorted-arrays</td>\n",
       "      <td>https://leetcode.com/problems/median-of-two-so...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Longest Palindromic Substring</td>\n",
       "      <td>Medium</td>\n",
       "      <td>[Shortest Palindrome, /problems/shortest-palin...</td>\n",
       "      <td>/articles/longest-palindromic-substring</td>\n",
       "      <td>https://leetcode.com/problems/longest-palindro...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Question Title Difficulty Level  \\\n",
       "Question ID                                                                    \n",
       "1                                                   Two Sum             Easy   \n",
       "2                                           Add Two Numbers           Medium   \n",
       "3            Longest Substring Without Repeating Characters           Medium   \n",
       "4                               Median of Two Sorted Arrays             Hard   \n",
       "5                             Longest Palindromic Substring           Medium   \n",
       "\n",
       "                                        Similar Questions Text  \\\n",
       "Question ID                                                      \n",
       "1            [3Sum, /problems/3sum/, Medium], [4Sum, /probl...   \n",
       "2            [Multiply Strings, /problems/multiply-strings/...   \n",
       "3            [Longest Substring with At Most Two Distinct C...   \n",
       "4                                                          NaN   \n",
       "5            [Shortest Palindrome, /problems/shortest-palin...   \n",
       "\n",
       "                                                 Solution Link  \\\n",
       "Question ID                                                      \n",
       "1                                            /articles/two-sum   \n",
       "2                                    /articles/add-two-numbers   \n",
       "3            /articles/longest-substring-without-repeating-...   \n",
       "4                        /articles/median-of-two-sorted-arrays   \n",
       "5                      /articles/longest-palindromic-substring   \n",
       "\n",
       "                                                           url  \n",
       "Question ID                                                     \n",
       "1                        https://leetcode.com/problems/two-sum  \n",
       "2                https://leetcode.com/problems/add-two-numbers  \n",
       "3            https://leetcode.com/problems/longest-substrin...  \n",
       "4            https://leetcode.com/problems/median-of-two-so...  \n",
       "5            https://leetcode.com/problems/longest-palindro...  "
      ]
     },
     "execution_count": 309,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Changing the column names to match and dropping useless columns\n",
    "ds1 = ds1.rename(columns={\"id\": \"Question ID\", \"title\": \"Question Title\", \"difficulty\": \"Difficulty Level\", \"similar_questions\": \"Similar Questions Text\", \"solution_link\": \"Solution Link\"})\n",
    "ds1 = ds1[[\"Question ID\", \"Question Title\", \"Difficulty Level\", \"Similar Questions Text\", \"Solution Link\", \"url\"]]\n",
    "ds1 = ds1.set_index(\"Question ID\")\n",
    "ds1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 310,
   "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>Question Title</th>\n",
       "      <th>Difficulty Level</th>\n",
       "      <th>Similar Questions Text</th>\n",
       "      <th>Question Text</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Question ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Two Sum</td>\n",
       "      <td>Easy</td>\n",
       "      <td>3Sum,4Sum,Two Sum II - Input Array Is Sorted,T...</td>\n",
       "      <td>Given an array of integers nums and an integer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Add Two Numbers</td>\n",
       "      <td>Medium</td>\n",
       "      <td>Multiply Strings,Add Binary,Sum of Two Integer...</td>\n",
       "      <td>You are given two non-empty linked lists repre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Longest Substring Without Repeating Characters</td>\n",
       "      <td>Medium</td>\n",
       "      <td>Longest Substring with At Most Two Distinct Ch...</td>\n",
       "      <td>Given a string s, find the length of the longe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Median of Two Sorted Arrays</td>\n",
       "      <td>Hard</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Given two sorted arrays nums1 and nums2 of siz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Longest Palindromic Substring</td>\n",
       "      <td>Medium</td>\n",
       "      <td>Shortest Palindrome,Palindrome Permutation,Pal...</td>\n",
       "      <td>Given a string s, return the longest palindrom...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Question Title Difficulty Level  \\\n",
       "Question ID                                                                    \n",
       "1                                                   Two Sum             Easy   \n",
       "2                                           Add Two Numbers           Medium   \n",
       "3            Longest Substring Without Repeating Characters           Medium   \n",
       "4                               Median of Two Sorted Arrays             Hard   \n",
       "5                             Longest Palindromic Substring           Medium   \n",
       "\n",
       "                                        Similar Questions Text  \\\n",
       "Question ID                                                      \n",
       "1            3Sum,4Sum,Two Sum II - Input Array Is Sorted,T...   \n",
       "2            Multiply Strings,Add Binary,Sum of Two Integer...   \n",
       "3            Longest Substring with At Most Two Distinct Ch...   \n",
       "4                                                          NaN   \n",
       "5            Shortest Palindrome,Palindrome Permutation,Pal...   \n",
       "\n",
       "                                                 Question Text  \n",
       "Question ID                                                     \n",
       "1            Given an array of integers nums and an integer...  \n",
       "2            You are given two non-empty linked lists repre...  \n",
       "3            Given a string s, find the length of the longe...  \n",
       "4            Given two sorted arrays nums1 and nums2 of siz...  \n",
       "5            Given a string s, return the longest palindrom...  "
      ]
     },
     "execution_count": 310,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Dropping useless columns in ds2\n",
    "ds2 = ds2[[\"Question ID\", \"Question Title\", \"Difficulty Level\", \"Similar Questions Text\", \"Question Text\"]]\n",
    "ds2 = ds2.set_index(\"Question ID\")\n",
    "ds2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 311,
   "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>Question Title</th>\n",
       "      <th>Difficulty Level</th>\n",
       "      <th>Similar Questions Text</th>\n",
       "      <th>Solution Link</th>\n",
       "      <th>url</th>\n",
       "      <th>Question Text</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Question ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Two Sum</td>\n",
       "      <td>Easy</td>\n",
       "      <td>[3Sum, /problems/3sum/, Medium], [4Sum, /probl...</td>\n",
       "      <td>/articles/two-sum</td>\n",
       "      <td>https://leetcode.com/problems/two-sum</td>\n",
       "      <td>Given an array of integers nums and an integer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Add Two Numbers</td>\n",
       "      <td>Medium</td>\n",
       "      <td>[Multiply Strings, /problems/multiply-strings/...</td>\n",
       "      <td>/articles/add-two-numbers</td>\n",
       "      <td>https://leetcode.com/problems/add-two-numbers</td>\n",
       "      <td>You are given two non-empty linked lists repre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Longest Substring Without Repeating Characters</td>\n",
       "      <td>Medium</td>\n",
       "      <td>[Longest Substring with At Most Two Distinct C...</td>\n",
       "      <td>/articles/longest-substring-without-repeating-...</td>\n",
       "      <td>https://leetcode.com/problems/longest-substrin...</td>\n",
       "      <td>Given a string s, find the length of the longe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Median of Two Sorted Arrays</td>\n",
       "      <td>Hard</td>\n",
       "      <td>NaN</td>\n",
       "      <td>/articles/median-of-two-sorted-arrays</td>\n",
       "      <td>https://leetcode.com/problems/median-of-two-so...</td>\n",
       "      <td>Given two sorted arrays nums1 and nums2 of siz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Longest Palindromic Substring</td>\n",
       "      <td>Medium</td>\n",
       "      <td>[Shortest Palindrome, /problems/shortest-palin...</td>\n",
       "      <td>/articles/longest-palindromic-substring</td>\n",
       "      <td>https://leetcode.com/problems/longest-palindro...</td>\n",
       "      <td>Given a string s, return the longest palindrom...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Question Title Difficulty Level  \\\n",
       "Question ID                                                                    \n",
       "1                                                   Two Sum             Easy   \n",
       "2                                           Add Two Numbers           Medium   \n",
       "3            Longest Substring Without Repeating Characters           Medium   \n",
       "4                               Median of Two Sorted Arrays             Hard   \n",
       "5                             Longest Palindromic Substring           Medium   \n",
       "\n",
       "                                        Similar Questions Text  \\\n",
       "Question ID                                                      \n",
       "1            [3Sum, /problems/3sum/, Medium], [4Sum, /probl...   \n",
       "2            [Multiply Strings, /problems/multiply-strings/...   \n",
       "3            [Longest Substring with At Most Two Distinct C...   \n",
       "4                                                          NaN   \n",
       "5            [Shortest Palindrome, /problems/shortest-palin...   \n",
       "\n",
       "                                                 Solution Link  \\\n",
       "Question ID                                                      \n",
       "1                                            /articles/two-sum   \n",
       "2                                    /articles/add-two-numbers   \n",
       "3            /articles/longest-substring-without-repeating-...   \n",
       "4                        /articles/median-of-two-sorted-arrays   \n",
       "5                      /articles/longest-palindromic-substring   \n",
       "\n",
       "                                                           url  \\\n",
       "Question ID                                                      \n",
       "1                        https://leetcode.com/problems/two-sum   \n",
       "2                https://leetcode.com/problems/add-two-numbers   \n",
       "3            https://leetcode.com/problems/longest-substrin...   \n",
       "4            https://leetcode.com/problems/median-of-two-so...   \n",
       "5            https://leetcode.com/problems/longest-palindro...   \n",
       "\n",
       "                                                 Question Text  \n",
       "Question ID                                                     \n",
       "1            Given an array of integers nums and an integer...  \n",
       "2            You are given two non-empty linked lists repre...  \n",
       "3            Given a string s, find the length of the longe...  \n",
       "4            Given two sorted arrays nums1 and nums2 of siz...  \n",
       "5            Given a string s, return the longest palindrom...  "
      ]
     },
     "execution_count": 311,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Merging the two datasets and making a couple of changes\n",
    "merged = pd.merge(ds1, ds2, on=\"Question ID\", how=\"inner\")\n",
    "dupplicate_columns = [x for x in merged.columns if x.endswith(\"_y\")]\n",
    "merged = merged.drop(dupplicate_columns, axis=1)\n",
    "merged = merged.rename(columns={x: x.replace(\"_x\", \"\") for x in merged.columns})\n",
    "# merged = merged.dropna()\n",
    "# merged[\"Solution Link\"] = merged[\"Solution Link\"].apply(lambda x: \"https://leetcode.com\" + x)\n",
    "merged.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 312,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAjsAAAHHCAYAAABZbpmkAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjkuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8hTgPZAAAACXBIWXMAAA9hAAAPYQGoP6dpAABBMklEQVR4nO3deXgNd///8ddJSGS3J5ZI1FKCoihpVZQQa221VYmtlsauVbqhStDb3qL1rVBLbUW1at9vW4lqUXstaQl1l0S4JSTz+6O/nNuRIOHEYTwf13Wuy/nMZ2bec0xyXpn5zIzFMAxDAAAAJuXk6AIAAACyEmEHAACYGmEHAACYGmEHAACYGmEHAACYGmEHAACYGmEHAACYGmEHAACYGmEHAACYGmEHMLk5c+aoVKlSyp49u3LmzOnocnT69GlZLBb961//um/fYcOGyWKxPIKqHj+BgYHq2LGjTdvx48dVt25d+fj4yGKxaPny5ZKkPXv26MUXX5SHh4csFov279+f5Z/d5s2bZbFYtHnz5ixbx5OgY8eOCgwMdHQZuA/CDrLcgQMH9NprrykgIEA5cuRQoUKFVKdOHU2ZMsXRpZnekSNH1LFjRxUrVkwzZszQl19+ede+qV+OqS93d3cFBQXpgw8+UHx8/COs+vEwa9Ysu4WFmjVrWj9XJycneXt769lnn1X79u21bt26DC8nPDxcBw4c0MiRIzVnzhxVrlxZN2/eVMuWLfX3339rwoQJmjNnjgICAuxSd2bNnz9fEydOtPtyLRaLevXqZffl4umRzdEFwNx27NihV155RUWKFNGbb74pPz8/xcTEaNeuXZo0aZJ69+7t6BJNbfPmzUpJSdGkSZNUvHjxDM0zbdo0eXp6KiEhQWvXrtXIkSO1ceNGbd++/ak9ymIPhQsXVmRkpCTp2rVrOnHihJYuXaq5c+eqVatWmjt3rrJnz27tf/ToUTk5/e/v0f/+97/auXOn3n//fZsv/iNHjujMmTOaMWOGunbtam3/4IMPNHjw4EewZf8zf/58HTx4UP369Xuk6wXuh7CDLDVy5Ej5+Phoz549aU6hXLx40TFFOZBhGLpx44bc3NweyfpSP+PMnL567bXXlDdvXklSjx491KJFCy1dulS7du1ScHBwuvNcv35d7u7uD12vmfn4+OiNN96waRs9erT69OmjqVOnKjAwUGPGjLFOc3V1ten7119/SUr7f3m3/+Ns2bIpWzZ+xQMSp7GQxU6ePKkyZcqk+2WbP39+679Tx3HMmjUrTT+LxaJhw4ZZ36eebjl27JjeeOMN+fj4KF++fPrwww9lGIZiYmLUpEkTeXt7y8/PT+PGjbNZXupYg0WLFmn48OEqVKiQvLy89NprrykuLk6JiYnq16+f8ufPL09PT3Xq1EmJiYk2y4iKilKtWrWUP39+ubq6KigoSNOmTUtTe2BgoBo1aqQ1a9aocuXKcnNz0xdffKGQkBCVL18+3c/s2WefVVhY2D0+1X9MnTpVZcqUkaurqwoWLKiIiAhduXLFZt1Dhw6VJOXLly/N55hRtWrVkiSdOnVK0j+nZMqWLavo6GjVqFFD7u7ueu+99yT988XbpUsX+fr6KkeOHCpfvrxmz55912VPmDBBAQEBcnNzU0hIiA4ePJihmubOnatKlSrJzc1NuXPnVps2bRQTE2PTJ7XOX3/9VSEhIXJ3d1fx4sW1ZMkSSdKWLVtUtWpVubm56dlnn9X69evvu969e/cqLCxMefPmlZubm4oWLarOnTtnqOb0ODs7a/LkyQoKCtJnn32muLg467Tbx+wMGzbMemrqnXfekcVisU4PCQmRJLVs2VIWi0U1a9a0zpPekbi5c+fqhRdekLu7u3LlyqUaNWpo7dq11ul320/SG0N0u5o1a2rlypU6c+aM9ZRdYGCgEhIS5OHhob59+6aZ548//pCzs7P1iNfDSElJ0cSJE1WmTBnlyJFDvr6+6t69uy5fvmzt06hRIz3zzDPpzh8cHKzKlSvbtGVkP0vPggULVKlSJXl5ecnb21vlypXTpEmTHm4D8VAIO8hSAQEBio6OzvCXWGa0bt1aKSkpGj16tKpWrapPPvlEEydOVJ06dVSoUCGNGTNGxYsX19tvv62tW7emmT8yMlJr1qzR4MGD1blzZy1dulQ9evRQ586ddezYMQ0bNkzNmzfXrFmzbP7ilv451RMQEKD33ntP48aNk7+/v9566y19/vnnadZz9OhRtW3bVnXq1NGkSZNUoUIFtW/fXr/++muaz2XPnj3WEHcvw4YNU0REhAoWLKhx48apRYsW+uKLL1S3bl3dvHlTkjRx4kQ1a9bMWu+cOXPUvHnzTH3G0j+BVZLy5MljbfvPf/6j+vXrq0KFCpo4caJeeeUV/fe//1XNmjU1Z84ctWvXTp9++ql8fHzUsWPHdH/Rf/3115o8ebIiIiI0ZMgQHTx4ULVq1dKFCxfuWc/IkSPVoUMHlShRQuPHj1e/fv20YcMG1ahRwybsSdLly5fVqFEjVa1aVWPHjpWrq6vatGmjhQsXqk2bNmrQoIFGjx6ta9eu6bXXXtPVq1fvut6LFy+qbt26On36tAYPHqwpU6aoXbt22rVrVyY+zbScnZ3Vtm1bXb9+Xf/+97/T7dO8eXNNmDBBktS2bVvNmTNHEydOVPfu3a1Bs0+fPpozZ47ef//9u65r+PDhat++vbJnz66PP/5Yw4cPl7+/vzZu3PhQ2yBJ77//vipUqKC8efNqzpw51ho9PT3VrFkzLVy4UMnJyTbzfPPNNzIMQ+3atXvo9Xfv3l3vvPOOXnrpJU2aNEmdOnXSvHnzFBYWZv2ZaN26tU6dOqU9e/bYzHvmzBnt2rVLbdq0sbZlZj+73bp169S2bVvlypVLY8aM0ejRo1WzZk1t3779obcRD8EAstDatWsNZ2dnw9nZ2QgODjYGDRpkrFmzxkhKSrLpd+rUKUOSERUVlWYZkoyhQ4da3w8dOtSQZHTr1s3aduvWLaNw4cKGxWIxRo8ebW2/fPmy4ebmZoSHh1vbNm3aZEgyypYta1NH27ZtDYvFYtSvX99m/cHBwUZAQIBN2/Xr19PUGRYWZjzzzDM2bQEBAYYkY/Xq1TbtV65cMXLkyGG8++67Nu19+vQxPDw8jISEhDTLT3Xx4kXDxcXFqFu3rpGcnGxt/+yzzwxJxsyZM61tqZ/VX3/9ddfl3dn36NGjxl9//WWcOnXK+OKLLwxXV1fD19fXuHbtmmEYhhESEmJIMqZPn24z/8SJEw1Jxty5c61tSUlJRnBwsOHp6WnEx8cbhvG//2s3Nzfjjz/+sPbdvXu3Icno379/mppSnT592nB2djZGjhxps+4DBw4Y2bJls2lPrXP+/PnWtiNHjhiSDCcnJ2PXrl3W9jVr1tx1/0u1bNkyQ5KxZ8+ee36O6QkJCTHKlClz32VPmjTJ2hYQEGCz36Z+bp9++qnNvKn78+LFi23a7/zsjh8/bjg5ORnNmjWz2W8MwzBSUlKs/77z5+1u9aSud9OmTda2hg0bpvlZMYz/fb6rVq2yaX/uueeMkJCQNP3vJMmIiIi46/Rt27YZkox58+bZtK9evdqmPS4uznB1dTUGDhxo02/s2LGGxWIxzpw5YxhG5vaz8PBwm23u27ev4e3tbdy6deu+24VHhyM7yFJ16tTRzp079eqrr+qXX37R2LFjFRYWpkKFCmnFihUPtezbB2M6OzurcuXKMgxDXbp0sbbnzJlTzz77rH7//fc083fo0MFmQGjVqlVlGEaa0xJVq1ZVTEyMbt26ZW27fcxNXFycLl26pJCQEP3+++82pyIkqWjRomlOS/n4+KhJkybWv2wlKTk5WQsXLlTTpk3l4eFx1+1ev369kpKS1K9fP5sBrG+++aa8vb21cuXKu86bEc8++6zy5cunokWLqnv37ipevLhWrlxpMybH1dVVnTp1spnvxx9/lJ+fn9q2bWtty549u/r06aOEhARt2bLFpn/Tpk1VqFAh6/sXXnhBVatW1Y8//njX2pYuXaqUlBS1atVKly5dsr78/PxUokQJbdq0yaa/p6enzV/rzz77rHLmzKnSpUuratWq1vbUf6e3n6RKPRX7ww8/WI8U2Iunp6ck3fPI0sNavny5UlJS9NFHH9nsN5KyfOB5aGioChYsqHnz5lnbDh48qF9//fW+RzEzYvHixfLx8VGdOnVs9otKlSrJ09PTul94e3urfv36WrRokfXnTpIWLlyoatWqqUiRIpIyv5/dLmfOnLp27VqmrrJD1iPsIMtVqVJFS5cu1eXLl/XTTz9pyJAhunr1ql577TX99ttvD7zc1F9MqXx8fJQjRw7r4Nrb228/b3+v+SXJ398/TXtKSopNiNm+fbtCQ0Pl4eGhnDlzKl++fNbTCemFnfR06NBBZ8+e1bZt2yT9E2IuXLig9u3b33WbpX8OuUv/fHHfzsXFRc8884x1+oP69ttvtW7dOm3evFknTpzQwYMHValSJZs+hQoVkouLS5q6SpQokeaLtHTp0jZ1pypRokSadZcsWVKnT5++a23Hjx+XYRgqUaKE8uXLZ/M6fPhwmkHvhQsXTvNF7uPjk+7/saR095NUISEhatGihYYPH668efOqSZMmioqKSjOe60EkJCRIkry8vB56WXdz8uRJOTk5KSgoKMvWcTdOTk5q166dli9fruvXr0uS5s2bpxw5cqhly5YPvfzjx48rLi5O+fPnT7NfJCQk2OwXrVu3VkxMjHbu3Cnpn88lOjparVu3tlleZvaz27311lsqWbKk6tevr8KFC6tz585avXr1Q28jHg5D9fHIuLi4qEqVKqpSpYpKliypTp06afHixRo6dOhd/7K88xz/7ZydnTPUJsnmr7j79b3fMk6ePKnatWurVKlSGj9+vPz9/eXi4qIff/xREyZMUEpKis18d7vyKiwsTL6+vpo7d65q1KihuXPnys/PT6Ghoen2f1Rq1KiRJjDe6VFdTXanlJQUWSwWrVq1Kt3/p9QjJKke9P84PRaLRUuWLNGuXbv0/fffa82aNercubPGjRunXbt2pVl3ZqSO3cro7QEc4V4/ixnRoUMHffrpp1q+fLnatm2r+fPnq1GjRtag+TBSUlKUP39+myNHt8uXL5/1340bN5a7u7sWLVqkF198UYsWLZKTk5NN6Mrsfna7/Pnza//+/VqzZo1WrVqlVatWKSoqSh06dLjnYH1kLcIOHCL1qofz589LknLlyiVJaQb+PexRiqzw/fffKzExUStWrLA5OnSvQ9vpcXZ21uuvv24dAL18+XK9+eabd/0iTpV6Vc7Ro0dtrixJSkrSqVOnHBaWAgIC9OuvvyolJcXm6M6RI0es0293/PjxNMs4duzYPe9GW6xYMRmGoaJFi6pkyZL2KTyTqlWrpmrVqmnkyJGaP3++2rVrpwULFticVs2M5ORkzZ8/X+7u7qpevbqdq/2fYsWKKSUlRb/99psqVKhw1365cuVK83OYlJRk/Vm9l3udDitbtqwqVqyoefPmqXDhwjp79qzdbixarFgxrV+/Xi+99NJ9g7iHh4caNWqkxYsXa/z48Vq4cKFefvllFSxY0GZ5D7Ofubi4qHHjxmrcuLFSUlL01ltv6YsvvtCHH374WAdaM+M0FrLUpk2b0v1rOXVcRuqpGG9vb+XNmzfNVVNTp07N+iIzKTWM3L5dcXFxioqKyvSy2rdvr8uXL6t79+5KSEjI0PiF0NBQubi4aPLkyTY1fPXVV4qLi1PDhg0zXYc9NGjQQLGxsVq4cKG17datW5oyZYo8PT2tl0inWr58uf7880/r+59++km7d+9W/fr177qO5s2by9nZWcOHD0+zXxmGof/85z922pq0Ll++nGadqaHhQU9lJScnq0+fPjp8+LD69Okjb2/vhy3zrpo2bSonJyd9/PHHaY4+3r5dxYoVS/Nz+OWXX2boyI6Hh0ea07i3a9++vdauXauJEycqT5489/y/zoxWrVopOTlZI0aMSDPt1q1bacJb69atde7cOf3f//2ffvnlF5tTWNLD7Wd3TnNyctJzzz0n6cH3Ezw8juwgS/Xu3VvXr19Xs2bNVKpUKSUlJWnHjh1auHChAgMDbQa5du3aVaNHj1bXrl1VuXJlbd26VceOHXNg9emrW7eu9S+31JAyY8YM5c+fP0N//d6uYsWKKlu2rBYvXqzSpUvr+eefv+88+fLl05AhQzR8+HDVq1dPr776qo4ePaqpU6eqSpUqdhnw+SC6deumL774Qh07dlR0dLQCAwO1ZMkSbd++XRMnTkwzHqV48eKqXr26evbsqcTEROsX4KBBg+66jmLFiumTTz7RkCFDdPr0aTVt2lReXl46deqUli1bpm7duuntt9/Oku2bPXu2pk6dqmbNmqlYsWK6evWqZsyYIW9vbzVo0OC+88fFxWnu3LmS/rkJY+odlE+ePKk2bdqk+0VtT8WLF9f777+vESNG6OWXX1bz5s3l6uqqPXv2qGDBgtZ73XTt2tV6M8k6derol19+0Zo1a+57alOSKlWqpIULF2rAgAGqUqWKPD091bhxY+v0119/XYMGDdKyZcvUs2dPmwsE7mfv3r365JNP0rTXrFlTISEh6t69uyIjI7V//37VrVtX2bNn1/Hjx7V48WJNmjRJr732mnWeBg0ayMvLS2+//bacnZ3VokULm2U+zH7WtWtX/f3336pVq5YKFy6sM2fOaMqUKapQoYJ1/Boc4NFe/IWnzapVq4zOnTsbpUqVMjw9PQ0XFxejePHiRu/evY0LFy7Y9L1+/brRpUsXw8fHx/Dy8jJatWplXLx48a6Xnt95OXV4eLjh4eGRpoY7L/u926W6UVFR6V5anN76VqxYYTz33HNGjhw5jMDAQGPMmDHGzJkzDUnGqVOnrP0CAgKMhg0b3vMzGjt2rCHJGDVq1D373emzzz4zSpUqZWTPnt3w9fU1evbsaVy+fPm+td9NRvve6zLqCxcuGJ06dTLy5s1ruLi4GOXKlUtzOfftl1CPGzfO8Pf3N1xdXY2XX37Z+OWXX9Kt6U7ffvutUb16dcPDw8Pw8PAwSpUqZURERBhHjx69b513+z/RfS5v3rdvn9G2bVujSJEihqurq5E/f36jUaNGxt69e+86z+21SLK+PD09jRIlShhvvPGGsXbt2nTnsfel56lmzpxpVKxY0XB1dTVy5cplhISEGOvWrbNOT05ONt59910jb968hru7uxEWFmacOHEiQ5eeJyQkGK+//rqRM2dOQ1K6l6E3aNDAkGTs2LHjHp+Yrds/uztfI0aMsPb78ssvjUqVKhlubm6Gl5eXUa5cOWPQoEHGuXPn0iyzXbt2hiQjNDT0ruvNyH5256XnS5YsMerWrWvkz5/fcHFxMYoUKWJ0797dOH/+fIa3F/ZnMYx7jMgDkOUmTZqk/v376/Tp02muEAPMplmzZjpw4IBOnDjh6FLwFGHMDuBAhmHoq6++UkhICEEHpnf+/HmtXLnyvrdXAOyNMTuAA1y7dk0rVqzQpk2bdODAAX333XeOLgnIMqdOndL27dv1f//3f8qePbu6d+/u6JLwlCHsAA7w119/6fXXX1fOnDn13nvv6dVXX3V0SUCW2bJlizp16qQiRYpo9uzZ8vPzc3RJeMowZgcAAJgaY3YAAICpEXYAAICpMWZH/zwH5dy5c/Ly8sryp/8CAAD7MAxDV69eVcGCBdM8hPh2hB1J586dS/MUZAAA8GSIiYlR4cKF7zqdsCNZb2MfExOTpc+mAQAA9hMfHy9/f/80j6O5E2FH/3tSr7e3N2EHAIAnzP2GoDBAGQAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmBphBwAAmFo2RxdgdqN/vuToEuBggyvmdXQJAPBU48gOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNcIOAAAwNYeGneTkZH344YcqWrSo3NzcVKxYMY0YMUKGYVj7GIahjz76SAUKFJCbm5tCQ0N1/Phxm+X8/fffateunby9vZUzZ0516dJFCQkJj3pzAADAY8ihYWfMmDGaNm2aPvvsMx0+fFhjxozR2LFjNWXKFGufsWPHavLkyZo+fbp2794tDw8PhYWF6caNG9Y+7dq106FDh7Ru3Tr98MMP2rp1q7p16+aITQIAAI8Zi3H7YZRHrFGjRvL19dVXX31lbWvRooXc3Nw0d+5cGYahggULauDAgXr77bclSXFxcfL19dWsWbPUpk0bHT58WEFBQdqzZ48qV64sSVq9erUaNGigP/74QwULFrxvHfHx8fLx8VFcXJy8vb3tuo2jf75k1+XhyTO4Yl5HlwAAppTR72+HHtl58cUXtWHDBh07dkyS9Msvv+jf//636tevL0k6deqUYmNjFRoaap3Hx8dHVatW1c6dOyVJO3fuVM6cOa1BR5JCQ0Pl5OSk3bt3p7vexMRExcfH27wAAIA5ZXPkygcPHqz4+HiVKlVKzs7OSk5O1siRI9WuXTtJUmxsrCTJ19fXZj5fX1/rtNjYWOXPn99merZs2ZQ7d25rnztFRkZq+PDh9t4cAADwGHLokZ1FixZp3rx5mj9/vvbt26fZs2frX//6l2bPnp2l6x0yZIji4uKsr5iYmCxdHwAAcByHHtl55513NHjwYLVp00aSVK5cOZ05c0aRkZEKDw+Xn5+fJOnChQsqUKCAdb4LFy6oQoUKkiQ/Pz9dvHjRZrm3bt3S33//bZ3/Tq6urnJ1dc2CLQIAAI8bhx7ZuX79upycbEtwdnZWSkqKJKlo0aLy8/PThg0brNPj4+O1e/duBQcHS5KCg4N15coVRUdHW/ts3LhRKSkpqlq16iPYCgAA8Dhz6JGdxo0ba+TIkSpSpIjKlCmjn3/+WePHj1fnzp0lSRaLRf369dMnn3yiEiVKqGjRovrwww9VsGBBNW3aVJJUunRp1atXT2+++aamT5+umzdvqlevXmrTpk2GrsQCAADm5tCwM2XKFH344Yd66623dPHiRRUsWFDdu3fXRx99ZO0zaNAgXbt2Td26ddOVK1dUvXp1rV69Wjly5LD2mTdvnnr16qXatWvLyclJLVq00OTJkx2xSQAA4DHj0PvsPC64zw6yEvfZAYCs8UTcZwcAACCrEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpEXYAAICpOTzs/Pnnn3rjjTeUJ08eubm5qVy5ctq7d691umEY+uijj1SgQAG5ubkpNDRUx48ft1nG33//rXbt2snb21s5c+ZUly5dlJCQ8Kg3BQAAPIYcGnYuX76sl156SdmzZ9eqVav022+/ady4ccqVK5e1z9ixYzV58mRNnz5du3fvloeHh8LCwnTjxg1rn3bt2unQoUNat26dfvjhB23dulXdunVzxCYBAIDHjMUwDMNRKx88eLC2b9+ubdu2pTvdMAwVLFhQAwcO1Ntvvy1JiouLk6+vr2bNmqU2bdro8OHDCgoK0p49e1S5cmVJ0urVq9WgQQP98ccfKliw4H3riI+Pl4+Pj+Li4uTt7W2/DZQ0+udLdl0enjyDK+Z1dAkAYEoZ/f526JGdFStWqHLlymrZsqXy58+vihUrasaMGdbpp06dUmxsrEJDQ61tPj4+qlq1qnbu3ClJ2rlzp3LmzGkNOpIUGhoqJycn7d69O931JiYmKj4+3uYFAADMyaFh5/fff9e0adNUokQJrVmzRj179lSfPn00e/ZsSVJsbKwkydfX12Y+X19f67TY2Fjlz5/fZnq2bNmUO3dua587RUZGysfHx/ry9/e396YBAIDHhEPDTkpKip5//nmNGjVKFStWVLdu3fTmm29q+vTpWbreIUOGKC4uzvqKiYnJ0vUBAADHeeiwk5ycrP379+vy5cuZnrdAgQIKCgqyaStdurTOnj0rSfLz85MkXbhwwabPhQsXrNP8/Px08eJFm+m3bt3S33//be1zJ1dXV3l7e9u8AACAOWU67PTr109fffWVpH+CTkhIiJ5//nn5+/tr8+bNmVrWSy+9pKNHj9q0HTt2TAEBAZKkokWLys/PTxs2bLBOj4+P1+7duxUcHCxJCg4O1pUrVxQdHW3ts3HjRqWkpKhq1aqZ3TwAAGAymQ47S5YsUfny5SVJ33//vU6dOqUjR46of//+ev/99zO1rP79+2vXrl0aNWqUTpw4ofnz5+vLL79URESEJMlisahfv3765JNPtGLFCh04cEAdOnRQwYIF1bRpU0n/HAmqV6+e3nzzTf3000/avn27evXqpTZt2mToSiwAAGBumQ47ly5dsp4e+vHHH9WyZUuVLFlSnTt31oEDBzK1rCpVqmjZsmX65ptvVLZsWY0YMUITJ05Uu3btrH0GDRqk3r17q1u3bqpSpYoSEhK0evVq5ciRw9pn3rx5KlWqlGrXrq0GDRqoevXq+vLLLzO7aQAAwIQyfZ+dgIAAzZgxQ7Vr11bRokU1bdo0NWzYUIcOHVL16tUfaOyOo3GfHWQl7rMDAFkjo9/f2TK74E6dOqlVq1YqUKCALBaL9R44u3fvVqlSpR68YgAAgCyQ6bAzbNgwlS1bVjExMWrZsqVcXV0lSc7Ozho8eLDdCwQAAHgYmQ47X3/9tVq3bm0NOanatm2rBQsW2K0wAAAAe8j0AOVOnTopLi4uTfvVq1fVqVMnuxQFAABgL5kOO4ZhyGKxpGn/448/5OPjY5eiAAAA7CXDp7EqVqwoi8Uii8Wi2rVrK1u2/82anJysU6dOqV69ellSJAAAwIPKcNhJvYnf/v37FRYWJk9PT+s0FxcXBQYGqkWLFnYvEAAA4GFkOOwMHTpUkhQYGKjWrVvb3NQPAADgcZXpq7HCw8MlSUlJSbp48aJSUlJsphcpUsQ+lQEAANhBpsPO8ePH1blzZ+3YscOmPXXgcnJyst2KAwAAeFiZDjsdO3ZUtmzZ9MMPP1jvogwAAPC4ynTY2b9/v6Kjo3k0BAAAeCJk+j47QUFBunSJh1sCAIAnQ6bDzpgxYzRo0CBt3rxZ//nPfxQfH2/zAgAAeJxk+jRW6lPOa9eubdPOAGUAAPA4ynTY2bRpU1bUAQAAkCUyHXZCQkKyog4AAIAskemws3Xr1ntOr1GjxgMXAwAAYG+ZDjs1a9ZM03b7vXYYswMAAB4nmb4a6/LlyzavixcvavXq1apSpYrWrl2bFTUCAAA8sEwf2fHx8UnTVqdOHbm4uGjAgAGKjo62S2EAAAD2kOkjO3fj6+uro0eP2mtxAAAAdpHpIzu//vqrzXvDMHT+/HmNHj1aFSpUsFddAAAAdpHpsFOhQgVZLBYZhmHTXq1aNc2cOdNuhQEAANhDpsPOqVOnbN47OTkpX758ypEjh92KAgAAsJdMh52AgICsqAMAACBLPNAA5S1btqhx48YqXry4ihcvrldffVXbtm2zd20AAAAPLdNhZ+7cuQoNDZW7u7v69OmjPn36yM3NTbVr19b8+fOzokYAAIAHZjHuHGl8H6VLl1a3bt3Uv39/m/bx48drxowZOnz4sF0LfBTi4+Pl4+OjuLg4eXt723XZo3++ZNfl4ckzuGJeR5cAAKaU0e/vTB/Z+f3339W4ceM07a+++mqawcsAAACOlumw4+/vrw0bNqRpX79+vfz9/e1SFAAAgL1k+mqsgQMHqk+fPtq/f79efPFFSdL27ds1a9YsTZo0ye4FAgAAPIxMh52ePXvKz89P48aN06JFiyT9M45n4cKFatKkid0LBAAAeBiZDjuS1KxZMzVr1szetQAAANhdhsfsXL58WVOmTFF8fHyaaXFxcXedBgAA4EgZDjufffaZtm7dmu6lXT4+Ptq2bZumTJli1+IAAAAeVobDzrfffqsePXrcdXr37t21ZMkSuxQFAABgLxkOOydPnlSJEiXuOr1EiRI6efKkXYoCAACwlwyHHWdnZ507d+6u08+dOycnpwd61BYAAECWyXA6qVixopYvX37X6cuWLVPFihXtURMAAIDdZPjS8169eqlNmzYqXLiwevbsKWdnZ0lScnKypk6dqgkTJvAgUAAA8NjJcNhp0aKFBg0apD59+uj999/XM888I+mfZ2UlJCTonXfe0WuvvZZlhQIAADyITN1UcOTIkWrSpInmzZunEydOyDAMhYSE6PXXX9cLL7yQVTUCAAA8sEzfQfmFF14g2AAAgCcGl08BAABTI+wAAABTI+wAAABTI+wAAABTy/QAZUm6deuWNm/erJMnT+r111+Xl5eXzp07J29vb3l6etq7RgAPYfTPlxxdAhxscMW8ji4BcKhMh50zZ86oXr16Onv2rBITE1WnTh15eXlpzJgxSkxM1PTp07OiTgAAgAeS6dNYffv2VeXKlXX58mW5ublZ25s1a6YNGzbYtTgAAICHlekjO9u2bdOOHTvk4uJi0x4YGKg///zTboUBAADYQ6aP7KSkpCg5OTlN+x9//CEvLy+7FAUAAGAvmQ47devW1cSJE63vLRaLEhISNHToUDVo0MCetQEAADy0TJ/GGjdunMLCwhQUFKQbN27o9ddf1/Hjx5U3b1598803WVEjAADAA8t02ClcuLB++eUXLViwQL/++qsSEhLUpUsXtWvXzmbAMgAAwOPgge6zky1bNr3xxhv2rgUAAMDuMh12vv7663tO79ChwwMXAwAAYG+ZDjt9+/a1eX/z5k1dv35dLi4ucnd3J+wAAIDHSqavxrp8+bLNKyEhQUePHlX16tUZoAwAAB47dnkQaIkSJTR69Og0R30AAAAczW5PPc+WLZvOnTtnr8UBAADYRabH7KxYscLmvWEYOn/+vD777DO99NJLdisMAADAHjIddpo2bWrz3mKxKF++fKpVq5bGjRtnr7oAAADsItNhJyUlJSvqAAAAyBJ2G7MDAADwOMrQkZ0BAwZkeIHjx49/oEJGjx6tIUOGqG/fvtYHjd64cUMDBw7UggULlJiYqLCwME2dOlW+vr7W+c6ePauePXtq06ZN8vT0VHh4uCIjI5Ut2wPdHBoAAJhMhhLBzz//nKGFWSyWBypiz549+uKLL/Tcc8/ZtPfv318rV67U4sWL5ePjo169eql58+bavn27JCk5OVkNGzaUn5+fduzYofPnz6tDhw7Knj27Ro0a9UC1AAAAc8lQ2Nm0aVOWFZCQkKB27dppxowZ+uSTT6ztcXFx+uqrrzR//nzVqlVLkhQVFaXSpUtr165dqlatmtauXavffvtN69evl6+vrypUqKARI0bo3Xff1bBhw+Ti4pJldQMAgCeDw8fsREREqGHDhgoNDbVpj46O1s2bN23aS5UqpSJFimjnzp2SpJ07d6pcuXI2p7XCwsIUHx+vQ4cO3XWdiYmJio+Pt3kBAABzeqCBLXv37tWiRYt09uxZJSUl2UxbunRphpezYMEC7du3T3v27EkzLTY2Vi4uLsqZM6dNu6+vr2JjY619bg86qdNTp91NZGSkhg8fnuE6AQDAkyvTR3YWLFigF198UYcPH9ayZct08+ZNHTp0SBs3bpSPj0+GlxMTE6O+fftq3rx5ypEjR2bLeChDhgxRXFyc9RUTE/NI1w8AAB6dTIedUaNGacKECfr+++/l4uKiSZMm6ciRI2rVqpWKFCmS4eVER0fr4sWLev7555UtWzZly5ZNW7Zs0eTJk5UtWzb5+voqKSlJV65csZnvwoUL8vPzkyT5+fnpwoULaaanTrsbV1dXeXt727wAAIA5ZTrsnDx5Ug0bNpQkubi46Nq1a7JYLOrfv7++/PLLDC+ndu3aOnDggPbv3299Va5cWe3atbP+O3v27NqwYYN1nqNHj+rs2bMKDg6WJAUHB+vAgQO6ePGitc+6devk7e2toKCgzG4aAAAwoUyP2cmVK5euXr0qSSpUqJAOHjyocuXK6cqVK7p+/XqGl+Pl5aWyZcvatHl4eChPnjzW9i5dumjAgAHKnTu3vL291bt3bwUHB6tatWqSpLp16yooKEjt27fX2LFjFRsbqw8++EARERFydXXN7KYBAAATynTYqVGjhtatW6dy5cqpZcuW6tu3rzZu3Kh169apdu3adi1uwoQJcnJyUosWLWxuKpjK2dlZP/zwg3r27Kng4GB5eHgoPDxcH3/8sV3rAAAATy6LYRhGRjoePHhQZcuW1d9//60bN26oYMGCSklJ0dixY7Vjxw6VKFFCH3zwgXLlypXVNdtdfHy8fHx8FBcXZ/fxO6N/vmTX5eHJM7hiXoeun30Qjt4HgayS0e/vDB/Zee6551SlShV17dpVbdq0kSQ5OTlp8ODBD18tAABAFsnwAOUtW7aoTJkyGjhwoAoUKKDw8HBt27YtK2sDAAB4aBkOOy+//LJmzpyp8+fPa8qUKTp9+rRCQkJUsmRJjRkz5p438QMAAHCUTF967uHhoU6dOmnLli06duyYWrZsqc8//1xFihTRq6++mhU1AgAAPLCHejZW8eLF9d577+mDDz6Ql5eXVq5caa+6AAAA7OKBno0lSVu3btXMmTP17bffysnJSa1atVKXLl3sWRsAwAS4IhCOviIwU2Hn3LlzmjVrlmbNmqUTJ07oxRdf1OTJk9WqVSt5eHhkVY0AAAAPLMNhp379+lq/fr3y5s2rDh06qHPnznr22WezsjYAAICHluGwkz17di1ZskSNGjWSs7NzVtYEAABgNxkOOytWrMjKOgAAALLEQ12NBQAA8Lgj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFMj7AAAAFNzaNiJjIxUlSpV5OXlpfz586tp06Y6evSoTZ8bN24oIiJCefLkkaenp1q0aKELFy7Y9Dl79qwaNmwod3d35c+fX++8845u3br1KDcFAAA8phwadrZs2aKIiAjt2rVL69at082bN1W3bl1du3bN2qd///76/vvvtXjxYm3ZskXnzp1T8+bNrdOTk5PVsGFDJSUlaceOHZo9e7ZmzZqljz76yBGbBAAAHjPZHLny1atX27yfNWuW8ufPr+joaNWoUUNxcXH66quvNH/+fNWqVUuSFBUVpdKlS2vXrl2qVq2a1q5dq99++03r16+Xr6+vKlSooBEjRujdd9/VsGHD5OLi4ohNAwAAj4nHasxOXFycJCl37tySpOjoaN28eVOhoaHWPqVKlVKRIkW0c+dOSdLOnTtVrlw5+fr6WvuEhYUpPj5ehw4deoTVAwCAx5FDj+zcLiUlRf369dNLL72ksmXLSpJiY2Pl4uKinDlz2vT19fVVbGystc/tQSd1euq09CQmJioxMdH6Pj4+3l6bAQAAHjOPzZGdiIgIHTx4UAsWLMjydUVGRsrHx8f68vf3z/J1AgAAx3gswk6vXr30ww8/aNOmTSpcuLC13c/PT0lJSbpy5YpN/wsXLsjPz8/a586rs1Lfp/a505AhQxQXF2d9xcTE2HFrAADA48ShYccwDPXq1UvLli3Txo0bVbRoUZvplSpVUvbs2bVhwwZr29GjR3X27FkFBwdLkoKDg3XgwAFdvHjR2mfdunXy9vZWUFBQuut1dXWVt7e3zQsAAJiTQ8fsREREaP78+fruu+/k5eVlHWPj4+MjNzc3+fj4qEuXLhowYIBy584tb29v9e7dW8HBwapWrZokqW7dugoKClL79u01duxYxcbG6oMPPlBERIRcXV0duXkAAOAx4NCwM23aNElSzZo1bdqjoqLUsWNHSdKECRPk5OSkFi1aKDExUWFhYZo6daq1r7Ozs3744Qf17NlTwcHB8vDwUHh4uD7++ONHtRkAAOAx5tCwYxjGffvkyJFDn3/+uT7//PO79gkICNCPP/5oz9IAAIBJPBYDlAEAALIKYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJgaYQcAAJiaacLO559/rsDAQOXIkUNVq1bVTz/95OiSAADAY8AUYWfhwoUaMGCAhg4dqn379ql8+fIKCwvTxYsXHV0aAABwMFOEnfHjx+vNN99Up06dFBQUpOnTp8vd3V0zZ850dGkAAMDBnviwk5SUpOjoaIWGhlrbnJycFBoaqp07dzqwMgAA8DjI5ugCHtalS5eUnJwsX19fm3ZfX18dOXIk3XkSExOVmJhofR8XFydJio+Pt3t9NxKu2n2ZeLLEx7s4dP3sg2AfhKNl1T6Y+r1tGMY9+z3xYedBREZGavjw4Wna/f39HVANzC7tngY8WuyDcLSs3gevXr0qHx+fu05/4sNO3rx55ezsrAsXLti0X7hwQX5+funOM2TIEA0YMMD6PiUlRX///bfy5Mkji8WSpfU+beLj4+Xv76+YmBh5e3s7uhw8hdgH4Wjsg1nHMAxdvXpVBQsWvGe/Jz7suLi4qFKlStqwYYOaNm0q6Z/wsmHDBvXq1SvdeVxdXeXq6mrTljNnziyu9Onm7e3NDzkcin0QjsY+mDXudUQn1RMfdiRpwIABCg8PV+XKlfXCCy9o4sSJunbtmjp16uTo0gAAgIOZIuy0bt1af/31lz766CPFxsaqQoUKWr16dZpBywAA4OljirAjSb169brraSs4jqurq4YOHZrmtCHwqLAPwtHYBx3PYtzvei0AAIAn2BN/U0EAAIB7IewAAABTI+wAAABTI+wgS2zevFkWi0VXrlyRJM2aNYt7GQFABt35OxQPh7DzlOrYsaMsFot69OiRZlpERIQsFos6duxot/W1bt1ax44ds9vy8PRJ3WfvfNWrV8/RpeEp0LFjR+uNa29HKHkyEHaeYv7+/lqwYIH++9//Wttu3Lih+fPnq0iRInZdl5ubm/Lnz2/XZeLpU69ePZ0/f97m9c033zi6LOCBJSUlObqEpwJh5yn2/PPPy9/fX0uXLrW2LV26VEWKFFHFihWtbSkpKYqMjFTRokXl5uam8uXLa8mSJTbL+vHHH1WyZEm5ubnplVde0enTp22m33kaK72/kvr166eaNWta39esWVO9e/dWv379lCtXLvn6+mrGjBnWu2N7eXmpePHiWrVq1UN/FngyuLq6ys/Pz+aVK1cuSdL48eNVrlw5eXh4yN/fX2+99ZYSEhKs8545c0aNGzdWrly55OHhoTJlyujHH3+UYRgqXry4/vWvf9msa//+/bJYLDpx4sQj3UY8uf7zn/+obdu2KlSokNzd3VWuXLk0YbxmzZrq1auX+vXrp7x58yosLEzS/X+H4uEQdp5ynTt3VlRUlPX9zJkz0zxmIzIyUl9//bWmT5+uQ4cOqX///nrjjTe0ZcsWSVJMTIyaN2+uxo0ba//+/eratasGDx5sl/pmz56tvHnz6qefflLv3r3Vs2dPtWzZUi+++KL27dununXrqn379rp+/bpd1ocnl5OTkyZPnqxDhw5p9uzZ2rhxowYNGmSdHhERocTERG3dulUHDhzQmDFj5OnpKYvFkubnQJKioqJUo0YNFS9e/FFvCp5QN27cUKVKlbRy5UodPHhQ3bp1U/v27fXTTz/Z9Js9e7ZcXFy0fft2TZ8+PUt/h+L/M/BUCg8PN5o0aWJcvHjRcHV1NU6fPm2cPn3ayJEjh/HXX38ZTZo0McLDw40bN24Y7u7uxo4dO2zm79Kli9G2bVvDMAxjyJAhRlBQkM30d99915BkXL582TAMw4iKijJ8fHzSrP92ffv2NUJCQqzvQ0JCjOrVq1vf37p1y/Dw8DDat29vbTt//rwhydi5c+dDfBp4EoSHhxvOzs6Gh4eHzWvkyJHp9l+8eLGRJ08e6/ty5coZw4YNS7fvn3/+aTg7Oxu7d+82DMMwkpKSjLx58xqzZs2y/4bgiXS3/S9Hjhw2v+vu1LBhQ2PgwIHW9yEhIUbFihVt+mTkdygejmkeF4EHky9fPjVs2FCzZs2SYRhq2LCh8ubNa51+4sQJXb9+XXXq1LGZLykpyXqq6/Dhw6patarN9ODgYLvU99xzz1n/7ezsrDx58qhcuXLWttTnn128eNEu68Pj7ZVXXtG0adNs2nLnzi1JWr9+vSIjI3XkyBHFx8fr1q1bunHjhq5fvy53d3f16dNHPXv21Nq1axUaGqoWLVpY96+CBQuqYcOGmjlzpl544QV9//33SkxMVMuWLR/5NuLxld7+t3v3br3xxhuSpOTkZI0aNUqLFi3Sn3/+qaSkJCUmJsrd3d1mnkqVKtm8z8rfofgHYQfq3Lmz9blin3/+uc201DEPK1euVKFChWymPcxzXpycnGTc8aSSmzdvpumXPXt2m/cWi8WmzWKxSPpnXBHMz8PDI93TSqdPn1ajRo3Us2dPjRw5Urlz59a///1vdenSRUlJSXJ3d1fXrl0VFhamlStXau3atYqMjNS4cePUu3dvSVLXrl3Vvn17TZgwQVFRUWrdunWaLyk83dLb//744w/rvz/99FNNmjRJEydOtI4f69evX5pByB4eHo+kXvwPYQeqV6+ekpKSZLFYrIPlUgUFBcnV1VVnz55VSEhIuvOXLl1aK1assGnbtWvXPdeZL18+HTx40KZt//79acINkBHR0dFKSUnRuHHj5OT0z1DERYsWpenn7++vHj16qEePHhoyZIhmzJhhDTsNGjSQh4eHpk2bptWrV2vr1q2PdBvw5Nu+fbuaNGliPdKTkpKiY8eOKSgo6J7zPcjvUGQOA5QhZ2dnHT58WL/99pucnZ1tpnl5eentt99W//79NXv2bJ08eVL79u3TlClTNHv2bElSjx49dPz4cb3zzjs6evSo5s+fr1mzZt1znbVq1dLevXv19ddf6/jx4xo6dGia8APcKTExUbGxsTavS5cuqXjx4rp586amTJmi33//XXPmzNH06dNt5u3Xr5/WrFmjU6dOad++fdq0aZNKly5tne7s7KyOHTtqyJAhKlGiBKcRkGklSpTQunXrtGPHDh0+fFjdu3fXhQsX7jvfg/wOReYQdiBJ8vb2lre3d7rTRowYoQ8//FCRkZEqXbq06tWrp5UrV6po0aKSpCJFiujbb7/V8uXLVb58eU2fPl2jRo265/rCwsL04YcfatCgQapSpYquXr2qDh062H27YC6rV69WgQIFbF7Vq1dX+fLlNX78eI0ZM0Zly5bVvHnzFBkZaTNvcnKyIiIirPtwyZIlNXXqVJs+qae97rwiEciIDz74QM8//7zCwsJUs2ZN+fn5pXsjwjs9yO9QZI7FuHPgBAA8pbZt26batWsrJibGOvgdwJOPsAPgqZeYmKi//vpL4eHh8vPz07x58xxdEgA74jQWgKfeN998o4CAAF25ckVjx451dDkA7IwjOwAAwNQ4sgMAAEyNsAMAAEyNsAMAAEyNsAMAAEyNsAPgsWOxWLR8+XLr+yNHjqhatWrKkSOHKlSokG7b6dOnZbFYtH//frvVERgYqIkTJ9pteQAcg7AD4JHp2LGjLBaL9YGuvr6+qlOnjmbOnGnzMNfz58+rfv361vdDhw6Vh4eHjh49qg0bNqTb5u/vr/Pnz6ts2bJZVv+dIQzAk4GwA+CRqlevns6fP6/Tp09r1apVeuWVV9S3b181atRIt27dkiT5+fnJ1dXVOs/JkydVvXp1BQQEKE+ePOm2OTs7y8/PT9my8XxjALYIOwAeKVdXV/n5+alQoUJ6/vnn9d577+m7777TqlWrrA8/vP0IisViUXR0tD7++GNZLBYNGzYs3bb0TmMdOnRIjRo1kre3t7y8vPTyyy/r5MmTkqSaNWuqX79+NrU1bdpUHTt2TLfuwMBASVKzZs1ksVgUGBio06dPy8nJSXv37rXpO3HiRAUEBNgcrQLgOIQdAA5Xq1YtlS9fXkuXLk0z7fz58ypTpowGDhyo8+fP6+2330637U5//vmnatSoIVdXV23cuFHR0dHq3Lmz9ehRZu3Zs0eSFBUVpfPnz2vPnj0KDAxUaGiooqKibPpGRUWpY8eOcnLiVyzwOOB4L4DHQqlSpfTrr7+maU89NeXp6Sk/Pz9JkqenZ5q2S5cu2cz3+eefy8fHRwsWLFD27NklSSVLlnzg+vLlyydJypkzp3WdktS1a1f16NFD48ePl6urq/bt26cDBw7ou+++e+B1AbAv/uwA8FgwDEMWi8Vuy9u/f79efvlla9DJKk2bNpWzs7OWLVsmSZo1a5ZeeeUV62kvAI5H2AHwWDh8+LCKFi1qt+W5ubndc7qTk5PufDTgzZs3M70eFxcXdejQQVFRUUpKStL8+fPVuXPnTC8HQNYh7ABwuI0bN+rAgQNq0aKF3Zb53HPPadu2bXcNMPny5dP58+et75OTk3Xw4MF7LjN79uxKTk5O0961a1etX79eU6dO1a1bt9S8efOHKx6AXRF2ADxSiYmJio2N1Z9//ql9+/Zp1KhRatKkiRo1aqQOHTrYbT29evVSfHy82rRpo7179+r48eOaM2eOjh49KumfQdErV67UypUrdeTIEfXs2VNXrly55zIDAwO1YcMGxcbG6vLly9b20qVLq1q1anr33XfVtm3b+x5VAvBoEXYAPFKrV69WgQIFFBgYqHr16mnTpk2aPHmyvvvuOzk7O9ttPXny5NHGjRuVkJCgkJAQVapUSTNmzLCO4encubPCw8PVoUMHhYSE6JlnntErr7xyz2WOGzdO69atk7+/vypWrGgzrUuXLkpKSuIUFvAYshh3nrQGAGTaiBEjtHjx4nSvKAPgWBzZAYCHkJCQoIMHD+qzzz5T7969HV0OgHQQdgDgIfTq1UuVKlVSzZo1OYUFPKY4jQUAAEyNIzsAAMDUCDsAAMDUCDsAAMDUCDsAAMDUCDsAAMDUCDsAAMDUCDsAAMDUCDsAAMDUCDsAAMDU/h/utRbkqf4evgAAAABJRU5ErkJggg==",
      "text/plain": [
       "<Figure size 640x480 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.bar(merged[\"Difficulty Level\"].value_counts().index, merged[\"Difficulty Level\"].value_counts().values, color='skyblue')\n",
    "\n",
    "plt.xlabel('Difficulty')\n",
    "plt.ylabel('Value Counts')\n",
    "plt.title(\"Summary of Problem's Difficulty Levels\")\n",
    "\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 313,
   "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>Question Title</th>\n",
       "      <th>Question Text</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Question ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Two Sum</td>\n",
       "      <td>Given an array of integers nums and an integer...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Add Two Numbers</td>\n",
       "      <td>You are given two non-empty linked lists repre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Longest Substring Without Repeating Characters</td>\n",
       "      <td>Given a string s, find the length of the longe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Median of Two Sorted Arrays</td>\n",
       "      <td>Given two sorted arrays nums1 and nums2 of siz...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Longest Palindromic Substring</td>\n",
       "      <td>Given a string s, return the longest palindrom...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Question Title  \\\n",
       "Question ID                                                   \n",
       "1                                                   Two Sum   \n",
       "2                                           Add Two Numbers   \n",
       "3            Longest Substring Without Repeating Characters   \n",
       "4                               Median of Two Sorted Arrays   \n",
       "5                             Longest Palindromic Substring   \n",
       "\n",
       "                                                 Question Text  \n",
       "Question ID                                                     \n",
       "1            Given an array of integers nums and an integer...  \n",
       "2            You are given two non-empty linked lists repre...  \n",
       "3            Given a string s, find the length of the longe...  \n",
       "4            Given two sorted arrays nums1 and nums2 of siz...  \n",
       "5            Given a string s, return the longest palindrom...  "
      ]
     },
     "execution_count": 313,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_only_important_cols = merged[['Question Title', 'Question Text']].copy()\n",
    "merged_only_important_cols.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 314,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Solution_Exists\n",
      "True     1060\n",
      "False     681\n",
      "Name: count, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "python_solution_path = \"./leetcode/solutions/python3/\"\n",
    "\n",
    "merged_only_important_cols['Solution_Path'] = merged_only_important_cols['Question Title'].str.lower()\n",
    "merged_only_important_cols['Solution_Path'] = merged_only_important_cols['Solution_Path'].apply(lambda x: python_solution_path + \"-\".join(x.split()) + \".py\")\n",
    "merged_only_important_cols[\"Solution_Exists\"] = merged_only_important_cols['Solution_Path'].apply(lambda x: os.path.isfile(x))\n",
    "print(merged_only_important_cols['Solution_Exists'].value_counts())\n",
    "final_merged = merged_only_important_cols[merged_only_important_cols['Solution_Exists'] == True].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 315,
   "metadata": {},
   "outputs": [],
   "source": [
    "def delete_comments(path):\n",
    "    with open(path, 'r') as file:\n",
    "        lines = file.readlines()\n",
    "\n",
    "    with open(path, 'w') as file:\n",
    "        for line in lines:\n",
    "            if not line.strip().startswith(\"#\"):\n",
    "                file.write(line)\n",
    "        \n",
    "for path in final_merged[\"Solution_Path\"]:\n",
    "    delete_comments(path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 316,
   "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>Question Title</th>\n",
       "      <th>Question Text</th>\n",
       "      <th>Solution_Path</th>\n",
       "      <th>Solution_Exists</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Question ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Two Sum</td>\n",
       "      <td>Given an array of integers nums and an integer...</td>\n",
       "      <td>./leetcode/solutions/python3/two-sum.py</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Add Two Numbers</td>\n",
       "      <td>You are given two non-empty linked lists repre...</td>\n",
       "      <td>./leetcode/solutions/python3/add-two-numbers.py</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Longest Substring Without Repeating Characters</td>\n",
       "      <td>Given a string s, find the length of the longe...</td>\n",
       "      <td>./leetcode/solutions/python3/longest-substring...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Median of Two Sorted Arrays</td>\n",
       "      <td>Given two sorted arrays nums1 and nums2 of siz...</td>\n",
       "      <td>./leetcode/solutions/python3/median-of-two-sor...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Longest Palindromic Substring</td>\n",
       "      <td>Given a string s, return the longest palindrom...</td>\n",
       "      <td>./leetcode/solutions/python3/longest-palindrom...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Question Title  \\\n",
       "Question ID                                                   \n",
       "1                                                   Two Sum   \n",
       "2                                           Add Two Numbers   \n",
       "3            Longest Substring Without Repeating Characters   \n",
       "4                               Median of Two Sorted Arrays   \n",
       "5                             Longest Palindromic Substring   \n",
       "\n",
       "                                                 Question Text  \\\n",
       "Question ID                                                      \n",
       "1            Given an array of integers nums and an integer...   \n",
       "2            You are given two non-empty linked lists repre...   \n",
       "3            Given a string s, find the length of the longe...   \n",
       "4            Given two sorted arrays nums1 and nums2 of siz...   \n",
       "5            Given a string s, return the longest palindrom...   \n",
       "\n",
       "                                                 Solution_Path  \\\n",
       "Question ID                                                      \n",
       "1                      ./leetcode/solutions/python3/two-sum.py   \n",
       "2              ./leetcode/solutions/python3/add-two-numbers.py   \n",
       "3            ./leetcode/solutions/python3/longest-substring...   \n",
       "4            ./leetcode/solutions/python3/median-of-two-sor...   \n",
       "5            ./leetcode/solutions/python3/longest-palindrom...   \n",
       "\n",
       "             Solution_Exists  \n",
       "Question ID                   \n",
       "1                       True  \n",
       "2                       True  \n",
       "3                       True  \n",
       "4                       True  \n",
       "5                       True  "
      ]
     },
     "execution_count": 316,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_merged.to_csv(\"merged.csv\")\n",
    "final_merged.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 320,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "True\n",
      "./leetcode/solutions/python3/3sum-closest.py\n"
     ]
    }
   ],
   "source": [
    "test = final_merged.iloc[14, -2]\n",
    "print(os.path.isfile(test))\n",
    "print(test)"
   ]
  }
 ],
 "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.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}