EDA of PMSM Motor Speed Prediction.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "81c32b90",
   "metadata": {},
   "source": [
    "# Importing libararies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "57212ff6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "\n",
    "\n",
    "\n",
    "plt.rcParams['figure.figsize']=(16,12)\n",
    "plt.rcParams['figure.dpi']=250\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d7b01e10",
   "metadata": {},
   "source": [
    "# Load Dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "77250a5f",
   "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>ambient</th>\n",
       "      <th>coolant</th>\n",
       "      <th>u_d</th>\n",
       "      <th>u_q</th>\n",
       "      <th>motor_speed</th>\n",
       "      <th>torque</th>\n",
       "      <th>i_d</th>\n",
       "      <th>i_q</th>\n",
       "      <th>pm</th>\n",
       "      <th>stator_yoke</th>\n",
       "      <th>stator_tooth</th>\n",
       "      <th>stator_winding</th>\n",
       "      <th>profile_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-0.752143</td>\n",
       "      <td>-1.118446</td>\n",
       "      <td>0.327935</td>\n",
       "      <td>-1.297858</td>\n",
       "      <td>-1.222428</td>\n",
       "      <td>-0.250182</td>\n",
       "      <td>1.029572</td>\n",
       "      <td>-0.245860</td>\n",
       "      <td>-2.522071</td>\n",
       "      <td>-1.831422</td>\n",
       "      <td>-2.066143</td>\n",
       "      <td>-2.018033</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>-0.771263</td>\n",
       "      <td>-1.117021</td>\n",
       "      <td>0.329665</td>\n",
       "      <td>-1.297686</td>\n",
       "      <td>-1.222429</td>\n",
       "      <td>-0.249133</td>\n",
       "      <td>1.029509</td>\n",
       "      <td>-0.245832</td>\n",
       "      <td>-2.522418</td>\n",
       "      <td>-1.830969</td>\n",
       "      <td>-2.064859</td>\n",
       "      <td>-2.017631</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>-0.782892</td>\n",
       "      <td>-1.116681</td>\n",
       "      <td>0.332771</td>\n",
       "      <td>-1.301822</td>\n",
       "      <td>-1.222428</td>\n",
       "      <td>-0.249431</td>\n",
       "      <td>1.029448</td>\n",
       "      <td>-0.245818</td>\n",
       "      <td>-2.522673</td>\n",
       "      <td>-1.830400</td>\n",
       "      <td>-2.064073</td>\n",
       "      <td>-2.017343</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.780935</td>\n",
       "      <td>-1.116764</td>\n",
       "      <td>0.333700</td>\n",
       "      <td>-1.301852</td>\n",
       "      <td>-1.222430</td>\n",
       "      <td>-0.248636</td>\n",
       "      <td>1.032845</td>\n",
       "      <td>-0.246955</td>\n",
       "      <td>-2.521639</td>\n",
       "      <td>-1.830333</td>\n",
       "      <td>-2.063137</td>\n",
       "      <td>-2.017632</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>-0.774043</td>\n",
       "      <td>-1.116775</td>\n",
       "      <td>0.335206</td>\n",
       "      <td>-1.303118</td>\n",
       "      <td>-1.222429</td>\n",
       "      <td>-0.248701</td>\n",
       "      <td>1.031807</td>\n",
       "      <td>-0.246610</td>\n",
       "      <td>-2.521900</td>\n",
       "      <td>-1.830498</td>\n",
       "      <td>-2.062795</td>\n",
       "      <td>-2.018145</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-0.762936</td>\n",
       "      <td>-1.116955</td>\n",
       "      <td>0.334901</td>\n",
       "      <td>-1.303017</td>\n",
       "      <td>-1.222429</td>\n",
       "      <td>-0.248197</td>\n",
       "      <td>1.031031</td>\n",
       "      <td>-0.246341</td>\n",
       "      <td>-2.522203</td>\n",
       "      <td>-1.831931</td>\n",
       "      <td>-2.062549</td>\n",
       "      <td>-2.017884</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>-0.749228</td>\n",
       "      <td>-1.116170</td>\n",
       "      <td>0.335014</td>\n",
       "      <td>-1.302082</td>\n",
       "      <td>-1.222430</td>\n",
       "      <td>-0.247914</td>\n",
       "      <td>1.030493</td>\n",
       "      <td>-0.246162</td>\n",
       "      <td>-2.522538</td>\n",
       "      <td>-1.833012</td>\n",
       "      <td>-2.062115</td>\n",
       "      <td>-2.017243</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>-0.738450</td>\n",
       "      <td>-1.113986</td>\n",
       "      <td>0.336256</td>\n",
       "      <td>-1.305155</td>\n",
       "      <td>-1.222432</td>\n",
       "      <td>-0.248321</td>\n",
       "      <td>1.030107</td>\n",
       "      <td>-0.246035</td>\n",
       "      <td>-2.522844</td>\n",
       "      <td>-1.832182</td>\n",
       "      <td>-2.061953</td>\n",
       "      <td>-2.017213</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>-0.730910</td>\n",
       "      <td>-1.111828</td>\n",
       "      <td>0.334905</td>\n",
       "      <td>-1.303790</td>\n",
       "      <td>-1.222431</td>\n",
       "      <td>-0.247785</td>\n",
       "      <td>1.029851</td>\n",
       "      <td>-0.245981</td>\n",
       "      <td>-2.522808</td>\n",
       "      <td>-1.831576</td>\n",
       "      <td>-2.062443</td>\n",
       "      <td>-2.017739</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>-0.727130</td>\n",
       "      <td>-1.109486</td>\n",
       "      <td>0.335988</td>\n",
       "      <td>-1.305633</td>\n",
       "      <td>-1.222431</td>\n",
       "      <td>-0.248294</td>\n",
       "      <td>1.029636</td>\n",
       "      <td>-0.245888</td>\n",
       "      <td>-2.522677</td>\n",
       "      <td>-1.831438</td>\n",
       "      <td>-2.062317</td>\n",
       "      <td>-2.018180</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    ambient   coolant       u_d       u_q  motor_speed    torque       i_d  \\\n",
       "0 -0.752143 -1.118446  0.327935 -1.297858    -1.222428 -0.250182  1.029572   \n",
       "1 -0.771263 -1.117021  0.329665 -1.297686    -1.222429 -0.249133  1.029509   \n",
       "2 -0.782892 -1.116681  0.332771 -1.301822    -1.222428 -0.249431  1.029448   \n",
       "3 -0.780935 -1.116764  0.333700 -1.301852    -1.222430 -0.248636  1.032845   \n",
       "4 -0.774043 -1.116775  0.335206 -1.303118    -1.222429 -0.248701  1.031807   \n",
       "5 -0.762936 -1.116955  0.334901 -1.303017    -1.222429 -0.248197  1.031031   \n",
       "6 -0.749228 -1.116170  0.335014 -1.302082    -1.222430 -0.247914  1.030493   \n",
       "7 -0.738450 -1.113986  0.336256 -1.305155    -1.222432 -0.248321  1.030107   \n",
       "8 -0.730910 -1.111828  0.334905 -1.303790    -1.222431 -0.247785  1.029851   \n",
       "9 -0.727130 -1.109486  0.335988 -1.305633    -1.222431 -0.248294  1.029636   \n",
       "\n",
       "        i_q        pm  stator_yoke  stator_tooth  stator_winding  profile_id  \n",
       "0 -0.245860 -2.522071    -1.831422     -2.066143       -2.018033           4  \n",
       "1 -0.245832 -2.522418    -1.830969     -2.064859       -2.017631           4  \n",
       "2 -0.245818 -2.522673    -1.830400     -2.064073       -2.017343           4  \n",
       "3 -0.246955 -2.521639    -1.830333     -2.063137       -2.017632           4  \n",
       "4 -0.246610 -2.521900    -1.830498     -2.062795       -2.018145           4  \n",
       "5 -0.246341 -2.522203    -1.831931     -2.062549       -2.017884           4  \n",
       "6 -0.246162 -2.522538    -1.833012     -2.062115       -2.017243           4  \n",
       "7 -0.246035 -2.522844    -1.832182     -2.061953       -2.017213           4  \n",
       "8 -0.245981 -2.522808    -1.831576     -2.062443       -2.017739           4  \n",
       "9 -0.245888 -2.522677    -1.831438     -2.062317       -2.018180           4  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "em=pd.read_csv(\"temperature_data.csv\")\n",
    "em.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "0d8d4ae3",
   "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>ambient</th>\n",
       "      <th>coolant</th>\n",
       "      <th>u_d</th>\n",
       "      <th>u_q</th>\n",
       "      <th>motor_speed</th>\n",
       "      <th>torque</th>\n",
       "      <th>i_d</th>\n",
       "      <th>i_q</th>\n",
       "      <th>pm</th>\n",
       "      <th>stator_yoke</th>\n",
       "      <th>stator_tooth</th>\n",
       "      <th>stator_winding</th>\n",
       "      <th>profile_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>998060</th>\n",
       "      <td>-0.050781</td>\n",
       "      <td>0.615396</td>\n",
       "      <td>0.331615</td>\n",
       "      <td>-1.249884</td>\n",
       "      <td>-1.222435</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029141</td>\n",
       "      <td>-0.245716</td>\n",
       "      <td>0.431472</td>\n",
       "      <td>1.078879</td>\n",
       "      <td>0.843361</td>\n",
       "      <td>0.503381</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998061</th>\n",
       "      <td>-0.050319</td>\n",
       "      <td>0.537794</td>\n",
       "      <td>0.331493</td>\n",
       "      <td>-1.248210</td>\n",
       "      <td>-1.222433</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029144</td>\n",
       "      <td>-0.245739</td>\n",
       "      <td>0.430466</td>\n",
       "      <td>1.074454</td>\n",
       "      <td>0.842227</td>\n",
       "      <td>0.501356</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998062</th>\n",
       "      <td>-0.055087</td>\n",
       "      <td>0.472326</td>\n",
       "      <td>0.331570</td>\n",
       "      <td>-1.251317</td>\n",
       "      <td>-1.222430</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029134</td>\n",
       "      <td>-0.245729</td>\n",
       "      <td>0.430192</td>\n",
       "      <td>1.068993</td>\n",
       "      <td>0.841414</td>\n",
       "      <td>0.499106</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998063</th>\n",
       "      <td>-0.056077</td>\n",
       "      <td>0.422167</td>\n",
       "      <td>0.331787</td>\n",
       "      <td>-1.246931</td>\n",
       "      <td>-1.222431</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029193</td>\n",
       "      <td>-0.245708</td>\n",
       "      <td>0.430151</td>\n",
       "      <td>1.060052</td>\n",
       "      <td>0.840832</td>\n",
       "      <td>0.497372</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998064</th>\n",
       "      <td>-0.049128</td>\n",
       "      <td>0.375127</td>\n",
       "      <td>0.331692</td>\n",
       "      <td>-1.250184</td>\n",
       "      <td>-1.222434</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029146</td>\n",
       "      <td>-0.245712</td>\n",
       "      <td>0.429423</td>\n",
       "      <td>1.034927</td>\n",
       "      <td>0.838381</td>\n",
       "      <td>0.495968</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998065</th>\n",
       "      <td>-0.047497</td>\n",
       "      <td>0.341638</td>\n",
       "      <td>0.331475</td>\n",
       "      <td>-1.246114</td>\n",
       "      <td>-1.222428</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029142</td>\n",
       "      <td>-0.245723</td>\n",
       "      <td>0.429853</td>\n",
       "      <td>1.018568</td>\n",
       "      <td>0.836084</td>\n",
       "      <td>0.494725</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998066</th>\n",
       "      <td>-0.048839</td>\n",
       "      <td>0.320022</td>\n",
       "      <td>0.331701</td>\n",
       "      <td>-1.250655</td>\n",
       "      <td>-1.222437</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029148</td>\n",
       "      <td>-0.245736</td>\n",
       "      <td>0.429751</td>\n",
       "      <td>1.013416</td>\n",
       "      <td>0.834438</td>\n",
       "      <td>0.494279</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998067</th>\n",
       "      <td>-0.042350</td>\n",
       "      <td>0.307415</td>\n",
       "      <td>0.330946</td>\n",
       "      <td>-1.246852</td>\n",
       "      <td>-1.222430</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029191</td>\n",
       "      <td>-0.245701</td>\n",
       "      <td>0.429439</td>\n",
       "      <td>1.002906</td>\n",
       "      <td>0.833936</td>\n",
       "      <td>0.492666</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998068</th>\n",
       "      <td>-0.039433</td>\n",
       "      <td>0.302082</td>\n",
       "      <td>0.330987</td>\n",
       "      <td>-1.249505</td>\n",
       "      <td>-1.222432</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029147</td>\n",
       "      <td>-0.245727</td>\n",
       "      <td>0.429558</td>\n",
       "      <td>0.999157</td>\n",
       "      <td>0.830504</td>\n",
       "      <td>0.490581</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998069</th>\n",
       "      <td>-0.043803</td>\n",
       "      <td>0.312666</td>\n",
       "      <td>0.330830</td>\n",
       "      <td>-1.246590</td>\n",
       "      <td>-1.222431</td>\n",
       "      <td>-0.25564</td>\n",
       "      <td>1.029141</td>\n",
       "      <td>-0.245722</td>\n",
       "      <td>0.429166</td>\n",
       "      <td>0.987163</td>\n",
       "      <td>0.828046</td>\n",
       "      <td>0.489382</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         ambient   coolant       u_d       u_q  motor_speed   torque  \\\n",
       "998060 -0.050781  0.615396  0.331615 -1.249884    -1.222435 -0.25564   \n",
       "998061 -0.050319  0.537794  0.331493 -1.248210    -1.222433 -0.25564   \n",
       "998062 -0.055087  0.472326  0.331570 -1.251317    -1.222430 -0.25564   \n",
       "998063 -0.056077  0.422167  0.331787 -1.246931    -1.222431 -0.25564   \n",
       "998064 -0.049128  0.375127  0.331692 -1.250184    -1.222434 -0.25564   \n",
       "998065 -0.047497  0.341638  0.331475 -1.246114    -1.222428 -0.25564   \n",
       "998066 -0.048839  0.320022  0.331701 -1.250655    -1.222437 -0.25564   \n",
       "998067 -0.042350  0.307415  0.330946 -1.246852    -1.222430 -0.25564   \n",
       "998068 -0.039433  0.302082  0.330987 -1.249505    -1.222432 -0.25564   \n",
       "998069 -0.043803  0.312666  0.330830 -1.246590    -1.222431 -0.25564   \n",
       "\n",
       "             i_d       i_q        pm  stator_yoke  stator_tooth  \\\n",
       "998060  1.029141 -0.245716  0.431472     1.078879      0.843361   \n",
       "998061  1.029144 -0.245739  0.430466     1.074454      0.842227   \n",
       "998062  1.029134 -0.245729  0.430192     1.068993      0.841414   \n",
       "998063  1.029193 -0.245708  0.430151     1.060052      0.840832   \n",
       "998064  1.029146 -0.245712  0.429423     1.034927      0.838381   \n",
       "998065  1.029142 -0.245723  0.429853     1.018568      0.836084   \n",
       "998066  1.029148 -0.245736  0.429751     1.013416      0.834438   \n",
       "998067  1.029191 -0.245701  0.429439     1.002906      0.833936   \n",
       "998068  1.029147 -0.245727  0.429558     0.999157      0.830504   \n",
       "998069  1.029141 -0.245722  0.429166     0.987163      0.828046   \n",
       "\n",
       "        stator_winding  profile_id  \n",
       "998060        0.503381          72  \n",
       "998061        0.501356          72  \n",
       "998062        0.499106          72  \n",
       "998063        0.497372          72  \n",
       "998064        0.495968          72  \n",
       "998065        0.494725          72  \n",
       "998066        0.494279          72  \n",
       "998067        0.492666          72  \n",
       "998068        0.490581          72  \n",
       "998069        0.489382          72  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "em.tail(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3410df99",
   "metadata": {},
   "source": [
    "# EDA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "8e0b4141",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(998070, 13)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "em.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "6eee4147",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 998070 entries, 0 to 998069\n",
      "Data columns (total 13 columns):\n",
      " #   Column          Non-Null Count   Dtype  \n",
      "---  ------          --------------   -----  \n",
      " 0   ambient         998070 non-null  float64\n",
      " 1   coolant         998070 non-null  float64\n",
      " 2   u_d             998070 non-null  float64\n",
      " 3   u_q             998070 non-null  float64\n",
      " 4   motor_speed     998070 non-null  float64\n",
      " 5   torque          998070 non-null  float64\n",
      " 6   i_d             998070 non-null  float64\n",
      " 7   i_q             998070 non-null  float64\n",
      " 8   pm              998070 non-null  float64\n",
      " 9   stator_yoke     998070 non-null  float64\n",
      " 10  stator_tooth    998070 non-null  float64\n",
      " 11  stator_winding  998070 non-null  float64\n",
      " 12  profile_id      998070 non-null  int64  \n",
      "dtypes: float64(12), int64(1)\n",
      "memory usage: 99.0 MB\n"
     ]
    }
   ],
   "source": [
    "em.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "bb2cab48",
   "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>count</th>\n",
       "      <th>mean</th>\n",
       "      <th>std</th>\n",
       "      <th>min</th>\n",
       "      <th>25%</th>\n",
       "      <th>50%</th>\n",
       "      <th>75%</th>\n",
       "      <th>max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ambient</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>-0.003905</td>\n",
       "      <td>0.993127</td>\n",
       "      <td>-8.573954</td>\n",
       "      <td>-0.599385</td>\n",
       "      <td>0.266157</td>\n",
       "      <td>0.686675</td>\n",
       "      <td>2.967117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>coolant</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>0.004723</td>\n",
       "      <td>1.002423</td>\n",
       "      <td>-1.429349</td>\n",
       "      <td>-1.037925</td>\n",
       "      <td>-0.177187</td>\n",
       "      <td>0.650709</td>\n",
       "      <td>2.649032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>u_d</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>0.004780</td>\n",
       "      <td>0.997878</td>\n",
       "      <td>-1.655373</td>\n",
       "      <td>-0.826359</td>\n",
       "      <td>0.267542</td>\n",
       "      <td>0.358491</td>\n",
       "      <td>2.274734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>u_q</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>-0.005690</td>\n",
       "      <td>1.002330</td>\n",
       "      <td>-1.861463</td>\n",
       "      <td>-0.927390</td>\n",
       "      <td>-0.099818</td>\n",
       "      <td>0.852625</td>\n",
       "      <td>1.793498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>motor_speed</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>-0.006336</td>\n",
       "      <td>1.001229</td>\n",
       "      <td>-1.371529</td>\n",
       "      <td>-0.951892</td>\n",
       "      <td>-0.140246</td>\n",
       "      <td>0.853584</td>\n",
       "      <td>2.024164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>torque</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>-0.003333</td>\n",
       "      <td>0.997907</td>\n",
       "      <td>-3.345953</td>\n",
       "      <td>-0.266917</td>\n",
       "      <td>-0.187246</td>\n",
       "      <td>0.547171</td>\n",
       "      <td>3.016971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>i_d</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>0.006043</td>\n",
       "      <td>0.998994</td>\n",
       "      <td>-3.245874</td>\n",
       "      <td>-0.756296</td>\n",
       "      <td>0.213935</td>\n",
       "      <td>1.013975</td>\n",
       "      <td>1.060937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>i_q</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>-0.003194</td>\n",
       "      <td>0.997912</td>\n",
       "      <td>-3.341639</td>\n",
       "      <td>-0.257269</td>\n",
       "      <td>-0.190076</td>\n",
       "      <td>0.499260</td>\n",
       "      <td>2.914185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pm</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>-0.004396</td>\n",
       "      <td>0.995686</td>\n",
       "      <td>-2.631991</td>\n",
       "      <td>-0.672308</td>\n",
       "      <td>0.094367</td>\n",
       "      <td>0.680691</td>\n",
       "      <td>2.917456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stator_yoke</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>0.000609</td>\n",
       "      <td>1.001049</td>\n",
       "      <td>-1.834688</td>\n",
       "      <td>-0.747265</td>\n",
       "      <td>-0.057226</td>\n",
       "      <td>0.697344</td>\n",
       "      <td>2.449158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stator_tooth</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>-0.002208</td>\n",
       "      <td>0.999597</td>\n",
       "      <td>-2.066143</td>\n",
       "      <td>-0.761951</td>\n",
       "      <td>0.005085</td>\n",
       "      <td>0.772239</td>\n",
       "      <td>2.326668</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stator_winding</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>-0.003935</td>\n",
       "      <td>0.998343</td>\n",
       "      <td>-2.019973</td>\n",
       "      <td>-0.725622</td>\n",
       "      <td>0.006536</td>\n",
       "      <td>0.725660</td>\n",
       "      <td>2.653781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>profile_id</th>\n",
       "      <td>998070.0</td>\n",
       "      <td>50.732001</td>\n",
       "      <td>22.073125</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>68.000000</td>\n",
       "      <td>81.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   count       mean        std       min        25%  \\\n",
       "ambient         998070.0  -0.003905   0.993127 -8.573954  -0.599385   \n",
       "coolant         998070.0   0.004723   1.002423 -1.429349  -1.037925   \n",
       "u_d             998070.0   0.004780   0.997878 -1.655373  -0.826359   \n",
       "u_q             998070.0  -0.005690   1.002330 -1.861463  -0.927390   \n",
       "motor_speed     998070.0  -0.006336   1.001229 -1.371529  -0.951892   \n",
       "torque          998070.0  -0.003333   0.997907 -3.345953  -0.266917   \n",
       "i_d             998070.0   0.006043   0.998994 -3.245874  -0.756296   \n",
       "i_q             998070.0  -0.003194   0.997912 -3.341639  -0.257269   \n",
       "pm              998070.0  -0.004396   0.995686 -2.631991  -0.672308   \n",
       "stator_yoke     998070.0   0.000609   1.001049 -1.834688  -0.747265   \n",
       "stator_tooth    998070.0  -0.002208   0.999597 -2.066143  -0.761951   \n",
       "stator_winding  998070.0  -0.003935   0.998343 -2.019973  -0.725622   \n",
       "profile_id      998070.0  50.732001  22.073125  4.000000  32.000000   \n",
       "\n",
       "                      50%        75%        max  \n",
       "ambient          0.266157   0.686675   2.967117  \n",
       "coolant         -0.177187   0.650709   2.649032  \n",
       "u_d              0.267542   0.358491   2.274734  \n",
       "u_q             -0.099818   0.852625   1.793498  \n",
       "motor_speed     -0.140246   0.853584   2.024164  \n",
       "torque          -0.187246   0.547171   3.016971  \n",
       "i_d              0.213935   1.013975   1.060937  \n",
       "i_q             -0.190076   0.499260   2.914185  \n",
       "pm               0.094367   0.680691   2.917456  \n",
       "stator_yoke     -0.057226   0.697344   2.449158  \n",
       "stator_tooth     0.005085   0.772239   2.326668  \n",
       "stator_winding   0.006536   0.725660   2.653781  \n",
       "profile_id      56.000000  68.000000  81.000000  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# computes various summary statistics, excluding NaN values\n",
    "\n",
    "em.describe().T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "c90fa6b5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ambient           0\n",
       "coolant           0\n",
       "u_d               0\n",
       "u_q               0\n",
       "motor_speed       0\n",
       "torque            0\n",
       "i_d               0\n",
       "i_q               0\n",
       "pm                0\n",
       "stator_yoke       0\n",
       "stator_tooth      0\n",
       "stator_winding    0\n",
       "profile_id        0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Check null values\n",
    "\n",
    "em.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "b351745a",
   "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>ambient</th>\n",
       "      <th>coolant</th>\n",
       "      <th>u_d</th>\n",
       "      <th>u_q</th>\n",
       "      <th>motor_speed</th>\n",
       "      <th>torque</th>\n",
       "      <th>i_d</th>\n",
       "      <th>i_q</th>\n",
       "      <th>pm</th>\n",
       "      <th>stator_yoke</th>\n",
       "      <th>stator_tooth</th>\n",
       "      <th>stator_winding</th>\n",
       "      <th>profile_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [ambient, coolant, u_d, u_q, motor_speed, torque, i_d, i_q, pm, stator_yoke, stator_tooth, stator_winding, profile_id]\n",
       "Index: []"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Print the duplicated values.\n",
    "\n",
    "em[em.duplicated()]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "857aa7c1",
   "metadata": {},
   "source": [
    "#### Observation: \n",
    "There are no duplicate values and null values present in this dataset."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "086e63c1",
   "metadata": {},
   "source": [
    "# Correlation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "53b9b473",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Pairlot for visualizing the correlation between features\n",
    "\n",
    "#sns.pairplot(em)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "91497228",
   "metadata": {},
   "source": [
    "#### Since there is no  proper pattern visible in the plot correlation matrix is used to get the magnitude of the correlations between the features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1a48a902",
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}