teste_ler_indicadores.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import models\n",
    "from models import get_raw_data, normalizar_sinal\n",
    "import os\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "pasta = 'database/dados_tratados/harmonicos_1'\n",
    "arquivos = os.listdir(pasta)\n",
    "arquivo = 'dados_extraidos_concatenado_novo.csv'\n",
    "coluna = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "sinal = get_raw_data.GetData(pasta,arquivo).GetDataframe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>rotacao_hz</th>\n",
       "      <th>maximo</th>\n",
       "      <th>rms</th>\n",
       "      <th>assimetria</th>\n",
       "      <th>curtose</th>\n",
       "      <th>fator_crista</th>\n",
       "      <th>pot_relativa_ball_fault</th>\n",
       "      <th>pot_ball_fault</th>\n",
       "      <th>pot_relativa_outer_race</th>\n",
       "      <th>pot_outer_race</th>\n",
       "      <th>pot_relativa_rotacao_hz</th>\n",
       "      <th>pot_rotacao_hz</th>\n",
       "      <th>sensor</th>\n",
       "      <th>normal</th>\n",
       "      <th>desalinhamento_horizontal</th>\n",
       "      <th>desalinhamento_vertical</th>\n",
       "      <th>desbalanceamento</th>\n",
       "      <th>ball_fault</th>\n",
       "      <th>outer_race</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1.2033</td>\n",
       "      <td>0.306913</td>\n",
       "      <td>0.383296</td>\n",
       "      <td>2.226203</td>\n",
       "      <td>3.920651</td>\n",
       "      <td>0.039027</td>\n",
       "      <td>4.115362e+05</td>\n",
       "      <td>0.028160</td>\n",
       "      <td>2.969424e+05</td>\n",
       "      <td>0.027424</td>\n",
       "      <td>2.891789e+05</td>\n",
       "      <td>rolamento_interno_radial1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1.4075</td>\n",
       "      <td>0.307380</td>\n",
       "      <td>0.384100</td>\n",
       "      <td>2.235281</td>\n",
       "      <td>4.579019</td>\n",
       "      <td>0.041382</td>\n",
       "      <td>4.358113e+05</td>\n",
       "      <td>0.024106</td>\n",
       "      <td>2.538694e+05</td>\n",
       "      <td>0.027466</td>\n",
       "      <td>2.892588e+05</td>\n",
       "      <td>rolamento_interno_radial1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1.4075</td>\n",
       "      <td>0.307292</td>\n",
       "      <td>0.381222</td>\n",
       "      <td>2.234560</td>\n",
       "      <td>4.580335</td>\n",
       "      <td>0.038949</td>\n",
       "      <td>4.092999e+05</td>\n",
       "      <td>0.022481</td>\n",
       "      <td>2.362429e+05</td>\n",
       "      <td>0.028774</td>\n",
       "      <td>3.023790e+05</td>\n",
       "      <td>rolamento_interno_radial1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1.5157</td>\n",
       "      <td>0.307326</td>\n",
       "      <td>0.393851</td>\n",
       "      <td>2.280551</td>\n",
       "      <td>4.931897</td>\n",
       "      <td>0.037949</td>\n",
       "      <td>4.123530e+05</td>\n",
       "      <td>0.025843</td>\n",
       "      <td>2.808105e+05</td>\n",
       "      <td>0.027161</td>\n",
       "      <td>2.951304e+05</td>\n",
       "      <td>rolamento_interno_radial1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12.0</td>\n",
       "      <td>1.5157</td>\n",
       "      <td>0.305832</td>\n",
       "      <td>0.391510</td>\n",
       "      <td>2.264915</td>\n",
       "      <td>4.955982</td>\n",
       "      <td>0.038167</td>\n",
       "      <td>4.093769e+05</td>\n",
       "      <td>0.024987</td>\n",
       "      <td>2.680151e+05</td>\n",
       "      <td>0.024279</td>\n",
       "      <td>2.604166e+05</td>\n",
       "      <td>rolamento_interno_radial1</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49603</th>\n",
       "      <td>57.6</td>\n",
       "      <td>5.7978</td>\n",
       "      <td>2.212795</td>\n",
       "      <td>0.067106</td>\n",
       "      <td>1.806046</td>\n",
       "      <td>2.620125</td>\n",
       "      <td>0.006414</td>\n",
       "      <td>3.696026e+07</td>\n",
       "      <td>0.004176</td>\n",
       "      <td>2.406313e+07</td>\n",
       "      <td>0.928131</td>\n",
       "      <td>5.348111e+09</td>\n",
       "      <td>rolamento_externo_radial2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49604</th>\n",
       "      <td>57.6</td>\n",
       "      <td>6.4505</td>\n",
       "      <td>2.207261</td>\n",
       "      <td>0.071203</td>\n",
       "      <td>1.813567</td>\n",
       "      <td>2.922400</td>\n",
       "      <td>0.004236</td>\n",
       "      <td>2.417095e+07</td>\n",
       "      <td>0.002744</td>\n",
       "      <td>1.566129e+07</td>\n",
       "      <td>0.928852</td>\n",
       "      <td>5.300479e+09</td>\n",
       "      <td>rolamento_externo_radial2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49605</th>\n",
       "      <td>57.6</td>\n",
       "      <td>6.4505</td>\n",
       "      <td>2.209941</td>\n",
       "      <td>0.071359</td>\n",
       "      <td>1.824577</td>\n",
       "      <td>2.918856</td>\n",
       "      <td>0.006761</td>\n",
       "      <td>3.851234e+07</td>\n",
       "      <td>0.003692</td>\n",
       "      <td>2.102779e+07</td>\n",
       "      <td>0.924839</td>\n",
       "      <td>5.267838e+09</td>\n",
       "      <td>rolamento_externo_radial2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49606</th>\n",
       "      <td>57.6</td>\n",
       "      <td>6.3605</td>\n",
       "      <td>2.212875</td>\n",
       "      <td>0.053552</td>\n",
       "      <td>1.839344</td>\n",
       "      <td>2.874315</td>\n",
       "      <td>0.004456</td>\n",
       "      <td>2.540897e+07</td>\n",
       "      <td>0.003395</td>\n",
       "      <td>1.935747e+07</td>\n",
       "      <td>0.921844</td>\n",
       "      <td>5.256313e+09</td>\n",
       "      <td>rolamento_externo_radial2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49607</th>\n",
       "      <td>57.6</td>\n",
       "      <td>6.5212</td>\n",
       "      <td>2.219202</td>\n",
       "      <td>0.070172</td>\n",
       "      <td>1.844844</td>\n",
       "      <td>2.938534</td>\n",
       "      <td>0.005157</td>\n",
       "      <td>2.945398e+07</td>\n",
       "      <td>0.004447</td>\n",
       "      <td>2.539932e+07</td>\n",
       "      <td>0.921565</td>\n",
       "      <td>5.263282e+09</td>\n",
       "      <td>rolamento_externo_radial2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49608 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       rotacao_hz  maximo       rms  assimetria   curtose  fator_crista  \\\n",
       "0            12.0  1.2033  0.306913    0.383296  2.226203      3.920651   \n",
       "1            12.0  1.4075  0.307380    0.384100  2.235281      4.579019   \n",
       "2            12.0  1.4075  0.307292    0.381222  2.234560      4.580335   \n",
       "3            12.0  1.5157  0.307326    0.393851  2.280551      4.931897   \n",
       "4            12.0  1.5157  0.305832    0.391510  2.264915      4.955982   \n",
       "...           ...     ...       ...         ...       ...           ...   \n",
       "49603        57.6  5.7978  2.212795    0.067106  1.806046      2.620125   \n",
       "49604        57.6  6.4505  2.207261    0.071203  1.813567      2.922400   \n",
       "49605        57.6  6.4505  2.209941    0.071359  1.824577      2.918856   \n",
       "49606        57.6  6.3605  2.212875    0.053552  1.839344      2.874315   \n",
       "49607        57.6  6.5212  2.219202    0.070172  1.844844      2.938534   \n",
       "\n",
       "       pot_relativa_ball_fault  pot_ball_fault  pot_relativa_outer_race  \\\n",
       "0                     0.039027    4.115362e+05                 0.028160   \n",
       "1                     0.041382    4.358113e+05                 0.024106   \n",
       "2                     0.038949    4.092999e+05                 0.022481   \n",
       "3                     0.037949    4.123530e+05                 0.025843   \n",
       "4                     0.038167    4.093769e+05                 0.024987   \n",
       "...                        ...             ...                      ...   \n",
       "49603                 0.006414    3.696026e+07                 0.004176   \n",
       "49604                 0.004236    2.417095e+07                 0.002744   \n",
       "49605                 0.006761    3.851234e+07                 0.003692   \n",
       "49606                 0.004456    2.540897e+07                 0.003395   \n",
       "49607                 0.005157    2.945398e+07                 0.004447   \n",
       "\n",
       "       pot_outer_race  pot_relativa_rotacao_hz  pot_rotacao_hz  \\\n",
       "0        2.969424e+05                 0.027424    2.891789e+05   \n",
       "1        2.538694e+05                 0.027466    2.892588e+05   \n",
       "2        2.362429e+05                 0.028774    3.023790e+05   \n",
       "3        2.808105e+05                 0.027161    2.951304e+05   \n",
       "4        2.680151e+05                 0.024279    2.604166e+05   \n",
       "...               ...                      ...             ...   \n",
       "49603    2.406313e+07                 0.928131    5.348111e+09   \n",
       "49604    1.566129e+07                 0.928852    5.300479e+09   \n",
       "49605    2.102779e+07                 0.924839    5.267838e+09   \n",
       "49606    1.935747e+07                 0.921844    5.256313e+09   \n",
       "49607    2.539932e+07                 0.921565    5.263282e+09   \n",
       "\n",
       "                          sensor  normal  desalinhamento_horizontal  \\\n",
       "0      rolamento_interno_radial1       1                        0.0   \n",
       "1      rolamento_interno_radial1       1                        0.0   \n",
       "2      rolamento_interno_radial1       1                        0.0   \n",
       "3      rolamento_interno_radial1       1                        0.0   \n",
       "4      rolamento_interno_radial1       1                        0.0   \n",
       "...                          ...     ...                        ...   \n",
       "49603  rolamento_externo_radial2       0                        0.0   \n",
       "49604  rolamento_externo_radial2       0                        0.0   \n",
       "49605  rolamento_externo_radial2       0                        0.0   \n",
       "49606  rolamento_externo_radial2       0                        0.0   \n",
       "49607  rolamento_externo_radial2       0                        0.0   \n",
       "\n",
       "       desalinhamento_vertical  desbalanceamento  ball_fault  outer_race  \n",
       "0                          0.0               0.0         0.0         0.0  \n",
       "1                          0.0               0.0         0.0         0.0  \n",
       "2                          0.0               0.0         0.0         0.0  \n",
       "3                          0.0               0.0         0.0         0.0  \n",
       "4                          0.0               0.0         0.0         0.0  \n",
       "...                        ...               ...         ...         ...  \n",
       "49603                      0.0               0.0         0.0        35.0  \n",
       "49604                      0.0               0.0         0.0        35.0  \n",
       "49605                      0.0               0.0         0.0        35.0  \n",
       "49606                      0.0               0.0         0.0        35.0  \n",
       "49607                      0.0               0.0         0.0        35.0  \n",
       "\n",
       "[49608 rows x 19 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sinal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Arquivo salvo com sucesso!\n",
      "database/dados_tratados/harmonicos_1/Dados_Normalizados.csv\n"
     ]
    }
   ],
   "source": [
    "normalizar_sinal.NormalizarSinal(sinal,1,2).save_as_csv()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>rotacao_hz</th>\n",
       "      <th>maximo</th>\n",
       "      <th>rms</th>\n",
       "      <th>assimetria</th>\n",
       "      <th>curtose</th>\n",
       "      <th>fator_crista</th>\n",
       "      <th>pot_ball_fault</th>\n",
       "      <th>pot_outer_race</th>\n",
       "      <th>pot_rotacao_hz</th>\n",
       "      <th>sensor</th>\n",
       "      <th>normal</th>\n",
       "      <th>desalinhamento_horizontal</th>\n",
       "      <th>desalinhamento_vertical</th>\n",
       "      <th>desbalanceamento</th>\n",
       "      <th>ball_fault</th>\n",
       "      <th>outer_race</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.282094</td>\n",
       "      <td>0.275661</td>\n",
       "      <td>0.466259</td>\n",
       "      <td>0.146040</td>\n",
       "      <td>0.341173</td>\n",
       "      <td>0.005802</td>\n",
       "      <td>0.004186</td>\n",
       "      <td>0.004077</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.332706</td>\n",
       "      <td>0.276122</td>\n",
       "      <td>0.467238</td>\n",
       "      <td>0.148418</td>\n",
       "      <td>0.466092</td>\n",
       "      <td>0.006144</td>\n",
       "      <td>0.003579</td>\n",
       "      <td>0.004078</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.332706</td>\n",
       "      <td>0.276035</td>\n",
       "      <td>0.463734</td>\n",
       "      <td>0.148229</td>\n",
       "      <td>0.466341</td>\n",
       "      <td>0.005770</td>\n",
       "      <td>0.003331</td>\n",
       "      <td>0.004263</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.359523</td>\n",
       "      <td>0.276068</td>\n",
       "      <td>0.479110</td>\n",
       "      <td>0.160277</td>\n",
       "      <td>0.533047</td>\n",
       "      <td>0.005814</td>\n",
       "      <td>0.003959</td>\n",
       "      <td>0.004161</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.359523</td>\n",
       "      <td>0.274593</td>\n",
       "      <td>0.476260</td>\n",
       "      <td>0.156181</td>\n",
       "      <td>0.537617</td>\n",
       "      <td>0.005772</td>\n",
       "      <td>0.003779</td>\n",
       "      <td>0.003671</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49603</th>\n",
       "      <td>0.95</td>\n",
       "      <td>1.420854</td>\n",
       "      <td>2.157980</td>\n",
       "      <td>0.081319</td>\n",
       "      <td>0.035974</td>\n",
       "      <td>0.094412</td>\n",
       "      <td>0.521079</td>\n",
       "      <td>0.339251</td>\n",
       "      <td>75.399603</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49604</th>\n",
       "      <td>0.95</td>\n",
       "      <td>1.582628</td>\n",
       "      <td>2.152515</td>\n",
       "      <td>0.086307</td>\n",
       "      <td>0.037944</td>\n",
       "      <td>0.151765</td>\n",
       "      <td>0.340771</td>\n",
       "      <td>0.220798</td>\n",
       "      <td>74.728060</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49605</th>\n",
       "      <td>0.95</td>\n",
       "      <td>1.582628</td>\n",
       "      <td>2.155161</td>\n",
       "      <td>0.086497</td>\n",
       "      <td>0.040828</td>\n",
       "      <td>0.151093</td>\n",
       "      <td>0.542961</td>\n",
       "      <td>0.296457</td>\n",
       "      <td>74.267885</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49606</th>\n",
       "      <td>0.95</td>\n",
       "      <td>1.560321</td>\n",
       "      <td>2.158060</td>\n",
       "      <td>0.064818</td>\n",
       "      <td>0.044697</td>\n",
       "      <td>0.142641</td>\n",
       "      <td>0.358225</td>\n",
       "      <td>0.272909</td>\n",
       "      <td>74.105395</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49607</th>\n",
       "      <td>0.95</td>\n",
       "      <td>1.600151</td>\n",
       "      <td>2.164308</td>\n",
       "      <td>0.085052</td>\n",
       "      <td>0.046138</td>\n",
       "      <td>0.154826</td>\n",
       "      <td>0.415253</td>\n",
       "      <td>0.358089</td>\n",
       "      <td>74.203646</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49608 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       rotacao_hz    maximo       rms  assimetria   curtose  fator_crista  \\\n",
       "0            0.00  0.282094  0.275661    0.466259  0.146040      0.341173   \n",
       "1            0.00  0.332706  0.276122    0.467238  0.148418      0.466092   \n",
       "2            0.00  0.332706  0.276035    0.463734  0.148229      0.466341   \n",
       "3            0.00  0.359523  0.276068    0.479110  0.160277      0.533047   \n",
       "4            0.00  0.359523  0.274593    0.476260  0.156181      0.537617   \n",
       "...           ...       ...       ...         ...       ...           ...   \n",
       "49603        0.95  1.420854  2.157980    0.081319  0.035974      0.094412   \n",
       "49604        0.95  1.582628  2.152515    0.086307  0.037944      0.151765   \n",
       "49605        0.95  1.582628  2.155161    0.086497  0.040828      0.151093   \n",
       "49606        0.95  1.560321  2.158060    0.064818  0.044697      0.142641   \n",
       "49607        0.95  1.600151  2.164308    0.085052  0.046138      0.154826   \n",
       "\n",
       "       pot_ball_fault  pot_outer_race  pot_rotacao_hz  sensor  normal  \\\n",
       "0            0.005802        0.004186        0.004077     0.0       1   \n",
       "1            0.006144        0.003579        0.004078     0.0       1   \n",
       "2            0.005770        0.003331        0.004263     0.0       1   \n",
       "3            0.005814        0.003959        0.004161     0.0       1   \n",
       "4            0.005772        0.003779        0.003671     0.0       1   \n",
       "...               ...             ...             ...     ...     ...   \n",
       "49603        0.521079        0.339251       75.399603     1.0       0   \n",
       "49604        0.340771        0.220798       74.728060     1.0       0   \n",
       "49605        0.542961        0.296457       74.267885     1.0       0   \n",
       "49606        0.358225        0.272909       74.105395     1.0       0   \n",
       "49607        0.415253        0.358089       74.203646     1.0       0   \n",
       "\n",
       "       desalinhamento_horizontal  desalinhamento_vertical  desbalanceamento  \\\n",
       "0                            0.0                      0.0               0.0   \n",
       "1                            0.0                      0.0               0.0   \n",
       "2                            0.0                      0.0               0.0   \n",
       "3                            0.0                      0.0               0.0   \n",
       "4                            0.0                      0.0               0.0   \n",
       "...                          ...                      ...               ...   \n",
       "49603                        0.0                      0.0               0.0   \n",
       "49604                        0.0                      0.0               0.0   \n",
       "49605                        0.0                      0.0               0.0   \n",
       "49606                        0.0                      0.0               0.0   \n",
       "49607                        0.0                      0.0               0.0   \n",
       "\n",
       "       ball_fault  outer_race  \n",
       "0             0.0         0.0  \n",
       "1             0.0         0.0  \n",
       "2             0.0         0.0  \n",
       "3             0.0         0.0  \n",
       "4             0.0         0.0  \n",
       "...           ...         ...  \n",
       "49603         0.0        35.0  \n",
       "49604         0.0        35.0  \n",
       "49605         0.0        35.0  \n",
       "49606         0.0        35.0  \n",
       "49607         0.0        35.0  \n",
       "\n",
       "[49608 rows x 16 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dado_normal = get_raw_data.GetData(pasta,\"Dados_Normalizados.csv\").GetDataframe()\n",
    "dado_normal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "feature = 'pot_rotacao_hz'\n",
    "feature_analisada = sinal[feature]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.plot(range(len(feature_analisada)),feature_analisada)\n",
    "plt.title(feature)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "defeito = \"desbalanceamento_alto\"\n",
    "sensor = 'rolamento_interno_axial'\n",
    "\n",
    "df_defeito = sinal[sinal[\"defeito\"] == defeito]\n",
    "df_defeito = df_defeito[df_defeito[\"sensor\"] == sensor]\n",
    "\n",
    "rotacao = df_defeito['rotacao_hz']\n",
    "feature_analisada = df_defeito[feature]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.plot(range(len(rotacao)),rotacao)\n",
    "plt.title('Rotação [Hz]')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.plot(range(len(feature_analisada)),feature_analisada)\n",
    "plt.title(feature)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "print(sinal)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.5"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "7ae7d46be2641d6e2c6d3fb52459160c7ebfdbc26f33f0f4d78b2d35162b5186"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}