Dropping multiple feature columns.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "899a400f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "#'BPM','HRV','R_peak','QRS_Complex','P_peak','T_peak','PR_interval','QT_interval','RR_interval','PR_segment','ST_segment',\n",
    "\n",
    "folder_path = 'C:/Users/Ewunetie/OneDrive - University of Gondar,/2022-2023 files/Courses/Project/data/Resampled/resampled_result.csv'\n",
    "filepath1 = 'C:/Users/Ewunetie/OneDrive - University of Gondar,/2022-2023 files/Courses/Project/data/Resampled'\n",
    "df1 = pd.read_csv(folder_path)\n",
    "\n",
    "#BPM data\n",
    "df=df1.drop(columns=['HRV','R_peak','QRS_Complex','P_peak','T_peak','PR_interval','QT_interval','RR_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'BPM_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#HRV_data\n",
    "df=df1.drop(columns=['BPM','R_peak','QRS_Complex','P_peak','T_peak','PR_interval','QT_interval','RR_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'HRV_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#R_peak_data\n",
    "df=df1.drop(columns=['BPM','HRV','QRS_Complex','P_peak','T_peak','PR_interval','QT_interval','RR_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'R_peak_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#QRS_Complex_data\n",
    "df=df1.drop(columns=['BPM','HRV','R_peak','P_peak','T_peak','PR_interval','QT_interval','RR_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'QRS_Complex_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#P_peak_data\n",
    "df=df1.drop(columns=['BPM','HRV','R_peak','QRS_Complex','T_peak','PR_interval','QT_interval','RR_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'P_peak_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#T_peak_data\n",
    "df=df1.drop(columns=['BPM','HRV','R_peak','QRS_Complex','P_peak','PR_interval','QT_interval','RR_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'T_peak_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#PR_interval_data\n",
    "df=df1.drop(columns=['BPM','HRV','R_peak','QRS_Complex','P_peak','T_peak','QT_interval','RR_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'PR_interval_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#QT_interval_data\n",
    "df=df1.drop(columns=['BPM','HRV','R_peak','QRS_Complex','P_peak','T_peak','PR_interval','RR_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'QT_interval_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#RR_interval_data\n",
    "df=df1.drop(columns=['BPM','HRV','R_peak','QRS_Complex','P_peak','T_peak','PR_interval','QT_interval',\n",
    "                    'PR_segment','ST_segment'])\n",
    "filename = 'RR_interval_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#PR_segment_data\n",
    "df=df1.drop(columns=['BPM','HRV','R_peak','QRS_Complex','P_peak','T_peak','PR_interval','QT_interval','RR_interval',\n",
    "                    'ST_segment'])\n",
    "filename = 'PR_segment_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)\n",
    "\n",
    "#ST_segment_data\n",
    "df=df1.drop(columns=['BPM','HRV','R_peak','QRS_Complex','P_peak','T_peak','PR_interval','QT_interval','RR_interval',\n",
    "                    'PR_segment'])\n",
    "filename = 'ST_segment_data.csv'\n",
    "filepath = os.path.join(filepath1, filename)\n",
    "# Save the modified DataFrame back to the file\n",
    "df.to_csv(filepath, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "754ef40f",
   "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>data_ID</th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>...</th>\n",
       "      <th>16374</th>\n",
       "      <th>16375</th>\n",
       "      <th>16376</th>\n",
       "      <th>16377</th>\n",
       "      <th>16378</th>\n",
       "      <th>16379</th>\n",
       "      <th>16380</th>\n",
       "      <th>16381</th>\n",
       "      <th>16382</th>\n",
       "      <th>BPM</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A_01_06_06</td>\n",
       "      <td>-0.116201</td>\n",
       "      <td>-0.120952</td>\n",
       "      <td>-0.125470</td>\n",
       "      <td>-0.129755</td>\n",
       "      <td>-0.133807</td>\n",
       "      <td>-0.137628</td>\n",
       "      <td>-0.141215</td>\n",
       "      <td>-0.144570</td>\n",
       "      <td>-0.147692</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.142216</td>\n",
       "      <td>-0.143829</td>\n",
       "      <td>-0.145370</td>\n",
       "      <td>-0.146797</td>\n",
       "      <td>-0.148074</td>\n",
       "      <td>-0.149168</td>\n",
       "      <td>-0.150053</td>\n",
       "      <td>-0.150706</td>\n",
       "      <td>-0.151112</td>\n",
       "      <td>82.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A_01_1</td>\n",
       "      <td>-0.110777</td>\n",
       "      <td>-0.119968</td>\n",
       "      <td>-0.128788</td>\n",
       "      <td>-0.137072</td>\n",
       "      <td>-0.144673</td>\n",
       "      <td>-0.151463</td>\n",
       "      <td>-0.157344</td>\n",
       "      <td>-0.162247</td>\n",
       "      <td>-0.166136</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.114064</td>\n",
       "      <td>-0.115967</td>\n",
       "      <td>-0.117768</td>\n",
       "      <td>-0.119419</td>\n",
       "      <td>-0.120877</td>\n",
       "      <td>-0.122106</td>\n",
       "      <td>-0.123078</td>\n",
       "      <td>-0.123769</td>\n",
       "      <td>-0.124165</td>\n",
       "      <td>83.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A_01_17_07</td>\n",
       "      <td>-0.061985</td>\n",
       "      <td>-0.065903</td>\n",
       "      <td>-0.069614</td>\n",
       "      <td>-0.073117</td>\n",
       "      <td>-0.076413</td>\n",
       "      <td>-0.079501</td>\n",
       "      <td>-0.082381</td>\n",
       "      <td>-0.085054</td>\n",
       "      <td>-0.087520</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.041292</td>\n",
       "      <td>-0.040163</td>\n",
       "      <td>-0.039244</td>\n",
       "      <td>-0.038572</td>\n",
       "      <td>-0.038178</td>\n",
       "      <td>-0.038093</td>\n",
       "      <td>-0.038341</td>\n",
       "      <td>-0.038940</td>\n",
       "      <td>-0.039903</td>\n",
       "      <td>76.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A_01_2</td>\n",
       "      <td>-0.071215</td>\n",
       "      <td>-0.067523</td>\n",
       "      <td>-0.063781</td>\n",
       "      <td>-0.060007</td>\n",
       "      <td>-0.056219</td>\n",
       "      <td>-0.052437</td>\n",
       "      <td>-0.048684</td>\n",
       "      <td>-0.044979</td>\n",
       "      <td>-0.041344</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.048474</td>\n",
       "      <td>-0.048538</td>\n",
       "      <td>-0.048585</td>\n",
       "      <td>-0.048634</td>\n",
       "      <td>-0.048705</td>\n",
       "      <td>-0.048821</td>\n",
       "      <td>-0.049004</td>\n",
       "      <td>-0.049278</td>\n",
       "      <td>-0.049663</td>\n",
       "      <td>81.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A_01_3</td>\n",
       "      <td>-0.119150</td>\n",
       "      <td>-0.120002</td>\n",
       "      <td>-0.120831</td>\n",
       "      <td>-0.121598</td>\n",
       "      <td>-0.122282</td>\n",
       "      <td>-0.122872</td>\n",
       "      <td>-0.123371</td>\n",
       "      <td>-0.123792</td>\n",
       "      <td>-0.124154</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.394111</td>\n",
       "      <td>-0.370438</td>\n",
       "      <td>-0.345248</td>\n",
       "      <td>-0.319237</td>\n",
       "      <td>-0.293054</td>\n",
       "      <td>-0.267288</td>\n",
       "      <td>-0.242461</td>\n",
       "      <td>-0.219016</td>\n",
       "      <td>-0.197320</td>\n",
       "      <td>82.0</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",
       "      <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>121</th>\n",
       "      <td>CB_07_5</td>\n",
       "      <td>-0.042867</td>\n",
       "      <td>-0.040006</td>\n",
       "      <td>-0.037546</td>\n",
       "      <td>-0.035554</td>\n",
       "      <td>-0.034082</td>\n",
       "      <td>-0.033164</td>\n",
       "      <td>-0.032819</td>\n",
       "      <td>-0.033047</td>\n",
       "      <td>-0.033831</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.026522</td>\n",
       "      <td>-0.026546</td>\n",
       "      <td>-0.026751</td>\n",
       "      <td>-0.027120</td>\n",
       "      <td>-0.027628</td>\n",
       "      <td>-0.028243</td>\n",
       "      <td>-0.028929</td>\n",
       "      <td>-0.029646</td>\n",
       "      <td>-0.030352</td>\n",
       "      <td>67.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>CB_08_1</td>\n",
       "      <td>-0.024156</td>\n",
       "      <td>-0.023661</td>\n",
       "      <td>-0.023184</td>\n",
       "      <td>-0.022735</td>\n",
       "      <td>-0.022320</td>\n",
       "      <td>-0.021945</td>\n",
       "      <td>-0.021614</td>\n",
       "      <td>-0.021328</td>\n",
       "      <td>-0.021086</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.030275</td>\n",
       "      <td>-0.029277</td>\n",
       "      <td>-0.028179</td>\n",
       "      <td>-0.027002</td>\n",
       "      <td>-0.025771</td>\n",
       "      <td>-0.024509</td>\n",
       "      <td>-0.023243</td>\n",
       "      <td>-0.021999</td>\n",
       "      <td>-0.020802</td>\n",
       "      <td>69.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>CB_08_2</td>\n",
       "      <td>-0.019543</td>\n",
       "      <td>-0.022498</td>\n",
       "      <td>-0.025228</td>\n",
       "      <td>-0.027804</td>\n",
       "      <td>-0.030297</td>\n",
       "      <td>-0.032774</td>\n",
       "      <td>-0.035303</td>\n",
       "      <td>-0.037942</td>\n",
       "      <td>-0.040745</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.163885</td>\n",
       "      <td>-0.146519</td>\n",
       "      <td>-0.129722</td>\n",
       "      <td>-0.113678</td>\n",
       "      <td>-0.098534</td>\n",
       "      <td>-0.084397</td>\n",
       "      <td>-0.071341</td>\n",
       "      <td>-0.059405</td>\n",
       "      <td>-0.048604</td>\n",
       "      <td>70.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>CB_08_3</td>\n",
       "      <td>-0.064041</td>\n",
       "      <td>-0.065549</td>\n",
       "      <td>-0.067094</td>\n",
       "      <td>-0.068611</td>\n",
       "      <td>-0.070035</td>\n",
       "      <td>-0.071309</td>\n",
       "      <td>-0.072379</td>\n",
       "      <td>-0.073198</td>\n",
       "      <td>-0.073729</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.034007</td>\n",
       "      <td>-0.032331</td>\n",
       "      <td>-0.030835</td>\n",
       "      <td>-0.029545</td>\n",
       "      <td>-0.028484</td>\n",
       "      <td>-0.027673</td>\n",
       "      <td>-0.027125</td>\n",
       "      <td>-0.026847</td>\n",
       "      <td>-0.026843</td>\n",
       "      <td>72.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>CB_08_4</td>\n",
       "      <td>-0.010116</td>\n",
       "      <td>-0.014700</td>\n",
       "      <td>-0.018962</td>\n",
       "      <td>-0.022896</td>\n",
       "      <td>-0.026501</td>\n",
       "      <td>-0.029784</td>\n",
       "      <td>-0.032754</td>\n",
       "      <td>-0.035427</td>\n",
       "      <td>-0.037819</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.037483</td>\n",
       "      <td>-0.037179</td>\n",
       "      <td>-0.036993</td>\n",
       "      <td>-0.036944</td>\n",
       "      <td>-0.037049</td>\n",
       "      <td>-0.037319</td>\n",
       "      <td>-0.037765</td>\n",
       "      <td>-0.038390</td>\n",
       "      <td>-0.039195</td>\n",
       "      <td>79.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>126 rows × 16385 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        data_ID         0         1         2         3         4         5  \\\n",
       "0    A_01_06_06 -0.116201 -0.120952 -0.125470 -0.129755 -0.133807 -0.137628   \n",
       "1        A_01_1 -0.110777 -0.119968 -0.128788 -0.137072 -0.144673 -0.151463   \n",
       "2    A_01_17_07 -0.061985 -0.065903 -0.069614 -0.073117 -0.076413 -0.079501   \n",
       "3        A_01_2 -0.071215 -0.067523 -0.063781 -0.060007 -0.056219 -0.052437   \n",
       "4        A_01_3 -0.119150 -0.120002 -0.120831 -0.121598 -0.122282 -0.122872   \n",
       "..          ...       ...       ...       ...       ...       ...       ...   \n",
       "121     CB_07_5 -0.042867 -0.040006 -0.037546 -0.035554 -0.034082 -0.033164   \n",
       "122     CB_08_1 -0.024156 -0.023661 -0.023184 -0.022735 -0.022320 -0.021945   \n",
       "123     CB_08_2 -0.019543 -0.022498 -0.025228 -0.027804 -0.030297 -0.032774   \n",
       "124     CB_08_3 -0.064041 -0.065549 -0.067094 -0.068611 -0.070035 -0.071309   \n",
       "125     CB_08_4 -0.010116 -0.014700 -0.018962 -0.022896 -0.026501 -0.029784   \n",
       "\n",
       "            6         7         8  ...     16374     16375     16376  \\\n",
       "0   -0.141215 -0.144570 -0.147692  ... -0.142216 -0.143829 -0.145370   \n",
       "1   -0.157344 -0.162247 -0.166136  ... -0.114064 -0.115967 -0.117768   \n",
       "2   -0.082381 -0.085054 -0.087520  ... -0.041292 -0.040163 -0.039244   \n",
       "3   -0.048684 -0.044979 -0.041344  ... -0.048474 -0.048538 -0.048585   \n",
       "4   -0.123371 -0.123792 -0.124154  ... -0.394111 -0.370438 -0.345248   \n",
       "..        ...       ...       ...  ...       ...       ...       ...   \n",
       "121 -0.032819 -0.033047 -0.033831  ... -0.026522 -0.026546 -0.026751   \n",
       "122 -0.021614 -0.021328 -0.021086  ... -0.030275 -0.029277 -0.028179   \n",
       "123 -0.035303 -0.037942 -0.040745  ... -0.163885 -0.146519 -0.129722   \n",
       "124 -0.072379 -0.073198 -0.073729  ... -0.034007 -0.032331 -0.030835   \n",
       "125 -0.032754 -0.035427 -0.037819  ... -0.037483 -0.037179 -0.036993   \n",
       "\n",
       "        16377     16378     16379     16380     16381     16382   BPM  \n",
       "0   -0.146797 -0.148074 -0.149168 -0.150053 -0.150706 -0.151112  82.0  \n",
       "1   -0.119419 -0.120877 -0.122106 -0.123078 -0.123769 -0.124165  83.0  \n",
       "2   -0.038572 -0.038178 -0.038093 -0.038341 -0.038940 -0.039903  76.0  \n",
       "3   -0.048634 -0.048705 -0.048821 -0.049004 -0.049278 -0.049663  81.0  \n",
       "4   -0.319237 -0.293054 -0.267288 -0.242461 -0.219016 -0.197320  82.0  \n",
       "..        ...       ...       ...       ...       ...       ...   ...  \n",
       "121 -0.027120 -0.027628 -0.028243 -0.028929 -0.029646 -0.030352  67.0  \n",
       "122 -0.027002 -0.025771 -0.024509 -0.023243 -0.021999 -0.020802  69.0  \n",
       "123 -0.113678 -0.098534 -0.084397 -0.071341 -0.059405 -0.048604  70.0  \n",
       "124 -0.029545 -0.028484 -0.027673 -0.027125 -0.026847 -0.026843  72.0  \n",
       "125 -0.036944 -0.037049 -0.037319 -0.037765 -0.038390 -0.039195  79.0  \n",
       "\n",
       "[126 rows x 16385 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "folder_path = 'C:/Users/Ewunetie/OneDrive - University of Gondar,/2022-2023 files/Courses/Project/data/BPM_data.csv'\n",
    "df = pd.read_csv(folder_path)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4d7c8526",
   "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}