附加csv，不覆盖

Question

如何在不覆盖现有结果的情况下添加新信息的csv文件?我试过了，但是它覆盖了:

def save_jobs_to_excel(jobs_list, filename):
path=r'UsersAlbertoOneDriveDocumentsBig Datapirplejobs'
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

Answer 1

我认为你是双重打开你的文件，然后有jobs.to_csv()覆盖。比如:

def save_jobs_to_excel(jobs_list, filename):
path = r'UsersAlbertoOneDriveDocumentsBig Datapirplejobs'
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