comparison scripts/score_parser.py @ 885:ba83143187d6

Scripts: score_parser.py: ignore empty rows (subject with no ratings for current song)

 
 # XML results files location (modify as needed):
 folder_name = "../saves"    # Looks in 'saves/' folder from 'scripts/' folder
 
 # get every XML file in folder
-for file in os.listdir(folder_name): # You have to put this in folder where output XML files are.
+for file in os.listdir(folder_name):
     if file.endswith(".xml"):
         tree = ET.parse(folder_name + '/' + file)
         root = tree.getroot()
         #print "DEBUG Reading " + file + "..."
 

                 # Which of the fragmentes are in fragmentnamelist but not in headerrow?
                 newfragments = list(set(fragmentnamelist)-set(headerrow))
                 newfragments = sorted(newfragments) # new fragments in alphabetical order
                 # If not empty, read file and rewrite adding extra columns
                 if newfragments: # if not empty
-                    print '        '+page_name+','+file_name+','+subject_id
                     #print "DEBUG New fragments found: " + str(newfragments)
                     with open('temp.csv', 'w') as writefile:
                         filewriter = csv.writer(writefile, delimiter=',')
                         filewriter.writerow(headerrow + newfragments) # write new header
                         #print "        "+str(headerrow + newfragments) # DEBUG

                     ratingrow.append(elementvalue.text) # add to rating row
                 else: # if this subject has not rated this fragment
                     ratingrow.append('') # append empty cell
 
             # write row: [subject ID, rating fragment ID 1, ..., rating fragment ID M]
-            filewriter.writerow(ratingrow)
+            if any(ratingrow[1:]): # append to file if row non-empty (except subject name)
+                filewriter.writerow(ratingrow)