擅长:python、mysql、java
<p><strong><em>[我会将此作为注释,但鉴于篇幅,我不能]</em></strong>我觉得没有足够的信息来帮助您解决问题,在您的位置上,我会添加这些信息以确保我理解代码失败的原因,同时继续此过程以完成它。这样,您就可以处理失败的文件,并在获得结果的同时更正脚本。在</p>
<pre><code>root = tk.Tk()
root.withdraw()
file_path = filedialog.askopenfilename()
# Load Spreadsheet data
f = open(file_path)
csv_f = csv.reader(f)
next(csv_f)
result_data = []
# Iterate
for row in csv_f:
try:
return_data = function.get_data(row[1], row[0])
if len(return_data) != 0:
# print(return_data)
result_data_loc = [row[1], row[0]]
result_data_loc.extend(return_data)
result_data.append(result_data_loc)
except AttributeError:
print(row[0])
print('\n\n')
print(row[1])
continue
if result_data is not None:
with open('resuls.csv', mode='w', newline='') as result_file:
csv_writer = csv.writer(result_file, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
for result in result_data:
# print(result)
csv_writer.writerow(result)
else:
print("No results found!")
</code></pre>