singles, multiples, zeroes = ([] for i in range(3))
dlength = df.shape[0]
for row in df.itertuples():
query = best_q(row)
hits, uri = ask_rkd(query)
if hits == 1:
singles.append([row.priref, row.name, hits, uri])
elif hits > 1:
multiples.append([row.priref, row.name, hits])
elif hits == 0:
query = bracket_q(row)
hits, uri = ask_rkd(query)
if hits == 1:
singles.append([row.priref, row.name, hits, uri])
elif hits > 1:
multiples.append([row.priref, row.name, hits])
elif hits == 0:
zeroes.append([row.priref, str(row.name)]) # PM: str!!
lists = singles, multiples, zeroes
listnames = ['singles','multiples','zeroes']
for s, l in zip(listnames, lists):
listfile = '{}_{}.csv'.format(input_fname, s)
writelist(list=l, fname=listfile)
outfile = fname + '_out' + ext
df.to_csv(outfile, sep='|', encoding='utf-8-sig')
Redo change in revision 4 by OP: “took out irrelevant line of code.”- doesn’t invalidate any answers
Sᴀᴍ Onᴇᴌᴀ ♦
- 29.6k
- 16
- 46
- 203
Post Closed as "Not suitable for this site" by Peilonrayz♦, Stephen Rauch, Toby Speight, Ludisposed, Vogel612