TIL/2024-04-25-search-documents-with-scikit-learn.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "4ec12f91-942f-4040-94b4-82376878d0de",
   "metadata": {},
   "source": "# Keyword search on a list of documents (with scikit-learn)"
  },
  {
   "cell_type": "code",
   "id": "9d62b61c-dc4f-4093-96cd-114a2b2415c3",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-07-03T11:57:20.722602Z",
     "start_time": "2024-07-03T11:57:20.718283Z"
    }
   },
   "source": [
    "documents = [\n",
    "  {\"id\": 1, \"text\": \"Programming requires logical thinking and problem-solving skills.\"},\n",
    "  {\"id\": 2, \"text\": \"Learning to code improves problem-solving and logical thinking abilities.\"},\n",
    "  {\"id\": 3, \"text\": \"Logical thinking is essential for writing efficient code.\"},\n",
    "  {\"id\": 4, \"text\": \"Effective programming involves solving complex problems logically.\"},\n",
    "  {\"id\": 5, \"text\": \"Developing software enhances problem-solving and logical thinking.\"}\n",
    "]"
   ],
   "outputs": [],
   "execution_count": 1
  },
  {
   "metadata": {},
   "cell_type": "markdown",
   "source": "## Convert the documents to a matrix of token counts",
   "id": "a39b088dbe03946c"
  },
  {
   "metadata": {},
   "cell_type": "markdown",
   "source": [
    "Install packages\n",
    "\n",
    "    pip install scikit-learn pandas numpy\n",
    "    \n"
   ],
   "id": "212a7867-8c15-47c0-8cea-b2527cf58d89"
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-07-03T11:57:21.219618Z",
     "start_time": "2024-07-03T11:57:20.723377Z"
    }
   },
   "cell_type": "code",
   "source": [
    "import pandas as pd\n",
    "from sklearn.feature_extraction.text import CountVectorizer"
   ],
   "id": "4df014fd62bcfa96",
   "outputs": [],
   "execution_count": 2
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-07-03T11:57:21.228522Z",
     "start_time": "2024-07-03T11:57:21.220826Z"
    }
   },
   "cell_type": "code",
   "source": [
    "df = pd.DataFrame(documents)\n",
    "df"
   ],
   "id": "bf1483653ae672f4",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "   id                                               text\n",
       "0   1  Programming requires logical thinking and prob...\n",
       "1   2  Learning to code improves problem-solving and ...\n",
       "2   3  Logical thinking is essential for writing effi...\n",
       "3   4  Effective programming involves solving complex...\n",
       "4   5  Developing software enhances problem-solving a..."
      ],
      "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>text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Programming requires logical thinking and prob...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Learning to code improves problem-solving and ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Logical thinking is essential for writing effi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Effective programming involves solving complex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Developing software enhances problem-solving a...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 3
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-07-03T11:57:21.235245Z",
     "start_time": "2024-07-03T11:57:21.229146Z"
    }
   },
   "cell_type": "code",
   "source": "df[\"text\"].tolist()",
   "id": "2718cfd3f787a092",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Programming requires logical thinking and problem-solving skills.',\n",
       " 'Learning to code improves problem-solving and logical thinking abilities.',\n",
       " 'Logical thinking is essential for writing efficient code.',\n",
       " 'Effective programming involves solving complex problems logically.',\n",
       " 'Developing software enhances problem-solving and logical thinking.']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 4
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-07-03T11:57:21.239547Z",
     "start_time": "2024-07-03T11:57:21.236177Z"
    }
   },
   "cell_type": "code",
   "source": [
    "count_vectorizer = CountVectorizer(binary=True)\n",
    "count_vectorizer.fit(df[\"text\"].tolist())\n",
    "count_vectorizer.get_feature_names_out()"
   ],
   "id": "f40b3c3d6596910",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['abilities', 'and', 'code', 'complex', 'developing', 'effective',\n",
       "       'efficient', 'enhances', 'essential', 'for', 'improves',\n",
       "       'involves', 'is', 'learning', 'logical', 'logically', 'problem',\n",
       "       'problems', 'programming', 'requires', 'skills', 'software',\n",
       "       'solving', 'thinking', 'to', 'writing'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 5
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-07-03T11:57:21.248875Z",
     "start_time": "2024-07-03T11:57:21.240212Z"
    }
   },
   "cell_type": "code",
   "source": [
    "corpus = df['text'].tolist()\n",
    "matrix = count_vectorizer.transform(corpus)\n",
    "tokens = sorted(count_vectorizer.vocabulary_.keys(), key=lambda token: count_vectorizer.vocabulary_[token])\n",
    "fit = pd.DataFrame(matrix.toarray(), columns=tokens)\n",
    "fit[\"text\"] = df[\"text\"]\n",
    "fit.set_index(\"text\", inplace=True)\n",
    "fit"
   ],
   "id": "3bb62ead60fe61b4",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                                                    abilities  and  code  \\\n",
       "text                                                                       \n",
       "Programming requires logical thinking and probl...          0    1     0   \n",
       "Learning to code improves problem-solving and l...          1    1     1   \n",
       "Logical thinking is essential for writing effic...          0    0     1   \n",
       "Effective programming involves solving complex ...          0    0     0   \n",
       "Developing software enhances problem-solving an...          0    1     0   \n",
       "\n",
       "                                                    complex  developing  \\\n",
       "text                                                                      \n",
       "Programming requires logical thinking and probl...        0           0   \n",
       "Learning to code improves problem-solving and l...        0           0   \n",
       "Logical thinking is essential for writing effic...        0           0   \n",
       "Effective programming involves solving complex ...        1           0   \n",
       "Developing software enhances problem-solving an...        0           1   \n",
       "\n",
       "                                                    effective  efficient  \\\n",
       "text                                                                       \n",
       "Programming requires logical thinking and probl...          0          0   \n",
       "Learning to code improves problem-solving and l...          0          0   \n",
       "Logical thinking is essential for writing effic...          0          1   \n",
       "Effective programming involves solving complex ...          1          0   \n",
       "Developing software enhances problem-solving an...          0          0   \n",
       "\n",
       "                                                    enhances  essential  for  \\\n",
       "text                                                                           \n",
       "Programming requires logical thinking and probl...         0          0    0   \n",
       "Learning to code improves problem-solving and l...         0          0    0   \n",
       "Logical thinking is essential for writing effic...         0          1    1   \n",
       "Effective programming involves solving complex ...         0          0    0   \n",
       "Developing software enhances problem-solving an...         1          0    0   \n",
       "\n",
       "                                                    ...  problem  problems  \\\n",
       "text                                                ...                      \n",
       "Programming requires logical thinking and probl...  ...        1         0   \n",
       "Learning to code improves problem-solving and l...  ...        1         0   \n",
       "Logical thinking is essential for writing effic...  ...        0         0   \n",
       "Effective programming involves solving complex ...  ...        0         1   \n",
       "Developing software enhances problem-solving an...  ...        1         0   \n",
       "\n",
       "                                                    programming  requires  \\\n",
       "text                                                                        \n",
       "Programming requires logical thinking and probl...            1         1   \n",
       "Learning to code improves problem-solving and l...            0         0   \n",
       "Logical thinking is essential for writing effic...            0         0   \n",
       "Effective programming involves solving complex ...            1         0   \n",
       "Developing software enhances problem-solving an...            0         0   \n",
       "\n",
       "                                                    skills  software  solving  \\\n",
       "text                                                                            \n",
       "Programming requires logical thinking and probl...       1         0        1   \n",
       "Learning to code improves problem-solving and l...       0         0        1   \n",
       "Logical thinking is essential for writing effic...       0         0        0   \n",
       "Effective programming involves solving complex ...       0         0        1   \n",
       "Developing software enhances problem-solving an...       0         1        1   \n",
       "\n",
       "                                                    thinking  to  writing  \n",
       "text                                                                       \n",
       "Programming requires logical thinking and probl...         1   0        0  \n",
       "Learning to code improves problem-solving and l...         1   1        0  \n",
       "Logical thinking is essential for writing effic...         1   0        1  \n",
       "Effective programming involves solving complex ...         0   0        0  \n",
       "Developing software enhances problem-solving an...         1   0        0  \n",
       "\n",
       "[5 rows x 26 columns]"
      ],
      "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>abilities</th>\n",
       "      <th>and</th>\n",
       "      <th>code</th>\n",
       "      <th>complex</th>\n",
       "      <th>developing</th>\n",
       "      <th>effective</th>\n",
       "      <th>efficient</th>\n",
       "      <th>enhances</th>\n",
       "      <th>essential</th>\n",
       "      <th>for</th>\n",
       "      <th>...</th>\n",
       "      <th>problem</th>\n",
       "      <th>problems</th>\n",
       "      <th>programming</th>\n",
       "      <th>requires</th>\n",
       "      <th>skills</th>\n",
       "      <th>software</th>\n",
       "      <th>solving</th>\n",
       "      <th>thinking</th>\n",
       "      <th>to</th>\n",
       "      <th>writing</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>text</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>Programming requires logical thinking and problem-solving skills.</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Learning to code improves problem-solving and logical thinking abilities.</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Logical thinking is essential for writing efficient code.</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Effective programming involves solving complex problems logically.</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Developing software enhances problem-solving and logical thinking.</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 6
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-07-03T11:57:21.257864Z",
     "start_time": "2024-07-03T11:57:21.249569Z"
    }
   },
   "cell_type": "code",
   "source": [
    "query_vector = count_vectorizer.transform([\"logical thinking\"])\n",
    "a = matrix.dot(query_vector.T).todense()\n",
    "fit[\"score\"] = a.sum(axis=1)\n",
    "fit.sort_values(\"score\", ascending=False)"
   ],
   "id": "c896c7f1626a822c",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "                                                    abilities  and  code  \\\n",
       "text                                                                       \n",
       "Programming requires logical thinking and probl...          0    1     0   \n",
       "Learning to code improves problem-solving and l...          1    1     1   \n",
       "Logical thinking is essential for writing effic...          0    0     1   \n",
       "Developing software enhances problem-solving an...          0    1     0   \n",
       "Effective programming involves solving complex ...          0    0     0   \n",
       "\n",
       "                                                    complex  developing  \\\n",
       "text                                                                      \n",
       "Programming requires logical thinking and probl...        0           0   \n",
       "Learning to code improves problem-solving and l...        0           0   \n",
       "Logical thinking is essential for writing effic...        0           0   \n",
       "Developing software enhances problem-solving an...        0           1   \n",
       "Effective programming involves solving complex ...        1           0   \n",
       "\n",
       "                                                    effective  efficient  \\\n",
       "text                                                                       \n",
       "Programming requires logical thinking and probl...          0          0   \n",
       "Learning to code improves problem-solving and l...          0          0   \n",
       "Logical thinking is essential for writing effic...          0          1   \n",
       "Developing software enhances problem-solving an...          0          0   \n",
       "Effective programming involves solving complex ...          1          0   \n",
       "\n",
       "                                                    enhances  essential  for  \\\n",
       "text                                                                           \n",
       "Programming requires logical thinking and probl...         0          0    0   \n",
       "Learning to code improves problem-solving and l...         0          0    0   \n",
       "Logical thinking is essential for writing effic...         0          1    1   \n",
       "Developing software enhances problem-solving an...         1          0    0   \n",
       "Effective programming involves solving complex ...         0          0    0   \n",
       "\n",
       "                                                    ...  problems  \\\n",
       "text                                                ...             \n",
       "Programming requires logical thinking and probl...  ...         0   \n",
       "Learning to code improves problem-solving and l...  ...         0   \n",
       "Logical thinking is essential for writing effic...  ...         0   \n",
       "Developing software enhances problem-solving an...  ...         0   \n",
       "Effective programming involves solving complex ...  ...         1   \n",
       "\n",
       "                                                    programming  requires  \\\n",
       "text                                                                        \n",
       "Programming requires logical thinking and probl...            1         1   \n",
       "Learning to code improves problem-solving and l...            0         0   \n",
       "Logical thinking is essential for writing effic...            0         0   \n",
       "Developing software enhances problem-solving an...            0         0   \n",
       "Effective programming involves solving complex ...            1         0   \n",
       "\n",
       "                                                    skills  software  solving  \\\n",
       "text                                                                            \n",
       "Programming requires logical thinking and probl...       1         0        1   \n",
       "Learning to code improves problem-solving and l...       0         0        1   \n",
       "Logical thinking is essential for writing effic...       0         0        0   \n",
       "Developing software enhances problem-solving an...       0         1        1   \n",
       "Effective programming involves solving complex ...       0         0        1   \n",
       "\n",
       "                                                    thinking  to  writing  \\\n",
       "text                                                                        \n",
       "Programming requires logical thinking and probl...         1   0        0   \n",
       "Learning to code improves problem-solving and l...         1   1        0   \n",
       "Logical thinking is essential for writing effic...         1   0        1   \n",
       "Developing software enhances problem-solving an...         1   0        0   \n",
       "Effective programming involves solving complex ...         0   0        0   \n",
       "\n",
       "                                                    score  \n",
       "text                                                       \n",
       "Programming requires logical thinking and probl...      2  \n",
       "Learning to code improves problem-solving and l...      2  \n",
       "Logical thinking is essential for writing effic...      2  \n",
       "Developing software enhances problem-solving an...      2  \n",
       "Effective programming involves solving complex ...      0  \n",
       "\n",
       "[5 rows x 27 columns]"
      ],
      "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>abilities</th>\n",
       "      <th>and</th>\n",
       "      <th>code</th>\n",
       "      <th>complex</th>\n",
       "      <th>developing</th>\n",
       "      <th>effective</th>\n",
       "      <th>efficient</th>\n",
       "      <th>enhances</th>\n",
       "      <th>essential</th>\n",
       "      <th>for</th>\n",
       "      <th>...</th>\n",
       "      <th>problems</th>\n",
       "      <th>programming</th>\n",
       "      <th>requires</th>\n",
       "      <th>skills</th>\n",
       "      <th>software</th>\n",
       "      <th>solving</th>\n",
       "      <th>thinking</th>\n",
       "      <th>to</th>\n",
       "      <th>writing</th>\n",
       "      <th>score</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>text</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></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>Programming requires logical thinking and problem-solving skills.</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Learning to code improves problem-solving and logical thinking abilities.</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Logical thinking is essential for writing efficient code.</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Developing software enhances problem-solving and logical thinking.</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Effective programming involves solving complex problems logically.</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 7
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}