信号处理（去除平均噪音）.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "cc72928f",
   "metadata": {
    "scrolled": true
   },
   "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>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>9</th>\n",
       "      <th>10</th>\n",
       "      <th>...</th>\n",
       "      <th>192</th>\n",
       "      <th>193</th>\n",
       "      <th>194</th>\n",
       "      <th>195</th>\n",
       "      <th>196</th>\n",
       "      <th>197</th>\n",
       "      <th>198</th>\n",
       "      <th>199</th>\n",
       "      <th>200</th>\n",
       "      <th>Average</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS Temperature(deg C)</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>30.441</th>\n",
       "      <td>2.390000e-11</td>\n",
       "      <td>2.430000e-12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.890000e-12</td>\n",
       "      <td>1.310000e-12</td>\n",
       "      <td>2.070000e-12</td>\n",
       "      <td>1.510000e-12</td>\n",
       "      <td>1.820000e-12</td>\n",
       "      <td>...</td>\n",
       "      <td>9.730000e-13</td>\n",
       "      <td>3.110000e-12</td>\n",
       "      <td>1.360000e-12</td>\n",
       "      <td>1.980000e-12</td>\n",
       "      <td>3.030000e-13</td>\n",
       "      <td>6.850000e-13</td>\n",
       "      <td>7.280000e-13</td>\n",
       "      <td>1.510000e-12</td>\n",
       "      <td>1.660000e-12</td>\n",
       "      <td>1.339640e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31.353</th>\n",
       "      <td>2.340000e-11</td>\n",
       "      <td>2.470000e-12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.940000e-12</td>\n",
       "      <td>1.400000e-12</td>\n",
       "      <td>2.100000e-12</td>\n",
       "      <td>1.580000e-12</td>\n",
       "      <td>1.860000e-12</td>\n",
       "      <td>...</td>\n",
       "      <td>1.070000e-12</td>\n",
       "      <td>3.260000e-12</td>\n",
       "      <td>1.370000e-12</td>\n",
       "      <td>2.000000e-12</td>\n",
       "      <td>4.020000e-13</td>\n",
       "      <td>7.960000e-13</td>\n",
       "      <td>8.440000e-13</td>\n",
       "      <td>1.580000e-12</td>\n",
       "      <td>1.700000e-12</td>\n",
       "      <td>1.376350e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32.265</th>\n",
       "      <td>2.280000e-11</td>\n",
       "      <td>2.510000e-12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.980000e-12</td>\n",
       "      <td>1.490000e-12</td>\n",
       "      <td>2.130000e-12</td>\n",
       "      <td>1.640000e-12</td>\n",
       "      <td>1.890000e-12</td>\n",
       "      <td>...</td>\n",
       "      <td>1.160000e-12</td>\n",
       "      <td>3.400000e-12</td>\n",
       "      <td>1.390000e-12</td>\n",
       "      <td>2.010000e-12</td>\n",
       "      <td>4.960000e-13</td>\n",
       "      <td>9.020000e-13</td>\n",
       "      <td>9.540000e-13</td>\n",
       "      <td>1.650000e-12</td>\n",
       "      <td>1.740000e-12</td>\n",
       "      <td>1.411790e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33.177</th>\n",
       "      <td>2.220000e-11</td>\n",
       "      <td>2.550000e-12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.020000e-12</td>\n",
       "      <td>1.570000e-12</td>\n",
       "      <td>2.160000e-12</td>\n",
       "      <td>1.700000e-12</td>\n",
       "      <td>1.910000e-12</td>\n",
       "      <td>...</td>\n",
       "      <td>1.240000e-12</td>\n",
       "      <td>3.540000e-12</td>\n",
       "      <td>1.410000e-12</td>\n",
       "      <td>2.030000e-12</td>\n",
       "      <td>5.860000e-13</td>\n",
       "      <td>1.000000e-12</td>\n",
       "      <td>1.060000e-12</td>\n",
       "      <td>1.710000e-12</td>\n",
       "      <td>1.780000e-12</td>\n",
       "      <td>1.444760e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34.089</th>\n",
       "      <td>2.170000e-11</td>\n",
       "      <td>2.580000e-12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.050000e-12</td>\n",
       "      <td>1.650000e-12</td>\n",
       "      <td>2.180000e-12</td>\n",
       "      <td>1.760000e-12</td>\n",
       "      <td>1.940000e-12</td>\n",
       "      <td>...</td>\n",
       "      <td>1.320000e-12</td>\n",
       "      <td>3.660000e-12</td>\n",
       "      <td>1.420000e-12</td>\n",
       "      <td>2.040000e-12</td>\n",
       "      <td>6.720000e-13</td>\n",
       "      <td>1.100000e-12</td>\n",
       "      <td>1.160000e-12</td>\n",
       "      <td>1.770000e-12</td>\n",
       "      <td>1.820000e-12</td>\n",
       "      <td>1.475910e-12</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>594.918</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>9.360000e-13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.430000e-12</td>\n",
       "      <td>3.920000e-13</td>\n",
       "      <td>2.700000e-13</td>\n",
       "      <td>3.040000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.550000e-12</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.430000e-13</td>\n",
       "      <td>1.310000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.080000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.669880e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595.884</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.890000e-13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.500000e-12</td>\n",
       "      <td>4.320000e-13</td>\n",
       "      <td>1.940000e-13</td>\n",
       "      <td>3.100000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.550000e-12</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.480000e-13</td>\n",
       "      <td>1.340000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.400000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.762570e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597.028</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.400000e-13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.570000e-12</td>\n",
       "      <td>4.740000e-13</td>\n",
       "      <td>1.130000e-13</td>\n",
       "      <td>3.160000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.550000e-12</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.520000e-13</td>\n",
       "      <td>1.380000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.740000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.870960e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598.005</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.880000e-13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.640000e-12</td>\n",
       "      <td>5.190000e-13</td>\n",
       "      <td>2.790000e-14</td>\n",
       "      <td>3.220000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.540000e-12</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.570000e-13</td>\n",
       "      <td>1.410000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.090000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.988790e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>599.128</th>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.330000e-13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.720000e-12</td>\n",
       "      <td>5.660000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.280000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.540000e-12</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.610000e-13</td>\n",
       "      <td>1.440000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.450000e-13</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>2.118070e-13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>582 rows × 201 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  1             2  3  4  5             6  \\\n",
       "MS Temperature(deg C)                                                      \n",
       "30.441                 2.390000e-11  2.430000e-12  0  0  0  1.890000e-12   \n",
       "31.353                 2.340000e-11  2.470000e-12  0  0  0  1.940000e-12   \n",
       "32.265                 2.280000e-11  2.510000e-12  0  0  0  1.980000e-12   \n",
       "33.177                 2.220000e-11  2.550000e-12  0  0  0  2.020000e-12   \n",
       "34.089                 2.170000e-11  2.580000e-12  0  0  0  2.050000e-12   \n",
       "...                             ...           ... .. .. ..           ...   \n",
       "594.918                0.000000e+00  9.360000e-13  0  0  0  1.430000e-12   \n",
       "595.884                0.000000e+00  8.890000e-13  0  0  0  1.500000e-12   \n",
       "597.028                0.000000e+00  8.400000e-13  0  0  0  1.570000e-12   \n",
       "598.005                0.000000e+00  7.880000e-13  0  0  0  1.640000e-12   \n",
       "599.128                0.000000e+00  7.330000e-13  0  0  0  1.720000e-12   \n",
       "\n",
       "                                  7             8             9            10  \\\n",
       "MS Temperature(deg C)                                                           \n",
       "30.441                 1.310000e-12  2.070000e-12  1.510000e-12  1.820000e-12   \n",
       "31.353                 1.400000e-12  2.100000e-12  1.580000e-12  1.860000e-12   \n",
       "32.265                 1.490000e-12  2.130000e-12  1.640000e-12  1.890000e-12   \n",
       "33.177                 1.570000e-12  2.160000e-12  1.700000e-12  1.910000e-12   \n",
       "34.089                 1.650000e-12  2.180000e-12  1.760000e-12  1.940000e-12   \n",
       "...                             ...           ...           ...           ...   \n",
       "594.918                3.920000e-13  2.700000e-13  3.040000e-13  0.000000e+00   \n",
       "595.884                4.320000e-13  1.940000e-13  3.100000e-13  0.000000e+00   \n",
       "597.028                4.740000e-13  1.130000e-13  3.160000e-13  0.000000e+00   \n",
       "598.005                5.190000e-13  2.790000e-14  3.220000e-13  0.000000e+00   \n",
       "599.128                5.660000e-13  0.000000e+00  3.280000e-13  0.000000e+00   \n",
       "\n",
       "                       ...           192           193           194  \\\n",
       "MS Temperature(deg C)  ...                                             \n",
       "30.441                 ...  9.730000e-13  3.110000e-12  1.360000e-12   \n",
       "31.353                 ...  1.070000e-12  3.260000e-12  1.370000e-12   \n",
       "32.265                 ...  1.160000e-12  3.400000e-12  1.390000e-12   \n",
       "33.177                 ...  1.240000e-12  3.540000e-12  1.410000e-12   \n",
       "34.089                 ...  1.320000e-12  3.660000e-12  1.420000e-12   \n",
       "...                    ...           ...           ...           ...   \n",
       "594.918                ...  0.000000e+00  2.550000e-12  0.000000e+00   \n",
       "595.884                ...  0.000000e+00  2.550000e-12  0.000000e+00   \n",
       "597.028                ...  0.000000e+00  2.550000e-12  0.000000e+00   \n",
       "598.005                ...  0.000000e+00  2.540000e-12  0.000000e+00   \n",
       "599.128                ...  0.000000e+00  2.540000e-12  0.000000e+00   \n",
       "\n",
       "                                195           196           197           198  \\\n",
       "MS Temperature(deg C)                                                           \n",
       "30.441                 1.980000e-12  3.030000e-13  6.850000e-13  7.280000e-13   \n",
       "31.353                 2.000000e-12  4.020000e-13  7.960000e-13  8.440000e-13   \n",
       "32.265                 2.010000e-12  4.960000e-13  9.020000e-13  9.540000e-13   \n",
       "33.177                 2.030000e-12  5.860000e-13  1.000000e-12  1.060000e-12   \n",
       "34.089                 2.040000e-12  6.720000e-13  1.100000e-12  1.160000e-12   \n",
       "...                             ...           ...           ...           ...   \n",
       "594.918                2.430000e-13  1.310000e-13  0.000000e+00  0.000000e+00   \n",
       "595.884                2.480000e-13  1.340000e-13  0.000000e+00  0.000000e+00   \n",
       "597.028                2.520000e-13  1.380000e-13  0.000000e+00  0.000000e+00   \n",
       "598.005                2.570000e-13  1.410000e-13  0.000000e+00  0.000000e+00   \n",
       "599.128                2.610000e-13  1.440000e-13  0.000000e+00  0.000000e+00   \n",
       "\n",
       "                                199           200       Average  \n",
       "MS Temperature(deg C)                                            \n",
       "30.441                 1.510000e-12  1.660000e-12  1.339640e-12  \n",
       "31.353                 1.580000e-12  1.700000e-12  1.376350e-12  \n",
       "32.265                 1.650000e-12  1.740000e-12  1.411790e-12  \n",
       "33.177                 1.710000e-12  1.780000e-12  1.444760e-12  \n",
       "34.089                 1.770000e-12  1.820000e-12  1.475910e-12  \n",
       "...                             ...           ...           ...  \n",
       "594.918                6.080000e-13  0.000000e+00  1.669880e-13  \n",
       "595.884                6.400000e-13  0.000000e+00  1.762570e-13  \n",
       "597.028                6.740000e-13  0.000000e+00  1.870960e-13  \n",
       "598.005                7.090000e-13  0.000000e+00  1.988790e-13  \n",
       "599.128                7.450000e-13  0.000000e+00  2.118070e-13  \n",
       "\n",
       "[582 rows x 201 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#1. 输入库\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "#2. 打开d带中心数据\n",
    "with open('My_Data.csv', encoding = 'UTF-8') as f:\n",
    "    df = pd.read_csv(f, index_col = 0)  #index_col=0 告诉第一列是索引\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "35caef55",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cb972b9c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "99c3f4d2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MS Temperature(deg C)\n",
       "30.441     1.339640e-12\n",
       "31.353     1.376350e-12\n",
       "32.265     1.411790e-12\n",
       "33.177     1.444760e-12\n",
       "34.089     1.475910e-12\n",
       "               ...     \n",
       "594.918    1.669880e-13\n",
       "595.884    1.762570e-13\n",
       "597.028    1.870960e-13\n",
       "598.005    1.988790e-13\n",
       "599.128    2.118070e-13\n",
       "Name: Average, Length: 582, dtype: float64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#设置自变量和因变量\n",
    "X = df.drop('Average', axis = 1)\n",
    "Del = df['Average']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "93ecf4d9",
   "metadata": {},
   "outputs": [],
   "source": [
    "#对列遍历\n",
    "#for i in X.columns:  #对列遍历\n",
    " #   X.loc[,i] -= Del\n",
    "    \n",
    "for i in X.columns:  #对列遍历\n",
    "    for j in X.index:  #对行遍历\n",
    "        X.loc[j,i] -= Del.loc[j]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "d8fe0b4c",
   "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>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>9</th>\n",
       "      <th>10</th>\n",
       "      <th>...</th>\n",
       "      <th>191</th>\n",
       "      <th>192</th>\n",
       "      <th>193</th>\n",
       "      <th>194</th>\n",
       "      <th>195</th>\n",
       "      <th>196</th>\n",
       "      <th>197</th>\n",
       "      <th>198</th>\n",
       "      <th>199</th>\n",
       "      <th>200</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MS Temperature(deg C)</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>30.441</th>\n",
       "      <td>2.256036e-11</td>\n",
       "      <td>1.090360e-12</td>\n",
       "      <td>-1.339640e-12</td>\n",
       "      <td>-1.339640e-12</td>\n",
       "      <td>-1.339640e-12</td>\n",
       "      <td>5.503600e-13</td>\n",
       "      <td>-2.964000e-14</td>\n",
       "      <td>7.303600e-13</td>\n",
       "      <td>1.703600e-13</td>\n",
       "      <td>4.803600e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>5.603600e-13</td>\n",
       "      <td>-3.666400e-13</td>\n",
       "      <td>1.770360e-12</td>\n",
       "      <td>2.036000e-14</td>\n",
       "      <td>6.403600e-13</td>\n",
       "      <td>-1.036640e-12</td>\n",
       "      <td>-6.546400e-13</td>\n",
       "      <td>-6.116400e-13</td>\n",
       "      <td>1.703600e-13</td>\n",
       "      <td>3.203600e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31.353</th>\n",
       "      <td>2.202365e-11</td>\n",
       "      <td>1.093650e-12</td>\n",
       "      <td>-1.376350e-12</td>\n",
       "      <td>-1.376350e-12</td>\n",
       "      <td>-1.376350e-12</td>\n",
       "      <td>5.636500e-13</td>\n",
       "      <td>2.365000e-14</td>\n",
       "      <td>7.236500e-13</td>\n",
       "      <td>2.036500e-13</td>\n",
       "      <td>4.836500e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>5.236500e-13</td>\n",
       "      <td>-3.063500e-13</td>\n",
       "      <td>1.883650e-12</td>\n",
       "      <td>-6.350000e-15</td>\n",
       "      <td>6.236500e-13</td>\n",
       "      <td>-9.743500e-13</td>\n",
       "      <td>-5.803500e-13</td>\n",
       "      <td>-5.323500e-13</td>\n",
       "      <td>2.036500e-13</td>\n",
       "      <td>3.236500e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32.265</th>\n",
       "      <td>2.138821e-11</td>\n",
       "      <td>1.098210e-12</td>\n",
       "      <td>-1.411790e-12</td>\n",
       "      <td>-1.411790e-12</td>\n",
       "      <td>-1.411790e-12</td>\n",
       "      <td>5.682100e-13</td>\n",
       "      <td>7.821000e-14</td>\n",
       "      <td>7.182100e-13</td>\n",
       "      <td>2.282100e-13</td>\n",
       "      <td>4.782100e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>4.982100e-13</td>\n",
       "      <td>-2.517900e-13</td>\n",
       "      <td>1.988210e-12</td>\n",
       "      <td>-2.179000e-14</td>\n",
       "      <td>5.982100e-13</td>\n",
       "      <td>-9.157900e-13</td>\n",
       "      <td>-5.097900e-13</td>\n",
       "      <td>-4.577900e-13</td>\n",
       "      <td>2.382100e-13</td>\n",
       "      <td>3.282100e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33.177</th>\n",
       "      <td>2.075524e-11</td>\n",
       "      <td>1.105240e-12</td>\n",
       "      <td>-1.444760e-12</td>\n",
       "      <td>-1.444760e-12</td>\n",
       "      <td>-1.444760e-12</td>\n",
       "      <td>5.752400e-13</td>\n",
       "      <td>1.252400e-13</td>\n",
       "      <td>7.152400e-13</td>\n",
       "      <td>2.552400e-13</td>\n",
       "      <td>4.652400e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>4.652400e-13</td>\n",
       "      <td>-2.047600e-13</td>\n",
       "      <td>2.095240e-12</td>\n",
       "      <td>-3.476000e-14</td>\n",
       "      <td>5.852400e-13</td>\n",
       "      <td>-8.587600e-13</td>\n",
       "      <td>-4.447600e-13</td>\n",
       "      <td>-3.847600e-13</td>\n",
       "      <td>2.652400e-13</td>\n",
       "      <td>3.352400e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34.089</th>\n",
       "      <td>2.022409e-11</td>\n",
       "      <td>1.104090e-12</td>\n",
       "      <td>-1.475910e-12</td>\n",
       "      <td>-1.475910e-12</td>\n",
       "      <td>-1.475910e-12</td>\n",
       "      <td>5.740900e-13</td>\n",
       "      <td>1.740900e-13</td>\n",
       "      <td>7.040900e-13</td>\n",
       "      <td>2.840900e-13</td>\n",
       "      <td>4.640900e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>4.340900e-13</td>\n",
       "      <td>-1.559100e-13</td>\n",
       "      <td>2.184090e-12</td>\n",
       "      <td>-5.591000e-14</td>\n",
       "      <td>5.640900e-13</td>\n",
       "      <td>-8.039100e-13</td>\n",
       "      <td>-3.759100e-13</td>\n",
       "      <td>-3.159100e-13</td>\n",
       "      <td>2.940900e-13</td>\n",
       "      <td>3.440900e-13</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>594.918</th>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>7.690120e-13</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>1.263012e-12</td>\n",
       "      <td>2.250120e-13</td>\n",
       "      <td>1.030120e-13</td>\n",
       "      <td>1.370120e-13</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.161880e-13</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>2.383012e-12</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>7.601200e-14</td>\n",
       "      <td>-3.598800e-14</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "      <td>4.410120e-13</td>\n",
       "      <td>-1.669880e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>595.884</th>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>7.127430e-13</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>1.323743e-12</td>\n",
       "      <td>2.557430e-13</td>\n",
       "      <td>1.774300e-14</td>\n",
       "      <td>1.337430e-13</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.320570e-13</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>2.373743e-12</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>7.174300e-14</td>\n",
       "      <td>-4.225700e-14</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "      <td>4.637430e-13</td>\n",
       "      <td>-1.762570e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>597.028</th>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>6.529040e-13</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>1.382904e-12</td>\n",
       "      <td>2.869040e-13</td>\n",
       "      <td>-7.409600e-14</td>\n",
       "      <td>1.289040e-13</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.497960e-13</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>2.362904e-12</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>6.490400e-14</td>\n",
       "      <td>-4.909600e-14</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "      <td>4.869040e-13</td>\n",
       "      <td>-1.870960e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>598.005</th>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>5.891210e-13</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>1.441121e-12</td>\n",
       "      <td>3.201210e-13</td>\n",
       "      <td>-1.709790e-13</td>\n",
       "      <td>1.231210e-13</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.686790e-13</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>2.341121e-12</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>5.812100e-14</td>\n",
       "      <td>-5.787900e-14</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "      <td>5.101210e-13</td>\n",
       "      <td>-1.988790e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>599.128</th>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>5.211930e-13</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>1.508193e-12</td>\n",
       "      <td>3.541930e-13</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>1.161930e-13</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.889070e-13</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>2.328193e-12</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>4.919300e-14</td>\n",
       "      <td>-6.780700e-14</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "      <td>5.331930e-13</td>\n",
       "      <td>-2.118070e-13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>582 rows × 200 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  1             2             3             4  \\\n",
       "MS Temperature(deg C)                                                           \n",
       "30.441                 2.256036e-11  1.090360e-12 -1.339640e-12 -1.339640e-12   \n",
       "31.353                 2.202365e-11  1.093650e-12 -1.376350e-12 -1.376350e-12   \n",
       "32.265                 2.138821e-11  1.098210e-12 -1.411790e-12 -1.411790e-12   \n",
       "33.177                 2.075524e-11  1.105240e-12 -1.444760e-12 -1.444760e-12   \n",
       "34.089                 2.022409e-11  1.104090e-12 -1.475910e-12 -1.475910e-12   \n",
       "...                             ...           ...           ...           ...   \n",
       "594.918               -1.669880e-13  7.690120e-13 -1.669880e-13 -1.669880e-13   \n",
       "595.884               -1.762570e-13  7.127430e-13 -1.762570e-13 -1.762570e-13   \n",
       "597.028               -1.870960e-13  6.529040e-13 -1.870960e-13 -1.870960e-13   \n",
       "598.005               -1.988790e-13  5.891210e-13 -1.988790e-13 -1.988790e-13   \n",
       "599.128               -2.118070e-13  5.211930e-13 -2.118070e-13 -2.118070e-13   \n",
       "\n",
       "                                  5             6             7             8  \\\n",
       "MS Temperature(deg C)                                                           \n",
       "30.441                -1.339640e-12  5.503600e-13 -2.964000e-14  7.303600e-13   \n",
       "31.353                -1.376350e-12  5.636500e-13  2.365000e-14  7.236500e-13   \n",
       "32.265                -1.411790e-12  5.682100e-13  7.821000e-14  7.182100e-13   \n",
       "33.177                -1.444760e-12  5.752400e-13  1.252400e-13  7.152400e-13   \n",
       "34.089                -1.475910e-12  5.740900e-13  1.740900e-13  7.040900e-13   \n",
       "...                             ...           ...           ...           ...   \n",
       "594.918               -1.669880e-13  1.263012e-12  2.250120e-13  1.030120e-13   \n",
       "595.884               -1.762570e-13  1.323743e-12  2.557430e-13  1.774300e-14   \n",
       "597.028               -1.870960e-13  1.382904e-12  2.869040e-13 -7.409600e-14   \n",
       "598.005               -1.988790e-13  1.441121e-12  3.201210e-13 -1.709790e-13   \n",
       "599.128               -2.118070e-13  1.508193e-12  3.541930e-13 -2.118070e-13   \n",
       "\n",
       "                                  9            10  ...           191  \\\n",
       "MS Temperature(deg C)                              ...                 \n",
       "30.441                 1.703600e-13  4.803600e-13  ...  5.603600e-13   \n",
       "31.353                 2.036500e-13  4.836500e-13  ...  5.236500e-13   \n",
       "32.265                 2.282100e-13  4.782100e-13  ...  4.982100e-13   \n",
       "33.177                 2.552400e-13  4.652400e-13  ...  4.652400e-13   \n",
       "34.089                 2.840900e-13  4.640900e-13  ...  4.340900e-13   \n",
       "...                             ...           ...  ...           ...   \n",
       "594.918                1.370120e-13 -1.669880e-13  ... -1.161880e-13   \n",
       "595.884                1.337430e-13 -1.762570e-13  ... -1.320570e-13   \n",
       "597.028                1.289040e-13 -1.870960e-13  ... -1.497960e-13   \n",
       "598.005                1.231210e-13 -1.988790e-13  ... -1.686790e-13   \n",
       "599.128                1.161930e-13 -2.118070e-13  ... -1.889070e-13   \n",
       "\n",
       "                                192           193           194           195  \\\n",
       "MS Temperature(deg C)                                                           \n",
       "30.441                -3.666400e-13  1.770360e-12  2.036000e-14  6.403600e-13   \n",
       "31.353                -3.063500e-13  1.883650e-12 -6.350000e-15  6.236500e-13   \n",
       "32.265                -2.517900e-13  1.988210e-12 -2.179000e-14  5.982100e-13   \n",
       "33.177                -2.047600e-13  2.095240e-12 -3.476000e-14  5.852400e-13   \n",
       "34.089                -1.559100e-13  2.184090e-12 -5.591000e-14  5.640900e-13   \n",
       "...                             ...           ...           ...           ...   \n",
       "594.918               -1.669880e-13  2.383012e-12 -1.669880e-13  7.601200e-14   \n",
       "595.884               -1.762570e-13  2.373743e-12 -1.762570e-13  7.174300e-14   \n",
       "597.028               -1.870960e-13  2.362904e-12 -1.870960e-13  6.490400e-14   \n",
       "598.005               -1.988790e-13  2.341121e-12 -1.988790e-13  5.812100e-14   \n",
       "599.128               -2.118070e-13  2.328193e-12 -2.118070e-13  4.919300e-14   \n",
       "\n",
       "                                196           197           198           199  \\\n",
       "MS Temperature(deg C)                                                           \n",
       "30.441                -1.036640e-12 -6.546400e-13 -6.116400e-13  1.703600e-13   \n",
       "31.353                -9.743500e-13 -5.803500e-13 -5.323500e-13  2.036500e-13   \n",
       "32.265                -9.157900e-13 -5.097900e-13 -4.577900e-13  2.382100e-13   \n",
       "33.177                -8.587600e-13 -4.447600e-13 -3.847600e-13  2.652400e-13   \n",
       "34.089                -8.039100e-13 -3.759100e-13 -3.159100e-13  2.940900e-13   \n",
       "...                             ...           ...           ...           ...   \n",
       "594.918               -3.598800e-14 -1.669880e-13 -1.669880e-13  4.410120e-13   \n",
       "595.884               -4.225700e-14 -1.762570e-13 -1.762570e-13  4.637430e-13   \n",
       "597.028               -4.909600e-14 -1.870960e-13 -1.870960e-13  4.869040e-13   \n",
       "598.005               -5.787900e-14 -1.988790e-13 -1.988790e-13  5.101210e-13   \n",
       "599.128               -6.780700e-14 -2.118070e-13 -2.118070e-13  5.331930e-13   \n",
       "\n",
       "                                200  \n",
       "MS Temperature(deg C)                \n",
       "30.441                 3.203600e-13  \n",
       "31.353                 3.236500e-13  \n",
       "32.265                 3.282100e-13  \n",
       "33.177                 3.352400e-13  \n",
       "34.089                 3.440900e-13  \n",
       "...                             ...  \n",
       "594.918               -1.669880e-13  \n",
       "595.884               -1.762570e-13  \n",
       "597.028               -1.870960e-13  \n",
       "598.005               -1.988790e-13  \n",
       "599.128               -2.118070e-13  \n",
       "\n",
       "[582 rows x 200 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "2f5e7a4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "X.to_csv('output.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d8e6f890",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}