如何在不覆盖现有结果的情况下,向csv文件追加新信息?我试过了,但它覆盖了:
def save_jobs_to_excel(jobs_list, filename):
path=r'\Users\Alberto\OneDrive\Documents\Big Data\pirple\jobs'
jobs = pd.DataFrame(jobs_list)
if filename not in path:
jobs.to_csv(os.path.join(path,f'{filename}.csv'))
elif filename in path:
with open(filename,'a') as f:
f.write(jobs.to_csv(os.path.join(path,f'{filename}.csv')))
else:
pass
发布于 2021-02-12 23:59:17
我认为您是在双重打开文件,然后让jobs.to_csv()重写。可能是这样的:
def save_jobs_to_excel(jobs_list, filename):
path = r'\Users\Alberto\OneDrive\Documents\Big Data\pirple\jobs'
jobs = pd.DataFrame(jobs_list)
filepath = os.path.join(path,f'{filename}.csv')
if filepath.exists():
jobs.to_csv(filepath)
elif filename in path:
jobs.to_csv(open(filepath,'a'))
else:
pass
https://stackoverflow.com/questions/66180521
复制