# UNIVERSIDAD CENTRAL DEL ECUADOR
# Facultad de Ingeniería en Geología, Minas, Petroleos y Ambiental
# Ingeniería Ambiental
# Autor: GUERRERO MARIA GABRIELA
# fecha:14/05/2025
library(readxl)
library(readr)
datos <- read_excel("C:/Users/User/Downloads/maate_focosdecalor_bdd_2021diciembre (2).xlsx")
# Guardar como CSV
write_csv(datos, "C:/Users/User/Downloads/maate_focosdecalor_bdd_2021diciembre (2).csv")
datos <- read.csv("C:/Users/User/Downloads/maate_focosdecalor_bdd_2021diciembre (2).csv",
header = TRUE,
sep = ",",
dec = ".",
fileEncoding = "UTF-8")
library(DescTools)
datos <- datos # tu dataframe original
# Primero, revisa un par de valores BRIGHTNESS
head(datos$BRIGHTNESS)
## [1] "354,759999999999990" "342,009999999999990" "331,860000000000010"
## [4] "331,399999999999980" "328,000000000000000" "341,800000000000010"
datos$BRIGHTNESS <- as.numeric(gsub(",", ".", datos$BRIGHTNESS))
str(datos$BRIGHTNESS)
## num [1:22476] 355 342 332 331 328 ...
BRIGHTNESS <- na.omit (datos$BRIGHTNESS)
summary(datos$BRIGHTNESS)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 207.9 331.6 336.1 335.3 342.3 367.0
sum(is.na(datos$BRIGHTNESS_num)) # Cuántos NAs quedaron
## [1] 0
# Primero, revisa un par de valores FRP
head(datos$FRP)
## [1] "12,100000000000000" "6,870000000000000" "3,770000000000000"
## [4] "5,500000000000000" "2,900000000000000" "9,199999999999999"
table(substr(datos$FRP, 1, 10))
##
## 0,19000000 0,20000000 0,24000000 0,27000000 0,29000000 0,30000000 0,31000000
## 2 1 1 1 1 6 3
## 0,32000000 0,34000000 0,36000000 0,37000000 0,38000000 0,39000000 0,40000000
## 2 1 2 3 6 3 11
## 0,41000000 0,42000000 0,43000000 0,44000000 0,45000000 0,46000000 0,47000000
## 8 7 4 10 6 11 2
## 0,48000000 0,49000000 0,50000000 0,51000000 0,52000000 0,53000000 0,54000000
## 4 2 16 5 8 4 6
## 0,55000000 0,56000000 0,57000000 0,58000000 0,59000000 0,60000000 0,61000000
## 12 10 13 11 7 34 3
## 0,62000000 0,63000000 0,64000000 0,65000000 0,66000000 0,67000000 0,68000000
## 5 12 8 5 16 15 10
## 0,69000000 0,70000000 0,71000000 0,72000000 0,73000000 0,74000000 0,75000000
## 10 27 11 6 4 7 8
## 0,76000000 0,77000000 0,78000000 0,79000000 0,80000000 0,81000000 0,82000000
## 6 8 11 13 27 7 8
## 0,83000000 0,84000000 0,85000000 0,86000000 0,87000000 0,88000000 0,89000000
## 12 11 12 13 8 6 7
## 0,90000000 0,91000000 0,92000000 0,93000000 0,94000000 0,95000000 0,96000000
## 27 6 10 8 9 7 13
## 0,97000000 0,98000000 0,99000000 1,00000000 1,01000000 1,02000000 1,03000000
## 15 8 9 42 11 10 7
## 1,04000000 1,05000000 1,06000000 1,07000000 1,08000000 1,09000000 1,10000000
## 8 14 11 4 11 10 32
## 1,11000000 1,12000000 1,13000000 1,14000000 1,15000000 1,16000000 1,17000000
## 5 8 10 10 16 6 15
## 1,18000000 1,19000000 1,20000000 1,21000000 1,22000000 1,23000000 1,24000000
## 9 10 40 11 14 13 11
## 1,25000000 1,26000000 1,27000000 1,28000000 1,29000000 1,30000000 1,31000000
## 6 6 14 16 13 39 14
## 1,32000000 1,33000000 1,34000000 1,35000000 1,36000000 1,37000000 1,38000000
## 16 17 17 11 8 12 11
## 1,39000000 1,40000000 1,41000000 1,42000000 1,43000000 1,44000000 1,45000000
## 19 33 9 9 10 11 22
## 1,46000000 1,47000000 1,48000000 1,49000000 1,50000000 1,51000000 1,52000000
## 14 17 6 10 41 11 13
## 1,53000000 1,54000000 1,55000000 1,56000000 1,57000000 1,58000000 1,59000000
## 14 16 18 18 14 21 13
## 1,60000000 1,61000000 1,62000000 1,63000000 1,64000000 1,65000000 1,66000000
## 43 10 10 16 8 12 17
## 1,67000000 1,68000000 1,69000000 1,70000000 1,71000000 1,72000000 1,73000000
## 13 16 28 40 8 13 9
## 1,74000000 1,75000000 1,76000000 1,77000000 1,78000000 1,79000000 1,80000000
## 10 7 16 21 22 21 44
## 1,81000000 1,82000000 1,83000000 1,84000000 1,85000000 1,86000000 1,87000000
## 18 7 21 9 20 20 13
## 1,88000000 1,89000000 1,90000000 1,91000000 1,92000000 1,93000000 1,94000000
## 18 20 33 26 13 15 14
## 1,95000000 1,96000000 1,97000000 1,98000000 1,99000000 10,0000000 10,0100000
## 16 22 18 22 15 9 9
## 10,0200000 10,0299999 10,0399999 10,0500000 10,0600000 10,0700000 10,0800000
## 5 8 11 6 6 4 13
## 10,0900000 10,1000000 10,1099999 10,1199999 10,1300000 10,1400000 10,1500000
## 3 15 3 7 10 8 9
## 10,1600000 10,1700000 10,1800000 10,1900000 10,1999999 10,2100000 10,2200000
## 5 9 5 6 6 12 13
## 10,2300000 10,2400000 10,2500000 10,2600000 10,2700000 10,2799999 10,2899999
## 7 7 3 3 7 6 2
## 10,3000000 10,3100000 10,3200000 10,3300000 10,3400000 10,3500000 10,3599999
## 17 13 2 8 6 4 3
## 10,3699999 10,3800000 10,3900000 10,4000000 10,4100000 10,4200000 10,4300000
## 4 4 6 8 5 7 10
## 10,4400000 10,4499999 10,4600000 10,4700000 10,4800000 10,4900000 10,5000000
## 5 4 5 10 3 3 10
## 10,5100000 10,5200000 10,5299999 10,5399999 10,5500000 10,5600000 10,5700000
## 3 7 6 5 10 6 5
## 10,5800000 10,5900000 10,6000000 10,6099999 10,6199999 10,6300000 10,6400000
## 3 8 6 3 1 11 5
## 10,6500000 10,6600000 10,6700000 10,6800000 10,6900000 10,6999999 10,7100000
## 5 1 5 7 2 9 7
## 10,7200000 10,7300000 10,7400000 10,7500000 10,7600000 10,7700000 10,7799999
## 3 2 5 3 10 3 4
## 10,7899999 10,8000000 10,8100000 10,8200000 10,8300000 10,8400000 10,8500000
## 6 10 2 9 8 3 8
## 10,8599999 10,8699999 10,8800000 10,8900000 10,9000000 10,9100000 10,9200000
## 5 8 5 10 7 3 4
## 10,9300000 10,9400000 10,9499999 10,9600000 10,9700000 10,9800000 10,9900000
## 4 5 4 6 9 11 6
## 100,000000 101,400000 101,470000 102,140000 104,000000 104,400000 104,510000
## 4 1 2 3 2 2 1
## 105,890000 107,849999 11,0000000 11,0100000 11,0200000 11,0299999 11,0399999
## 1 4 10 11 3 5 2
## 11,0500000 11,0600000 11,0700000 11,0800000 11,0900000 11,1000000 11,1099999
## 5 6 9 3 7 10 9
## 11,1199999 11,1300000 11,1400000 11,1500000 11,1600000 11,1700000 11,1800000
## 3 5 1 5 6 5 2
## 11,1900000 11,1999999 11,2100000 11,2200000 11,2300000 11,2400000 11,2500000
## 10 7 2 4 3 3 5
## 11,2600000 11,2700000 11,2799999 11,2899999 11,3000000 11,3100000 11,3200000
## 3 5 4 3 2 1 4
## 11,3300000 11,3400000 11,3500000 11,3599999 11,3699999 11,3800000 11,3900000
## 1 9 3 6 8 5 5
## 11,4000000 11,4100000 11,4200000 11,4300000 11,4400000 11,4499999 11,4600000
## 4 6 3 7 3 5 4
## 11,4700000 11,4800000 11,4900000 11,5000000 11,5100000 11,5200000 11,5299999
## 3 1 2 5 8 8 6
## 11,5399999 11,5500000 11,5600000 11,5700000 11,5800000 11,5900000 11,6000000
## 9 2 4 4 2 3 9
## 11,6099999 11,6199999 11,6300000 11,6400000 11,6500000 11,6600000 11,6700000
## 11 10 3 2 5 4 3
## 11,6800000 11,6900000 11,6999999 11,7100000 11,7200000 11,7300000 11,7400000
## 4 8 14 2 2 5 1
## 11,7500000 11,7600000 11,7700000 11,7799999 11,7899999 11,8000000 11,8100000
## 5 3 6 3 5 9 6
## 11,8200000 11,8300000 11,8400000 11,8500000 11,8599999 11,8699999 11,8800000
## 2 2 1 1 7 3 4
## 11,8900000 11,9000000 11,9100000 11,9200000 11,9300000 11,9499999 11,9600000
## 4 4 1 4 6 1 3
## 11,9700000 11,9800000 11,9900000 110,550000 111,160000 112,239999 112,420000
## 1 1 3 1 1 4 1
## 112,720000 113,200000 113,849999 114,450000 115,209999 115,400000 115,840000
## 2 2 4 1 3 1 1
## 116,790000 117,040000 12,0000000 12,0100000 12,0200000 12,0299999 12,0399999
## 1 2 1 7 5 4 1
## 12,0500000 12,0600000 12,0700000 12,0900000 12,1000000 12,1099999 12,1199999
## 7 4 2 5 5 7 6
## 12,1300000 12,1400000 12,1500000 12,1600000 12,1700000 12,1800000 12,1900000
## 2 4 4 3 4 6 2
## 12,1999999 12,2100000 12,2200000 12,2300000 12,2400000 12,2500000 12,2600000
## 7 3 2 8 7 2 2
## 12,2700000 12,2799999 12,2899999 12,3000000 12,3100000 12,3200000 12,3300000
## 5 7 5 5 3 5 3
## 12,3400000 12,3500000 12,3599999 12,3699999 12,3800000 12,3900000 12,4000000
## 10 3 1 1 4 1 8
## 12,4100000 12,4200000 12,4300000 12,4400000 12,4499999 12,4600000 12,4700000
## 2 8 6 3 1 7 5
## 12,4800000 12,4900000 12,5000000 12,5100000 12,5200000 12,5299999 12,5399999
## 3 5 5 3 3 4 7
## 12,5600000 12,5700000 12,5800000 12,5900000 12,6000000 12,6099999 12,6199999
## 9 3 9 6 4 4 3
## 12,6300000 12,6500000 12,6600000 12,6800000 12,6900000 12,6999999 12,7100000
## 5 3 1 1 1 10 3
## 12,7300000 12,7400000 12,7500000 12,7600000 12,7700000 12,7799999 12,7899999
## 1 2 1 1 2 1 3
## 12,8000000 12,8100000 12,8200000 12,8400000 12,8500000 12,8599999 12,8699999
## 4 3 7 4 2 4 5
## 12,8800000 12,8900000 12,9000000 12,9100000 12,9200000 12,9300000 12,9400000
## 3 1 7 8 3 4 1
## 12,9499999 12,9600000 12,9700000 12,9800000 12,9900000 121,510000 122,800000
## 3 3 2 4 1 1 3
## 123,300000 123,770000 123,950000 124,770000 126,860000 126,940000 127,400000
## 1 3 1 1 1 2 2
## 127,440000 128,720000 129,370000 13,0000000 13,0200000 13,0299999 13,0399999
## 1 1 3 9 2 1 1
## 13,0500000 13,0600000 13,0800000 13,0900000 13,1000000 13,1099999 13,1199999
## 3 3 5 7 4 7 2
## 13,1300000 13,1400000 13,1500000 13,1600000 13,1700000 13,1800000 13,1900000
## 2 4 5 3 3 9 4
## 13,1999999 13,2100000 13,2200000 13,2300000 13,2400000 13,2500000 13,2600000
## 6 7 1 3 2 5 7
## 13,2700000 13,2799999 13,2899999 13,3000000 13,3100000 13,3300000 13,3400000
## 4 2 5 7 5 2 10
## 13,3500000 13,3599999 13,3699999 13,3800000 13,3900000 13,4000000 13,4100000
## 4 3 4 6 1 3 7
## 13,4200000 13,4300000 13,4499999 13,4600000 13,4700000 13,4800000 13,4900000
## 3 5 4 2 7 2 2
## 13,5100000 13,5200000 13,5299999 13,5399999 13,5500000 13,5600000 13,5700000
## 2 1 2 1 7 6 2
## 13,5800000 13,6000000 13,6099999 13,6199999 13,6300000 13,6400000 13,6500000
## 5 2 2 5 1 1 1
## 13,6600000 13,6700000 13,6800000 13,6900000 13,6999999 13,7100000 13,7200000
## 3 2 6 3 4 5 2
## 13,7300000 13,7400000 13,7500000 13,7600000 13,7700000 13,7799999 13,7899999
## 7 3 7 2 6 2 5
## 13,8000000 13,8100000 13,8200000 13,8300000 13,8400000 13,8599999 13,8699999
## 3 1 6 1 2 6 1
## 13,8800000 13,8900000 13,9000000 13,9100000 13,9200000 13,9300000 13,9400000
## 2 1 8 1 7 2 6
## 13,9499999 13,9600000 13,9700000 13,9800000 13,9900000 130,310000 132,780000
## 1 1 4 4 5 1 1
## 132,830000 139,000000 14,0000000 14,0100000 14,0200000 14,0299999 14,0399999
## 1 1 2 3 1 5 4
## 14,0500000 14,0600000 14,0700000 14,0900000 14,1099999 14,1199999 14,1300000
## 5 2 1 2 1 2 2
## 14,1400000 14,1600000 14,1700000 14,1800000 14,1900000 14,1999999 14,2100000
## 2 1 1 4 1 3 3
## 14,2200000 14,2300000 14,2400000 14,2500000 14,2600000 14,2799999 14,2899999
## 6 3 2 2 2 3 3
## 14,3000000 14,3100000 14,3200000 14,3300000 14,3400000 14,3500000 14,3599999
## 2 3 3 1 1 4 2
## 14,3699999 14,3800000 14,3900000 14,4000000 14,4100000 14,4200000 14,4300000
## 4 3 2 1 6 2 2
## 14,4400000 14,4499999 14,4600000 14,4700000 14,4800000 14,4900000 14,5000000
## 1 3 1 3 5 3 2
## 14,5100000 14,5200000 14,5299999 14,5500000 14,5600000 14,5700000 14,5800000
## 5 2 1 7 1 3 2
## 14,5900000 14,6000000 14,6099999 14,6199999 14,6300000 14,6400000 14,6500000
## 4 9 3 5 1 3 8
## 14,6800000 14,6900000 14,6999999 14,7100000 14,7200000 14,7300000 14,7400000
## 5 1 3 3 5 4 3
## 14,7700000 14,7799999 14,7899999 14,8000000 14,8200000 14,8300000 14,8400000
## 2 3 6 1 1 1 2
## 14,8500000 14,8699999 14,8900000 14,9000000 14,9100000 14,9200000 14,9400000
## 1 3 2 3 4 2 2
## 14,9499999 14,9600000 14,9700000 14,9800000 14,9900000 140,139999 142,539999
## 2 3 1 2 2 2 1
## 144,120000 144,810000 148,830000 15,0000000 15,0100000 15,0200000 15,0299999
## 2 3 3 1 4 5 1
## 15,0500000 15,0600000 15,0700000 15,0800000 15,0900000 15,1000000 15,1199999
## 10 3 4 1 2 2 2
## 15,1300000 15,1400000 15,1500000 15,1600000 15,1800000 15,1900000 15,1999999
## 3 1 3 1 7 2 5
## 15,2100000 15,2200000 15,2300000 15,2400000 15,2500000 15,2600000 15,2700000
## 2 1 2 1 3 1 3
## 15,2799999 15,2899999 15,3000000 15,3100000 15,3200000 15,3400000 15,3500000
## 4 7 4 1 4 3 2
## 15,3599999 15,3699999 15,3900000 15,4000000 15,4200000 15,4400000 15,4499999
## 2 1 2 6 2 2 1
## 15,4600000 15,4700000 15,4900000 15,5000000 15,5200000 15,5399999 15,5500000
## 1 4 3 8 2 3 3
## 15,5600000 15,5700000 15,5900000 15,6000000 15,6099999 15,6199999 15,6300000
## 4 2 1 3 5 3 1
## 15,6400000 15,6500000 15,6600000 15,6700000 15,6800000 15,6900000 15,6999999
## 4 2 3 1 6 2 2
## 15,7100000 15,7300000 15,7600000 15,7700000 15,7799999 15,8000000 15,8100000
## 2 1 1 1 2 1 2
## 15,8300000 15,8400000 15,8500000 15,8599999 15,8699999 15,8800000 15,8900000
## 1 1 1 3 1 3 5
## 15,9000000 15,9100000 15,9300000 15,9400000 15,9499999 15,9600000 15,9700000
## 1 1 2 1 4 4 7
## 15,9800000 15,9900000 150,270000 155,160000 158,020000 16,0000000 16,0100000
## 4 1 1 1 1 8 1
## 16,0200000 16,0300000 16,0399999 16,0500000 16,0599999 16,0799999 16,0900000
## 4 1 2 2 1 2 3
## 16,1000000 16,1099999 16,1200000 16,1299999 16,1400000 16,1499999 16,1600000
## 3 3 5 1 1 3 10
## 16,1700000 16,1800000 16,1900000 16,2300000 16,2399999 16,2500000 16,2600000
## 2 3 2 1 5 4 1
## 16,2800000 16,2899999 16,3000000 16,3099999 16,3200000 16,3299999 16,3400000
## 1 3 4 6 4 1 3
## 16,3599999 16,3700000 16,3799999 16,3999999 16,4100000 16,4300000 16,4499999
## 4 4 1 4 1 1 3
## 16,4600000 16,4800000 16,4899999 16,5000000 16,5200000 16,5300000 16,5399999
## 1 2 1 5 1 2 2
## 16,5500000 16,5599999 16,5700000 16,5900000 16,6000000 16,6099999 16,6200000
## 1 1 2 1 4 3 1
## 16,6299999 16,6400000 16,6600000 16,6700000 16,6800000 16,6999999 16,7100000
## 2 2 3 5 2 6 1
## 16,7199999 16,7399999 16,7500000 16,7600000 16,7700000 16,7899999 16,8000000
## 3 2 2 4 1 2 5
## 16,8099999 16,8299999 16,8599999 16,8700000 16,8900000 16,8999999 16,9100000
## 4 3 1 1 1 7 1
## 16,9200000 16,9300000 16,9400000 16,9600000 16,9699999 16,9800000 162,449999
## 3 1 4 1 1 2 1
## 164,180000 164,819999 164,919999 166,610000 168,199999 17,0000000 17,0100000
## 2 2 1 1 1 2 3
## 17,0200000 17,0300000 17,0500000 17,0599999 17,0700000 17,0799999 17,0900000
## 2 1 2 4 1 5 3
## 17,1000000 17,1099999 17,1200000 17,1400000 17,1600000 17,1700000 17,1800000
## 1 6 1 4 3 1 4
## 17,1900000 17,1999999 17,2100000 17,2300000 17,2399999 17,2500000 17,2600000
## 3 2 3 1 4 2 1
## 17,2700000 17,2800000 17,2899999 17,3000000 17,3200000 17,3299999 17,3400000
## 2 2 5 5 3 1 1
## 17,3500000 17,3599999 17,3900000 17,4100000 17,4400000 17,4499999 17,4899999
## 2 1 1 2 2 3 2
## 17,5000000 17,5100000 17,5200000 17,5300000 17,5399999 17,5500000 17,5599999
## 6 1 2 5 2 1 1
## 17,5700000 17,5799999 17,6000000 17,6099999 17,6200000 17,6400000 17,6499999
## 6 2 3 1 4 1 3
## 17,6600000 17,6700000 17,6800000 17,6900000 17,7100000 17,7199999 17,7500000
## 2 2 2 1 5 5 1
## 17,7600000 17,7700000 17,7800000 17,8000000 17,8099999 17,8200000 17,8299999
## 2 1 1 5 1 2 5
## 17,8400000 17,8500000 17,8799999 17,8900000 17,8999999 17,9100000 17,9200000
## 1 3 1 2 4 2 2
## 17,9400000 17,9600000 17,9699999 17,9800000 17,9899999 171,280000 18,0000000
## 4 1 2 2 2 1 3
## 18,0200000 18,0300000 18,0399999 18,0500000 18,0599999 18,0700000 18,0900000
## 1 4 2 3 2 1 1
## 18,1000000 18,1099999 18,1299999 18,1499999 18,1800000 18,1900000 18,1999999
## 2 2 2 2 2 1 1
## 18,2100000 18,2300000 18,2500000 18,2600000 18,2800000 18,2899999 18,3000000
## 4 2 3 1 1 1 1
## 18,3200000 18,3299999 18,3700000 18,3799999 18,3900000 18,3999999 18,4200000
## 1 1 1 2 1 2 2
## 18,4300000 18,4600000 18,4699999 18,4800000 18,4899999 18,5000000 18,5200000
## 4 3 4 2 1 1 4
## 18,5300000 18,5399999 18,5500000 18,5599999 18,5700000 18,5799999 18,5900000
## 3 1 4 3 1 3 1
## 18,6000000 18,6099999 18,6200000 18,6299999 18,6400000 18,6700000 18,6800000
## 4 2 4 7 2 1 3
## 18,6999999 18,7100000 18,7199999 18,7300000 18,7500000 18,7700000 18,7800000
## 1 3 1 1 6 2 1
## 18,8000000 18,8099999 18,8200000 18,8299999 18,8400000 18,8599999 18,8700000
## 2 2 4 3 1 2 2
## 18,8799999 18,8900000 18,8999999 18,9200000 18,9499999 18,9600000 18,9699999
## 1 2 4 4 2 1 1
## 18,9800000 18,9899999 180,110000 19,0100000 19,0200000 19,0300000 19,0399999
## 2 1 2 1 2 4 2
## 19,0500000 19,0799999 19,0900000 19,1000000 19,1099999 19,1299999 19,1400000
## 4 2 1 6 5 4 1
## 19,1700000 19,1800000 19,1900000 19,1999999 19,2100000 19,2399999 19,2600000
## 2 5 1 3 1 1 3
## 19,2700000 19,2899999 19,3099999 19,3200000 19,3299999 19,3400000 19,3599999
## 1 2 2 3 1 2 2
## 19,3799999 19,3900000 19,3999999 19,4200000 19,4400000 19,4499999 19,4899999
## 1 3 1 2 1 2 1
## 19,5100000 19,5300000 19,5399999 19,5599999 19,6000000 19,6200000 19,6299999
## 2 2 1 2 4 1 1
## 19,6400000 19,6600000 19,6800000 19,6999999 19,7100000 19,7199999 19,7300000
## 3 2 1 1 3 1 2
## 19,7399999 19,7500000 19,7800000 19,7899999 19,8000000 19,8500000 19,8599999
## 1 1 2 3 1 3 1
## 19,8799999 19,9400000 19,9499999 19,9600000 19,9800000 19,9899999 2,00000000
## 1 3 1 1 3 2 41
## 2,01000000 2,02000000 2,03000000 2,04000000 2,05000000 2,06000000 2,07000000
## 15 18 21 18 18 20 17
## 2,08000000 2,09000000 2,10000000 2,11000000 2,12000000 2,13000000 2,14000000
## 29 8 45 16 30 23 23
## 2,15000000 2,16000000 2,17000000 2,18000000 2,19000000 2,20000000 2,21000000
## 20 13 24 23 26 42 24
## 2,22000000 2,23000000 2,24000000 2,25000000 2,26000000 2,27000000 2,28000000
## 17 39 26 20 20 17 13
## 2,29000000 2,30000000 2,31000000 2,32000000 2,33000000 2,34000000 2,35000000
## 19 45 23 26 20 22 31
## 2,36000000 2,37000000 2,38000000 2,39000000 2,40000000 2,41000000 2,42000000
## 26 25 35 22 64 29 18
## 2,43000000 2,44000000 2,45000000 2,46000000 2,47000000 2,48000000 2,49000000
## 16 20 28 23 25 25 22
## 2,50000000 2,51000000 2,52000000 2,53000000 2,54000000 2,55000000 2,56000000
## 58 34 25 30 22 32 17
## 2,57000000 2,58000000 2,59000000 2,60000000 2,61000000 2,62000000 2,63000000
## 21 35 27 47 23 32 26
## 2,64000000 2,65000000 2,66000000 2,67000000 2,68000000 2,69000000 2,70000000
## 32 31 27 40 14 20 48
## 2,71000000 2,72000000 2,73000000 2,74000000 2,75000000 2,76000000 2,77000000
## 28 25 16 20 26 24 37
## 2,78000000 2,79000000 2,80000000 2,81000000 2,82000000 2,83000000 2,84000000
## 27 25 61 34 18 37 26
## 2,85000000 2,86000000 2,87000000 2,88000000 2,89000000 2,90000000 2,91000000
## 30 23 24 40 31 55 31
## 2,92000000 2,93000000 2,94000000 2,95000000 2,96000000 2,97000000 2,98000000
## 15 30 30 28 28 23 26
## 2,99000000 20,0000000 20,0100000 20,0200000 20,0300000 20,0399999 20,0500000
## 22 1 1 5 1 1 4
## 20,0700000 20,0799999 20,1000000 20,1099999 20,1200000 20,1299999 20,1800000
## 1 3 8 2 2 9 2
## 20,1900000 20,1999999 20,2100000 20,2199999 20,2399999 20,2600000 20,2700000
## 1 4 1 2 3 3 3
## 20,2800000 20,3000000 20,3099999 20,3200000 20,3400000 20,3500000 20,3799999
## 1 2 2 1 3 1 1
## 20,3900000 20,3999999 20,4200000 20,4499999 20,4600000 20,4800000 20,4899999
## 1 3 2 1 2 2 4
## 20,5100000 20,5399999 20,5500000 20,5599999 20,5799999 20,6000000 20,6499999
## 2 1 3 1 4 2 6
## 20,6800000 20,6900000 20,6999999 20,7100000 20,7199999 20,7300000 20,7399999
## 1 1 1 4 4 2 1
## 20,7600000 20,7700000 20,7800000 20,8000000 20,8500000 20,8700000 20,8900000
## 3 1 1 1 2 2 1
## 20,9100000 20,9200000 20,9400000 20,9499999 20,9699999 20,9800000 21,0000000
## 3 1 1 2 1 2 3
## 21,0300000 21,0500000 21,0599999 21,0700000 21,0900000 21,1000000 21,1099999
## 1 2 1 4 1 3 1
## 21,1499999 21,1800000 21,1999999 21,2199999 21,2700000 21,3000000 21,3299999
## 2 2 3 1 1 4 1
## 21,3400000 21,3700000 21,3799999 21,3900000 21,3999999 21,4100000 21,4200000
## 2 4 4 1 2 3 4
## 21,4300000 21,4499999 21,4800000 21,5000000 21,5100000 21,5200000 21,5599999
## 3 1 1 2 6 1 2
## 21,5700000 21,5799999 21,5900000 21,6200000 21,6299999 21,6400000 21,6499999
## 1 3 5 5 4 3 1
## 21,6600000 21,6800000 21,6900000 21,6999999 21,7100000 21,7199999 21,7700000
## 3 2 1 2 1 6 3
## 21,7800000 21,8000000 21,8099999 21,8200000 21,8299999 21,8500000 21,8700000
## 2 3 4 5 10 2 3
## 21,8900000 21,8999999 21,9200000 22,0000000 22,0399999 22,0599999 22,1000000
## 2 1 1 3 1 2 1
## 22,1099999 22,1200000 22,1299999 22,1400000 22,1499999 22,1700000 22,1800000
## 1 3 3 2 7 1 1
## 22,1900000 22,1999999 22,2500000 22,2899999 22,3000000 22,3099999 22,3200000
## 1 2 1 1 2 5 2
## 22,3299999 22,3599999 22,3900000 22,3999999 22,4100000 22,4499999 22,4899999
## 2 2 5 2 1 3 1
## 22,5100000 22,5200000 22,5399999 22,5599999 22,5700000 22,6200000 22,6299999
## 2 1 2 1 5 2 1
## 22,6400000 22,6700000 22,6800000 22,6999999 22,7100000 22,7199999 22,7399999
## 3 1 4 3 1 1 2
## 22,7500000 22,7600000 22,7700000 22,7899999 22,8000000 22,8400000 22,8500000
## 1 1 1 1 1 1 1
## 22,8799999 22,8900000 22,8999999 22,9100000 22,9200000 22,9400000 22,9499999
## 2 1 1 1 3 1 2
## 22,9600000 222,830000 228,810000 23,0100000 23,0200000 23,0300000 23,0399999
## 1 2 1 1 1 2 1
## 23,0599999 23,0799999 23,0900000 23,1000000 23,1400000 23,1600000 23,1999999
## 1 1 1 3 1 2 1
## 23,2100000 23,2199999 23,2600000 23,2800000 23,3000000 23,3099999 23,3200000
## 3 1 1 1 1 1 4
## 23,3700000 23,3799999 23,3900000 23,4200000 23,4400000 23,5000000 23,5300000
## 1 1 2 2 1 2 2
## 23,5799999 23,6099999 23,6200000 23,6299999 23,6999999 23,7100000 23,7399999
## 2 1 1 1 1 1 2
## 23,7500000 23,7800000 23,8000000 23,8099999 23,8799999 23,8900000 23,9200000
## 1 3 3 2 2 3 1
## 23,9400000 23,9499999 230,729999 24,0000000 24,0599999 24,0900000 24,1000000
## 1 3 3 3 1 4 1
## 24,1099999 24,1299999 24,1400000 24,1999999 24,2199999 24,2300000 24,2399999
## 2 1 1 1 3 2 2
## 24,2600000 24,2700000 24,2800000 24,3000000 24,3099999 24,3299999 24,3400000
## 1 2 1 2 1 1 3
## 24,3700000 24,3799999 24,4200000 24,4499999 24,4699999 24,4800000 24,5300000
## 1 1 1 2 1 1 3
## 24,5399999 24,5599999 24,5700000 24,5900000 24,6000000 24,6499999 24,6700000
## 2 1 3 1 1 2 1
## 24,6800000 24,6999999 24,7100000 24,8099999 24,8599999 24,9200000 247,770000
## 1 2 1 3 1 2 2
## 248,220000 248,870000 25,0000000 25,0100000 25,0399999 25,1299999 25,1400000
## 1 1 4 4 3 4 2
## 25,2100000 25,2300000 25,2399999 25,2500000 25,2600000 25,2700000 25,2800000
## 1 1 4 2 4 2 1
## 25,3000000 25,3099999 25,3799999 25,4400000 25,4600000 25,4800000 25,4899999
## 3 2 1 2 1 1 2
## 25,5000000 25,5100000 25,5200000 25,5300000 25,5799999 25,6200000 25,6800000
## 1 1 1 1 1 1 2
## 25,7199999 25,7399999 25,7600000 25,8099999 25,8200000 25,8400000 25,8999999
## 1 1 1 3 2 1 3
## 25,9100000 25,9499999 25,9699999 25,9800000 25,9899999 259,829999 26,0000000
## 1 1 3 1 1 2 2
## 26,0100000 26,0399999 26,1200000 26,1299999 26,1400000 26,1600000 26,1900000
## 1 4 1 1 3 1 2
## 26,2199999 26,2399999 26,2500000 26,2899999 26,3099999 26,4200000 26,4600000
## 2 4 1 1 5 2 5
## 26,5599999 26,5799999 26,6000000 26,6099999 26,6200000 26,6600000 26,7199999
## 1 2 4 1 1 3 1
## 26,7500000 26,7700000 26,8000000 26,8299999 26,8400000 26,8500000 26,9100000
## 1 1 2 1 1 2 2
## 26,9699999 27,0000000 27,0100000 27,0799999 27,0900000 27,1299999 27,1999999
## 3 1 2 2 1 1 2
## 27,2300000 27,2500000 27,2700000 27,2800000 27,3200000 27,3400000 27,3500000
## 4 1 1 1 2 1 3
## 27,3700000 27,3900000 27,3999999 27,4699999 27,4899999 27,5300000 27,5399999
## 3 6 2 1 3 3 1
## 27,5599999 27,6000000 27,6200000 27,6400000 27,6499999 27,6700000 27,6800000
## 3 1 1 2 2 1 1
## 27,6900000 27,6999999 27,7100000 27,7700000 27,8000000 27,9200000 27,9300000
## 1 2 4 1 1 1 2
## 27,9499999 27,9800000 27,9899999 28,0399999 28,0599999 28,0900000 28,1099999
## 3 1 1 1 1 4 1
## 28,1700000 28,2399999 28,2800000 28,3000000 28,3700000 28,4400000 28,4600000
## 1 2 1 3 1 6 2
## 28,4699999 28,5000000 28,5200000 28,5799999 28,5900000 28,6000000 28,6099999
## 1 2 1 1 1 2 1
## 28,6800000 28,6900000 28,7100000 28,7199999 28,7399999 28,7600000 28,7899999
## 2 5 1 1 1 2 1
## 28,8299999 28,8599999 28,8999999 28,9400000 28,9499999 283,850000 287,660000
## 1 1 1 3 3 1 2
## 29,0000000 29,0200000 29,0300000 29,0399999 29,0599999 29,0799999 29,0900000
## 1 1 2 2 2 1 2
## 29,1000000 29,1499999 29,1800000 29,1999999 29,2100000 29,2199999 29,2700000
## 1 2 1 1 2 1 2
## 29,2899999 29,3000000 29,3099999 29,3400000 29,3500000 29,3900000 29,3999999
## 1 4 3 1 1 1 3
## 29,4400000 29,4699999 29,4800000 29,5000000 29,5100000 29,5399999 29,5900000
## 1 3 2 1 1 4 1
## 29,6200000 29,6299999 29,6400000 29,6600000 29,7399999 29,8000000 29,8200000
## 2 1 1 4 5 1 1
## 29,8599999 3,00000000 3,01000000 3,02000000 3,03000000 3,04000000 3,05000000
## 2 51 35 23 33 32 37
## 3,06000000 3,07000000 3,08000000 3,09000000 3,10000000 3,11000000 3,12000000
## 34 33 29 24 63 40 32
## 3,13000000 3,14000000 3,15000000 3,16000000 3,17000000 3,18000000 3,19000000
## 25 25 31 33 37 28 25
## 3,20000000 3,21000000 3,22000000 3,23000000 3,24000000 3,25000000 3,26000000
## 51 23 24 30 34 37 31
## 3,27000000 3,28000000 3,29000000 3,30000000 3,31000000 3,32000000 3,33000000
## 23 27 30 53 35 22 40
## 3,34000000 3,35000000 3,36000000 3,37000000 3,38000000 3,39000000 3,40000000
## 28 27 30 26 30 25 67
## 3,41000000 3,42000000 3,43000000 3,44000000 3,45000000 3,46000000 3,47000000
## 43 28 30 19 28 25 22
## 3,48000000 3,49000000 3,50000000 3,51000000 3,52000000 3,53000000 3,54000000
## 24 27 50 33 27 39 27
## 3,55000000 3,56000000 3,57000000 3,58000000 3,59000000 3,60000000 3,61000000
## 32 17 38 37 26 41 33
## 3,62000000 3,63000000 3,64000000 3,65000000 3,66000000 3,67000000 3,68000000
## 16 33 23 28 27 27 30
## 3,69000000 3,70000000 3,71000000 3,72000000 3,73000000 3,74000000 3,75000000
## 25 40 30 33 27 24 29
## 3,76000000 3,77000000 3,78000000 3,79000000 3,80000000 3,81000000 3,82000000
## 30 25 38 29 52 25 17
## 3,83000000 3,84000000 3,85000000 3,86000000 3,87000000 3,88000000 3,89000000
## 25 40 28 18 33 26 30
## 3,90000000 3,91000000 3,92000000 3,93000000 3,94000000 3,95000000 3,96000000
## 44 47 24 26 26 29 23
## 3,97000000 3,98000000 3,99000000 30,0000000 30,0100000 30,0300000 30,0700000
## 35 31 22 2 1 3 2
## 30,1000000 30,1099999 30,1400000 30,1700000 30,2100000 30,2199999 30,4100000
## 4 3 1 1 1 3 1
## 30,5000000 30,5100000 30,5300000 30,5399999 30,5500000 30,5700000 30,6099999
## 1 1 2 1 1 2 1
## 30,6200000 30,6400000 30,6499999 30,6600000 30,6999999 30,7600000 30,8299999
## 1 2 1 1 3 2 2
## 30,8700000 30,8900000 30,9100000 30,9499999 30,9899999 31,0000000 31,0399999
## 2 1 1 1 1 2 1
## 31,2800000 31,3299999 31,3500000 31,3599999 31,3700000 31,3799999 31,4100000
## 1 1 2 3 1 2 1
## 31,4200000 31,4400000 31,4600000 31,4800000 31,4899999 31,5000000 31,5300000
## 1 1 4 2 3 1 2
## 31,5399999 31,5700000 31,5900000 31,6299999 31,6400000 31,6900000 31,6999999
## 4 2 4 1 2 1 1
## 31,7199999 31,7300000 31,7500000 31,7600000 31,8000000 31,8200000 31,8500000
## 2 2 8 2 2 1 1
## 31,8599999 31,8700000 31,8799999 31,9300000 31,9600000 32,0000000 32,0300000
## 1 1 1 2 1 3 1
## 32,0700000 32,0900000 32,2000000 32,2199999 32,2500000 32,2999999 32,3400000
## 1 2 4 2 2 1 1
## 32,3999999 32,4300000 32,4600000 32,5499999 32,5600000 32,6000000 32,6400000
## 2 1 2 2 1 3 2
## 32,7199999 32,7700000 32,7899999 32,8599999 32,8800000 32,9099999 32,9200000
## 4 1 1 2 1 1 2
## 32,9799999 324,980000 33,1199999 33,1800000 33,2000000 33,2700000 33,3200000
## 3 2 2 4 5 2 1
## 33,3400000 33,3500000 33,3999999 33,4300000 33,5200000 33,5900000 33,6499999
## 1 1 5 1 3 4 1
## 33,7400000 33,7500000 33,7700000 33,7999999 33,8299999 33,8500000 33,8999999
## 1 2 1 1 2 3 2
## 33,9399999 33,9799999 34,0000000 34,2100000 34,2299999 34,2599999 34,2999999
## 3 1 1 1 1 1 1
## 34,3500000 34,3599999 34,3800000 34,4699999 34,5399999 34,6099999 34,6899999
## 1 1 5 2 4 1 1
## 34,7100000 34,7500000 34,9500000 34,9699999 35,0499999 35,0900000 35,1000000
## 2 2 1 1 3 1 2
## 35,1300000 35,1499999 35,2100000 35,2599999 35,2800000 35,4099999 35,4300000
## 3 4 1 1 1 2 1
## 35,4399999 35,4799999 35,4900000 35,5600000 35,7999999 35,8400000 35,8599999
## 1 1 1 1 1 3 4
## 35,8800000 35,9600000 35,9699999 36,0000000 36,0900000 36,3299999 36,3500000
## 3 1 1 1 1 1 1
## 36,3900000 36,3999999 36,4500000 36,5099999 36,5300000 36,5499999 36,5799999
## 2 5 2 4 2 4 1
## 36,6000000 36,6099999 36,6499999 36,7199999 36,7700000 36,9399999 36,9500000
## 3 1 2 1 4 1 2
## 36,9600000 368,889999 37,2000000 37,2100000 37,2999999 37,3599999 37,3999999
## 2 1 1 1 1 4 1
## 37,4500000 37,4699999 37,5000000 37,5399999 37,6000000 37,6099999 37,6499999
## 3 1 1 2 2 4 1
## 37,6700000 37,7299999 37,8699999 37,8999999 37,9900000 38,1000000 38,1400000
## 2 1 1 3 3 3 1
## 38,1899999 38,2500000 38,4099999 38,4500000 38,5399999 38,5600000 38,6499999
## 1 3 1 1 4 1 2
## 38,6800000 38,7400000 38,8100000 38,9200000 38,9699999 38,9799999 39,0700000
## 2 2 1 1 2 3 1
## 39,1000000 39,1499999 39,2000000 39,2199999 39,2800000 39,3500000 39,3599999
## 5 1 1 1 4 2 2
## 39,3900000 39,4300000 39,5000000 39,5700000 39,6000000 39,6300000 39,7800000
## 1 1 1 2 1 4 1
## 39,8999999 4,00000000 4,01000000 4,02000000 4,03000000 4,04000000 4,05000000
## 3 46 35 33 37 26 31
## 4,06000000 4,07000000 4,08000000 4,09000000 4,10000000 4,11000000 4,12000000
## 24 30 25 32 54 26 25
## 4,13000000 4,14000000 4,15000000 4,16000000 4,17000000 4,18000000 4,19000000
## 23 33 31 24 15 32 27
## 4,20000000 4,21000000 4,22000000 4,23000000 4,24000000 4,25000000 4,26000000
## 33 27 27 33 33 28 29
## 4,27000000 4,28000000 4,29000000 4,30000000 4,31000000 4,32000000 4,33000000
## 22 24 25 42 25 22 29
## 4,34000000 4,35000000 4,36000000 4,37000000 4,38000000 4,39000000 4,40000000
## 30 26 25 24 24 32 57
## 4,41000000 4,42000000 4,43000000 4,44000000 4,45000000 4,46000000 4,47000000
## 26 31 22 21 24 42 27
## 4,48000000 4,49000000 4,50000000 4,51000000 4,52000000 4,53000000 4,54000000
## 28 25 57 23 29 19 29
## 4,55000000 4,56000000 4,57000000 4,58000000 4,59000000 4,60000000 4,61000000
## 29 26 27 29 26 46 19
## 4,62000000 4,63000000 4,64000000 4,65000000 4,66000000 4,67000000 4,68000000
## 20 17 25 25 30 17 19
## 4,69000000 4,70000000 4,71000000 4,72000000 4,73000000 4,74000000 4,75000000
## 22 45 24 23 28 21 25
## 4,76000000 4,77000000 4,78000000 4,79000000 4,80000000 4,81000000 4,82000000
## 25 20 22 23 36 18 28
## 4,83000000 4,84000000 4,85000000 4,86000000 4,87000000 4,88000000 4,89000000
## 20 21 14 23 33 18 17
## 4,90000000 4,91000000 4,92000000 4,93000000 4,94000000 4,95000000 4,96000000
## 43 33 30 29 34 23 23
## 4,97000000 4,98000000 4,99000000 40,0300000 40,0399999 40,0799999 40,1800000
## 28 28 25 1 3 2 1
## 40,2199999 40,2599999 40,6099999 40,6300000 40,6899999 40,7100000 40,7299999
## 1 2 1 3 1 2 1
## 40,7500000 40,7800000 40,8100000 40,9300000 41,3900000 41,4399999 41,5300000
## 2 2 1 1 1 1 1
## 41,6800000 41,8200000 41,8999999 41,9399999 42,1300000 42,1700000 42,2100000
## 1 5 2 2 1 2 1
## 42,2999999 42,3699999 42,4600000 42,6300000 42,6499999 42,7299999 42,8100000
## 1 1 2 1 1 1 1
## 42,8800000 43,1199999 43,2199999 43,3400000 43,5099999 43,6000000 43,6300000
## 1 2 1 1 1 1 4
## 43,7599999 43,7999999 43,8599999 43,9399999 43,9900000 44,0700000 44,1000000
## 1 3 4 1 1 2 1
## 44,1499999 44,3299999 44,5600000 44,5700000 44,6000000 44,6300000 44,7100000
## 1 1 4 1 1 1 2
## 44,7400000 44,7700000 44,7999999 44,8599999 44,9099999 44,9300000 45,1199999
## 2 1 4 2 1 1 1
## 45,2400000 45,3400000 45,3599999 45,3699999 45,4399999 45,5000000 45,5399999
## 6 2 3 1 1 1 1
## 45,5499999 45,6000000 45,6599999 45,9200000 45,9600000 45,9699999 46,0399999
## 1 4 1 1 1 1 3
## 46,0799999 46,0900000 46,1000000 46,1800000 46,2000000 46,3500000 46,3999999
## 1 1 1 1 1 3 2
## 46,4500000 46,6300000 46,6400000 46,7999999 46,8100000 46,8999999 46,9500000
## 1 1 4 1 3 2 2
## 47,0200000 47,1400000 47,2599999 47,3500000 47,4399999 47,9799999 48,0200000
## 1 2 1 1 1 1 1
## 48,0600000 48,2899999 48,6099999 48,7100000 48,7400000 48,8800000 48,9399999
## 2 4 2 1 1 2 1
## 48,9900000 49,1000000 49,1599999 49,2000000 49,2500000 49,3999999 49,4200000
## 2 1 2 2 1 1 1
## 49,4399999 49,5700000 49,9500000 49,9699999 5,00000000 5,01000000 5,02000000
## 1 1 4 1 26 29 17
## 5,03000000 5,04000000 5,05000000 5,06000000 5,07000000 5,08000000 5,09000000
## 13 19 33 11 33 21 25
## 5,10000000 5,11000000 5,12000000 5,13000000 5,14000000 5,15000000 5,16000000
## 32 28 31 21 19 24 23
## 5,17000000 5,18000000 5,19000000 5,20000000 5,21000000 5,22000000 5,23000000
## 39 20 25 24 21 21 16
## 5,24000000 5,25000000 5,26000000 5,27000000 5,28000000 5,29000000 5,30000000
## 23 19 20 20 14 27 41
## 5,31000000 5,32000000 5,33000000 5,34000000 5,35000000 5,36000000 5,37000000
## 19 25 22 14 11 14 18
## 5,38000000 5,39000000 5,40000000 5,41000000 5,42000000 5,43000000 5,44000000
## 23 19 25 19 18 20 20
## 5,45000000 5,46000000 5,47000000 5,48000000 5,49000000 5,50000000 5,51000000
## 17 16 17 20 15 26 19
## 5,52000000 5,53000000 5,54000000 5,55000000 5,56000000 5,57000000 5,58000000
## 25 19 21 28 24 23 20
## 5,59000000 5,60000000 5,61000000 5,62000000 5,63000000 5,64000000 5,65000000
## 21 27 10 22 21 22 14
## 5,66000000 5,67000000 5,68000000 5,69000000 5,70000000 5,71000000 5,72000000
## 26 15 30 18 39 20 13
## 5,73000000 5,74000000 5,75000000 5,76000000 5,77000000 5,78000000 5,79000000
## 19 20 27 23 22 11 20
## 5,80000000 5,81000000 5,82000000 5,83000000 5,84000000 5,85000000 5,86000000
## 36 17 13 12 26 13 21
## 5,87000000 5,88000000 5,89000000 5,90000000 5,91000000 5,92000000 5,93000000
## 19 22 15 28 22 27 19
## 5,94000000 5,95000000 5,96000000 5,97000000 5,98000000 5,99000000 50,0700000
## 21 19 17 18 20 19 4
## 50,2899999 50,2999999 50,4699999 50,4799999 50,4900000 50,5000000 50,6199999
## 2 4 3 2 1 1 2
## 50,7500000 50,8100000 50,8400000 51,0000000 51,0200000 51,0799999 51,2299999
## 3 1 2 1 1 1 4
## 51,3100000 51,4600000 51,4799999 51,9699999 52,4200000 52,7500000 52,7599999
## 1 1 1 1 1 1 1
## 53,1700000 53,3800000 53,7199999 54,2000000 54,3299999 54,3400000 54,5300000
## 1 1 1 1 1 2 1
## 54,6000000 54,7299999 54,8599999 55,0499999 55,0799999 55,1899999 55,4699999
## 1 1 1 5 1 2 1
## 55,5099999 55,6000000 55,6899999 55,7299999 55,7700000 55,9799999 56,0300000
## 4 1 1 1 1 1 1
## 56,0900000 56,1000000 56,1499999 56,4900000 56,5300000 56,8999999 56,9399999
## 1 1 1 2 3 2 1
## 57,0900000 57,3599999 57,3999999 57,5700000 58,6000000 58,8800000 59,3299999
## 2 1 2 3 3 2 1
## 59,5399999 59,6400000 6,00000000 6,01000000 6,02000000 6,03000000 6,04000000
## 1 2 33 13 17 12 24
## 6,05000000 6,06000000 6,07000000 6,08000000 6,09000000 6,10000000 6,11000000
## 24 17 21 14 21 26 15
## 6,12000000 6,13000000 6,14000000 6,15000000 6,16000000 6,17000000 6,18000000
## 29 13 23 15 23 18 18
## 6,19000000 6,20000000 6,21000000 6,22000000 6,23000000 6,24000000 6,25000000
## 14 31 25 14 12 22 16
## 6,26000000 6,27000000 6,28000000 6,29000000 6,30000000 6,31000000 6,32000000
## 14 16 22 14 20 22 18
## 6,33000000 6,34000000 6,35000000 6,36000000 6,37000000 6,38000000 6,39000000
## 8 20 23 21 16 20 21
## 6,40000000 6,41000000 6,42000000 6,43000000 6,44000000 6,45000000 6,46000000
## 36 17 19 19 21 21 26
## 6,47000000 6,48000000 6,49000000 6,50000000 6,51000000 6,52000000 6,53000000
## 13 12 15 21 13 7 14
## 6,54000000 6,55000000 6,56000000 6,57000000 6,58000000 6,59000000 6,60000000
## 21 21 12 19 15 6 35
## 6,61000000 6,62000000 6,63000000 6,64000000 6,65000000 6,66000000 6,67000000
## 20 13 11 8 11 16 17
## 6,68000000 6,69000000 6,70000000 6,71000000 6,72000000 6,73000000 6,74000000
## 25 8 30 19 15 13 22
## 6,75000000 6,76000000 6,77000000 6,78000000 6,79000000 6,80000000 6,81000000
## 19 16 12 12 13 22 12
## 6,82000000 6,83000000 6,84000000 6,85000000 6,86000000 6,87000000 6,88000000
## 7 21 9 17 7 15 5
## 6,89000000 6,90000000 6,91000000 6,92000000 6,93000000 6,94000000 6,95000000
## 12 13 10 13 9 17 18
## 6,96000000 6,97000000 6,98000000 6,99000000 60,0900000 60,2999999 60,5200000
## 18 14 13 14 1 2 1
## 60,7100000 60,8999999 61,2299999 61,6599999 61,7899999 61,8699999 61,8999999
## 2 1 1 3 1 1 2
## 61,9500000 62,1000000 62,3400000 62,4300000 63,3599999 63,4799999 63,8299999
## 2 1 1 2 1 2 1
## 64,0799999 64,4599999 64,4699999 64,7000000 65,5600000 65,7999999 66,1200000
## 1 1 1 1 2 4 1
## 66,5300000 66,5999999 66,6200000 67,2199999 67,5999999 67,8299999 68,1700000
## 1 1 2 1 1 4 3
## 68,2199999 68,3799999 68,9699999 69,2199999 69,4000000 69,6500000 69,9000000
## 1 1 4 5 3 1 2
## 7,00000000 7,01000000 7,02000000 7,03000000 7,04000000 7,05000000 7,06000000
## 19 19 10 18 15 12 14
## 7,07000000 7,08000000 7,09000000 7,10000000 7,11000000 7,12000000 7,13000000
## 19 11 14 15 17 26 13
## 7,14000000 7,15000000 7,16000000 7,17000000 7,18000000 7,19000000 7,20000000
## 6 15 15 14 18 9 14
## 7,21000000 7,22000000 7,23000000 7,24000000 7,25000000 7,26000000 7,27000000
## 12 13 6 7 12 5 9
## 7,28000000 7,29000000 7,30000000 7,31000000 7,32000000 7,33000000 7,34000000
## 10 9 25 15 12 14 16
## 7,35000000 7,36000000 7,37000000 7,38000000 7,39000000 7,40000000 7,41000000
## 7 16 12 9 7 22 8
## 7,42000000 7,43000000 7,44000000 7,45000000 7,46000000 7,47000000 7,48000000
## 14 9 8 18 15 20 7
## 7,49000000 7,50000000 7,51000000 7,52000000 7,53000000 7,54000000 7,55000000
## 11 34 20 8 4 8 7
## 7,56000000 7,57000000 7,58000000 7,59000000 7,60000000 7,61000000 7,62000000
## 13 17 7 11 14 10 12
## 7,63000000 7,64000000 7,65000000 7,66000000 7,67000000 7,68000000 7,69000000
## 11 13 14 11 12 14 12
## 7,70000000 7,71000000 7,72000000 7,73000000 7,74000000 7,75000000 7,76000000
## 14 9 9 17 16 8 11
## 7,77000000 7,78000000 7,79000000 7,80000000 7,81000000 7,82000000 7,83000000
## 5 13 6 13 15 8 13
## 7,84000000 7,85000000 7,86000000 7,87000000 7,88000000 7,89000000 7,90000000
## 18 6 12 6 18 8 7
## 7,91000000 7,92000000 7,93000000 7,94000000 7,95000000 7,96000000 7,97000000
## 11 10 13 9 6 7 20
## 7,98000000 7,99000000 70,2000000 70,2999999 70,4000000 71,1899999 72,2099999
## 5 4 3 1 1 2 1
## 72,3900000 72,5300000 73,7399999 73,9399999 74,5000000 74,5400000 74,5900000
## 3 2 1 4 2 1 4
## 75,1500000 75,4000000 75,7999999 75,8599999 76,1599999 76,2000000 76,2999999
## 2 6 2 1 4 1 2
## 77,0000000 77,5300000 78,0100000 78,3100000 79,0999999 79,3299999 79,3400000
## 2 1 4 4 1 2 1
## 79,4800000 79,5199999 79,7500000 8,00000000 8,01000000 8,02000000 8,02999999
## 1 1 1 18 20 12 17
## 8,03999999 8,05000000 8,06000000 8,07000000 8,08000000 8,09000000 8,10000000
## 12 10 5 10 9 14 17
## 8,10999999 8,11999999 8,13000000 8,14000000 8,15000000 8,16000000 8,17000000
## 5 7 12 15 7 10 17
## 8,18000000 8,19000000 8,19999999 8,21000000 8,22000000 8,23000000 8,24000000
## 13 10 19 6 10 9 9
## 8,25000000 8,26000000 8,27000000 8,27999999 8,28999999 8,30000000 8,31000000
## 12 6 7 6 8 24 11
## 8,32000000 8,33000000 8,34000000 8,35000000 8,35999999 8,36999999 8,38000000
## 10 9 12 10 15 11 20
## 8,39000000 8,40000000 8,41000000 8,42000000 8,43000000 8,44000000 8,44999999
## 12 6 10 10 10 11 10
## 8,46000000 8,47000000 8,48000000 8,49000000 8,50000000 8,51000000 8,52000000
## 9 7 14 15 9 8 3
## 8,52999999 8,53999999 8,55000000 8,56000000 8,57000000 8,58000000 8,59000000
## 5 6 10 6 10 7 9
## 8,60000000 8,60999999 8,61999999 8,63000000 8,64000000 8,65000000 8,66000000
## 11 2 12 10 10 10 7
## 8,67000000 8,68000000 8,69000000 8,69999999 8,71000000 8,72000000 8,73000000
## 10 11 7 18 3 9 9
## 8,74000000 8,75000000 8,76000000 8,77000000 8,77999999 8,78999999 8,80000000
## 2 7 6 10 11 4 12
## 8,81000000 8,82000000 8,83000000 8,84000000 8,85000000 8,85999999 8,86999999
## 10 6 13 1 4 10 10
## 8,88000000 8,89000000 8,90000000 8,91000000 8,92000000 8,93000000 8,94000000
## 2 2 15 12 9 9 6
## 8,94999999 8,96000000 8,97000000 8,98000000 8,99000000 80,0999999 80,4899999
## 15 7 7 15 3 1 1
## 81,2399999 81,3900000 81,4599999 81,8499999 82,2099999 82,9800000 84,4399999
## 4 1 2 1 1 1 2
## 84,4599999 85,2800000 86,2600000 86,4899999 86,7300000 87,0699999 87,6700000
## 1 1 1 1 2 4 1
## 88,2600000 88,5400000 88,7199999 89,4699999 89,5199999 89,5300000 89,6800000
## 2 4 4 4 2 2 1
## 89,7999999 89,8100000 9,00000000 9,01000000 9,02000000 9,02999999 9,03999999
## 2 2 25 6 13 8 7
## 9,05000000 9,06000000 9,07000000 9,08000000 9,09000000 9,10000000 9,10999999
## 7 6 12 10 8 13 12
## 9,11999999 9,13000000 9,14000000 9,15000000 9,16000000 9,17000000 9,18000000
## 4 7 9 6 14 1 5
## 9,19000000 9,19999999 9,21000000 9,22000000 9,23000000 9,24000000 9,25000000
## 12 14 7 8 8 14 11
## 9,26000000 9,27000000 9,27999999 9,28999999 9,30000000 9,31000000 9,32000000
## 6 4 6 10 6 9 6
## 9,33000000 9,34000000 9,35000000 9,35999999 9,36999999 9,38000000 9,39000000
## 6 6 7 5 11 3 4
## 9,40000000 9,41000000 9,42000000 9,43000000 9,44000000 9,44999999 9,46000000
## 13 9 7 5 7 10 6
## 9,47000000 9,48000000 9,49000000 9,50000000 9,51000000 9,52000000 9,52999999
## 8 7 7 15 11 4 8
## 9,53999999 9,55000000 9,56000000 9,57000000 9,58000000 9,59000000 9,60000000
## 9 4 7 9 9 6 17
## 9,60999999 9,61999999 9,63000000 9,64000000 9,65000000 9,66000000 9,67000000
## 6 9 4 6 1 4 9
## 9,68000000 9,69000000 9,69999999 9,71000000 9,72000000 9,73000000 9,74000000
## 8 4 11 5 9 5 6
## 9,75000000 9,76000000 9,77000000 9,77999999 9,78999999 9,80000000 9,81000000
## 5 7 8 2 9 6 2
## 9,82000000 9,83000000 9,84000000 9,85000000 9,85999999 9,86999999 9,88000000
## 9 2 7 7 5 7 7
## 9,89000000 9,90000000 9,91000000 9,92000000 9,93000000 9,94000000 9,94999999
## 10 8 10 9 12 3 10
## 9,96000000 9,97000000 9,98000000 9,99000000 90,2000000 90,2600000 90,5900000
## 4 6 12 9 1 2 2
## 90,9699999 91,1800000 91,2099999 91,4000000 92,0000000 93,0100000 93,4899999
## 1 1 1 2 1 2 1
## 93,6099999 93,7999999 93,8299999 94,7399999 95,1899999 95,2399999 96,1200000
## 2 1 3 1 1 2 3
## 96,6500000 97,2300000 97,3799999 98,2699999 98,4599999 99,8599999
## 1 1 3 1 3 2
datos$FRP <- as.numeric(gsub(",", ".", datos$FRP))
str(datos$FRP)
## num [1:22476] 12.1 6.87 3.77 5.5 2.9 9.2 3.76 3.75 2.5 8 ...
FRP <- na.omit (datos$FRP)
summary(datos$FRP)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.190 3.200 5.160 8.953 8.930 368.890
sum(is.na(datos$FRP_num)) # Cuántos NAs quedaron
## [1] 0
# Función para eliminar outliers en una columna
remove_outliers_iqr <- function(x) {
Q1 <- quantile(x, 0.25, na.rm = TRUE)
Q3 <- quantile(x, 0.75, na.rm = TRUE)
IQRx <- Q3 - Q1
x[x >= (Q1 - 1.5 * IQRx) & x <= (Q3 + 1.5 * IQRx)]
}
# Filtrar dataframe completo, eliminando filas donde cualquiera de las dos sea outlier
datos_clean <- datos[
datos$BRIGHTNESS %in% remove_outliers_iqr(datos$BRIGHTNESS) &
datos$FRP %in% remove_outliers_iqr(datos$FRP),
]
#RELACIÓN DE BRIGHTNESS y FRP--------------------------------------------------
#Sacar valores únicos y sus respectivas medias para la relación de BRIGHTNESS y FRP
datos <- data.frame(BRIGHTNESS,FRP)
str(datos)
## 'data.frame': 22476 obs. of 2 variables:
## $ BRIGHTNESS: num 355 342 332 331 328 ...
## $ FRP : num 12.1 6.87 3.77 5.5 2.9 9.2 3.76 3.75 2.5 8 ...
ValoresBRIGHTNESS <- unique(datos$BRIGHTNESS) # Extrae los valores únicos directamente del dataframe
X <- c()
Y <- c()
for (i in 1:length(ValoresBRIGHTNESS)) {
Filtro <- datos[datos$BRIGHTNESS == ValoresBRIGHTNESS[i], ]
X[i] <- ValoresBRIGHTNESS[i]
Y[i] <- mean(Filtro$FRP, na.rm = TRUE) # Ignora los NA
}
TablaPares1 <- data.frame(X,Y)
TablaPares1$x_cent <- TablaPares1$X - mean(TablaPares1$X, na.rm = TRUE)
mod_cent <- lm(Y ~ x_cent, data = TablaPares1)
summary(mod_cent)
##
## Call:
## lm(formula = Y ~ x_cent, data = TablaPares1)
##
## Residuals:
## Min 1Q Median 3Q Max
## -10.01 -4.91 -3.17 -0.20 317.49
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 9.38426 0.18601 50.45 <2e-16 ***
## x_cent 0.18310 0.01018 17.99 <2e-16 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 12.66 on 4629 degrees of freedom
## Multiple R-squared: 0.06533, Adjusted R-squared: 0.06513
## F-statistic: 323.6 on 1 and 4629 DF, p-value: < 2.2e-16
regresion <- lm(Y~x_cent, data = TablaPares1)
regresion
##
## Call:
## lm(formula = Y ~ x_cent, data = TablaPares1)
##
## Coefficients:
## (Intercept) x_cent
## 9.3843 0.1831
#Gráfica de dispersión de puntos de la relación
plot(TablaPares1$x_cent, TablaPares1$Y,
xlab = "X centrada", ylab = "FRP",
main = "Regresión con X centrada")
abline(mod_cent, col="blue", lwd=2)
#Pearson para regresión lineal
r <- cor(X,Y)
r
## [1] 0.255605
#Coeficiente de determinación para regresión lineal
r2 <- r^2*100
r2
## [1] 6.533392
#Regresión polinomica
x2 <- X[61:81]
y2 <- Y[61:81]
Tabla2 <- data.frame(x2,y2)
plot(Tabla2, ylim=c(0,50), main="Regresión Polinómica")
xcuad <- x2^2
xcub <- x2^3
regresionPolinomica <- lm(y2~x2+xcuad+xcub)
regresionPolinomica
##
## Call:
## lm(formula = y2 ~ x2 + xcuad + xcub)
##
## Coefficients:
## (Intercept) x2 xcuad xcub
## -6.477e+04 5.611e+02 -1.621e+00 1.561e-03
summary(regresionPolinomica)
##
## Call:
## lm(formula = y2 ~ x2 + xcuad + xcub)
##
## Residuals:
## Min 1Q Median 3Q Max
## -6.646 -4.000 -2.459 2.331 13.656
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -6.477e+04 1.377e+05 -0.470 0.644
## x2 5.611e+02 1.209e+03 0.464 0.649
## xcuad -1.621e+00 3.539e+00 -0.458 0.653
## xcub 1.561e-03 3.452e-03 0.452 0.657
##
## Residual standard error: 6.143 on 17 degrees of freedom
## Multiple R-squared: 0.2919, Adjusted R-squared: 0.1669
## F-statistic: 2.336 on 3 and 17 DF, p-value: 0.1101
beta0 <-regresionPolinomica$coefficients[1]
beta1 <-regresionPolinomica$coefficients[2]
beta2 <-regresionPolinomica$coefficients[3]
beta3 <-regresionPolinomica$coefficients[4]
a <-beta0
b <-beta1
c <-beta2
d <-beta3
plot(x2,y2,col=5,pch=7,main = "Regresión polinómica",xlab = "x2", ylab = "y2", ylim=c(0,50))
curve(a+(b*x)+(c*x^2)+(d*x^3),add = T,col="purple")
#Pearson para regresión polinómica
r <- cor(y2,x2+xcuad+xcub)
r
## [1] 0.5039704
#Coeficiente de Determinación para regresión polinómica
r2 <- r^2*100
r2
## [1] 25.39862
#COMBINAR MODELOS (Lineal y Polinómico)----
# Graficar puntos
plot(y2 ~ x2, data = TablaPares1,
col = 4, pch = 7,
main = "Gráfica No. 1: Relación BRIGHTNESS vs FRP",
xlab = "FRP", ylab = "BRIGHTNESS",
ylim = c(0, 50))
# Ajustar modelo lineal
modelo_lineal <- lm(y2 ~ x2, data = TablaPares1)
abline(modelo_lineal, col = "red", lwd = 2)
# Ajustar modelo polinómico de tercer grado
modelo_polinomico <- lm(y2 ~ poly(x2, 3, raw = TRUE), data = TablaPares1)
curve(predict(modelo_polinomico, newdata = data.frame(x2 = x)),
add = TRUE, col = "orange", lwd = 2)
