def make_usernames_csv_for_turk(): print "Creating csv file of usernames for evaluation on Mechanical Turk..." twitter_site = short_text_websites.get_twitter_site() usernames_to_evaluate = crosssite_username_dataset_mgr.get_usernames_to_evaluate_mturk(twitter_site) print str(len(usernames_to_evaluate))+" unconfirmed usernames available:" print usernames_to_evaluate # dump to csv username_rows = [[username] for username in usernames_to_evaluate] csv_util.write_to_spreadsheet(__usernames_to_judge_csv_path__, username_rows, None)
def __update_confirmed_usernames__(site, confirmed_usernames, confirmed_value): usernames_csv_path = __get_usernames_csv_path__(site) headers = csv_util.query_csv_for_headers(usernames_csv_path) username_col_index = headers.index(COLUMN_USERNAME) confirmed_col_index = headers.index(__COLUMN_SAME_INDIVIDUAL__) updated_rows = [] rows = csv_util.query_csv_for_rows(usernames_csv_path, False) for row in rows: if row[username_col_index] in confirmed_usernames: row[confirmed_col_index] = confirmed_value updated_rows.append(row) csv_util.write_to_spreadsheet(usernames_csv_path, updated_rows)
def make_tweet_entities_csv_for_turk(): twitter_site = short_text_websites.get_twitter_site() entities_to_evaluate = entity_dataset_mgr.get_valid_ne_candidates(twitter_site) if entities_to_evaluate is None: print "No ambiguous entities + candidates in cache. Run run_all_dataset_generators "+\ "script and choose to first fetch and store more entities from short texts." return judged_row_plus_headers = csv_util.query_csv_for_rows(__entities_results_csv_path__, False) judged_row_num = 0 already_judged = [] # list of (entity id, candidate link) for judge_row in judged_row_plus_headers: try: if judged_row_num==0: # row 0 is header entity_id_col = judge_row.index('Input.entity_id') candidate_link_col = judge_row.index('Input.candidate_link') else: judged_tuple = (judge_row[entity_id_col], judge_row[candidate_link_col]) if not judged_tuple in already_judged: already_judged.append(judged_tuple) judged_row_num = judged_row_num+1 except: continue # just ignore a problematic row # Determine what entity+candidate tasks we actually want to write to a spreadsheet # and send to mturk since we don't have resources for unlimited mturk tasks tasks = {} # NamedEntity object -> candidate judgment tasks we actually want performed user_entities = defaultdict(list) # username -> [NamedEntity obj] done_shorttexts = [] # list of shorttext id random.shuffle(entities_to_evaluate) # so we get a random subset of a user's entities for ne_obj in entities_to_evaluate: # "40 nouns usually enough to establish statistically significant # differences between WSD algorithms" (Santamaria et al., 2010) username = ne_obj.username if len(user_entities[username]) > 50: continue # have enough entities for this user # limiting our dataset to one named entity per short text shorttext_id = ne_obj.shorttext_id if shorttext_id in done_shorttexts: continue # no need to create tasks for candidates we already have annotator judgments for entity_id = ne_obj.get_entity_id() candidate_URLs = ne_obj.get_candidate_wikiURLs() valid_candidate_tasks = [] for candidate_URL in candidate_URLs: if ((entity_id, candidate_URL) in already_judged): continue valid_candidate_tasks.append(candidate_URL) if len(valid_candidate_tasks)==0: continue # already have annotator judgments for all of this entity's candidates if len(candidate_URLs)+len(valid_candidate_tasks) < 2: # this would be a non-ambiguous entity, and we should never reach this # point because such entities should have been filtered out by now raise tasks[entity_id] = valid_candidate_tasks user_entities[username].append(ne_obj) done_shorttexts.append(shorttext_id) # put valid entities + candidates in the spreadsheet until reach our limit of tasks task_max = 1400 rows = [] headers = ['entity_id', 'short_text', 'ambiguous_entity', 'candidate_link'] rows.append(headers) for username in user_entities: # add users until reach our limit on the number of tasks we can afford, # but break at this point in the loop rather than in the inner loop to # ensure that we do have at least 50 entities per user (even if this # means we go over our task limit a little in order to reach that amount) if len(rows) > task_max: break # bypass users who haven't written the minimum number of valid entities # required to establish statistical significance between the algorithms if len(user_entities[username]) < 50: continue # should be 50 NamedEntity objects per user, and we'll make tasks for their candidates for ne_obj in user_entities[username]: entity_id = ne_obj.get_entity_id() # make sure the entity presented to a Turker looks the same as # it appears in the short text (ie with the same capitalization) original_shorttext = ne_obj.shorttext_str.decode('latin-1') surface_form = ne_obj.surface_form if not surface_form in original_shorttext: surface_form = __match_appearance__(surface_form, original_shorttext) # shuffle candidates so that they don't appear # in wikiminer's/dbpedia's ranking order and bias the turker candidate_URLs = tasks[entity_id] random.shuffle(candidate_URLs) choices = candidate_URLs[:] # copy (list slicing) for choice in choices: # make a separate row for each candidate link # rather than putting all links in a single cell row = [entity_id, original_shorttext, surface_form, choice] rows.append(row) if len(rows)%50==0: # write the rows every once in a while in case we reach an error print "Updating spreadsheet..."+str(len(rows)) csv_util.write_to_spreadsheet(__entities_to_judge_csv_path__, rows) # dump to csv csv_util.write_to_spreadsheet(__entities_to_judge_csv_path__, rows)