schedule/schedule_reader.py at main · kanggoaid/schedule · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
import pandas as pd

Location = 'excel'
File = 'schedule.xlsx'

data_pd = pd.read_excel('{}/{}'.format(Location, File),
                        header=None, index_col=None, names=None)

# 시간표 수작업도 싫고 머리쓰기도 귀찮은 휘근쨩의 무지성무논리30분코딩 시간표리더기
# 2023 1학기 시간표 기준
# 그냥 다시 만들자 tlqkf ㅋㅋ 하나하나 바꾸기 매우 귀찮음
# 쓰고 json에 넣을땐 탭한번 치는게 이쁜듯

h = 4
# 행

y = 1
# 열

for i in range(0, 24):
    y = 1
    E = (i % 8) + 1
    # 반

    M = (i // 8) + 1
    # 학년

    print('"' + str(M) + "-" + str(E) + '" : [')

    for j in range(1, 15):
        if y > 14:
            break

        else:
            if y == 1:
                print('\t["' + data_pd.iloc[h, y] + '", ', end=' ')
                y = y + 1

            elif y == 7:
                print('"' + data_pd.iloc[h, y] + '",], ', end=' ')
                y = y + 1

            elif y == 8:
                print('\t["' + data_pd.iloc[h, y] + '", ', end=' ')
                y = y + 1

            elif y == 14:
                print('"' + data_pd.iloc[h, y] + '",], ', end=' ')
                y = y + 1

            else:
                print('"' + data_pd.iloc[h, y] + '", ', end=' ')
                y = y + 1

        if j == 7:
            print(" ")

    print(" ")

    for j in range(1, 7):
        if y > 20:
            break

        else:
            if y == 15:
                print('\t["' + data_pd.iloc[h, y] + '", ', end=' ')
                y = y + 1

            elif y == 20:
                print('"' + data_pd.iloc[h, y] + '",], ', end=' ')
                y = y + 1

            else:
                print('"' + data_pd.iloc[h, y] + '", ', end=' ')
                y = y + 1

        if j == 6:
            print(" ")

    for j in range(1, 15):
        if y > 34:
            break

        else:
            if y == 21:
                print('\t["' + data_pd.iloc[h, y] + '", ', end=' ')
                y = y + 1

            elif y == 27:
                print('"' + data_pd.iloc[h, y] + '",], ', end=' ')
                y = y + 1

            elif y == 28:
                print('\t["' + data_pd.iloc[h, y] + '", ', end=' ')
                y = y + 1

            elif y == 34:
                print('"' + data_pd.iloc[h, y] + '",] ', end=' ')
                y = y + 1

            else:
                print('"' + data_pd.iloc[h, y] + '", ', end=' ')
                y = y + 1

        if j == 7:
            print("")

    print("\n],")
    h = h + 2