annotate scripts/generate_report.py @ 1071:e2dd3105a84c

Scripts: Generate PDF report on set of result XML files (using LaTeX)
author Brecht De Man <BrechtDeMan@users.noreply.github.com>
date Tue, 18 Aug 2015 23:56:05 +0200
parents
children 2c7dc66c102e
rev   line source
BrechtDeMan@1071 1 #!/usr/bin/python
BrechtDeMan@1071 2 # -*- coding: utf-8 -*-
BrechtDeMan@1071 3
BrechtDeMan@1071 4 import xml.etree.ElementTree as ET
BrechtDeMan@1071 5 import os # for getting files from directory
BrechtDeMan@1071 6 import operator # for sorting data with multiple keys
BrechtDeMan@1071 7 import sys # for accessing command line arguments
BrechtDeMan@1071 8 import subprocess # for calling pdflatex
BrechtDeMan@1071 9 import shlex # for calling pdflatex
BrechtDeMan@1071 10 import matplotlib.pyplot as plt # plots
BrechtDeMan@1071 11 import numpy as np # numbers
BrechtDeMan@1071 12
BrechtDeMan@1071 13 # Command line arguments
BrechtDeMan@1071 14 assert len(sys.argv)<3, "evaluation_stats takes at most 1 command line argument\n"+\
BrechtDeMan@1071 15 "Use: python evaluation_stats.py [results_folder]"
BrechtDeMan@1071 16
BrechtDeMan@1071 17 # XML results files location
BrechtDeMan@1071 18 if len(sys.argv) == 1:
BrechtDeMan@1071 19 folder_name = "../saves" # Looks in 'saves/' folder from 'scripts/' folder
BrechtDeMan@1071 20 print "Use: python evaluation_stats.py [results_folder]"
BrechtDeMan@1071 21 print "Using default path: " + folder_name
BrechtDeMan@1071 22 elif len(sys.argv) == 2:
BrechtDeMan@1071 23 folder_name = sys.argv[1] # First command line argument is folder
BrechtDeMan@1071 24
BrechtDeMan@1071 25 # Turn number of seconds (int) to '[minutes] min [seconds] s' (string)
BrechtDeMan@1071 26 def seconds2timestr(time_in_seconds):
BrechtDeMan@1071 27 time_in_minutes = int(time_in_seconds/60)
BrechtDeMan@1071 28 remaining_seconds = int(time_in_seconds%60)
BrechtDeMan@1071 29 return str(time_in_minutes) + " min " + str(remaining_seconds) + " s"
BrechtDeMan@1071 30
BrechtDeMan@1071 31 # stats initialisation
BrechtDeMan@1071 32 number_of_XML_files = 0
BrechtDeMan@1071 33 number_of_pages = 0
BrechtDeMan@1071 34 number_of_fragments = 0
BrechtDeMan@1071 35 total_empty_comments = 0
BrechtDeMan@1071 36 total_not_played = 0
BrechtDeMan@1071 37 total_not_moved = 0
BrechtDeMan@1071 38 time_per_page_accum = 0
BrechtDeMan@1071 39
BrechtDeMan@1071 40 # arrays initialisation
BrechtDeMan@1071 41 page_names = []
BrechtDeMan@1071 42 page_count = []
BrechtDeMan@1071 43 duration_page = [] # duration of experiment in function of page content
BrechtDeMan@1071 44 duration_order = [] # duration of experiment in function of page number
BrechtDeMan@1071 45 fragments_per_page = [] # number of fragments for corresponding page
BrechtDeMan@1071 46
BrechtDeMan@1071 47 # get username if available
BrechtDeMan@1071 48 for name in ('LOGNAME', 'USER', 'LNAME', 'USERNAME'):
BrechtDeMan@1071 49 user = os.environ.get(name)
BrechtDeMan@1071 50 if user:
BrechtDeMan@1071 51 break
BrechtDeMan@1071 52 else:
BrechtDeMan@1071 53 user = ''
BrechtDeMan@1071 54
BrechtDeMan@1071 55
BrechtDeMan@1071 56 # begin LaTeX document
BrechtDeMan@1071 57 header = r'''\documentclass[11pt, oneside]{article}
BrechtDeMan@1071 58 \usepackage{geometry}
BrechtDeMan@1071 59 \geometry{letterpaper}
BrechtDeMan@1071 60 \usepackage[parfill]{parskip}
BrechtDeMan@1071 61 \usepackage{graphicx}
BrechtDeMan@1071 62 \title{Report}
BrechtDeMan@1071 63 \author{'''+\
BrechtDeMan@1071 64 user+\
BrechtDeMan@1071 65 r'''}
BrechtDeMan@1071 66 \graphicspath{{'''+\
BrechtDeMan@1071 67 folder_name+\
BrechtDeMan@1071 68 r'''/}}
BrechtDeMan@1071 69 \begin{document}
BrechtDeMan@1071 70 \maketitle
BrechtDeMan@1071 71 \tableofcontents
BrechtDeMan@1071 72 '''
BrechtDeMan@1071 73
BrechtDeMan@1071 74 footer = '\end{document}'
BrechtDeMan@1071 75
BrechtDeMan@1071 76 body = ''
BrechtDeMan@1071 77
BrechtDeMan@1071 78 # generate images for later use
BrechtDeMan@1071 79 subprocess.call("timeline_view_movement.py", shell=True)
BrechtDeMan@1071 80
BrechtDeMan@1071 81 # get every XML file in folder
BrechtDeMan@1071 82 files_list = os.listdir(folder_name)
BrechtDeMan@1071 83 for file in files_list: # iterate over all files in files_list
BrechtDeMan@1071 84 if file.endswith(".xml"): # check if XML file
BrechtDeMan@1071 85 number_of_XML_files += 1
BrechtDeMan@1071 86 tree = ET.parse(folder_name + '/' + file)
BrechtDeMan@1071 87 root = tree.getroot()
BrechtDeMan@1071 88
BrechtDeMan@1071 89 # PRINT name as section
BrechtDeMan@1071 90 body+= '\section{'+file[:-4].capitalize()+'}\n' # make section header from name without extension
BrechtDeMan@1071 91
BrechtDeMan@1071 92 # reset for new subject
BrechtDeMan@1071 93 total_duration = 0
BrechtDeMan@1071 94 page_number = 0
BrechtDeMan@1071 95
BrechtDeMan@1071 96 individual_table = '' # table with stats for this individual test file
BrechtDeMan@1071 97
BrechtDeMan@1071 98 # get list of all page names
BrechtDeMan@1071 99 for audioholder in root.findall("./audioholder"): # iterate over pages
BrechtDeMan@1071 100 page_name = audioholder.get('id') # get page name
BrechtDeMan@1071 101
BrechtDeMan@1071 102 if page_name is None: # ignore 'empty' audio_holders
BrechtDeMan@1071 103 print "WARNING: " + file + " contains empty audio holder. (evaluation_stats.py)"
BrechtDeMan@1071 104 break # move on to next
BrechtDeMan@1071 105
BrechtDeMan@1071 106 number_of_comments = 0 # for this page
BrechtDeMan@1071 107 number_of_missing_comments = 0 # for this page
BrechtDeMan@1071 108 not_played = 0 # for this page
BrechtDeMan@1071 109 not_moved = 0 # for this page
BrechtDeMan@1071 110
BrechtDeMan@1071 111 # 'testTime' keeps total duration: subtract time so far for duration of this audioholder
BrechtDeMan@1071 112 duration = float(audioholder.find("./metric/metricresult[@id='testTime']").text) - total_duration
BrechtDeMan@1071 113
BrechtDeMan@1071 114 # total duration of test
BrechtDeMan@1071 115 total_duration += duration
BrechtDeMan@1071 116
BrechtDeMan@1071 117 # number of audio elements
BrechtDeMan@1071 118 audioelements = audioholder.findall("./audioelement") # get audioelements
BrechtDeMan@1071 119 number_of_fragments += len(audioelements) # add length of this list to total
BrechtDeMan@1071 120
BrechtDeMan@1071 121 # number of comments (interesting if comments not mandatory)
BrechtDeMan@1071 122 for audioelement in audioelements:
BrechtDeMan@1071 123 response = audioelement.find("./comment/response")
BrechtDeMan@1071 124 was_played = audioelement.find("./metric/metricresult/[@name='elementFlagListenedTo']")
BrechtDeMan@1071 125 was_moved = audioelement.find("./metric/metricresult/[@name='elementFlagMoved']")
BrechtDeMan@1071 126 if response.text is not None and len(response.text) > 1:
BrechtDeMan@1071 127 number_of_comments += 1
BrechtDeMan@1071 128 else:
BrechtDeMan@1071 129 number_of_missing_comments += 1
BrechtDeMan@1071 130 if was_played is not None and was_played.text == 'false':
BrechtDeMan@1071 131 not_played += 1
BrechtDeMan@1071 132 if was_moved is not None and was_moved.text == 'false':
BrechtDeMan@1071 133 not_moved += 1
BrechtDeMan@1071 134
BrechtDeMan@1071 135 # update global counters
BrechtDeMan@1071 136 total_empty_comments += number_of_missing_comments
BrechtDeMan@1071 137 total_not_played += not_played
BrechtDeMan@1071 138 total_not_moved += not_moved
BrechtDeMan@1071 139
BrechtDeMan@1071 140 # PRINT alerts when elements not played or markers not moved
BrechtDeMan@1071 141 # number of audio elements not played
BrechtDeMan@1071 142 if not_played > 1:
BrechtDeMan@1071 143 body += '\\emph{\\textbf{ATTENTION: '+str(not_played)+' fragments were not listened to in '+page_name+'!}} \\\\ \n'
BrechtDeMan@1071 144 if not_played == 1:
BrechtDeMan@1071 145 body += '\\emph{\\textbf{ATTENTION: one fragment was not listened to in '+page_name+'!}} \\\\ \n '
BrechtDeMan@1071 146
BrechtDeMan@1071 147 # number of audio element markers not moved
BrechtDeMan@1071 148 if not_moved > 1:
BrechtDeMan@1071 149 body += '\\emph{\\textbf{ATTENTION: '+str(not_moved)+' markers were not moved in '+page_name+'!}} \\\\ \n'
BrechtDeMan@1071 150 if not_moved == 1:
BrechtDeMan@1071 151 body += '\\emph{\\textbf{ATTENTION: one marker was not moved in '+page_name+'!}} \\\\ \n'
BrechtDeMan@1071 152
BrechtDeMan@1071 153 #TODO which one not moved/listened to?
BrechtDeMan@1071 154
BrechtDeMan@1071 155 # PRINT song-specific statistic
BrechtDeMan@1071 156 individual_table += page_name+'&'+\
BrechtDeMan@1071 157 str(number_of_comments) + '/' +\
BrechtDeMan@1071 158 str(number_of_comments+number_of_missing_comments)+'&'+\
BrechtDeMan@1071 159 seconds2timestr(duration)+'\\\\'
BrechtDeMan@1071 160
BrechtDeMan@1071 161 # get timeline for this audioholder
BrechtDeMan@1071 162 img_path = 'timelines_movement/'+file[:-4]+'-'+page_name+'.pdf'
BrechtDeMan@1071 163
BrechtDeMan@1071 164 # check if available
BrechtDeMan@1071 165 if os.path.isfile(folder_name+'/'+img_path):
BrechtDeMan@1071 166 # SHOW timeline image
BrechtDeMan@1071 167 body += r'''\begin{figure}[htbp]
BrechtDeMan@1071 168 \begin{center}
BrechtDeMan@1071 169 \includegraphics[width=\textwidth]{'''+\
BrechtDeMan@1071 170 folder_name+'/'+img_path+\
BrechtDeMan@1071 171 r'''}
BrechtDeMan@1071 172 \caption{Timeline of '''+\
BrechtDeMan@1071 173 page_name+' by '+ file[:-4].capitalize() +\
BrechtDeMan@1071 174 r'''.}
BrechtDeMan@1071 175 \end{center}
BrechtDeMan@1071 176 \end{figure}
BrechtDeMan@1071 177 '''
BrechtDeMan@1071 178
BrechtDeMan@1071 179 # keep track of duration in function of page index
BrechtDeMan@1071 180 if len(duration_order)>page_number:
BrechtDeMan@1071 181 duration_order[page_number].append(duration)
BrechtDeMan@1071 182 else:
BrechtDeMan@1071 183 duration_order.append([duration])
BrechtDeMan@1071 184
BrechtDeMan@1071 185 # keep list of audioholder ids and count how many times each audioholder id
BrechtDeMan@1071 186 # was tested, how long it took, and how many fragments there were (if number of
BrechtDeMan@1071 187 # fragments is different, store as different audioholder id)
BrechtDeMan@1071 188 if page_name in page_names:
BrechtDeMan@1071 189 page_index = page_names.index(page_name) # get index
BrechtDeMan@1071 190 # check if number of audioelements the same
BrechtDeMan@1071 191 if len(audioelements) == fragments_per_page[page_index]:
BrechtDeMan@1071 192 page_count[page_index] += 1
BrechtDeMan@1071 193 duration_page[page_index].append(duration)
BrechtDeMan@1071 194 else: # make new entry
BrechtDeMan@1071 195 alt_page_name = page_name+"("+str(len(audioelements))+")"
BrechtDeMan@1071 196 if alt_page_name in page_names: # if already there
BrechtDeMan@1071 197 alt_page_index = page_names.index(alt_page_name) # get index
BrechtDeMan@1071 198 page_count[alt_page_index] += 1
BrechtDeMan@1071 199 duration_page[alt_page_index].append(duration)
BrechtDeMan@1071 200 else:
BrechtDeMan@1071 201 page_names.append(alt_page_name)
BrechtDeMan@1071 202 page_count.append(1)
BrechtDeMan@1071 203 duration_page.append([duration])
BrechtDeMan@1071 204 fragments_per_page.append(len(audioelements))
BrechtDeMan@1071 205 else:
BrechtDeMan@1071 206 page_names.append(page_name)
BrechtDeMan@1071 207 page_count.append(1)
BrechtDeMan@1071 208 duration_page.append([duration])
BrechtDeMan@1071 209 fragments_per_page.append(len(audioelements))
BrechtDeMan@1071 210
BrechtDeMan@1071 211 # bookkeeping
BrechtDeMan@1071 212 page_number += 1 # increase page count for this specific test
BrechtDeMan@1071 213 number_of_pages += 1 # increase total number of pages
BrechtDeMan@1071 214 time_per_page_accum += duration # total duration (for average time spent per page)
BrechtDeMan@1071 215
BrechtDeMan@1071 216 # PRINT table with statistics about this test
BrechtDeMan@1071 217 body += r'''\begin{tabular}{|p{3.5cm}|c|p{2.5cm}|}
BrechtDeMan@1071 218 \hline
BrechtDeMan@1071 219 \textbf{Song name} & \textbf{Comments} & \textbf{Duration} \\ \hline '''+\
BrechtDeMan@1071 220 individual_table+\
BrechtDeMan@1071 221 r'''\hline
BrechtDeMan@1071 222 \textbf{TOTAL} & & \textbf{'''+\
BrechtDeMan@1071 223 seconds2timestr(total_duration)+\
BrechtDeMan@1071 224 r'''}\\
BrechtDeMan@1071 225 \hline
BrechtDeMan@1071 226 \end{tabular}'''
BrechtDeMan@1071 227
BrechtDeMan@1071 228 # join to footer
BrechtDeMan@1071 229 footer = body + footer
BrechtDeMan@1071 230
BrechtDeMan@1071 231 # empty body again
BrechtDeMan@1071 232 body = ''
BrechtDeMan@1071 233
BrechtDeMan@1071 234 # PRINT summary of everything (at start)
BrechtDeMan@1071 235 body += '\section{Summary}\n'
BrechtDeMan@1071 236
BrechtDeMan@1071 237 # PRINT table with statistics
BrechtDeMan@1071 238 body += '\\begin{tabular}{ll}'
BrechtDeMan@1071 239 body += r'Number of XML files: &' + str(number_of_XML_files) + r'\\'
BrechtDeMan@1071 240 body += r'Number of pages: &' + str(number_of_pages) + r'\\'
BrechtDeMan@1071 241 body += r'Number of fragments: &' + str(number_of_fragments) + r'\\'
BrechtDeMan@1071 242 body += r'Number of empty comments: &' + str(total_empty_comments) +\
BrechtDeMan@1071 243 " (" + str(round(100.0*total_empty_comments/number_of_fragments,2)) + r"\%)\\"
BrechtDeMan@1071 244 body += r'Number of unplayed fragments: &' + str(total_not_played) +\
BrechtDeMan@1071 245 " (" + str(round(100.0*total_not_played/number_of_fragments,2)) + r"\%)\\"
BrechtDeMan@1071 246 body += r'Number of unmoved markers: &' + str(total_not_moved) +\
BrechtDeMan@1071 247 " (" + str(round(100.0*total_not_moved/number_of_fragments,2)) + r"\%)\\"
BrechtDeMan@1071 248 body += r'Average time per page: &' + seconds2timestr(time_per_page_accum/number_of_pages) + r"\\"
BrechtDeMan@1071 249
BrechtDeMan@1071 250
BrechtDeMan@1071 251 # Pages and number of times tested
BrechtDeMan@1071 252 page_count_strings = list(str(x) for x in page_count)
BrechtDeMan@1071 253 count_list = page_names + page_count_strings
BrechtDeMan@1071 254 count_list[::2] = page_names
BrechtDeMan@1071 255 count_list[1::2] = page_count_strings
BrechtDeMan@1071 256 #body += r'Pages tested: &' + str(count_list) + r"\\"
BrechtDeMan@1071 257
BrechtDeMan@1071 258 body += '\\end{tabular} \\vspace{1.5cm} \\\\ \n'
BrechtDeMan@1071 259
BrechtDeMan@1071 260 # Average duration for first, second, ... page
BrechtDeMan@1071 261 body += " \\vspace{.5cm} Average duration per page (see also Figure \\ref{fig:avgtimeperpage}): \\\\ \n"
BrechtDeMan@1071 262 body += r'''\begin{tabular}{lll}
BrechtDeMan@1071 263 \textbf{Page} & \textbf{Duration} & \textbf{\# subjects}\\
BrechtDeMan@1071 264 '''
BrechtDeMan@1071 265 tpp_averages = [] # store average time per page
BrechtDeMan@1071 266 for page_number in range(len(duration_order)):
BrechtDeMan@1071 267 body += str(page_number+1) + "&" +\
BrechtDeMan@1071 268 seconds2timestr(sum(duration_order[page_number])/len(duration_order[page_number])) +\
BrechtDeMan@1071 269 "&"+str(len(duration_order[page_number]))+r"\\"
BrechtDeMan@1071 270 tpp_averages.append(sum(duration_order[page_number])/len(duration_order[page_number]))
BrechtDeMan@1071 271
BrechtDeMan@1071 272 body += '\\end{tabular} \\vspace{1.5cm} \\\\ \n'
BrechtDeMan@1071 273
BrechtDeMan@1071 274 # SHOW bar plot of average time per page
BrechtDeMan@1071 275 plt.bar(range(1,len(duration_order)+1), tpp_averages)
BrechtDeMan@1071 276 plt.xlabel('Page')
BrechtDeMan@1071 277 plt.xlim(.8, len(duration_order)+1)
BrechtDeMan@1071 278 plt.xticks(np.arange(1,len(duration_order)+1)+.4, range(1,len(duration_order)+1))
BrechtDeMan@1071 279 plt.ylabel('Time [seconds]')
BrechtDeMan@1071 280 plt.savefig(folder_name+"/time_per_page.pdf", bbox_inches='tight')
BrechtDeMan@1071 281 plt.close()
BrechtDeMan@1071 282 body += r'''\begin{figure}[htbp]
BrechtDeMan@1071 283 \begin{center}
BrechtDeMan@1071 284 \includegraphics[width=\textwidth]{'''+\
BrechtDeMan@1071 285 folder_name+"/time_per_page.pdf"+\
BrechtDeMan@1071 286 r'''}
BrechtDeMan@1071 287 \caption{Average time spent per audioholder page.}
BrechtDeMan@1071 288 \label{fig:avgtimeperpage}
BrechtDeMan@1071 289 \end{center}
BrechtDeMan@1071 290 \end{figure}
BrechtDeMan@1071 291 '''
BrechtDeMan@1071 292 #TODO add error bars
BrechtDeMan@1071 293
BrechtDeMan@1071 294
BrechtDeMan@1071 295 # Sort pages by number of audioelements, then by duration
BrechtDeMan@1071 296
BrechtDeMan@1071 297 # average duration and number of subjects per page
BrechtDeMan@1071 298 average_duration_page = []
BrechtDeMan@1071 299 number_of_subjects_page = []
BrechtDeMan@1071 300 for line in duration_page:
BrechtDeMan@1071 301 number_of_subjects_page.append(len(line))
BrechtDeMan@1071 302 average_duration_page.append(sum(line)/len(line))
BrechtDeMan@1071 303
BrechtDeMan@1071 304 # combine and sort in function of number of audioelements and duration
BrechtDeMan@1071 305 combined_list = [page_names, average_duration_page, fragments_per_page, number_of_subjects_page]
BrechtDeMan@1071 306 combined_list = sorted(zip(*combined_list), key=operator.itemgetter(1, 2)) # sort
BrechtDeMan@1071 307
BrechtDeMan@1071 308 # Show average duration for all songs
BrechtDeMan@1071 309 body += r'''\vspace{.5cm} Average duration per audioholder: \\
BrechtDeMan@1071 310 \begin{tabular}{llll}
BrechtDeMan@1071 311 \textbf{Audioholder} & \textbf{Duration} & \textbf{\# subjects} & \textbf{\# fragments} \\
BrechtDeMan@1071 312 '''
BrechtDeMan@1071 313 for page_index in range(len(page_names)):
BrechtDeMan@1071 314 body += combined_list[page_index][0] + "&" +\
BrechtDeMan@1071 315 seconds2timestr(combined_list[page_index][1]) + "&" +\
BrechtDeMan@1071 316 str(combined_list[page_index][3]) + "&" +\
BrechtDeMan@1071 317 str(combined_list[page_index][2]) + r"\\"
BrechtDeMan@1071 318 body += '\\end{tabular}\n'
BrechtDeMan@1071 319
BrechtDeMan@1071 320 #TODO
BrechtDeMan@1071 321 # time per page in function of number of fragments (plot)
BrechtDeMan@1071 322 # time per participant in function of number of pages
BrechtDeMan@1071 323 # plot total time for each participant
BrechtDeMan@1071 324 # plot total time
BrechtDeMan@1071 325 # show 'count' per page (in order)
BrechtDeMan@1071 326
BrechtDeMan@1071 327 # clear up page_index <> page_count <> page_number confusion
BrechtDeMan@1071 328
BrechtDeMan@1071 329
BrechtDeMan@1071 330 texfile = header+body+footer
BrechtDeMan@1071 331
BrechtDeMan@1071 332 # write TeX file
BrechtDeMan@1071 333 with open(folder_name + '/' + 'test.tex','w') as f:
BrechtDeMan@1071 334 f.write(texfile)
BrechtDeMan@1071 335 proc=subprocess.Popen(shlex.split('pdflatex -output-directory='+folder_name+' '+ folder_name + '/test.tex'))
BrechtDeMan@1071 336 proc.communicate()
BrechtDeMan@1071 337 # run again
BrechtDeMan@1071 338 proc=subprocess.Popen(shlex.split('pdflatex -output-directory='+folder_name+' '+ folder_name + '/test.tex'))
BrechtDeMan@1071 339 proc.communicate()
BrechtDeMan@1071 340
BrechtDeMan@1071 341 #TODO remove auxiliary LaTeX files