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
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")