annotate scripts/comment_parser.py @ 1805:bcbc8bc12afe

Scripts: test if folder name (default or provided via command line) exists
author Brecht De Man <b.deman@qmul.ac.uk>
date Tue, 11 Aug 2015 10:15:17 +0200
parents 032bcca680a5
children 2ea78697aadf
rev   line source
b@1548 1 #!/usr/bin/python
b@1550 2 # -*- coding: utf-8 -*-
b@1548 3
b@1597 4 import xml.etree.ElementTree as ET
b@1597 5 import os
b@1597 6 import csv
b@1597 7
b@1805 8
b@1805 9 # COMMAND LINE ARGUMENTS
b@1805 10
b@1805 11 assert len(sys.argv)<3, "comment_parser takes at most 1 command line argument\n"+\
b@1805 12 "Use: python score_parser.py [rating_folder_location]"
b@1805 13
b@1805 14 # XML results files location
b@1805 15 if len(sys.argv) == 1:
b@1805 16 folder_name = "../saves" # Looks in 'saves/' folder from 'scripts/' folder
b@1805 17 print "Use: python comment_parser.py [XML_files_location]"
b@1805 18 print "Using default path: " + folder_name
b@1805 19 elif len(sys.argv) == 2:
b@1805 20 folder_name = sys.argv[1] # First command line argument is folder
b@1805 21
b@1805 22 # check if folder_name exists
b@1805 23 if not os.path.exists(folder_name):
b@1805 24 #the file is not there
b@1805 25 print "Folder '"+folder_name+"' does not exist."
b@1805 26 sys.exit() # terminate script execution
b@1805 27 elif not os.access(os.path.dirname(folder_name), os.W_OK):
b@1805 28 #the file does exist but write privileges are not given
b@1805 29 print "No write privileges in folder '"+folder_name+"'."
b@1805 30
b@1805 31
b@1805 32 # CODE
b@1553 33
b@1597 34 # get every XML file in folder
b@1553 35 for file in os.listdir(folder_name):
b@1597 36 if file.endswith(".xml"):
b@1553 37 tree = ET.parse(folder_name + '/' + file)
b@1597 38 root = tree.getroot()
b@1790 39
b@1598 40 # get list of all page names
b@1598 41 for audioholder in root.findall("./audioholder"): # iterate over pages
b@1598 42 page_name = audioholder.get('id') # get page name
b@1769 43
b@1769 44 if page_name is None: # ignore 'empty' audio_holders
b@1790 45 print "WARNING: " + file + " contains empty audio holder. (comment_parser.py)"
b@1769 46 break
b@1597 47
b@1598 48 # create folder [page_name] if not yet created
b@1553 49 if not os.path.exists(folder_name + "/" + page_name):
b@1553 50 os.makedirs(folder_name + "/" + page_name)
b@1597 51
b@1598 52 # for page [page_name], print comments related to fragment [id]
b@1553 53 for audioelement in audioholder.findall("./audioelement"):
b@1769 54 if audioelement is not None: # Check it exists
b@1769 55 audio_id = str(audioelement.get('id'))
b@1548 56
b@1553 57 csv_name = folder_name +'/' + page_name+'/'+page_name+'-comments-'+audio_id+'.csv'
b@1597 58
b@1548 59 # append (!) to file [page_name]/[page_name]-comments-[id].csv
b@1548 60 with open(csv_name, 'a') as csvfile:
b@1548 61 writer = csv.writer(csvfile,
b@1548 62 delimiter=',',
b@1548 63 dialect="excel",
b@1548 64 quoting=csv.QUOTE_ALL)
b@1553 65 commentstr = audioelement.find("./comment/response").text
b@1553 66
b@1769 67 if commentstr is None:
b@1553 68 commentstr = '';
b@1553 69
b@1553 70 # anonymous comments:
b@1553 71 #writer.writerow([commentstr.encode("utf-8")])
b@1553 72 # comments with (file) name:
b@1553 73 writer.writerow([file[:-4]] + [commentstr.encode("utf-8")])
b@1597 74
b@1548 75 #TODO Replace 'new line' in comment with something else?
b@1548 76
b@1548 77 # PRO TIP: Change from csv to txt by running this in bash:
b@1548 78 # $ cd folder_where_csvs_are/
b@1548 79 # $ for i in *.csv; do mv "$i" "${i/.csv}".txt; done