擅长:python、mysql、java
<pre class="lang-py prettyprint-override"><code>df.to_csv('/Desktop/file.csv', mode='a')
</code></pre>
<p>.to\u csv的默认模式为写入。你必须把它改成附加。如果你想那样做的话。你知道吗</p>
<p>更好的解决方案是生成整个数据帧,然后将其保存到所需的文件中</p>
<pre class="lang-py prettyprint-override"><code>projects = ['project_a','project_b']
result = []
for project in projects:
issues = jira.search_issues('project= ' + project, maxResults=False, fields="worklog")
for value in issues:
for i in value.fields.worklog.worklogs:
value = value
timeSpentSeconds = i.timeSpentSeconds
timeSpent = i.timeSpent
updated = i.updated
started = i.started
author = i.author
dict_ = {'value': value,
'timeSpent': timeSpent,
'updated': updated,
'started': started,
'author': author}
result.append(dict_)
df = pd.DataFrame(result)
df.to_csv('/Desktop/file.csv')
</code></pre>