13_DuFrExpecData.py

from twicebursterDataMining.RH_Library import *
from Bunker.Marines import *
import matplotlib.pyplot as plt
import numpy as np

#
#
# 75분 수업만 뽑아내기
class75MDic = {}
for row in sqlite3.connect(getDatabasePathing("SCHEDULEDATABASE.db")).execute("SELECT * FROM SCHEDULETABLE"):
    startTime = datetime.datetime.strptime(list(row)[4][3:8], "%H:%M")
    endTime = datetime.datetime.strptime(list(row)[4][12:], "%H:%M")
    if str(endTime - startTime) == "1:15:00":
        class75MDic[row[0]] = [row[4], row[5]]

#
#
# 전체학생 Bin 평균의 Duration, Frequency 박스플롯
studentsDataDurationDic, studentsFrequencyDic = {}, {}
for studentIndex in range(0, 84):
    studentDataPath = getStudentDataPathing(studentIndex)
    print(studentDataPath)

    #
    #
    # 출석시간 뽑아내기
    attendanceTimeArray = []
    for attendanceRow in sqlite3.connect(getDatabasePathing("ATTENDANCEDATABASE.db")).execute("SELECT * FROM ATTENDANCETABLE WHERE ID==" + "'" + getStudentID(studentIndex) + "'"):
        if attendanceRow[1] in class75MDic.keys():
            for row in attendanceRow[2:]:
                if row == "":
                    continue
                attendanceTimeArray.append([attendanceRow[1], row.split("~")[0], row.split("~")[1]])

    #
    #
    # 수업 시작시간 뽑아내기
    classStartTimeDic = {}
    for attendanceRow in attendanceTimeArray:
        firstClassTime = class75MDic[attendanceRow[0]][0]
        startTime = attendanceRow[1][0:11] + firstClassTime[3:5] + "." + firstClassTime[6:8] + ".00.000"

        if attendanceRow[0] in classStartTimeDic.keys():
            classStartTimeDic[attendanceRow[0]].append(startTime)
        else:
            classStartTimeDic[attendanceRow[0]] = [startTime]

    #
    #
    # Duration, Frequency Bin 데이터 추출하기
    binArray = []
    for className, usingStartTime, usingEndTime in sqlite3.connect(studentDataPath + "\\CLASSUSAGEDATABASE.db").execute("SELECT CLASSNAME, STARTTIME, ENDTIME FROM CLASSUSAGETABLE"):
        for classStartTime in classStartTimeDic[className]:
            if usingStartTime[:10] == classStartTime[:10]:
                binArray.append([elapsedTimeCalculating(classStartTime, usingStartTime), elapsedTimeCalculating(classStartTime, usingEndTime)])

    binDic = {}
    for binStartTime, binEndTime in binArray:
        tempDic = {}
        for sec in range(int(binStartTime), int(binEndTime) + 1):
            for binIndex in range(0, 15):
                if binIndex * 300 <= sec <= (binIndex + 1) * 300:
                    if binIndex in tempDic.keys():
                        tempDic[binIndex] = tempDic[binIndex] + 1
                    else:
                        tempDic[binIndex] = 1
        for row in tempDic.items():
            if row[0] in binDic.keys():
                binDic[row[0]].append(row[1])
            else:
                binDic[row[0]] = [row[1]]

    for binIndex, binArray in sorted(binDic.items(), key=lambda row: row[0]):
        if binIndex in studentsDataDurationDic.keys():
            studentsDataDurationDic[binIndex].append(round(sum(binArray) / len(binArray), 3))
            studentsFrequencyDic[binIndex].append(len(binArray))
        else:
            studentsDataDurationDic[binIndex] = [round(sum(binArray) / len(binArray), 3)]
            studentsFrequencyDic[binIndex] = [len(binArray)]

#
#
# Duration 사용야기 박스플롯
temp = []
for row in studentsDataDurationDic.values():
    temp.append(row)

X = np.array(temp).transpose()
expectedVal = []
for eachStudentArray in X:
    prevValue = 0
    temp = []
    for index, row in enumerate(eachStudentArray):
        if index == 0:
            prevValue = row
        else:
            temp.append(round(row - prevValue, 3))
            prevValue = row

    expectedVal.append(round(sum(temp) / 14, 3))

plt.boxplot(expectedVal)
plt.show()

#
#
# Frequency 사용야기 박스플롯
temp = []
for row in studentsFrequencyDic.values():
    temp.append(row)

X = np.array(temp).transpose()
expectedVal = []
for eachStudentArray in X:
    prevValue = 0
    temp = []
    for index, row in enumerate(eachStudentArray):
        if index == 0:
            prevValue = row
        else:
            temp.append(round(row - prevValue, 3))
            prevValue = row

    expectedVal.append(round(sum(temp) / 14, 3))

plt.boxplot(expectedVal)
plt.show()