Prototipado Soluciones IoT -KPIS

import pandas as pd

paquetesMaskcam_DF = pd.read_csv ('/work/Datasets/paquetes_maskcam_01_09_2021__01_10_2021.csv') Ubicaciones_DF = pd.read_csv ('/work/Datasets/maskcam_tabasco_ubicaciones.csv')

paquetesMaskcam_DF.dtypes

paquetesMaskcam_DF['hora_recepcion']=pd.to_datetime(paquetesMaskcam_DF['hora_recepcion']) paquetesMaskcam_DF.dtypes

IndicadoresRedPorHora = pd.DataFrame(columns=['fecha', 'hora', 'total_personas_detectadas_por_hora', 'total_personas_con_cubrebocas_por_hora', 'total_personas_sin_cubrebocas_por_hora', 'id_ubicacion_mayor_afluencia', 'total_personas_en_mayor_afluencia', 'personas_sin_cubrebobas_en_mayor_afluencia', 'personas_con_cubrebobas_en_mayor_afluencia', 'id_ubicacion_menor_uso_cubrebocas', 'total_personas_en_menor_uso_cubrebocas', 'personas_sin_cubrebobas_en_menor_uso_cubrebocas', 'personas_con_cubrebobas_en_menor_uso_cubrebocas',])

AgrupadoPorDispositivo_df = paquetesMaskcam_DF.groupby(paquetesMaskcam_DF["id_dispositivo"]); AgrupadoPorDispositivo_df

AgrupadoPorDispositivo_df["personas_detectadas"].max()

AgrupadoPorDispositivo_df.get_group('iotdev1')

This chart is empty

AgrupadoPorHora_df= paquetesMaskcam_DF.groupby(paquetesMaskcam_DF['hora_recepcion'].dt.floor('h'))

AgrupadoPorHora_df["personas_con_cubrebocas"].max()

AgrupadoPorHora_df.get_group("2021-09-01 02:00:00")

#len(AgrupadoPorHora_df) AgrupadoPorHora_df.ngroups

for hora, grupo in AgrupadoPorHora_df: print(hora)

2021-09-01 02:00:00
2021-09-01 03:00:00
2021-09-01 04:00:00
2021-09-01 05:00:00
2021-09-01 06:00:00
2021-09-01 07:00:00
2021-09-01 08:00:00
2021-09-01 09:00:00
2021-09-01 10:00:00
2021-09-01 11:00:00
2021-09-01 12:00:00
2021-09-01 13:00:00
2021-09-01 14:00:00
2021-09-01 15:00:00
2021-09-01 16:00:00
2021-09-01 17:00:00
2021-09-01 18:00:00
2021-09-01 19:00:00
2021-09-01 20:00:00
2021-09-01 21:00:00
2021-09-01 22:00:00
2021-09-01 23:00:00
2021-09-02 00:00:00
2021-09-02 01:00:00
2021-09-02 02:00:00
2021-09-02 03:00:00
2021-09-02 04:00:00
2021-09-02 05:00:00
2021-09-02 06:00:00
2021-09-02 07:00:00
2021-09-02 08:00:00
2021-09-02 09:00:00
2021-09-02 10:00:00
2021-09-02 11:00:00
2021-09-02 12:00:00
2021-09-02 13:00:00
2021-09-02 14:00:00
2021-09-02 15:00:00
2021-09-02 16:00:00
2021-09-02 17:00:00
2021-09-02 18:00:00
2021-09-02 19:00:00
2021-09-02 20:00:00
2021-09-02 21:00:00
2021-09-02 22:00:00
2021-09-02 23:00:00
2021-09-03 00:00:00
2021-09-03 01:00:00
2021-09-03 02:00:00
2021-09-03 03:00:00
2021-09-03 04:00:00
2021-09-03 05:00:00
2021-09-03 06:00:00
2021-09-03 07:00:00
2021-09-03 08:00:00
2021-09-03 09:00:00
2021-09-03 10:00:00
2021-09-03 11:00:00
2021-09-03 12:00:00
2021-09-03 13:00:00
2021-09-03 14:00:00
2021-09-03 15:00:00
2021-09-03 16:00:00
2021-09-03 17:00:00
2021-09-03 18:00:00
2021-09-03 19:00:00
2021-09-03 20:00:00
2021-09-03 21:00:00
2021-09-03 22:00:00
2021-09-03 23:00:00
2021-09-04 00:00:00
2021-09-04 01:00:00
2021-09-04 02:00:00
2021-09-04 03:00:00
2021-09-04 04:00:00
2021-09-04 05:00:00
2021-09-04 06:00:00
2021-09-04 07:00:00
2021-09-04 08:00:00
2021-09-04 09:00:00
2021-09-04 10:00:00
2021-09-04 11:00:00
2021-09-04 12:00:00
2021-09-04 13:00:00
2021-09-04 14:00:00
2021-09-04 15:00:00
2021-09-04 16:00:00
2021-09-04 17:00:00
2021-09-04 18:00:00
2021-09-04 19:00:00
2021-09-04 20:00:00
2021-09-04 21:00:00
2021-09-04 22:00:00
2021-09-04 23:00:00
2021-09-05 00:00:00
2021-09-05 01:00:00
2021-09-05 02:00:00
2021-09-05 03:00:00
2021-09-05 04:00:00
2021-09-05 05:00:00
2021-09-05 06:00:00
2021-09-05 07:00:00
2021-09-05 08:00:00
2021-09-05 09:00:00
2021-09-05 10:00:00
2021-09-05 11:00:00
2021-09-05 12:00:00
2021-09-05 13:00:00
2021-09-05 14:00:00
2021-09-05 15:00:00
2021-09-05 16:00:00
2021-09-05 17:00:00
2021-09-05 18:00:00
2021-09-05 19:00:00
2021-09-05 20:00:00
2021-09-05 21:00:00
2021-09-05 22:00:00
2021-09-05 23:00:00
2021-09-06 00:00:00
2021-09-06 01:00:00
2021-09-06 02:00:00
2021-09-06 03:00:00
2021-09-06 04:00:00
2021-09-06 05:00:00
2021-09-06 06:00:00
2021-09-06 07:00:00
2021-09-06 08:00:00
2021-09-06 09:00:00
2021-09-06 10:00:00
2021-09-06 11:00:00
2021-09-06 12:00:00
2021-09-06 13:00:00
2021-09-06 14:00:00
2021-09-06 15:00:00
2021-09-06 16:00:00
2021-09-06 17:00:00
2021-09-06 18:00:00
2021-09-06 19:00:00
2021-09-06 20:00:00
2021-09-06 21:00:00
2021-09-06 22:00:00
2021-09-06 23:00:00
2021-09-07 00:00:00
2021-09-07 01:00:00
2021-09-07 02:00:00
2021-09-07 03:00:00
2021-09-07 04:00:00
2021-09-07 05:00:00
2021-09-07 06:00:00
2021-09-07 07:00:00
2021-09-07 08:00:00
2021-09-07 09:00:00
2021-09-07 10:00:00
2021-09-07 11:00:00
2021-09-07 12:00:00
2021-09-07 13:00:00
2021-09-07 14:00:00
2021-09-07 15:00:00
2021-09-07 16:00:00
2021-09-07 17:00:00
2021-09-07 18:00:00
2021-09-07 19:00:00
2021-09-07 20:00:00
2021-09-07 21:00:00
2021-09-07 22:00:00
2021-09-07 23:00:00
2021-09-08 00:00:00
2021-09-08 01:00:00
2021-09-08 02:00:00
2021-09-08 03:00:00
2021-09-08 04:00:00
2021-09-08 05:00:00
2021-09-08 06:00:00
2021-09-08 07:00:00
2021-09-08 08:00:00
2021-09-08 09:00:00
2021-09-08 10:00:00
2021-09-08 11:00:00
2021-09-08 12:00:00
2021-09-08 13:00:00
2021-09-08 14:00:00
2021-09-08 15:00:00
2021-09-08 16:00:00
2021-09-08 17:00:00
2021-09-08 18:00:00
2021-09-08 19:00:00
2021-09-08 20:00:00
2021-09-08 21:00:00
2021-09-08 22:00:00
2021-09-08 23:00:00
2021-09-09 00:00:00
2021-09-09 01:00:00
2021-09-09 02:00:00
2021-09-09 03:00:00
2021-09-09 04:00:00
2021-09-09 05:00:00
2021-09-09 06:00:00
2021-09-09 07:00:00
2021-09-09 08:00:00
2021-09-09 09:00:00
2021-09-09 10:00:00
2021-09-09 11:00:00
2021-09-09 12:00:00
2021-09-09 13:00:00
2021-09-09 14:00:00
2021-09-09 15:00:00
2021-09-09 16:00:00
2021-09-09 17:00:00
2021-09-09 18:00:00
2021-09-09 19:00:00
2021-09-09 20:00:00
2021-09-09 21:00:00
2021-09-09 22:00:00
2021-09-09 23:00:00
2021-09-10 00:00:00
2021-09-10 01:00:00
2021-09-10 02:00:00
2021-09-10 03:00:00
2021-09-10 04:00:00
2021-09-10 05:00:00
2021-09-10 06:00:00
2021-09-10 07:00:00
2021-09-10 08:00:00
2021-09-10 09:00:00
2021-09-10 10:00:00
2021-09-10 11:00:00
2021-09-10 12:00:00
2021-09-10 13:00:00
2021-09-10 14:00:00
2021-09-10 15:00:00
2021-09-10 16:00:00
2021-09-10 17:00:00
2021-09-10 18:00:00
2021-09-10 19:00:00
2021-09-10 20:00:00
2021-09-10 21:00:00
2021-09-10 22:00:00
2021-09-10 23:00:00
2021-09-11 00:00:00
2021-09-11 01:00:00
2021-09-11 02:00:00
2021-09-11 03:00:00
2021-09-11 04:00:00
2021-09-11 05:00:00
2021-09-11 06:00:00
2021-09-11 07:00:00
2021-09-11 08:00:00
2021-09-11 09:00:00
2021-09-11 10:00:00
2021-09-11 11:00:00
2021-09-11 12:00:00
2021-09-11 13:00:00
2021-09-11 14:00:00
2021-09-11 15:00:00
2021-09-11 16:00:00
2021-09-11 17:00:00
2021-09-11 18:00:00
2021-09-11 19:00:00
2021-09-11 20:00:00
2021-09-11 21:00:00
2021-09-11 22:00:00
2021-09-11 23:00:00
2021-09-12 00:00:00
2021-09-12 01:00:00
2021-09-12 02:00:00
2021-09-12 03:00:00
2021-09-12 04:00:00
2021-09-12 05:00:00
2021-09-12 06:00:00
2021-09-12 07:00:00
2021-09-12 08:00:00
2021-09-12 09:00:00
2021-09-12 10:00:00
2021-09-12 11:00:00
2021-09-12 12:00:00
2021-09-12 13:00:00
2021-09-12 14:00:00
2021-09-12 15:00:00
2021-09-12 16:00:00
2021-09-12 17:00:00
2021-09-12 18:00:00
2021-09-12 19:00:00
2021-09-12 20:00:00
2021-09-12 21:00:00
2021-09-12 22:00:00
2021-09-12 23:00:00
2021-09-13 00:00:00
2021-09-13 01:00:00
2021-09-13 02:00:00
2021-09-13 03:00:00
2021-09-13 04:00:00
2021-09-13 05:00:00
2021-09-13 06:00:00
2021-09-13 07:00:00
2021-09-13 08:00:00
2021-09-13 09:00:00
2021-09-13 10:00:00
2021-09-13 11:00:00
2021-09-13 12:00:00
2021-09-13 13:00:00
2021-09-13 14:00:00
2021-09-13 15:00:00
2021-09-13 16:00:00
2021-09-13 17:00:00
2021-09-13 18:00:00
2021-09-13 19:00:00
2021-09-13 20:00:00
2021-09-13 21:00:00
2021-09-13 22:00:00
2021-09-13 23:00:00
2021-09-14 00:00:00
2021-09-14 01:00:00
2021-09-14 02:00:00
2021-09-14 03:00:00
2021-09-14 04:00:00
2021-09-14 05:00:00
2021-09-14 06:00:00
2021-09-14 07:00:00
2021-09-14 08:00:00
2021-09-14 09:00:00
2021-09-14 10:00:00
2021-09-14 11:00:00
2021-09-14 12:00:00
2021-09-14 13:00:00
2021-09-14 14:00:00
2021-09-14 15:00:00
2021-09-14 16:00:00
2021-09-14 17:00:00
2021-09-14 18:00:00
2021-09-14 19:00:00
2021-09-14 20:00:00
2021-09-14 21:00:00
2021-09-14 22:00:00
2021-09-14 23:00:00
2021-09-15 00:00:00
2021-09-15 01:00:00
2021-09-15 02:00:00
2021-09-15 03:00:00
2021-09-15 04:00:00
2021-09-15 05:00:00
2021-09-15 06:00:00
2021-09-15 07:00:00
2021-09-15 08:00:00
2021-09-15 09:00:00
2021-09-15 10:00:00
2021-09-15 11:00:00
2021-09-15 12:00:00
2021-09-15 13:00:00
2021-09-15 14:00:00
2021-09-15 15:00:00
2021-09-15 16:00:00
2021-09-15 17:00:00
2021-09-15 18:00:00
2021-09-15 19:00:00
2021-09-15 20:00:00
2021-09-15 21:00:00
2021-09-15 22:00:00
2021-09-15 23:00:00
2021-09-16 00:00:00
2021-09-16 01:00:00
2021-09-16 02:00:00
2021-09-16 03:00:00
2021-09-16 04:00:00
2021-09-16 05:00:00
2021-09-16 06:00:00
2021-09-16 07:00:00
2021-09-16 08:00:00
2021-09-16 09:00:00
2021-09-16 10:00:00
2021-09-16 11:00:00
2021-09-16 12:00:00
2021-09-16 13:00:00
2021-09-16 14:00:00
2021-09-16 15:00:00
2021-09-16 16:00:00
2021-09-16 17:00:00
2021-09-16 18:00:00
2021-09-16 19:00:00
2021-09-16 20:00:00
2021-09-16 21:00:00
2021-09-16 22:00:00
2021-09-16 23:00:00
2021-09-17 00:00:00
2021-09-17 01:00:00
2021-09-17 02:00:00
2021-09-17 03:00:00
2021-09-17 04:00:00
2021-09-17 05:00:00
2021-09-17 06:00:00
2021-09-17 07:00:00
2021-09-17 08:00:00
2021-09-17 09:00:00
2021-09-17 10:00:00
2021-09-17 11:00:00
2021-09-17 12:00:00
2021-09-17 13:00:00
2021-09-17 14:00:00
2021-09-17 15:00:00
2021-09-17 16:00:00
2021-09-17 17:00:00
2021-09-17 18:00:00
2021-09-17 19:00:00
2021-09-17 20:00:00
2021-09-17 21:00:00
2021-09-17 22:00:00
2021-09-17 23:00:00
2021-09-18 00:00:00
2021-09-18 01:00:00
2021-09-18 02:00:00
2021-09-18 03:00:00
2021-09-18 04:00:00
2021-09-18 05:00:00
2021-09-18 06:00:00
2021-09-18 07:00:00
2021-09-18 08:00:00
2021-09-18 09:00:00
2021-09-18 10:00:00
2021-09-18 11:00:00
2021-09-18 12:00:00
2021-09-18 13:00:00
2021-09-18 14:00:00
2021-09-18 15:00:00
2021-09-18 16:00:00
2021-09-18 17:00:00
2021-09-18 18:00:00
2021-09-18 19:00:00
2021-09-18 20:00:00
2021-09-18 21:00:00
2021-09-18 22:00:00
2021-09-18 23:00:00
2021-09-19 00:00:00
2021-09-19 01:00:00
2021-09-19 02:00:00
2021-09-19 03:00:00
2021-09-19 04:00:00
2021-09-19 05:00:00
2021-09-19 06:00:00
2021-09-19 07:00:00
2021-09-19 08:00:00
2021-09-19 09:00:00
2021-09-19 10:00:00
2021-09-19 11:00:00
2021-09-19 12:00:00
2021-09-19 13:00:00
2021-09-19 14:00:00
2021-09-19 15:00:00
2021-09-19 16:00:00
2021-09-19 17:00:00
2021-09-19 18:00:00
2021-09-19 19:00:00
2021-09-19 20:00:00
2021-09-19 21:00:00
2021-09-19 22:00:00
2021-09-19 23:00:00
2021-09-20 00:00:00
2021-09-20 01:00:00
2021-09-20 02:00:00
2021-09-20 03:00:00
2021-09-20 04:00:00
2021-09-20 05:00:00
2021-09-20 06:00:00
2021-09-20 07:00:00
2021-09-20 08:00:00
2021-09-20 09:00:00
2021-09-20 10:00:00
2021-09-20 11:00:00
2021-09-20 12:00:00
2021-09-20 13:00:00
2021-09-20 14:00:00
2021-09-20 15:00:00
2021-09-20 16:00:00
2021-09-20 17:00:00
2021-09-20 18:00:00
2021-09-20 19:00:00
2021-09-20 20:00:00
2021-09-20 21:00:00
2021-09-20 22:00:00
2021-09-20 23:00:00
2021-09-21 00:00:00
2021-09-21 01:00:00
2021-09-21 02:00:00
2021-09-21 03:00:00
2021-09-21 04:00:00
2021-09-21 05:00:00
2021-09-21 06:00:00
2021-09-21 07:00:00
2021-09-21 08:00:00
2021-09-21 09:00:00
2021-09-21 10:00:00
2021-09-21 11:00:00
2021-09-21 12:00:00
2021-09-21 13:00:00
2021-09-21 14:00:00
2021-09-21 15:00:00
2021-09-21 16:00:00
2021-09-21 17:00:00
2021-09-21 18:00:00
2021-09-21 19:00:00
2021-09-21 20:00:00
2021-09-21 21:00:00
2021-09-21 22:00:00
2021-09-21 23:00:00
2021-09-22 00:00:00
2021-09-22 01:00:00
2021-09-22 02:00:00
2021-09-22 03:00:00
2021-09-22 04:00:00
2021-09-22 05:00:00
2021-09-22 06:00:00
2021-09-22 07:00:00
2021-09-22 08:00:00
2021-09-22 09:00:00
2021-09-22 10:00:00
2021-09-22 11:00:00
2021-09-22 12:00:00
2021-09-22 13:00:00
2021-09-22 14:00:00
2021-09-22 15:00:00
2021-09-22 16:00:00
2021-09-22 17:00:00
2021-09-22 18:00:00
2021-09-22 19:00:00
2021-09-22 20:00:00
2021-09-22 21:00:00
2021-09-22 22:00:00
2021-09-22 23:00:00
2021-09-23 00:00:00
2021-09-23 01:00:00
2021-09-23 02:00:00
2021-09-23 03:00:00
2021-09-23 04:00:00
2021-09-23 05:00:00
2021-09-23 06:00:00
2021-09-23 07:00:00
2021-09-23 08:00:00
2021-09-23 09:00:00
2021-09-23 10:00:00
2021-09-23 11:00:00
2021-09-23 12:00:00
2021-09-23 13:00:00
2021-09-23 14:00:00
2021-09-23 15:00:00
2021-09-23 16:00:00
2021-09-23 17:00:00
2021-09-23 18:00:00
2021-09-23 19:00:00
2021-09-23 20:00:00
2021-09-23 21:00:00
2021-09-23 22:00:00
2021-09-23 23:00:00
2021-09-24 00:00:00
2021-09-24 01:00:00
2021-09-24 02:00:00
2021-09-24 03:00:00
2021-09-24 04:00:00
2021-09-24 05:00:00
2021-09-24 06:00:00
2021-09-24 07:00:00
2021-09-24 08:00:00
2021-09-24 09:00:00
2021-09-24 10:00:00
2021-09-24 11:00:00
2021-09-24 12:00:00
2021-09-24 13:00:00
2021-09-24 14:00:00
2021-09-24 15:00:00
2021-09-24 16:00:00
2021-09-24 17:00:00
2021-09-24 18:00:00
2021-09-24 19:00:00
2021-09-24 20:00:00
2021-09-24 21:00:00
2021-09-24 22:00:00
2021-09-24 23:00:00
2021-09-25 00:00:00
2021-09-25 01:00:00
2021-09-25 02:00:00
2021-09-25 03:00:00
2021-09-25 04:00:00
2021-09-25 05:00:00
2021-09-25 06:00:00
2021-09-25 07:00:00
2021-09-25 08:00:00
2021-09-25 09:00:00
2021-09-25 10:00:00
2021-09-25 11:00:00
2021-09-25 12:00:00
2021-09-25 13:00:00
2021-09-25 14:00:00
2021-09-25 15:00:00
2021-09-25 16:00:00
2021-09-25 17:00:00
2021-09-25 18:00:00
2021-09-25 19:00:00
2021-09-25 20:00:00
2021-09-25 21:00:00
2021-09-25 22:00:00
2021-09-25 23:00:00
2021-09-26 00:00:00
2021-09-26 01:00:00
2021-09-26 02:00:00
2021-09-26 03:00:00
2021-09-26 04:00:00
2021-09-26 05:00:00
2021-09-26 06:00:00
2021-09-26 07:00:00
2021-09-26 08:00:00
2021-09-26 09:00:00
2021-09-26 10:00:00
2021-09-26 11:00:00
2021-09-26 12:00:00
2021-09-26 13:00:00
2021-09-26 14:00:00
2021-09-26 15:00:00
2021-09-26 16:00:00
2021-09-26 17:00:00
2021-09-26 18:00:00
2021-09-26 19:00:00
2021-09-26 20:00:00
2021-09-26 21:00:00
2021-09-26 22:00:00
2021-09-26 23:00:00
2021-09-27 00:00:00
2021-09-27 01:00:00
2021-09-27 02:00:00
2021-09-27 03:00:00
2021-09-27 04:00:00
2021-09-27 05:00:00
2021-09-27 06:00:00
2021-09-27 07:00:00
2021-09-27 08:00:00
2021-09-27 09:00:00
2021-09-27 10:00:00
2021-09-27 11:00:00
2021-09-27 12:00:00
2021-09-27 13:00:00
2021-09-27 14:00:00
2021-09-27 15:00:00
2021-09-27 16:00:00
2021-09-27 17:00:00
2021-09-27 18:00:00
2021-09-27 19:00:00
2021-09-27 20:00:00
2021-09-27 21:00:00
2021-09-27 22:00:00
2021-09-27 23:00:00
2021-09-28 00:00:00
2021-09-28 01:00:00
2021-09-28 02:00:00
2021-09-28 03:00:00
2021-09-28 04:00:00
2021-09-28 05:00:00
2021-09-28 06:00:00
2021-09-28 07:00:00
2021-09-28 08:00:00
2021-09-28 09:00:00
2021-09-28 10:00:00
2021-09-28 11:00:00
2021-09-28 12:00:00
2021-09-28 13:00:00
2021-09-28 14:00:00
2021-09-28 15:00:00
2021-09-28 16:00:00
2021-09-28 17:00:00
2021-09-28 18:00:00
2021-09-28 19:00:00
2021-09-28 20:00:00
2021-09-28 21:00:00
2021-09-28 22:00:00
2021-09-28 23:00:00
2021-09-29 00:00:00
2021-09-29 01:00:00
2021-09-29 02:00:00
2021-09-29 03:00:00
2021-09-29 04:00:00
2021-09-29 05:00:00
2021-09-29 06:00:00
2021-09-29 07:00:00
2021-09-29 08:00:00
2021-09-29 09:00:00
2021-09-29 10:00:00
2021-09-29 11:00:00
2021-09-29 12:00:00
2021-09-29 13:00:00
2021-09-29 14:00:00
2021-09-29 15:00:00
2021-09-29 16:00:00
2021-09-29 17:00:00
2021-09-29 18:00:00
2021-09-29 19:00:00
2021-09-29 20:00:00
2021-09-29 21:00:00
2021-09-29 22:00:00
2021-09-29 23:00:00
2021-09-30 00:00:00
2021-09-30 01:00:00
2021-09-30 02:00:00
2021-09-30 03:00:00
2021-09-30 04:00:00
2021-09-30 05:00:00
2021-09-30 06:00:00
2021-09-30 07:00:00
2021-09-30 08:00:00
2021-09-30 09:00:00
2021-09-30 10:00:00
2021-09-30 11:00:00
2021-09-30 12:00:00
2021-09-30 13:00:00
2021-09-30 14:00:00
2021-09-30 15:00:00
2021-09-30 16:00:00
2021-09-30 17:00:00
2021-09-30 18:00:00
2021-09-30 19:00:00
2021-09-30 20:00:00
2021-09-30 21:00:00
2021-09-30 22:00:00
2021-09-30 23:00:00
2021-10-01 00:00:00

for hora, grupo in AgrupadoPorHora_df: AgrupadoPorDispositivo_df = grupo.groupby(grupo["id_dispositivo"]); print(AgrupadoPorDispositivo_df["personas_detectadas"].max())

iotdev6     130
iotdev7     168
iotdev8      93
iotdev9     171
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     133
iotdev10     73
iotdev11    142
iotdev12    101
iotdev2      79
iotdev3      89
iotdev4      56
iotdev5      85
iotdev6     157
iotdev7     126
iotdev8      81
iotdev9      92
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      72
iotdev10     52
iotdev11     95
iotdev12    100
iotdev2      63
iotdev3      99
iotdev4     101
iotdev5      83
iotdev6     192
iotdev7      75
iotdev8      29
iotdev9      47
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     146
iotdev10    137
iotdev11    174
iotdev12    107
iotdev2      85
iotdev3      82
iotdev4      20
iotdev5      93
iotdev6     145
iotdev7      99
iotdev8      33
iotdev9     103
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     133
iotdev10     79
iotdev11     17
iotdev12    130
iotdev2     125
iotdev3     169
iotdev4      65
iotdev5      84
iotdev6      79
iotdev7     103
iotdev8      74
iotdev9     151
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     159
iotdev10     82
iotdev11    119
iotdev12    136
iotdev2     162
iotdev3      84
iotdev4     139
iotdev5      68
iotdev6     149
iotdev7      78
iotdev8      16
iotdev9     100
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     164
iotdev10    144
iotdev11    119
iotdev12    105
iotdev2     107
iotdev3     116
iotdev4      58
iotdev5      16
iotdev6     149
iotdev7      50
iotdev8     138
iotdev9     125
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     165
iotdev10    132
iotdev11     28
iotdev12     41
iotdev2      63
iotdev3      71
iotdev4      43
iotdev5      45
iotdev6      95
iotdev7      48
iotdev8      90
iotdev9      65
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      88
iotdev10     58
iotdev11    174
iotdev12    163
iotdev2     167
iotdev3      15
iotdev4      87
iotdev5     126
iotdev6     112
iotdev7      80
iotdev8     120
iotdev9     114
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     114
iotdev10    132
iotdev11     80
iotdev12    125
iotdev2      86
iotdev3     133
iotdev4     101
iotdev5      98
iotdev6     149
iotdev7      29
iotdev8      95
iotdev9     147
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      97
iotdev10     82
iotdev11    142
iotdev12    124
iotdev2     153
iotdev3      65
iotdev4      89
iotdev5      99
iotdev6     112
iotdev7     161
iotdev8      72
iotdev9      69
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      75
iotdev10    147
iotdev11     99
iotdev12    122
iotdev2      85
iotdev3      72
iotdev4     123
iotdev5     120
iotdev6      95
iotdev7      57
iotdev8     108
iotdev9      46
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      38
iotdev10     92
iotdev11    139
iotdev12     69
iotdev2     109
iotdev3      78
iotdev4      91
iotdev5     159
iotdev6      69
iotdev7     135
iotdev8      87
iotdev9     111
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      98
iotdev10    138
iotdev11    123
iotdev12    100
iotdev2     174
iotdev3     104
iotdev4     154
iotdev5      68
iotdev6     131
iotdev7     114
iotdev8      85
iotdev9     103
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     122
iotdev10    123
iotdev11    108
iotdev12     77
iotdev2      29
iotdev3      49
iotdev4     100
iotdev5      90
iotdev6      81
iotdev7     191
iotdev8     116
iotdev9     130
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      50
iotdev10     38
iotdev11    190
iotdev12    100
iotdev2     165
iotdev3      20
iotdev4     119
iotdev5      68
iotdev6      41
iotdev7      61
iotdev8     154
iotdev9     124
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     109
iotdev10     45
iotdev11    149
iotdev12    115
iotdev2      57
iotdev3      45
iotdev4      84
iotdev5      56
iotdev6     110
iotdev7      70
iotdev8     137
iotdev9     183
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     114
iotdev10     52
iotdev11     51
iotdev12     23
iotdev2     103
iotdev3     114
iotdev4      12
iotdev5      97
iotdev6     113
iotdev7     102
iotdev8     131
iotdev9      99
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     127
iotdev10     93
iotdev11    176
iotdev12     54
iotdev2     105
iotdev3      60
iotdev4      79
iotdev5      69
iotdev6     114
iotdev7      54
iotdev8     108
iotdev9      69
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     168
iotdev10    151
iotdev11     76
iotdev12     77
iotdev2      78
iotdev3     117
iotdev4     128
iotdev5      69
iotdev6      88
iotdev7     116
iotdev8      58
iotdev9     125
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      44
iotdev10    127
iotdev11    139
iotdev12    120
iotdev2     143
iotdev3     145
iotdev4     141
iotdev5      64
iotdev6      23
iotdev7     107
iotdev8      56
iotdev9     119
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     106
iotdev10    108
iotdev11     49
iotdev12     12
iotdev2      77
iotdev3      68
iotdev4      90
iotdev5     114
iotdev6      79
iotdev7     190
iotdev8     103
iotdev9     118
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      90
iotdev10     75
iotdev11    137
iotdev12    121
iotdev2     134
iotdev3      40
iotdev4     102
iotdev5      65
iotdev6      51
iotdev7     118
iotdev8      97
iotdev9     159
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     130
iotdev10    105
iotdev11     96
iotdev12    141
iotdev2     181
iotdev3     145
iotdev4     134
iotdev5     143
iotdev6      38
iotdev7     114
iotdev8     147
iotdev9     118
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     148
iotdev10     64
iotdev11     91
iotdev12     26
iotdev2     139
iotdev3      98
iotdev4      65
iotdev5     143
iotdev6     116
iotdev7     144
iotdev8     143
iotdev9     128
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      59
iotdev10    114
iotdev11    142
iotdev12    110
iotdev2      96
iotdev3      76
iotdev4     100
iotdev5      58
iotdev6      73
iotdev7     158
iotdev8     125
iotdev9      88
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     106
iotdev10    127
iotdev11     61
iotdev12     83
iotdev2     115
iotdev3      80
iotdev4      65
iotdev5     152
iotdev6     102
iotdev7     119
iotdev8     127
iotdev9     160
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      88
iotdev10    141
iotdev11    141
iotdev12     23
iotdev2      44
iotdev3      56
iotdev4      86
iotdev5      83
iotdev6      55
iotdev7      43
iotdev8     155
iotdev9      98
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     186
iotdev10     71
iotdev11    143
iotdev12    132
iotdev2     152
iotdev3      75
iotdev4      56
iotdev5      36
iotdev6      81
iotdev7      61
iotdev8      99
iotdev9     103
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      69
iotdev10    124
iotdev11    189
iotdev12    111
iotdev2      87
iotdev3      38
iotdev4     112
iotdev5      67
iotdev6      64
iotdev7     129
iotdev8      65
iotdev9      82
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     125
iotdev10     77
iotdev11     91
iotdev12    120
iotdev2     143
iotdev3     119
iotdev4      60
iotdev5      37
iotdev6      90
iotdev7     107
iotdev8      62
iotdev9      83
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      54
iotdev10    106
iotdev11    145
iotdev12    132
iotdev2     130
iotdev3     142
iotdev4     104
iotdev5     169
iotdev6     131
iotdev7      91
iotdev8     150
iotdev9     131
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      88
iotdev10    163
iotdev11    102
iotdev12    108
iotdev2      98
iotdev3      74
iotdev4      96
iotdev5     145
iotdev6     138
iotdev7     145
iotdev8     171
iotdev9      51
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     117
iotdev10    121
iotdev11    165
iotdev12    148
iotdev2      38
iotdev3     140
iotdev4      94
iotdev5      74
iotdev6      68
iotdev7     118
iotdev8      60
iotdev9      36
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     117
iotdev10    112
iotdev11     98
iotdev12    146
iotdev2      93
iotdev3     176
iotdev4      37
iotdev5      93
iotdev6     146
iotdev7     162
iotdev8     159
iotdev9      94
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      97
iotdev10     55
iotdev11      9
iotdev12    122
iotdev2     135
iotdev3      61
iotdev4      77
iotdev5     141
iotdev6      75
iotdev7     137
iotdev8     137
iotdev9     130
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      76
iotdev10     89
iotdev11    103
iotdev12     34
iotdev2     147
iotdev3      89
iotdev4      82
iotdev5      67
iotdev6     152
iotdev7      96
iotdev8     106
iotdev9     100
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      93
iotdev10     15
iotdev11    102
iotdev12    110
iotdev2      68
iotdev3     147
iotdev4     142
iotdev5      65
iotdev6       7
iotdev7      84
iotdev8      52
iotdev9     133
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      83
iotdev10    109
iotdev11     83
iotdev12     27
iotdev2      94
iotdev3     102
iotdev4      90
iotdev5     115
iotdev6     192
iotdev7      90
iotdev8     170
iotdev9     113
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     114
iotdev10     23
iotdev11     55
iotdev12     95
iotdev2     122
iotdev3     119
iotdev4      82
iotdev5      53
iotdev6      71
iotdev7     154
iotdev8     104
iotdev9      42
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      47
iotdev10    163
iotdev11     63
iotdev12    131
iotdev2     117
iotdev3     139
iotdev4      70
iotdev5     157
iotdev6      22
iotdev7     152
iotdev8      69
iotdev9      35
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     107
iotdev10    131
iotdev11     84
iotdev12     36
iotdev2      79
iotdev3     145
iotdev4     145
iotdev5      99
iotdev6      33
iotdev7      89
iotdev8      78
iotdev9      85
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     153
iotdev10    148
iotdev11     89
iotdev12     75
iotdev2     115
iotdev3     180
iotdev4      54
iotdev5      36
iotdev6     120
iotdev7      84
iotdev8     126
iotdev9      68
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     109
iotdev10     33
iotdev11    121
iotdev12    167
iotdev2     172
iotdev3     104
iotdev4     141
iotdev5     112
iotdev6     169
iotdev7      81
iotdev8      71
iotdev9     115
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      99
iotdev10    122
iotdev11    140
iotdev12     93
iotdev2      83
iotdev3      73
iotdev4      62
iotdev5      81
iotdev6     108
iotdev7     129
iotdev8     135
iotdev9      93
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      84
iotdev10     95
iotdev11    142
iotdev12    127
iotdev2     146
iotdev3      91
iotdev4      72
iotdev5     149
iotdev6      38
iotdev7      42
iotdev8      40
iotdev9      96
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      74
iotdev10    125
iotdev11    112
iotdev12    158
iotdev2     163
iotdev3      99
iotdev4      90
iotdev5      27
iotdev6     156
iotdev7     123
iotdev8      64
iotdev9     103
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     180
iotdev10    101
iotdev11    142
iotdev12     93
iotdev2     140
iotdev3      93
iotdev4      90
iotdev5     156
iotdev6      35
iotdev7      78
iotdev8      97
iotdev9      42
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      82
iotdev10    125
iotdev11    178
iotdev12    172
iotdev2      58
iotdev3      18
iotdev4     179
iotdev5     118
iotdev6      31
iotdev7      99
iotdev8      58
iotdev9      95
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     111
iotdev10     91
iotdev11     94
iotdev12     99
iotdev2     151
iotdev3      79
iotdev4      48
iotdev5     117
iotdev6      70
iotdev7      87
iotdev8      65
iotdev9      57
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     118
iotdev10     70
iotdev11    147
iotdev12     37
iotdev2     126
iotdev3      87
iotdev4      14
iotdev5     132
iotdev6     140
iotdev7     139
iotdev8      86
iotdev9     103
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     111
iotdev10    125
iotdev11     58
iotdev12     50
iotdev2     101
iotdev3     154
iotdev4     101
iotdev5      85
iotdev6     101
iotdev7     147
iotdev8      80
iotdev9     147
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     113
iotdev10    170
iotdev11    113
iotdev12    106
iotdev2      67
iotdev3     117
iotdev4      26
iotdev5     121
iotdev6      73
iotdev7      62
iotdev8      99
iotdev9      68
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     127
iotdev10     83
iotdev11     95
iotdev12     28
iotdev2      24
iotdev3     103
iotdev4      33
iotdev5     140
iotdev6     134
iotdev7     154
iotdev8     129
iotdev9     157
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     166
iotdev10    179
iotdev11     77
iotdev12    155
iotdev2     111
iotdev3     103
iotdev4      80
iotdev5      99
iotdev6     128
iotdev7     165
iotdev8     117
iotdev9     112
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     160
iotdev10     76
iotdev11     68
iotdev12    118
iotdev2      93
iotdev3     133
iotdev4      76
iotdev5     179
iotdev6     130
iotdev7      43
iotdev8      77
iotdev9     138
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     181
iotdev10    133
iotdev11     89
iotdev12     45
iotdev2     157
iotdev3     104
iotdev4      80
iotdev5      92
iotdev6      85
iotdev7      98
iotdev8      83
iotdev9      76
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     116
iotdev10     50
iotdev11     53
iotdev12     29
iotdev2     125
iotdev3      74
iotdev4      44
iotdev5     108
iotdev6     118
iotdev7     132
iotdev8      99
iotdev9      50
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     111
iotdev10    144
iotdev11    118
iotdev12    145
iotdev2      97
iotdev3     180
iotdev4     168
iotdev5     114
iotdev6     117
iotdev7     105
iotdev8      57
iotdev9     115
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      96
iotdev10     98
iotdev11    112
iotdev12     32
iotdev2     130
iotdev3      63
iotdev4     166
iotdev5     133
iotdev6      93
iotdev7       4
iotdev8      85
iotdev9      65
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      95
iotdev10     91
iotdev11     98
iotdev12    148
iotdev2      77
iotdev3      60
iotdev4     101
iotdev5      44
iotdev6     153
iotdev7      81
iotdev8     139
iotdev9     148
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     152
iotdev10     85
iotdev11    124
iotdev12     71
iotdev2     181
iotdev3      34
iotdev4      55
iotdev5      86
iotdev6     114
iotdev7     142
iotdev8     164
iotdev9     100
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     147
iotdev10    126
iotdev11    100
iotdev12     56
iotdev2     113
iotdev3     154
iotdev4      76
iotdev5      53
iotdev6     110
iotdev7      83
iotdev8     182
iotdev9      85
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      89
iotdev10    107
iotdev11     48
iotdev12    141
iotdev2     109
iotdev3     155
iotdev4     172
iotdev5      53
iotdev6      59
iotdev7     116
iotdev8      57
iotdev9      58
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      18
iotdev10    133
iotdev11     86
iotdev12    182
iotdev2     156
iotdev3     156
iotdev4     121
iotdev5     181
iotdev6     106
iotdev7      36
iotdev8     111
iotdev9      43
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      74
iotdev10     45
iotdev11    133
iotdev12    103
iotdev2     107
iotdev3     129
iotdev4      99
iotdev5      73
iotdev6      64
iotdev7      56
iotdev8     130
iotdev9     118
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     154
iotdev10    183
iotdev11    125
iotdev12    178
iotdev2     151
iotdev3     137
iotdev4     109
iotdev5      70
iotdev6      59
iotdev7      80
iotdev8     101
iotdev9     145
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      78
iotdev10    125
iotdev11     92
iotdev12    108
iotdev2      95
iotdev3      47
iotdev4     154
iotdev5      76
iotdev6     132
iotdev7     113
iotdev8      60
iotdev9     140
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      47
iotdev10     96
iotdev11     89
iotdev12     98
iotdev2      80
iotdev3      35
iotdev4     143
iotdev5      18
iotdev6      60
iotdev7      45
iotdev8      98
iotdev9     102
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     118
iotdev10     45
iotdev11    130
iotdev12     75
iotdev2      73
iotdev3      47
iotdev4      50
iotdev5      55
iotdev6      89
iotdev7      45
iotdev8      83
iotdev9     152
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1      89
iotdev10    162
iotdev11    158
iotdev12    101
iotdev2      54
iotdev3     110
iotdev4      95
iotdev5     104
iotdev6       8
iotdev7      90
iotdev8      58
iotdev9      69
Name: personas_detectadas, dtype: int64
id_dispositivo
iotdev1     100
iotdev10    160
iotdev11    136
iotdev12    122
iotdev2      27
iotdev3     122
iotdev4     113
iotdev5      26
iotdev6     113
iotdev7     155
iotdev8     179
iotdev9     105
Name: personas_detectadas, dtype: int64

for hora, grupo in AgrupadoPorHora_df: AgrupadoPorDispositivo_df = grupo.groupby(grupo["id_dispositivo"]); for dispositivo, grupo in AgrupadoPorDispositivo_df: print(dispositivo,grupo["personas_detectadas"].sum())

iotdev7 10
iotdev8 46
iotdev9 49
iotdev1 93
iotdev10 97
iotdev11 164
iotdev12 145
iotdev2 132
iotdev3 59
iotdev4 92
iotdev5 25
iotdev6 66
iotdev7 111
iotdev8 189
iotdev9 100
iotdev1 52
iotdev10 113
iotdev11 88
iotdev12 127
iotdev2 32
iotdev3 102
iotdev4 123
iotdev5 70
iotdev6 11
iotdev7 99
iotdev8 84
iotdev9 116
iotdev1 128
iotdev10 127
iotdev11 44
iotdev12 151
iotdev2 80
iotdev3 181
iotdev4 124
iotdev5 58
iotdev6 95
iotdev7 83
iotdev8 165
iotdev9 69
iotdev1 82
iotdev10 98
iotdev11 157
iotdev12 103
iotdev2 23
iotdev3 39
iotdev4 102
iotdev5 82
iotdev6 71
iotdev7 76
iotdev8 84
iotdev9 61
iotdev1 100
iotdev10 169
iotdev11 124
iotdev12 191
iotdev2 144
iotdev3 76
iotdev4 116
iotdev5 36
iotdev6 74
iotdev7 152
iotdev8 123
iotdev9 116
iotdev1 22
iotdev10 95
iotdev11 48
iotdev12 113
iotdev2 120
iotdev3 61
iotdev4 94
iotdev5 111
iotdev6 150
iotdev7 99
iotdev8 56
iotdev9 75
iotdev1 33
iotdev10 109
iotdev11 90
iotdev12 104
iotdev2 143
iotdev3 132
iotdev4 109
iotdev5 84
iotdev6 8
iotdev7 92
iotdev8 163
iotdev9 43
iotdev1 103
iotdev10 150
iotdev11 170
iotdev12 88
iotdev2 19
iotdev3 121
iotdev4 131
iotdev5 29
iotdev6 117
iotdev7 141
iotdev8 88
iotdev9 87
iotdev1 166
iotdev10 80
iotdev11 42
iotdev12 122
iotdev2 111
iotdev3 133
iotdev4 64
iotdev5 183
iotdev6 63
iotdev7 151
iotdev8 112
iotdev9 81
iotdev1 32
iotdev10 98
iotdev11 117
iotdev12 111
iotdev2 122
iotdev3 85
iotdev4 79
iotdev5 94
iotdev6 74
iotdev7 155
iotdev8 195
iotdev9 65
iotdev1 21
iotdev10 85
iotdev11 60
iotdev12 68
iotdev2 100
iotdev3 94
iotdev4 125
iotdev5 117
iotdev6 83
iotdev7 63
iotdev8 107
iotdev9 63
iotdev1 131
iotdev10 72
iotdev11 49
iotdev12 36
iotdev2 84
iotdev3 62
iotdev4 123
iotdev5 102
iotdev6 130
iotdev7 168
iotdev8 93
iotdev9 171
iotdev1 133
iotdev10 73
iotdev11 142
iotdev12 101
iotdev2 79
iotdev3 89
iotdev4 56
iotdev5 85
iotdev6 157
iotdev7 126
iotdev8 81
iotdev9 92
iotdev1 72
iotdev10 52
iotdev11 95
iotdev12 100
iotdev2 63
iotdev3 99
iotdev4 101
iotdev5 83
iotdev6 192
iotdev7 75
iotdev8 29
iotdev9 47
iotdev1 146
iotdev10 137
iotdev11 174
iotdev12 107
iotdev2 85
iotdev3 82
iotdev4 20
iotdev5 93
iotdev6 145
iotdev7 99
iotdev8 33
iotdev9 103
iotdev1 133
iotdev10 79
iotdev11 17
iotdev12 130
iotdev2 125
iotdev3 169
iotdev4 65
iotdev5 84
iotdev6 79
iotdev7 103
iotdev8 74
iotdev9 151
iotdev1 159
iotdev10 82
iotdev11 119
iotdev12 136
iotdev2 162
iotdev3 84
iotdev4 139
iotdev5 68
iotdev6 149
iotdev7 78
iotdev8 16
iotdev9 100
iotdev1 164
iotdev10 144
iotdev11 119
iotdev12 105
iotdev2 107
iotdev3 116
iotdev4 58
iotdev5 16
iotdev6 149
iotdev7 50
iotdev8 138
iotdev9 125
iotdev1 165
iotdev10 132
iotdev11 28
iotdev12 41
iotdev2 63
iotdev3 71
iotdev4 43
iotdev5 45
iotdev6 95
iotdev7 48
iotdev8 90
iotdev9 65
iotdev1 88
iotdev10 58
iotdev11 174
iotdev12 163
iotdev2 167
iotdev3 15
iotdev4 87
iotdev5 126
iotdev6 112
iotdev7 80
iotdev8 120
iotdev9 114
iotdev1 114
iotdev10 132
iotdev11 80
iotdev12 125
iotdev2 86
iotdev3 133
iotdev4 101
iotdev5 98
iotdev6 149
iotdev7 29
iotdev8 95
iotdev9 147
iotdev1 97
iotdev10 82
iotdev11 142
iotdev12 124
iotdev2 153
iotdev3 65
iotdev4 89
iotdev5 99
iotdev6 112
iotdev7 161
iotdev8 72
iotdev9 69
iotdev1 75
iotdev10 147
iotdev11 99
iotdev12 122
iotdev2 85
iotdev3 72
iotdev4 123
iotdev5 120
iotdev6 95
iotdev7 57
iotdev8 108
iotdev9 46
iotdev1 38
iotdev10 92
iotdev11 139
iotdev12 69
iotdev2 109
iotdev3 78
iotdev4 91
iotdev5 159
iotdev6 69
iotdev7 135
iotdev8 87
iotdev9 111
iotdev1 98
iotdev10 138
iotdev11 123
iotdev12 100
iotdev2 174
iotdev3 104
iotdev4 154
iotdev5 68
iotdev6 131
iotdev7 114
iotdev8 85
iotdev9 103
iotdev1 122
iotdev10 123
iotdev11 108
iotdev12 77
iotdev2 29
iotdev3 49
iotdev4 100
iotdev5 90
iotdev6 81
iotdev7 191
iotdev8 116
iotdev9 130
iotdev1 50
iotdev10 38
iotdev11 190
iotdev12 100
iotdev2 165
iotdev3 20
iotdev4 119
iotdev5 68
iotdev6 41
iotdev7 61
iotdev8 154
iotdev9 124
iotdev1 109
iotdev10 45
iotdev11 149
iotdev12 115
iotdev2 57
iotdev3 45
iotdev4 84
iotdev5 56
iotdev6 110
iotdev7 70
iotdev8 137
iotdev9 183
iotdev1 114
iotdev10 52
iotdev11 51
iotdev12 23
iotdev2 103
iotdev3 114
iotdev4 12
iotdev5 97
iotdev6 113
iotdev7 102
iotdev8 131
iotdev9 99
iotdev1 127
iotdev10 93
iotdev11 176
iotdev12 54
iotdev2 105
iotdev3 60
iotdev4 79
iotdev5 69
iotdev6 114
iotdev7 54
iotdev8 108
iotdev9 69
iotdev1 168
iotdev10 151
iotdev11 76
iotdev12 77
iotdev2 78
iotdev3 117
iotdev4 128
iotdev5 69
iotdev6 88
iotdev7 116
iotdev8 58
iotdev9 125
iotdev1 44
iotdev10 127
iotdev11 139
iotdev12 120
iotdev2 143
iotdev3 145
iotdev4 141
iotdev5 64
iotdev6 23
iotdev7 107
iotdev8 56
iotdev9 119
iotdev1 106
iotdev10 108
iotdev11 49
iotdev12 12
iotdev2 77
iotdev3 68
iotdev4 90
iotdev5 114
iotdev6 79
iotdev7 190
iotdev8 103
iotdev9 118
iotdev1 90
iotdev10 75
iotdev11 137
iotdev12 121
iotdev2 134
iotdev3 40
iotdev4 102
iotdev5 65
iotdev6 51
iotdev7 118
iotdev8 97
iotdev9 159
iotdev1 130
iotdev10 105
iotdev11 96
iotdev12 141
iotdev2 181
iotdev3 145
iotdev4 134
iotdev5 143
iotdev6 38
iotdev7 114
iotdev8 147
iotdev9 118
iotdev1 148
iotdev10 64
iotdev11 91
iotdev12 26
iotdev2 139
iotdev3 98
iotdev4 65
iotdev5 143
iotdev6 116
iotdev7 144
iotdev8 143
iotdev9 128
iotdev1 59
iotdev10 114
iotdev11 142
iotdev12 110
iotdev2 96
iotdev3 76
iotdev4 100
iotdev5 58
iotdev6 73
iotdev7 158
iotdev8 125
iotdev9 88
iotdev1 106
iotdev10 127
iotdev11 61
iotdev12 83
iotdev2 115
iotdev3 80
iotdev4 65
iotdev5 152
iotdev6 102
iotdev7 119
iotdev8 127
iotdev9 160
iotdev1 88
iotdev10 141
iotdev11 141
iotdev12 23
iotdev2 44
iotdev3 56
iotdev4 86
iotdev5 83
iotdev6 55
iotdev7 43
iotdev8 155
iotdev9 98
iotdev1 186
iotdev10 71
iotdev11 143
iotdev12 132
iotdev2 152
iotdev3 75
iotdev4 56
iotdev5 36
iotdev6 81
iotdev7 61
iotdev8 99
iotdev9 103
iotdev1 69
iotdev10 124
iotdev11 189
iotdev12 111
iotdev2 87
iotdev3 38
iotdev4 112
iotdev5 67
iotdev6 64
iotdev7 129
iotdev8 65
iotdev9 82
iotdev1 125
iotdev10 77
iotdev11 91
iotdev12 120
iotdev2 143
iotdev3 119
iotdev4 60
iotdev5 37
iotdev6 90
iotdev7 107
iotdev8 62
iotdev9 83
iotdev1 54
iotdev10 106
iotdev11 145
iotdev12 132
iotdev2 130
iotdev3 142
iotdev4 104
iotdev5 169
iotdev6 131
iotdev7 91
iotdev8 150
iotdev9 131
iotdev1 88
iotdev10 163
iotdev11 102
iotdev12 108
iotdev2 98
iotdev3 74
iotdev4 96
iotdev5 145
iotdev6 138
iotdev7 145
iotdev8 171
iotdev9 51
iotdev1 117
iotdev10 121
iotdev11 165
iotdev12 148
iotdev2 38
iotdev3 140
iotdev4 94
iotdev5 74
iotdev6 68
iotdev7 118
iotdev8 60
iotdev9 36
iotdev1 117
iotdev10 112
iotdev11 98
iotdev12 146
iotdev2 93
iotdev3 176
iotdev4 37
iotdev5 93
iotdev6 146
iotdev7 162
iotdev8 159
iotdev9 94
iotdev1 97
iotdev10 55
iotdev11 9
iotdev12 122
iotdev2 135
iotdev3 61
iotdev4 77
iotdev5 141
iotdev6 75
iotdev7 137
iotdev8 137
iotdev9 130
iotdev1 76
iotdev10 89
iotdev11 103
iotdev12 34
iotdev2 147
iotdev3 89
iotdev4 82
iotdev5 67
iotdev6 152
iotdev7 96
iotdev8 106
iotdev9 100
iotdev1 93
iotdev10 15
iotdev11 102
iotdev12 110
iotdev2 68
iotdev3 147
iotdev4 142
iotdev5 65
iotdev6 7
iotdev7 84
iotdev8 52
iotdev9 133
iotdev1 83
iotdev10 109
iotdev11 83
iotdev12 27
iotdev2 94
iotdev3 102
iotdev4 90
iotdev5 115
iotdev6 192
iotdev7 90
iotdev8 170
iotdev9 113
iotdev1 114
iotdev10 23
iotdev11 55
iotdev12 95
iotdev2 122
iotdev3 119
iotdev4 82
iotdev5 53
iotdev6 71
iotdev7 154
iotdev8 104
iotdev9 42
iotdev1 47
iotdev10 163
iotdev11 63
iotdev12 131
iotdev2 117
iotdev3 139
iotdev4 70
iotdev5 157
iotdev6 22
iotdev7 152
iotdev8 69
iotdev9 35
iotdev1 107
iotdev10 131
iotdev11 84
iotdev12 36
iotdev2 79
iotdev3 145
iotdev4 145
iotdev5 99
iotdev6 33
iotdev7 89
iotdev8 78
iotdev9 85
iotdev1 153
iotdev10 148
iotdev11 89
iotdev12 75
iotdev2 115
iotdev3 180
iotdev4 54
iotdev5 36
iotdev6 120
iotdev7 84
iotdev8 126
iotdev9 68
iotdev1 109
iotdev10 33
iotdev11 121
iotdev12 167
iotdev2 172
iotdev3 104
iotdev4 141
iotdev5 112
iotdev6 169
iotdev7 81
iotdev8 71
iotdev9 115
iotdev1 99
iotdev10 122
iotdev11 140
iotdev12 93
iotdev2 83
iotdev3 73
iotdev4 62
iotdev5 81
iotdev6 108
iotdev7 129
iotdev8 135
iotdev9 93
iotdev1 84
iotdev10 95
iotdev11 142
iotdev12 127
iotdev2 146
iotdev3 91
iotdev4 72
iotdev5 149
iotdev6 38
iotdev7 42
iotdev8 40
iotdev9 96
iotdev1 74
iotdev10 125
iotdev11 112
iotdev12 158
iotdev2 163
iotdev3 99
iotdev4 90
iotdev5 27
iotdev6 156
iotdev7 123
iotdev8 64
iotdev9 103
iotdev1 180
iotdev10 101
iotdev11 142
iotdev12 93
iotdev2 140
iotdev3 93
iotdev4 90
iotdev5 156
iotdev6 35
iotdev7 78
iotdev8 97
iotdev9 42
iotdev1 82
iotdev10 125
iotdev11 178
iotdev12 172
iotdev2 58
iotdev3 18
iotdev4 179
iotdev5 118
iotdev6 31
iotdev7 99
iotdev8 58
iotdev9 95
iotdev1 111
iotdev10 91
iotdev11 94
iotdev12 99
iotdev2 151
iotdev3 79
iotdev4 48
iotdev5 117
iotdev6 70
iotdev7 87
iotdev8 65
iotdev9 57
iotdev1 118
iotdev10 70
iotdev11 147
iotdev12 37
iotdev2 126
iotdev3 87
iotdev4 14
iotdev5 132
iotdev6 140
iotdev7 139
iotdev8 86
iotdev9 103
iotdev1 111
iotdev10 125
iotdev11 58
iotdev12 50
iotdev2 101
iotdev3 154
iotdev4 101
iotdev5 85
iotdev6 101
iotdev7 147
iotdev8 80
iotdev9 147
iotdev1 113
iotdev10 170
iotdev11 113
iotdev12 106
iotdev2 67
iotdev3 117
iotdev4 26
iotdev5 121
iotdev6 73
iotdev7 62
iotdev8 99
iotdev9 68
iotdev1 127
iotdev10 83
iotdev11 95
iotdev12 28
iotdev2 24
iotdev3 103
iotdev4 33
iotdev5 140
iotdev6 134
iotdev7 154
iotdev8 129
iotdev9 157
iotdev1 166
iotdev10 179
iotdev11 77
iotdev12 155
iotdev2 111
iotdev3 103
iotdev4 80
iotdev5 99
iotdev6 128
iotdev7 165
iotdev8 117
iotdev9 112
iotdev1 160
iotdev10 76
iotdev11 68
iotdev12 118
iotdev2 93
iotdev3 133
iotdev4 76
iotdev5 179
iotdev6 130
iotdev7 43
iotdev8 77
iotdev9 138
iotdev1 181
iotdev10 133
iotdev11 89
iotdev12 45
iotdev2 157
iotdev3 104
iotdev4 80
iotdev5 92
iotdev6 85
iotdev7 98
iotdev8 83
iotdev9 76
iotdev1 116
iotdev10 50
iotdev11 53
iotdev12 29
iotdev2 125
iotdev3 74
iotdev4 44
iotdev5 108
iotdev6 118
iotdev7 132
iotdev8 99
iotdev9 50
iotdev1 111
iotdev10 144
iotdev11 118
iotdev12 145
iotdev2 97
iotdev3 180
iotdev4 168
iotdev5 114
iotdev6 117
iotdev7 105
iotdev8 57
iotdev9 115
iotdev1 96
iotdev10 98
iotdev11 112
iotdev12 32
iotdev2 130
iotdev3 63
iotdev4 166
iotdev5 133
iotdev6 93
iotdev7 4
iotdev8 85
iotdev9 65
iotdev1 95
iotdev10 91
iotdev11 98
iotdev12 148
iotdev2 77
iotdev3 60
iotdev4 101
iotdev5 44
iotdev6 153
iotdev7 81
iotdev8 139
iotdev9 148
iotdev1 152
iotdev10 85
iotdev11 124
iotdev12 71
iotdev2 181
iotdev3 34
iotdev4 55
iotdev5 86
iotdev6 114
iotdev7 142
iotdev8 164
iotdev9 100
iotdev1 147
iotdev10 126
iotdev11 100
iotdev12 56
iotdev2 113
iotdev3 154
iotdev4 76
iotdev5 53
iotdev6 110
iotdev7 83
iotdev8 182
iotdev9 85
iotdev1 89
iotdev10 107
iotdev11 48
iotdev12 141
iotdev2 109
iotdev3 155
iotdev4 172
iotdev5 53
iotdev6 59
iotdev7 116
iotdev8 57
iotdev9 58
iotdev1 18
iotdev10 133
iotdev11 86
iotdev12 182
iotdev2 156
iotdev3 156
iotdev4 121
iotdev5 181
iotdev6 106
iotdev7 36
iotdev8 111
iotdev9 43
iotdev1 74
iotdev10 45
iotdev11 133
iotdev12 103
iotdev2 107
iotdev3 129
iotdev4 99
iotdev5 73
iotdev6 64
iotdev7 56
iotdev8 130
iotdev9 118
iotdev1 154
iotdev10 183
iotdev11 125
iotdev12 178
iotdev2 151
iotdev3 137
iotdev4 109
iotdev5 70
iotdev6 59
iotdev7 80
iotdev8 101
iotdev9 145
iotdev1 78
iotdev10 125
iotdev11 92
iotdev12 108
iotdev2 95
iotdev3 47
iotdev4 154
iotdev5 76
iotdev6 132
iotdev7 113
iotdev8 60
iotdev9 140
iotdev1 47
iotdev10 96
iotdev11 89
iotdev12 98
iotdev2 80
iotdev3 35
iotdev4 143
iotdev5 18
iotdev6 60
iotdev7 45
iotdev8 98
iotdev9 102
iotdev1 118
iotdev10 45
iotdev11 130
iotdev12 75
iotdev2 73
iotdev3 47
iotdev4 50
iotdev5 55
iotdev6 89
iotdev7 45
iotdev8 83
iotdev9 152
iotdev1 89
iotdev10 162
iotdev11 158
iotdev12 101
iotdev2 54
iotdev3 110
iotdev4 95
iotdev5 104
iotdev6 8
iotdev7 90
iotdev8 58
iotdev9 69
iotdev1 100
iotdev10 160
iotdev11 136
iotdev12 122
iotdev2 27
iotdev3 122
iotdev4 113
iotdev5 26
iotdev6 113
iotdev7 155
iotdev8 179
iotdev9 105

for hora, grupoHora in AgrupadoPorHora_df: #AgrupadoPorDispositivo_df = grupoHora.groupby(grupoHora["id_dispositivo"]); UbicacionConMayorAfluencia=grupoHora.nlargest(1,["personas_detectadas"]) UbicacionMenosUsoCubrebocas=grupoHora.nlargest(1,["personas_sin_cubrebocas"]) IndicadoresRedPorHora = IndicadoresRedPorHora.append({ 'fecha':hora.strftime('%Y-%m-%d'), 'hora':hora.strftime('%H:%M:%S'), 'total_personas_detectadas_por_hora':grupoHora["personas_detectadas"].sum(), 'total_personas_con_cubrebocas_por_hora':grupoHora["personas_con_cubrebocas"].sum(), 'total_personas_sin_cubrebocas_por_hora':grupoHora["personas_sin_cubrebocas"].sum(), 'id_ubicacion_mayor_afluencia':UbicacionConMayorAfluencia.iloc[0]['id_dispositivo'], 'total_personas_en_mayor_afluencia':UbicacionConMayorAfluencia.iloc[0]['personas_detectadas'], 'personas_sin_cubrebobas_en_mayor_afluencia':UbicacionConMayorAfluencia.iloc[0]['personas_sin_cubrebocas'], 'personas_con_cubrebobas_en_mayor_afluencia':UbicacionConMayorAfluencia.iloc[0]['personas_con_cubrebocas'], 'id_ubicacion_menor_uso_cubrebocas':UbicacionMenosUsoCubrebocas.iloc[0]['id_dispositivo'], 'total_personas_en_menor_uso_cubrebocas':UbicacionMenosUsoCubrebocas.iloc[0]['personas_detectadas'], 'personas_sin_cubrebobas_en_menor_uso_cubrebocas':UbicacionMenosUsoCubrebocas.iloc[0]['personas_sin_cubrebocas'], 'personas_con_cubrebobas_en_menor_uso_cubrebocas':UbicacionMenosUsoCubrebocas.iloc[0]['personas_con_cubrebocas'] },ignore_index=True)

IndicadoresRedPorHora

IndicadoresRedPorHora.to_csv("IndicadoresRedPorHora.csv")