I have two lists of protein sequences, I have to check every entry's existence in the two lists, say like
list A = [1,2,3,4]
list B= [3,4,5]
result = [
[1, true, false],
[2, true, false],
[3, true, true],
[4, true, true],
[5, false, true]
]
I did it this way. Not sure if it's the right way
def FindDifferences():
df1 = pd.read_csv('Gmax_v6_annotation_info.txt', names=['name'], usecols=[0], delimiter='\t')
df2 = pd.read_csv('Gmax_v9_annotation_info.txt', names=['name'], usecols=[2], delimiter='\t')
v6_set = set(df1['name'])
v9_set = set(df2['name'])
result = []
for val in v6_set:
if val in v9_set:
result.append([val, True, True])
else:
result.append([val, True, False])
for val in v9_set:
if val not in v6_set:
result.append([val, False, True])
result_df = pd.DataFrame(result, columns=['name', 'inv6', 'inv9'])
result_df.to_csv('result_csv.csv', index=False, header=False)
return
txt
files. \$\endgroup\$ – hpaulj Mar 16 '17 at 21:40v6_set
etc. \$\endgroup\$ – hpaulj Mar 17 '17 at 0:26