-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathshonandai_table.py
147 lines (136 loc) · 6.21 KB
/
shonandai_table.py
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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
# -*- coding: utf-8 -*-
import pandas as pd
import datetime
import csv
file = "data/stoptime.csv"
f = pd.read_csv(file)
# 配列に格納
lyear = []
lmonth = []
lday = []
lh = []
lmin = []
lsec = []
lstop = []
lyear= f['year']
lmonth= f['month']
lday = f['day']
lh = f['h']
lmin = f['min']
lsec = f['sec']
lstop = f['stop']
length = len(lyear)
A1 = []
A2 = []
A3 = []
A4 = []
A5 = []
A6 = []
A7 = []
A8 = []
A9 = []
A10 = []
A11 = []
A12 = []
A13 = []
csving = list()
for n in range(length):
if lstop[n] == 'shonandai':
time = datetime.datetime(lyear[n], lmonth[n], lday[n], lh[n], lmin[n], lsec[n])
jst = time + datetime.timedelta(hours=+9)
jstime = jst.time()
if datetime.time(8,5)<= jstime <= datetime.time(8,44):
# A1便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],23,15)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A1.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A1', delay])
elif datetime.time(8,45)<= jstime <= datetime.time(9,24):
# A2便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],23,55)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A2.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A2', delay])
elif datetime.time(9,25)<= jstime <= datetime.time(10,4):
# A3便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],0,35)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A3.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A3', delay])
elif datetime.time(10,5)<= jstime <= datetime.time(10,44):
# A4便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],1,15)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A4.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A4', delay])
elif datetime.time(10,45)<= jstime <= datetime.time(11,24):
# A5便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],1,55)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A5.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A5', delay])
elif datetime.time(11,25)<= jstime <= datetime.time(12,4):
# A6便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],2,35)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A6.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A6', delay])
elif datetime.time(12,5)<= jstime <= datetime.time(12,44):
# A7便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],3,15)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A7.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A7', delay])
elif datetime.time(12,45)<= jstime <= datetime.time(13,24):
# A8便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],3,55)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A8.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A8', delay])
elif datetime.time(13,25)<= jstime <= datetime.time(14,4):
# A9便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],4,35)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A9.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A9', delay])
elif datetime.time(14,5)<= jstime <= datetime.time(14,44):
# A10便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],5,15)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A10.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A10', delay])
elif datetime.time(14,45)<= jstime <= datetime.time(15,24):
# A11便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],5,55)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A11.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A11', delay])
elif datetime.time(15,25)<= jstime <= datetime.time(16,4):
# A12便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],6,35)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A12.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A12', delay])
elif datetime.time(16,15)<= jstime <= datetime.time(16,54):
# A13便に該当
table = datetime.datetime(lyear[n], lmonth[n], lday[n],7,25)
table = table + datetime.timedelta(hours=+9)
delay = jst- table
A13.append([jst, delay])
csving.append([jst.year, jst.month, jst.day, jst.weekday(), jst.hour, jst.minute, jst.second, lstop[n], 'A13', delay])
# csvに書き込み
with open('data/shonandai.csv', 'w') as file:
writer = csv.writer(file, lineterminator='\n')
writer.writerows(csving)