-
Notifications
You must be signed in to change notification settings - Fork 0
/
cleanData.py
63 lines (55 loc) · 1.59 KB
/
cleanData.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
# coding=UTF-8
from bs4 import BeautifulSoup
from urllib.request import urlopen
from urllib.parse import quote
import re
def findID(line):
for i in range(0,3):
pos = line.find(',')
line = line[pos+1:]
pos = line.find(',')
line = line[:pos]
return line
file = open("C:\\Users\\user\\Google Drive\\NTU\\Year 2\\OR\\FinalProject\\Outside-1.txt", "a", encoding = "UTF-8")
# main = open("C:\\Users\\user\\Google Drive\\NTU\\Year 2\\OR\\FinalProject\\104-1.txt", "a", encoding = "UTF-8")
count = 0
with open("C:\\Users\\user\\Google Drive\\NTU\\Year 2\\OR\\FinalProject\\104-1.txt", 'r',encoding = "UTF-8" ) as mainCourse:
for course in mainCourse:
count = count + 1
cid = findID(course)
# print (cid)
for pageNum in range(1,7):
with open("C:\\Users\\user\\Google Drive\\NTU\\Year 2\\OR\\FinalProject\\104-1-A" + str(pageNum) + ".txt", 'r',encoding = "UTF-8" ) as f:
for line in f:
child_id = findID(line)
# print (line[:pos])
if cid == child_id:
print (cid)
f.close()
print (count)
mainCourse.close()
file.close()
# open another page
# courseurl = quote(col[16].a['href'], safe="%/:=&?~#+!$,;'@()*[]")
# coursePage = urlopen(courseurl)
# soup2 = BeautifulSoup(coursePage, "html.parser")
# x = soup2.body.table.tbody.tr.td.findAll('table')
# count = 0
# for row in x[1].findAll('tr'):
# if(count == 10):
# col = row.findAll('td')
# print (''.join(col[1].getText()))
# file.write(col[1].getText())
# count = count + 1
# cool constructure
# <table>
# <td>
# <table>
# <td>
# <table>
# <table>
# <td>
# <td>
# <table>
# <td>
# <table>