Esempio n. 1
0
    def application_Vacance(self, dataset):
        donnees_covid = dataset.donnees_covid.liste
        donnees_vacance = dataset.donnees_vacances
        indice_dep = donnees_covid[0].index("dep")
        indice_jour = donnees_covid[0].index("jour")
        indice_selection = donnees_covid[0].index(self.var_selection)
        new_dataset = Dataset(
            Covid(None, [
                donnees_covid[0][indice_dep], donnees_covid[0][indice_jour],
                self.var_jointure, self.var_selection
            ]), donnees_vacance)
        endroit = None

        if self.var_jointure in donnees_vacance['Academie'][
                0] and self.var_jointure in donnees_vacance['Calendrier'][0]:
            endroit = 'Academie'
        elif self.var_jointure in donnees_vacance['Calendrier'][0]:
            endroit = 'Calendrier'
        elif self.var_jointure in donnees_vacance['Academie'][0]:
            endroit = 'Academie'
        else:
            print(
                "La variable recherchée n'est pas présente. Revoyez l'écriture ou les données"
            )

        for i in range(1, len(donnees_covid)):
            pos = 0
            if donnees_covid[i][indice_dep] == '2A':
                while not donnees_vacance['Academie'][pos][
                        "Code_Dpt"] == '2A' and pos < (
                            len(donnees_vacance['Academie']) - 1):
                    pos += 1

            elif donnees_covid[i][indice_dep] == '2B':
                while not donnees_vacance['Academie'][pos][
                        "Code_Dpt"] == '2B' and pos < (
                            len(donnees_vacance['Academie']) - 1):
                    pos += 1

            else:
                while not float(donnees_vacance['Academie'][pos]["Code_Dpt"]
                                ) == donnees_covid[i][indice_dep] and pos < (
                                    len(donnees_vacance['Academie']) - 1):
                    pos += 1

            new_dataset.ajout_donnees_covid([
                donnees_covid[i][indice_dep], donnees_covid[i][indice_jour],
                donnees_vacance[endroit][pos][self.var_jointure],
                donnees_covid[i][indice_selection]
            ])
        return (new_dataset.donnees_covid.liste)
    def ecart_type(self,dataset):
        resu=[]
        var=self.variance(dataset).donnees_covid.liste
        for ligne in var:
            resu.append([ligne[0],ligne[1]**(0.5)])

        return Dataset(Covid(None,resu),None)
Esempio n. 3
0
 def application_Covid(self, dataset):
     new_list = []
     covid = dataset.donnees_covid.liste
     indice = covid[0].index(self.var_selection)
     for elt in covid:
         new_list.append([elt[indice]])
     return (Dataset(Covid(None, new_list), dataset.donnees_vacances))
 def application_Covid(self, dataset):
     list_covid = dataset.donnees_covid.liste
     indice_var = list_covid[0].index(self.var_selection)
     list_moyenne = [[self.var_selection]]
     for i in range(self.time, len(list_covid)):
         moyenne = 0
         for x in list_covid[i - self.time + 1:i]:
             moyenne += x[indice_var]
         moyenne /= self.time
         list_moyenne.append([moyenne])
     return Dataset(Covid(None, list_moyenne), dataset.donnees_vacances)
Esempio n. 5
0
 def application_Vacance(self, dataset):
     vacances = dataset.donnees_vacances
     new_list = []
     if self.var_selection in vacances['Calendrier'][0]:
         for elt in vacances['Calendrier']:
             new_list.append(elt[self.var_selection])
     else:
         for elt in vacances['Academie']:
             new_list.append(elt[self.var_selection])
     new_list.insert(0, self.var_selection)
     return (Dataset(dataset.donnees_covid, new_list))
 def moyenne(self,dataset):
     resu=[]
     largueur=len(dataset.donnees_covid.liste[0])
     longueur = len(dataset.donnees_covid.liste)-1
     for i in range(largueur):
         if type(dataset.donnees_covid.liste[1][i])==float:
             sum=0
             for donnees in dataset.donnees_covid.liste[1:]:
                 sum=sum +float(donnees[i])
             resu.append(['{}'.format(dataset.donnees_covid.liste[0][i]),sum/longueur])
     return Dataset(Covid(None,resu),dataset.donnees_vacances)
    def variance(self,dataset):
        resu=[]
        largueur=len(dataset.donnees_covid.liste[0])
        longueur = len(dataset.donnees_covid.liste)-1
        for i in range(largueur):
            if type(dataset.donnees_covid.liste[1][i])==float:
                var=0
                for j in range(len(self.moyenne(dataset).donnees_covid.liste)):
                    if self.moyenne(dataset).donnees_covid.liste[j][0]==dataset.donnees_covid.liste[0][i]:
                        indice= j

                
                moy=self.moyenne(dataset).donnees_covid.liste[indice][1]
                
        
                for donnees in dataset.donnees_covid.liste[1:]:
                    var= var+(float(donnees[i])-moy)**2
                resu.append(['{}'.format(dataset.donnees_covid.liste[0][i]),var/longueur])
        return Dataset(Covid(None,resu),dataset.donnees_vacances)
Esempio n. 8
0
 def application_Vacance(self, dataset):
     vacances = dataset.donnees_vacances.dictionnaire
     debut = [int(x) for x in self.date_debut.split('-')]
     fin = [int(x) for x in self.date_fin.split('-')]
     def convient(date):
         if not(debut[0]<=date[0]<=fin[0]):
             return False
         elif ( debut[0] == date[0] and debut[1] > date[1] ) or (fin[0] == date[0] and fin[1] < date[1]):
             return False
         elif ( debut[0] == date[0] and debut[1] == date[1] and debut[2] > date[2]) or (fin[0] == date[0] and fin[1] == date[1] and fin[2] < date[2]):
             return False
         else :
             return True
     list_calendrier = []
     for i in range(len(vacances['Calendrier'])):
         if (vacances['Calendrier'][i]['Debut'] != None ) and (vacances['Calendrier'][i]['Fin'] != None) :
             vac_debut = [int(x) for x in vacances['Calendrier'][i]['Debut'].split('-')]
             vac_fin = [int(x) for x in vacances['Calendrier'][i]['Fin'].split('-')]
             if convient(vac_debut) and convient(vac_fin):
                 list_calendrier.append(vacances['Calendrier'][i])
     return Dataset(dataset.donnees_covid,Vacance(None,{'Calendrier': list_calendrier, 'Academie': vacances['Academie']}))
Esempio n. 9
0
    def application_Covid(self, dataset):
        list_covid = dataset.donnees_covid.liste
        list_date = []
        indice_date=list_covid[0].index('jour')
        for x in list_covid[1:] :
            list_date.append([int(y) for y in x[indice_date].split('-')])
        debut = [int(x) for x in self.date_debut.split('-')]
        fin = [int(x) for x in self.date_fin.split('-')]

        def convient(date):
            if not(debut[0]<=date[0]<=fin[0]):
                return False
            elif ( debut[0] == date[0] and debut[1] > date[1] ) or (fin[0] == date[0] and fin[1] < date[1]):
                return False
            elif ( debut[0] == date[0] and debut[1] == date[1] and debut[2] > date[2]) or (fin[0] == date[0] and fin[1] == date[1] and fin[2] < date[2]):
                return False
            else :
                return True
        new_jeu_covid =[list_covid[0]]
        for i in range(len(list_covid)-1):
            date = list_date[i]
            if convient(date):
                new_jeu_covid.append(list_covid[i+1])
        return Dataset(Covid(None,new_jeu_covid),dataset.donnees_vacances)
Esempio n. 10
0
    def application_Covid(self, dataset):
        donnees_covid = dataset.donnees_covid.liste
        donnees_covid2 = self.dataset2.donnees_covid.liste

        indice_jour = donnees_covid[0].index("jour")
        indice_jour2 = donnees_covid2[0].index("jour")

        indice_sexe = None

        if "reg" in donnees_covid[0]:
            indice_spatial = donnees_covid[0].index("reg")
        elif "dep" in donnees_covid[0]:
            indice_spatial = donnees_covid[0].index("dep")
        elif "numReg" in donnees_covid[0]:
            indice_spatial = donnees_covid[0].index("Numreg")

        if 'sexe' in donnees_covid[0]:
            indice_sexe = donnees_covid[0].index("sexe")

        if self.var_selection in donnees_covid[0]:
            indice1 = donnees_covid[0].index(self.var_selection)
        elif self.var_jointure in donnees_covid[0]:
            indice1 = donnees_covid[0].index(self.var_jointure)
        if self.var_selection in donnees_covid2[0]:
            indice2 = donnees_covid2[0].index(self.var_selection)
        elif self.var_jointure in donnees_covid2[0]:
            indice2 = donnees_covid2[0].index(self.var_jointure)

        new_dataset = Dataset(
            Covid(None, [[
                donnees_covid[0][indice_spatial],
                donnees_covid2[0][indice_jour2], donnees_covid[0][indice1],
                donnees_covid2[0][indice2]
            ]]), dataset.donnees_vacances)
        new_dataset.donnees_covid.append()
        pos = 1
        i = 1
        if len(donnees_covid) >= len(
                donnees_covid2):  #il y a plus de jours dans donnees_covid

            if indice_sexe == None:
                while i < len(donnees_covid) and pos < (len(donnees_covid2)):
                    if donnees_covid[i][indice_jour] == donnees_covid2[pos][
                            indice_jour2]:
                        new_dataset.ajout_donnees_covid([
                            donnees_covid[i][indice_spatial],
                            donnees_covid2[pos][indice_jour2],
                            donnees_covid[i][indice1],
                            donnees_covid2[pos][indice2]
                        ])
                        i += 1
                        pos += 1
                    else:
                        i += 1
            else:
                while i < len(donnees_covid) and pos < (len(donnees_covid2)):
                    if donnees_covid[i][indice_jour] == donnees_covid2[pos][
                            indice_jour2]:
                        new_dataset.ajout_donnees_covid([
                            donnees_covid[i][indice_spatial],
                            donnees_covid2[pos][indice_jour2],
                            donnees_covid[i][indice1],
                            donnees_covid2[pos][indice2]
                        ])
                        i += 3
                        pos += 1
                    else:
                        i += 3

        else:

            if indice_sexe == None:
                while i < len(donnees_covid2) and pos < (len(donnees_covid2)):
                    if donnees_covid2[i][indice_jour2] == donnees_covid[pos][
                            indice_jour]:
                        new_dataset.ajout_donnees_covid([
                            donnees_covid[pos][indice_spatial],
                            donnees_covid[pos][indice_jour2],
                            donnees_covid[pos][indice1],
                            donnees_covid2[i][indice2]
                        ])
                        i += 1
                        pos += 1
                    else:
                        i += 1
            else:
                while i < len(donnees_covid) and pos < (len(donnees_covid2)):
                    if donnees_covid2[i][indice_jour2] == donnees_covid[pos][
                            indice_jour]:

                        new_dataset.ajout_donnees_covid([
                            donnees_covid[pos][indice_spatial],
                            donnees_covid[pos][indice_jour2],
                            donnees_covid[pos][indice1],
                            donnees_covid2[i][indice2]
                        ])
                        i += 3
                        pos += 1
                    else:
                        i += 3

        return (new_dataset)
Esempio n. 11
0
    './Donnees/Donnees_Covid/donnees-hospitalieres-nouveaux-covid19-2021-03-03-17h03.csv'
)

#d=Covid('/Users/thomashilger/Desktop/projet_donnees/Donnees/Donnees_Covid/covid-hospit-incid-reg-2021-03-03-17h20.csv')
#data=Dataset(d)

#print(Moyenne_glissante('numReg', 'covid', 20).application(data).donnees_covid.liste)
# unittest.main()
#Sauvegarder(Normalisation('numReg','covid').application(data)).SauvegarderCSV('normal')
#print(Fenetrage('numReg', 'covid', '2020-03-019', '2020-03-20').application(Dataset(d)).donnees_covid)

#Sauvegarder(a.liste).SauvegarderCSV('test',sep=',')

#print(EstimationDescriptive().ecart_type(data))

data = Dataset(a, b.dictionnaire)
#print(Covid(None,[["Academie"],['France']]))

#print((Jointure('incid_hosp','vacance',"Zone").application(data)))

#print(Selection_Var('jour','Covid').application(data))

#print(data2)
#Sauvegarder(Selection_Var('numReg','covid').application(data)).SauvegarderCSV('selection.csv')
# print((Agregation_Spatiale("dc",'Covid',"region").application(data)))  #chiffre eh dessous des offciciels ???

#Selection_Var('numReg','covid').application(data).donnees_covid

#data=(Selection_Var('jour','Covid').application(data))

#print(Selection_Var('numReg','covid').application(data).donnees_covid)
Esempio n. 12
0
    def application_regionale(self, dataset):
        var_dataset = (Selection_Var(
            self.var_selection,
            'covid').application(dataset)).donnees_covid.liste

        liste_region = self.reg()
        donnees_covid = dataset.donnees_covid.liste
        somme = 0
        indice_jour = donnees_covid[0].index("jour")
        indice_dep = donnees_covid[0].index("dep")

        if 'sexe' in dataset.donnees_covid.liste[0]:

            indice0, indice1, indice2 = self.sexe(dataset)

            somme0 = 0
            somme1 = 0
            somme2 = 0

            difference1 = indice1 - indice0
            difference2 = indice2 - indice0
            difference = indice2 - indice0 + 1
            ind_bon_dep = None

            new_dataset = Dataset(
                Covid(None, [["Region", 'jour', "sexe", self.var_selection]]),
                dataset.donnees_vacances)
            new_jour = donnees_covid[1][indice_jour]
            for region in liste_region:
                pos0 = indice0

                while pos0 < (len(var_dataset) - difference):
                    jour = donnees_covid[pos0][indice_jour]
                    while jour == new_jour and pos0 < (len(var_dataset) -
                                                       difference):
                        if donnees_covid[pos0][indice_dep] in region:

                            somme0 += var_dataset[pos0][0]
                            somme1 += var_dataset[pos0 + difference1][0]
                            somme2 += var_dataset[pos0 + difference2][0]
                            ind_bon_dep = pos0
                            pos0 += difference
                            new_jour = donnees_covid[pos0][indice_jour]
                        else:
                            pos0 += difference
                            new_jour = donnees_covid[pos0][indice_jour]
                    if ind_bon_dep != None:
                        new_dataset.ajout_donnees_covid([
                            region[0], donnees_covid[pos0][indice_jour],
                            float(0), somme0
                        ])
                        new_dataset.ajout_donnees_covid([
                            region[0],
                            donnees_covid[pos0 + difference1][indice_jour],
                            float(1), somme1
                        ])
                        new_dataset.ajout_donnees_covid([
                            region[0],
                            donnees_covid[pos0 + difference2][indice_jour],
                            float(2), somme2
                        ])
                    ind_bon_dep = None
                    somme0 = 0
                    somme1 = 0
                    somme2 = 0
                    pos0 += difference

        else:
            new_dataset = Dataset(
                Covid(None, [["Region", 'jour', self.var_selection]]),
                dataset.donnees_vacances)
            somme = 0
            i = 1
            new_jour = donnees_covid[i][indice_jour]
            ind_bon_dep = None
            for region in liste_region:
                i = 1
                while i < len(var_dataset) - 1:
                    jour = donnees_covid[i][indice_jour]
                    while jour == new_jour and i < len(var_dataset) - 1:
                        if donnees_covid[i][indice_dep] in region:

                            somme += var_dataset[i][0]
                            ind_bon_dep = i
                            i += 1
                            new_jour = donnees_covid[i][indice_jour]
                        else:
                            i += 1
                            new_jour = donnees_covid[i][indice_jour]
                    if ind_bon_dep != None:
                        new_dataset.ajout_donnees_covid([
                            region[0], donnees_covid[ind_bon_dep][indice_jour],
                            somme
                        ])
                    ind_bon_dep = None
                    somme = 0
                    i += 1

        return (new_dataset.donnees_covid.liste)
Esempio n. 13
0
    def application_nationale(self, dataset):

        var_dataset = (Selection_Var(
            self.var_selection,
            'covid').application(dataset)).donnees_covid.liste
        donnees_covid = dataset.donnees_covid.liste
        somme = 0
        indice_jour = donnees_covid[0].index("jour")

        if "sexe" in donnees_covid[0]:

            indice0, indice1, indice2 = self.sexe(dataset)

            somme0 = var_dataset[indice0][0]
            somme1 = var_dataset[indice2][0]
            somme2 = var_dataset[indice2][0]

            difference1 = indice1 - indice0
            difference2 = indice2 - indice0
            difference = indice2 - indice0 + 1

            pos0 = indice0 + difference

            new_dataset = Dataset(
                Covid(None,
                      [["Nationale", 'jour', 'sexe', self.var_selection]]),
                dataset.donnees_vacances)

            while pos0 < len(var_dataset) - difference:
                if donnees_covid[pos0][indice_jour] == donnees_covid[
                        pos0 - difference][indice_jour]:
                    somme0 += var_dataset[pos0][0]
                    somme1 += var_dataset[pos0 + difference1][0]
                    somme2 += var_dataset[pos0 + difference2][0]
                    pos0 += difference
                else:
                    new_dataset.ajout_donnees_covid([
                        "France", donnees_covid[pos0][indice_jour],
                        float(0), somme0
                    ])
                    new_dataset.ajout_donnees_covid([
                        "France",
                        donnees_covid[pos0 + difference1][indice_jour],
                        float(1), somme1
                    ])
                    new_dataset.ajout_donnees_covid([
                        "France",
                        donnees_covid[pos0 + difference2][indice_jour],
                        float(2), somme2
                    ])
                    somme0 = var_dataset[pos0][0]
                    somme1 = var_dataset[pos0 + difference1][0]
                    somme2 = var_dataset[pos0 + difference2][0]
                    pos0 += difference

        else:
            new_dataset = Dataset(
                Covid(None, [["Nationale", 'jour', self.var_selection]]),
                dataset.donnees_vacances)
            somme = var_dataset[1][0]
            i = 2
            while i < len(var_dataset):
                if donnees_covid[i][indice_jour] == donnees_covid[
                        i - 1][indice_jour]:
                    somme += var_dataset[i][0]
                    i += 1
                else:
                    new_dataset.ajout_donnees_covid(
                        ["France", donnees_covid[i][indice_jour], somme])
                    somme = var_dataset[i][0]
                    i += 1

        return (new_dataset.donnees_covid.liste)