Python Loader.load_ArmPL Exemples

Exemple #1

from utils.constants import Armoire_NAME, Armoire_ARM_CAT, Armoire_DEPART_CAT, Armoire_TIME, Armoire_ARM_DIST
from modules.loader import Loader
from modules.cleaner import Cleaner
from modules.analyser import Analyzer
import datetime as dt

loader = Loader(
    datadir=
    "/Users/zhangyuan/Documents/Workspace/StageCiteosWorkspace/data/noumea")
cleaner = Cleaner()
analyser = Analyzer()

# load the data
data_Ar = loader.load_ArmPL(
    filename="BDDExport_ArmoireBt_NOUMEA_2018-05-15.xlsx",
    NAME_LIST=Armoire_NAME)

# remove the duplicated rows and replace the date with the duration
data_Ar = cleaner.rv_dupRow(data_Ar)
data_Ar = cleaner.rep_dur(data_Ar,
                          Var_lst=Armoire_TIME,
                          currtime=dt.datetime(2018, 5, 5, 0, 0, 0, 0))

# generate the count for NAN for all the variables
analyser.gen_NAN_excel(data_Ar.iloc[:, 0:43], 'Armoire_arm', 'Armoire_arm_or')
analyser.gen_NAN_excel(data_Ar.iloc[:, 43:], 'Armoire_depart',
                       'Armoire_depart_or')

# pick the variables and regroup
data_Ar_arm = analyser.pick_Var(data=data_Ar,
                                Var_lst=Armoire_ARM_CAT + Armoire_ARM_DIST)

Exemple #2

from utils.constants import PL_NAME, PL_TIME,PL_PL_CAT,PL_PL_DIST,PL_LAN_CAT,PL_LAN_DIST
from modules.loader import Loader
from modules.cleaner import Cleaner
from modules.analyser import Analyzer
import datetime as dt

loader = Loader(datadir="/Users/zhangyuan/Documents/Workspace/StageCiteosWorkspace/data/noumea")
cleaner = Cleaner()
analyser = Analyzer()
data_PL = loader.load_ArmPL(filename="BDDExport_PointLumineux_NOUMEA_2018-05-15.xlsx", NAME_LIST=PL_NAME)

data_PL = cleaner.rv_dupRow(data_PL)
data_PL = cleaner.rep_dur(data_PL,Var_lst=PL_TIME,currtime=dt.datetime(2018, 5, 5, 0, 0, 0, 0))

data_PL_PL = analyser.pick_Var(data=data_PL, Var_lst=PL_PL_CAT+PL_PL_DIST)
data_PL_LAN = analyser.pick_Var(data=data_PL, Var_lst=PL_LAN_CAT+PL_LAN_DIST)
data_PL_PL = cleaner.rv_dupRow(data_PL_PL)

analyser.gen_NAN_excel(data_PL.iloc[:,0:60],'PL_PL','PL_PL_or')
analyser.gen_NAN_excel(data_PL.iloc[:,60:],'PL_LAN','PL_LAN_or')

analyser.gen_histogram_Pie(data_PL_PL, 'PL_PL', Var_lst=PL_PL_CAT)
analyser.gen_histogram_Pie(data_PL_LAN, 'PL_LAN', Var_lst=PL_LAN_CAT)

analyser.gen_Dist(data_PL, 'PL_PL', Var_lst=PL_PL_DIST)
analyser.gen_Dist(data_PL_LAN,'PL_LAN',Var_lst=PL_LAN_DIST)

analyser.gen_NAN_excel(data_PL_PL,'PL_PL','PL_PL')
analyser.gen_NAN_excel(data_PL_LAN,'PL_LAN','PL_LAN')