Clinical parameters Dataset - Data Cleaning code-checkpoint.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": null,
   "id": "4da747d3",
   "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
}