The last sentence in:
with open(events_path) as events_file: csv_reader = csv.reader(events_file, delimiter='\t') # use csv.reader to read file header = next(csv_reader) # read the titles in the first row for row in csv_reader: # save data events.append([int(row[4]), 0, int(row[3])]) # select a column and add to data if row[2] not in event_id.keys(): event_id[row[2]] = int(row[3])
should be:
event_id[int(row[3])] = str(row[2])
The original code leads to a reverse key-value relation in the [dict] event_id.
The last sentence in:
with open(events_path) as events_file: csv_reader = csv.reader(events_file, delimiter='\t') # use csv.reader to read file header = next(csv_reader) # read the titles in the first row for row in csv_reader: # save data events.append([int(row[4]), 0, int(row[3])]) # select a column and add to data if row[2] not in event_id.keys(): event_id[row[2]] = int(row[3])should be:
event_id[int(row[3])] = str(row[2])The original code leads to a reverse key-value relation in the [dict] event_id.