Vacunació 2021 ============== Creació del DataFrame a partir del fitxer amb les dades ------------------------------------------------------- >>> import pandas as pd >>> dfvacuna = pd.read_csv('vacunacio.csv') >>> dfvacuna.columns Index(['SEXE', 'PROVINCIA', 'COMARCA', 'EDAT', 'DOSI', 'DATA', 'MARCA', 'VACC', 'COMP'], dtype='object') >>> dfvacuna[['SEXE', 'COMARCA', 'EDAT', 'DOSI', 'DATA', 'MARCA', 'VACC', 'COMP']][82:90] SEXE COMARCA EDAT DOSI DATA MARCA VACC COMP 82 Home BARCELONES 35 a 39 2 2021/04/22 Moderna Si 17 83 Dona VALLES ORIENTAL 30 a 34 1 2021/04/22 Moderna Si 4 84 Dona OSONA 65 a 69 1 2021/04/22 AstraZeneca Si 167 85 Home TARRAGONES 40 a 44 1 2021/04/23 Moderna Si 3 86 Dona VALLES OCCIDENTAL 55 a 59 1 2021/04/22 Moderna Si 38 87 Dona BAIX LLOBREGAT 75 a 79 2 2021/04/23 Moderna Si 5 88 Home VALLES OCCIDENTAL 50 a 54 1 2021/04/20 Moderna Si 7 89 Home BAIX LLOBREGAT 60 a 64 1 2021/04/22 Moderna Si 7 Tests per vacunes ----------------- >>> from vacunacio import vacunes >>> vacunes(dfvacuna[:1000], 'Barcelona') # doctesttag: +TAG=1_p1 (16039, 626) >>> vacunes(dfvacuna[1000:2000], 'Barcelona') # doctesttag: +TAG=1_p1 (22333, 349) >>> vacunes(dfvacuna[200:1200], 'Girona') # doctesttag: +TAG=1_p1 (2774, 82) >>> vacunes(dfvacuna[600:2600], 'Girona') # doctesttag: +TAG=1_p1 (5662, 150) >>> vacunes(dfvacuna[:500], 'Tarragona') # doctesttag: +TAG=1_p1 (825, 7) >>> vacunes(dfvacuna[2500:3000], 'Tarragona') # doctesttag: +TAG=1_p1 (1799, 25) >>> vacunes(dfvacuna[4000:4500], 'Lleida') # doctesttag: +TAG=1_p1 (984, 41) >>> vacunes(dfvacuna[4500:5000], 'Lleida') # doctesttag: +TAG=1_p1 (1068, 15) Tests per max_vacunes ------------------------ >>> from vacunacio import max_vacunes >>> max_vacunes(dfvacuna[1000:4000], '2021/01/01', '2021/01/31') # doctesttag: +TAG=2_p2 ('BARCELONES', '55 a 59', '2021/01/05', 'Pfizer', 219) >>> max_vacunes(dfvacuna[1000:4000], '2021/03/01', '2021/03/31') # doctesttag: +TAG=2_p2 ('BARCELONES', '80 o més', '2021/03/31', 'Pfizer', 4936) >>> max_vacunes(dfvacuna[1000:4000], '2021/04/01', '2021/04/30') # doctesttag: +TAG=2_p2 ('BAIX LLOBREGAT', '75 a 79', '2021/04/13', 'Pfizer', 1265) >>> max_vacunes(dfvacuna[4000:6000], '2021/01/01', '2021/01/31') # doctesttag: +TAG=2_p2 ('BAIX LLOBREGAT', '80 o més', '2021/01/26', 'Pfizer', 368) >>> max_vacunes(dfvacuna[4000:6000], '2021/02/01', '2021/02/28') # doctesttag: +TAG=2_p2 ('VALLES OCCIDENTAL', '35 a 39', '2021/02/02', 'Pfizer', 101) >>> max_vacunes(dfvacuna[4000:6000], '2021/03/01', '2021/03/31') # doctesttag: +TAG=2_p2 ('BARCELONES', '80 o més', '2021/03/24', 'Pfizer', 2179) >>> max_vacunes(dfvacuna[400:1100], '2021/02/01', '2021/02/28') # doctesttag: +TAG=2_p2 ('VALLES ORIENTAL', '55 a 59', '2021/02/04', 'Pfizer', 59) >>> max_vacunes(dfvacuna[400:1100], '2021/03/01', '2021/03/31') # doctesttag: +TAG=2_p2 ('VALLES OCCIDENTAL', '80 o més', '2021/03/31', 'Pfizer', 2504) >>> max_vacunes(dfvacuna[400:1100], '2021/04/01', '2021/04/30') # doctesttag: +TAG=2_p2 ('BAIX LLOBREGAT', '80 o més', '2021/04/01', 'Pfizer', 1560) Tests per valors_possibles -------------------------- >>> from vacunacio import valors_possibles >>> valors_possibles(dfvacuna[:20], 'MARCA') # doctesttag: +TAG=3_p3 ['AstraZeneca', 'Moderna', 'No admin', 'Pfizer'] >>> valors_possibles(dfvacuna[124:135], 'MARCA') # doctesttag: +TAG=3_p3 ['Moderna', 'Pfizer'] >>> valors_possibles(dfvacuna[:20], 'EDAT') # doctesttag: +TAG=3_p3 ['15 a 19', '20 a 24', '30 a 34', '35 a 39', '40 a 44', '50 a 54', '55 a 59', '60 a 64', '65 a 69', '75 a 79', '80 o més'] >>> valors_possibles(dfvacuna[128:150], 'PROVINCIA') # doctesttag: +TAG=3_p3 ['Barcelona', 'Lleida', 'Tarragona'] >>> valors_possibles(dfvacuna[3000:3100], 'SEXE') # doctesttag: +TAG=3_p3 ['Dona', 'Home', 'No classificat'] >>> lc = valors_possibles(dfvacuna[3000:3100], 'COMARCA') >>> lc[:5] # doctesttag: +TAG=3_p3 ['ALT CAMP', 'ALT EMPORDA', 'ALT PENEDES', 'ANOIA', 'BAGES'] Tests per df_edats ------------------ >>> from vacunacio import df_edats >>> df = dfvacuna[:10] >>> dfe1 = df_edats(df) >>> isinstance(dfe1, pd.core.frame.DataFrame) # doctesttag: +TAG=4_p4-un True >>> dfe1 AstraZeneca Moderna No admin Pfizer 30 a 34 0 7 0 0 35 a 39 0 1 0 0 40 a 44 0 7 1 0 50 a 54 0 2 0 0 60 a 64 365 0 0 0 65 a 69 68 8 0 0 80 o més 0 0 0 1 >>> dfe1['AstraZeneca']['60 a 64'] # doctesttag: +TAG=4_p4-un 365 >>> dfe1['Moderna']['30 a 34'] # doctesttag: +TAG=4_p4-un 7 >>> dfe1['No admin']['40 a 44'] # doctesttag: +TAG=4_p4-un 1 >>> dfe1['Pfizer']['80 o més'] # doctesttag: +TAG=4_p4-un 1 >>> dfe1['AstraZeneca']['65 a 69'] # doctesttag: +TAG=4_p4-un 68 >>> dfe2 = df_edats(dfvacuna[15000:18000]) >>> isinstance(dfe2, pd.core.frame.DataFrame) # doctesttag: +TAG=4_p4-dos True >>> dfe2 AstraZeneca Moderna No admin Pfizer 0 a 14 0 0 12 4 15 a 19 18 48 0 50 20 a 24 1672 307 7 1916 25 a 29 1910 210 13 6074 30 a 34 3178 257 11 4704 35 a 39 3097 205 4 5852 40 a 44 5825 403 4 5007 45 a 49 5463 248 15 5406 50 a 54 2891 475 8 3222 55 a 59 697 313 7 2881 60 a 64 5316 284 65 1904 65 a 69 7193 418 161 2617 70 a 74 28 659 1640 9774 75 a 79 0 100 761 32835 80 o més 0 14 2541 39759 No classificat 1130 498 21 4617 >>> dfe2['AstraZeneca']['70 a 74'] # doctesttag: +TAG=4_p4-dos 28 >>> dfe2['Moderna']['25 a 29'] # doctesttag: +TAG=4_p4-dos 210 >>> dfe2['No admin']['70 a 74'] # doctesttag: +TAG=4_p4-dos 1640 >>> dfe2['Pfizer']['75 a 79'] # doctesttag: +TAG=4_p4-dos 32835 >>> dfe2['Pfizer']['60 a 64'] # doctesttag: +TAG=4_p4-dos 1904