Clinical parameters Dataset - Data Cleaning code.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0a297a59",
   "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>№</th>\n",
       "      <th>Age</th>\n",
       "      <th>IVF/ICSI cycle</th>\n",
       "      <th>FSH, IU/L</th>\n",
       "      <th>LH, IU/L</th>\n",
       "      <th>AMH, ng/mL</th>\n",
       "      <th>Progesterone, nmol/L</th>\n",
       "      <th>Follicles obtained</th>\n",
       "      <th>LH/FSH ratio</th>\n",
       "      <th>FSHB c.-211 G&gt;T</th>\n",
       "      <th>FSHR c.2039 A&gt;G</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>7.30</td>\n",
       "      <td>2.42</td>\n",
       "      <td>1.19</td>\n",
       "      <td>8.20</td>\n",
       "      <td>10</td>\n",
       "      <td>0.331507</td>\n",
       "      <td>TT</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>8.80</td>\n",
       "      <td>6.90</td>\n",
       "      <td>5.90</td>\n",
       "      <td>4.70</td>\n",
       "      <td>14</td>\n",
       "      <td>0.784091</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>9.40</td>\n",
       "      <td>3.70</td>\n",
       "      <td>3.04</td>\n",
       "      <td>0.95</td>\n",
       "      <td>15</td>\n",
       "      <td>0.393617</td>\n",
       "      <td>GG</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>5.76</td>\n",
       "      <td>5.55</td>\n",
       "      <td>1.86</td>\n",
       "      <td>0.95</td>\n",
       "      <td>5</td>\n",
       "      <td>0.963542</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>6.35</td>\n",
       "      <td>8.80</td>\n",
       "      <td>2.25</td>\n",
       "      <td>0.90</td>\n",
       "      <td>4</td>\n",
       "      <td>1.385827</td>\n",
       "      <td>GT</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>140</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>6.90</td>\n",
       "      <td>11.10</td>\n",
       "      <td>3.80</td>\n",
       "      <td>11.70</td>\n",
       "      <td>2</td>\n",
       "      <td>1.608696</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>141</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>7.91</td>\n",
       "      <td>4.21</td>\n",
       "      <td>2.94</td>\n",
       "      <td>0.40</td>\n",
       "      <td>12</td>\n",
       "      <td>0.532238</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>142</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>5.67</td>\n",
       "      <td>3.98</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.70</td>\n",
       "      <td>4</td>\n",
       "      <td>0.701940</td>\n",
       "      <td>GT</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>143</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>8.18</td>\n",
       "      <td>11.20</td>\n",
       "      <td>10.02</td>\n",
       "      <td>1.85</td>\n",
       "      <td>20</td>\n",
       "      <td>1.369193</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>144</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>6.12</td>\n",
       "      <td>10.10</td>\n",
       "      <td>9.51</td>\n",
       "      <td>2.03</td>\n",
       "      <td>20</td>\n",
       "      <td>1.650327</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>144 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       №  Age  IVF/ICSI cycle  FSH, IU/L  LH, IU/L  AMH, ng/mL  \\\n",
       "0      1   35               1       7.30      2.42        1.19   \n",
       "1      2   33               1       8.80      6.90        5.90   \n",
       "2      3   38               1       9.40      3.70        3.04   \n",
       "3      4   30               1       5.76      5.55        1.86   \n",
       "4      5   34               1       6.35      8.80        2.25   \n",
       "..   ...  ...             ...        ...       ...         ...   \n",
       "139  140   33               1       6.90     11.10        3.80   \n",
       "140  141   34               2       7.91      4.21        2.94   \n",
       "141  142   34               1       5.67      3.98        1.32   \n",
       "142  143   34               1       8.18     11.20       10.02   \n",
       "143  144   34               2       6.12     10.10        9.51   \n",
       "\n",
       "     Progesterone, nmol/L  Follicles obtained  LH/FSH ratio FSHB c.-211 G>T  \\\n",
       "0                    8.20                  10      0.331507              TT   \n",
       "1                    4.70                  14      0.784091              GG   \n",
       "2                    0.95                  15      0.393617              GG   \n",
       "3                    0.95                   5      0.963542              GG   \n",
       "4                    0.90                   4      1.385827              GT   \n",
       "..                    ...                 ...           ...             ...   \n",
       "139                 11.70                   2      1.608696              GG   \n",
       "140                  0.40                  12      0.532238              GG   \n",
       "141                  0.70                   4      0.701940              GT   \n",
       "142                  1.85                  20      1.369193              GG   \n",
       "143                  2.03                  20      1.650327              GG   \n",
       "\n",
       "    FSHR c.2039 A>G  \n",
       "0                AG  \n",
       "1                AG  \n",
       "2                AA  \n",
       "3                GG  \n",
       "4                GG  \n",
       "..              ...  \n",
       "139              AG  \n",
       "140              AG  \n",
       "141              AA  \n",
       "142              GG  \n",
       "143              GG  \n",
       "\n",
       "[144 rows x 11 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import xlrd\n",
    "df = pd.read_excel(\"Clinical parameters Dataset.xlsx\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4da747d3",
   "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>№</th>\n",
       "      <th>Age</th>\n",
       "      <th>IVF/ICSI cycle</th>\n",
       "      <th>FSH, IU/L</th>\n",
       "      <th>LH, IU/L</th>\n",
       "      <th>AMH, ng/mL</th>\n",
       "      <th>Progesterone, nmol/L</th>\n",
       "      <th>Follicles obtained</th>\n",
       "      <th>LH/FSH ratio</th>\n",
       "      <th>FSHB c.-211 G&gt;T</th>\n",
       "      <th>FSHR c.2039 A&gt;G</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>7.30</td>\n",
       "      <td>2.42</td>\n",
       "      <td>1.19</td>\n",
       "      <td>8.20</td>\n",
       "      <td>10</td>\n",
       "      <td>0.331507</td>\n",
       "      <td>TT</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>8.80</td>\n",
       "      <td>6.90</td>\n",
       "      <td>5.90</td>\n",
       "      <td>4.70</td>\n",
       "      <td>14</td>\n",
       "      <td>0.784091</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>9.40</td>\n",
       "      <td>3.70</td>\n",
       "      <td>3.04</td>\n",
       "      <td>0.95</td>\n",
       "      <td>15</td>\n",
       "      <td>0.393617</td>\n",
       "      <td>GG</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>5.76</td>\n",
       "      <td>5.55</td>\n",
       "      <td>1.86</td>\n",
       "      <td>0.95</td>\n",
       "      <td>5</td>\n",
       "      <td>0.963542</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>6.35</td>\n",
       "      <td>8.80</td>\n",
       "      <td>2.25</td>\n",
       "      <td>0.90</td>\n",
       "      <td>4</td>\n",
       "      <td>1.385827</td>\n",
       "      <td>GT</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>138</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>6.20</td>\n",
       "      <td>6.25</td>\n",
       "      <td>4.24</td>\n",
       "      <td>1.50</td>\n",
       "      <td>7</td>\n",
       "      <td>1.008065</td>\n",
       "      <td>GT</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>139</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>4.25</td>\n",
       "      <td>4.09</td>\n",
       "      <td>4.50</td>\n",
       "      <td>1.27</td>\n",
       "      <td>4</td>\n",
       "      <td>0.962353</td>\n",
       "      <td>GT</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>140</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>6.90</td>\n",
       "      <td>11.10</td>\n",
       "      <td>3.80</td>\n",
       "      <td>11.70</td>\n",
       "      <td>2</td>\n",
       "      <td>1.608696</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>142</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>5.67</td>\n",
       "      <td>3.98</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.70</td>\n",
       "      <td>4</td>\n",
       "      <td>0.701940</td>\n",
       "      <td>GT</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>143</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>8.18</td>\n",
       "      <td>11.20</td>\n",
       "      <td>10.02</td>\n",
       "      <td>1.85</td>\n",
       "      <td>20</td>\n",
       "      <td>1.369193</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>129 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       №  Age  IVF/ICSI cycle  FSH, IU/L  LH, IU/L  AMH, ng/mL  \\\n",
       "0      1   35               1       7.30      2.42        1.19   \n",
       "1      2   33               1       8.80      6.90        5.90   \n",
       "2      3   38               1       9.40      3.70        3.04   \n",
       "3      4   30               1       5.76      5.55        1.86   \n",
       "4      5   34               1       6.35      8.80        2.25   \n",
       "..   ...  ...             ...        ...       ...         ...   \n",
       "137  138   33               1       6.20      6.25        4.24   \n",
       "138  139   39               1       4.25      4.09        4.50   \n",
       "139  140   33               1       6.90     11.10        3.80   \n",
       "141  142   34               1       5.67      3.98        1.32   \n",
       "142  143   34               1       8.18     11.20       10.02   \n",
       "\n",
       "     Progesterone, nmol/L  Follicles obtained  LH/FSH ratio FSHB c.-211 G>T  \\\n",
       "0                    8.20                  10      0.331507              TT   \n",
       "1                    4.70                  14      0.784091              GG   \n",
       "2                    0.95                  15      0.393617              GG   \n",
       "3                    0.95                   5      0.963542              GG   \n",
       "4                    0.90                   4      1.385827              GT   \n",
       "..                    ...                 ...           ...             ...   \n",
       "137                  1.50                   7      1.008065              GT   \n",
       "138                  1.27                   4      0.962353              GT   \n",
       "139                 11.70                   2      1.608696              GG   \n",
       "141                  0.70                   4      0.701940              GT   \n",
       "142                  1.85                  20      1.369193              GG   \n",
       "\n",
       "    FSHR c.2039 A>G  \n",
       "0                AG  \n",
       "1                AG  \n",
       "2                AA  \n",
       "3                GG  \n",
       "4                GG  \n",
       "..              ...  \n",
       "137              AG  \n",
       "138              AG  \n",
       "139              AG  \n",
       "141              AA  \n",
       "142              GG  \n",
       "\n",
       "[129 rows x 11 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Filter the DataFrame to keep only rows where the \"Type of ART\" column is 0 (IVF)\n",
    "df1 = df[df['IVF/ICSI cycle'] == 1]\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "7deaa7d0",
   "metadata": {
    "scrolled": false
   },
   "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>№</th>\n",
       "      <th>Age</th>\n",
       "      <th>IVF/ICSI cycle</th>\n",
       "      <th>FSH, IU/L</th>\n",
       "      <th>LH, IU/L</th>\n",
       "      <th>AMH, ng/mL</th>\n",
       "      <th>Progesterone, nmol/L</th>\n",
       "      <th>Follicles obtained</th>\n",
       "      <th>LH/FSH ratio</th>\n",
       "      <th>FSHB c.-211 G&gt;T</th>\n",
       "      <th>FSHR c.2039 A&gt;G</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>7.30</td>\n",
       "      <td>2.42</td>\n",
       "      <td>1.19</td>\n",
       "      <td>8.20</td>\n",
       "      <td>10</td>\n",
       "      <td>0.331507</td>\n",
       "      <td>TT</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>8.80</td>\n",
       "      <td>6.90</td>\n",
       "      <td>5.90</td>\n",
       "      <td>4.70</td>\n",
       "      <td>14</td>\n",
       "      <td>0.784091</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>9.40</td>\n",
       "      <td>3.70</td>\n",
       "      <td>3.04</td>\n",
       "      <td>0.95</td>\n",
       "      <td>15</td>\n",
       "      <td>0.393617</td>\n",
       "      <td>GG</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>5.76</td>\n",
       "      <td>5.55</td>\n",
       "      <td>1.86</td>\n",
       "      <td>0.95</td>\n",
       "      <td>5</td>\n",
       "      <td>0.963542</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>6.35</td>\n",
       "      <td>8.80</td>\n",
       "      <td>2.25</td>\n",
       "      <td>0.90</td>\n",
       "      <td>4</td>\n",
       "      <td>1.385827</td>\n",
       "      <td>GT</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>140</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>6.90</td>\n",
       "      <td>11.10</td>\n",
       "      <td>3.80</td>\n",
       "      <td>11.70</td>\n",
       "      <td>2</td>\n",
       "      <td>1.608696</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>141</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>7.91</td>\n",
       "      <td>4.21</td>\n",
       "      <td>2.94</td>\n",
       "      <td>0.40</td>\n",
       "      <td>12</td>\n",
       "      <td>0.532238</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>142</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>5.67</td>\n",
       "      <td>3.98</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.70</td>\n",
       "      <td>4</td>\n",
       "      <td>0.701940</td>\n",
       "      <td>GT</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>143</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>8.18</td>\n",
       "      <td>11.20</td>\n",
       "      <td>10.02</td>\n",
       "      <td>1.85</td>\n",
       "      <td>20</td>\n",
       "      <td>1.369193</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>144</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>6.12</td>\n",
       "      <td>10.10</td>\n",
       "      <td>9.51</td>\n",
       "      <td>2.03</td>\n",
       "      <td>20</td>\n",
       "      <td>1.650327</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>144 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       №  Age  IVF/ICSI cycle  FSH, IU/L  LH, IU/L  AMH, ng/mL  \\\n",
       "0      1   35               1       7.30      2.42        1.19   \n",
       "1      2   33               1       8.80      6.90        5.90   \n",
       "2      3   38               1       9.40      3.70        3.04   \n",
       "3      4   30               1       5.76      5.55        1.86   \n",
       "4      5   34               1       6.35      8.80        2.25   \n",
       "..   ...  ...             ...        ...       ...         ...   \n",
       "139  140   33               1       6.90     11.10        3.80   \n",
       "140  141   34               2       7.91      4.21        2.94   \n",
       "141  142   34               1       5.67      3.98        1.32   \n",
       "142  143   34               1       8.18     11.20       10.02   \n",
       "143  144   34               2       6.12     10.10        9.51   \n",
       "\n",
       "     Progesterone, nmol/L  Follicles obtained  LH/FSH ratio FSHB c.-211 G>T  \\\n",
       "0                    8.20                  10      0.331507              TT   \n",
       "1                    4.70                  14      0.784091              GG   \n",
       "2                    0.95                  15      0.393617              GG   \n",
       "3                    0.95                   5      0.963542              GG   \n",
       "4                    0.90                   4      1.385827              GT   \n",
       "..                    ...                 ...           ...             ...   \n",
       "139                 11.70                   2      1.608696              GG   \n",
       "140                  0.40                  12      0.532238              GG   \n",
       "141                  0.70                   4      0.701940              GT   \n",
       "142                  1.85                  20      1.369193              GG   \n",
       "143                  2.03                  20      1.650327              GG   \n",
       "\n",
       "    FSHR c.2039 A>G  \n",
       "0                AG  \n",
       "1                AG  \n",
       "2                AA  \n",
       "3                GG  \n",
       "4                GG  \n",
       "..              ...  \n",
       "139              AG  \n",
       "140              AG  \n",
       "141              AA  \n",
       "142              GG  \n",
       "143              GG  \n",
       "\n",
       "[144 rows x 11 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = df.dropna()\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7aa1e45a",
   "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>№</th>\n",
       "      <th>Age</th>\n",
       "      <th>IVF/ICSI cycle</th>\n",
       "      <th>FSH, IU/L</th>\n",
       "      <th>LH, IU/L</th>\n",
       "      <th>AMH, ng/mL</th>\n",
       "      <th>Progesterone, nmol/L</th>\n",
       "      <th>Follicles obtained</th>\n",
       "      <th>LH/FSH ratio</th>\n",
       "      <th>FSHB c.-211 G&gt;T</th>\n",
       "      <th>FSHR c.2039 A&gt;G</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>7.30</td>\n",
       "      <td>2.42</td>\n",
       "      <td>1.19</td>\n",
       "      <td>8.20</td>\n",
       "      <td>10</td>\n",
       "      <td>0.331507</td>\n",
       "      <td>TT</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>8.80</td>\n",
       "      <td>6.90</td>\n",
       "      <td>5.90</td>\n",
       "      <td>4.70</td>\n",
       "      <td>14</td>\n",
       "      <td>0.784091</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>38</td>\n",
       "      <td>1</td>\n",
       "      <td>9.40</td>\n",
       "      <td>3.70</td>\n",
       "      <td>3.04</td>\n",
       "      <td>0.95</td>\n",
       "      <td>15</td>\n",
       "      <td>0.393617</td>\n",
       "      <td>GG</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>5.76</td>\n",
       "      <td>5.55</td>\n",
       "      <td>1.86</td>\n",
       "      <td>0.95</td>\n",
       "      <td>5</td>\n",
       "      <td>0.963542</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>6.35</td>\n",
       "      <td>8.80</td>\n",
       "      <td>2.25</td>\n",
       "      <td>0.90</td>\n",
       "      <td>4</td>\n",
       "      <td>1.385827</td>\n",
       "      <td>GT</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>140</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>6.90</td>\n",
       "      <td>11.10</td>\n",
       "      <td>3.80</td>\n",
       "      <td>11.70</td>\n",
       "      <td>2</td>\n",
       "      <td>1.608696</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>141</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>7.91</td>\n",
       "      <td>4.21</td>\n",
       "      <td>2.94</td>\n",
       "      <td>0.40</td>\n",
       "      <td>12</td>\n",
       "      <td>0.532238</td>\n",
       "      <td>GG</td>\n",
       "      <td>AG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>142</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>5.67</td>\n",
       "      <td>3.98</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.70</td>\n",
       "      <td>4</td>\n",
       "      <td>0.701940</td>\n",
       "      <td>GT</td>\n",
       "      <td>AA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>143</td>\n",
       "      <td>34</td>\n",
       "      <td>1</td>\n",
       "      <td>8.18</td>\n",
       "      <td>11.20</td>\n",
       "      <td>10.02</td>\n",
       "      <td>1.85</td>\n",
       "      <td>20</td>\n",
       "      <td>1.369193</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>144</td>\n",
       "      <td>34</td>\n",
       "      <td>2</td>\n",
       "      <td>6.12</td>\n",
       "      <td>10.10</td>\n",
       "      <td>9.51</td>\n",
       "      <td>2.03</td>\n",
       "      <td>20</td>\n",
       "      <td>1.650327</td>\n",
       "      <td>GG</td>\n",
       "      <td>GG</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>144 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       №  Age  IVF/ICSI cycle  FSH, IU/L  LH, IU/L  AMH, ng/mL  \\\n",
       "0      1   35               1       7.30      2.42        1.19   \n",
       "1      2   33               1       8.80      6.90        5.90   \n",
       "2      3   38               1       9.40      3.70        3.04   \n",
       "3      4   30               1       5.76      5.55        1.86   \n",
       "4      5   34               1       6.35      8.80        2.25   \n",
       "..   ...  ...             ...        ...       ...         ...   \n",
       "139  140   33               1       6.90     11.10        3.80   \n",
       "140  141   34               2       7.91      4.21        2.94   \n",
       "141  142   34               1       5.67      3.98        1.32   \n",
       "142  143   34               1       8.18     11.20       10.02   \n",
       "143  144   34               2       6.12     10.10        9.51   \n",
       "\n",
       "     Progesterone, nmol/L  Follicles obtained  LH/FSH ratio FSHB c.-211 G>T  \\\n",
       "0                    8.20                  10      0.331507              TT   \n",
       "1                    4.70                  14      0.784091              GG   \n",
       "2                    0.95                  15      0.393617              GG   \n",
       "3                    0.95                   5      0.963542              GG   \n",
       "4                    0.90                   4      1.385827              GT   \n",
       "..                    ...                 ...           ...             ...   \n",
       "139                 11.70                   2      1.608696              GG   \n",
       "140                  0.40                  12      0.532238              GG   \n",
       "141                  0.70                   4      0.701940              GT   \n",
       "142                  1.85                  20      1.369193              GG   \n",
       "143                  2.03                  20      1.650327              GG   \n",
       "\n",
       "    FSHR c.2039 A>G  \n",
       "0                AG  \n",
       "1                AG  \n",
       "2                AA  \n",
       "3                GG  \n",
       "4                GG  \n",
       "..              ...  \n",
       "139              AG  \n",
       "140              AG  \n",
       "141              AA  \n",
       "142              GG  \n",
       "143              GG  \n",
       "\n",
       "[144 rows x 11 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.to_excel('dataset2_for_mp.xlsx', index=False)\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "20d2483d",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "             Column Name Data Type  \\\n",
      "0                      №     int64   \n",
      "1                    Age     int64   \n",
      "2         IVF/ICSI cycle     int64   \n",
      "3              FSH, IU/L   float64   \n",
      "4               LH, IU/L   float64   \n",
      "5             AMH, ng/mL   float64   \n",
      "6   Progesterone, nmol/L   float64   \n",
      "7     Follicles obtained     int64   \n",
      "8           LH/FSH ratio   float64   \n",
      "9        FSHB c.-211 G>T    object   \n",
      "10       FSHR c.2039 A>G    object   \n",
      "\n",
      "                                          Description  \n",
      "0                   Unique identifier for each record  \n",
      "1                                  Age of the patient  \n",
      "2              The cycle number of IVF/ICSI treatment  \n",
      "3   Follicle Stimulating Hormone level, measured i...  \n",
      "4         Luteinizing Hormone level, measured in IU/L  \n",
      "5     Anti-Müllerian Hormone level, measured in ng/mL  \n",
      "6              Progesterone level, measured in nmol/L  \n",
      "7   Number of follicles obtained during the procedure  \n",
      "8                           Ratio of LH to FSH levels  \n",
      "9               Genetic polymorphism in the FSHB gene  \n",
      "10              Genetic polymorphism in the FSHR gene  \n"
     ]
    }
   ],
   "source": [
    "descriptions = {\n",
    "    '№': 'Unique identifier for each record',\n",
    "    'Age': 'Age of the patient',\n",
    "    'IVF/ICSI cycle': 'The cycle number of IVF/ICSI treatment',\n",
    "    'FSH, IU/L': 'Follicle Stimulating Hormone level, measured in IU/L',\n",
    "    'LH, IU/L': 'Luteinizing Hormone level, measured in IU/L',\n",
    "    'AMH, ng/mL': 'Anti-Müllerian Hormone level, measured in ng/mL',\n",
    "    'Progesterone, nmol/L': 'Progesterone level, measured in nmol/L',\n",
    "    'Follicles obtained': 'Number of follicles obtained during the procedure',\n",
    "    'LH/FSH ratio': 'Ratio of LH to FSH levels',\n",
    "    'FSHB c.-211 G>T': 'Genetic polymorphism in the FSHB gene',\n",
    "    'FSHR c.2039 A>G': 'Genetic polymorphism in the FSHR gene'\n",
    "}\n",
    "\n",
    "# Create the data dictionary DataFrame\n",
    "data_dict = pd.DataFrame({\n",
    "    'Column Name': df1.columns,\n",
    "    'Data Type': df1.dtypes.values,\n",
    "    'Description': df1.columns.map(descriptions)\n",
    "})\n",
    "\n",
    "# Save the data dictionary to a CSV file\n",
    "data_dict.to_excel('data_dictionary.xlsx', index=False)\n",
    "\n",
    "# Print the data dictionary to verify the results\n",
    "print(data_dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f6606765",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}