ProjectCM/reed.py at master · chandms/ProjectCM · 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
from xml.etree import ElementTree as ET
import csv

tree = ET.parse('reed.xml')
root = tree.getroot()

with open('reedfile.csv','wb') as reed_file:
    csvwriter = csv.writer(reed_file)

    rh =[]

    count=0

    for member in root.findall('course'):
        course =[]
##    time_list =[]
##    place_list =[]
        if count==0:
            reg_num=member.find('reg_num').tag
            rh.append(reg_num)
            subj=member.find('subj').tag
            rh.append(subj)
            crse=member.find('crse').tag
            rh.append(crse)
            sect=member.find('sect').tag
            rh.append(sect)
            title=member.find('title').tag
            rh.append(title)
            units=member.find('units').tag
            rh.append(units)
            instructor=member.find('instructor').tag
            rh.append(instructor)
            days=member.find('days').tag
            rh.append(days)
            time=member[8].tag
            st_time=member[8][0].tag
            en_time=member[8][1].tag
            rh.append(st_time)
            rh.append(en_time)
            place=member[9].tag
            building=member[9][0].tag
            room=member[9][1].tag
            rh.append(building)
            rh.append(room)
            csvwriter.writerow(rh)
            count=count+1


        reg_num= member.find('reg_num').text
        course.append(reg_num)
        subj=member.find('subj').text
        course.append(subj)
        crse=member.find('crse').text
        course.append(crse)
        sect=member.find('sect').text
        course.append(sect)
        title=member.find('title').text
        course.append(title)
        units=member.find('units').text
        course.append(units)
        instructor=member.find('instructor').text
        course.append(instructor)
        days=member.find('days').text
        course.append(days)
        st_time=member[8][0].text
        course.append(st_time)
        end_time=member[8][1].text
        course.append(end_time)
        #course.append(time_list)
        building=member[9][0].text
        course.append(building)
        room=member[9][1].text
        course.append(room)
       # course.append(place_list)
        csvwriter.writerow(course)
reed_file.close()