## 4 Data Analysis and Methodology
#### Data Collection and Integration
\begin{table}
\begin{tabular}{l l l} \hline \hline
**No.** & **Variable/Attribute** & **Description** \\ \hline A54 & MEAN & Average consumption \\ A55 & MEDIAN & Median consumption \\ A56 & MAX & Maximum consumption value recorded \\ A57 & MIN & Minimum consumption value recorded \\ A58 & RANGE & Difference: maximum value - minimum value \\ A59 & STDEV & Coefficient of variation in consumption \\ A60 & STAN\_DEVIA & Standard deviation of consumption \\ A61 & MEDIAN\_QUARTILE & Range divided by two \\ A62 & NUM\_ZEROS & Number of times the consumption is zero \\ A63 & REG1\_INCREASE & Number of times the consumption increases compared with the first \\ A64 & REG1\_DECREASE & Number of times the consumption decreases compared with the first \\ A65 & REG\_AUM\_PRO & Number of times the consumption increases compared with the average consumption \\ A66 & REG\_DIS\_PRO & Number of times the consumption decreases compared with the average consumption \\ A67 & REG\_AUM\_MED & Number of times the consumption increases compared with the median consumption \\ A68 & REG\_DIS\_MED & Number of times the consumption decreases compared with the median consumption \\ \hline \hline \end{tabular}
\end{table} 
Table 4: Descriptive statistics of deterministic variables. \begin{table}
\begin{tabular}{l l l l l l} \hline \hline
**Variable** & **Count** & **Mean** & **Std** & **Min** & **Max** \\ \hline CLICOD & 30,026 & 3,065,145 & 2,816,055 & 100,103 & 8,997,481 \\ SEQUEN & 30,026 & 277,243.6 & 270,561 & 600 & 8,003,400 \\ YEAR & 29,319 & 2014.1157 & 6.567368 & 1972 & 2021 \\ DATE\_INSTALLEDC & 29,235 & 19,395,480 & 3,859,021 & 0 & 20,210,600 \\ AMOUNT / DEBT & 28,620 & 62.021783 & 361.811714 & \(-\)0.03 & 37,943.1 \\ MONTHS\_DEBT & 29,620 & 1.559558 & 3.904805 & 0 & 61 \\ DATE\_RE-INV & 1644 & 20,186,270 & 23,234.05 & 20,100,220 & 20,210,530 \\ P\_FACTOR & 30,026 & 0.99977 & 0.009135 & 0.220877 & 1 \\ TJUN\_18 & 30,026 & 290.1325 & 7082.58 & 0 & 1,017,104 \\ TJUL\_18 & 30,005 & 225.537268 & 2397.2796 & 0 & 290,801 \\... &... &... &... &... &... \\ REG1\_AUM & 30,026 & 13.56 & 11.47 & 0 & 35 \\ REG1\_DIS & 30,026 & 14.72 & 12.00 & 0 & 35 \\ REG\_AUM\_PRO & 30,026 & 15.21 & 5.36 & 0 & 33 \\ REG\_DIS\_PRO & 30,026 & 17.39 & 6.13 & 0 & 35 \\ REG\_AUM\_MED & 30,026 & 21.19 & 12.21 & 0 & 36 \\ REG\_DIS\_MED & 30,026 & 11.69 & 11.34 & 0 & 35 \\ \hline \hline \end{tabular}
\end{table} 
Table 5: Descriptive statistics. Based on the results presented in Tables 5 (descriptive statistics) and 6 (existing null values), the following is determined:  
* Not all variables have complete records, especially in the consumption variables, which should be taken into account when cleaning the data. * There are high values of standard deviation, due to the fact that the database contains profiles of residential, commercial, and industrial customers. Therefore, the variation in consumption is high. This can also be evidenced in the difference between the maximum and minimum values, that is, the range (MAX-MIN) will be large. * In variable A15, there are a large number of null values (blank or empty), so this variable could be removed from the database. In this case, it is decided to keep the variable for information, but it will not be considered for the training of classification techniques. As observed in Table 5, there are high values in the standard deviation, due to the existence of customer profiles with different tariffs, which is reflected in a high variation in consumption. In the analyzed database, five types of tariffs are evident: