如何在DataFrame中存储jira.search_issues的结果

import pandas as pd
from jira import JIRA

options = {
    'server': 'https://your-jira-instance-url.com'
}
jira = JIRA(options, basic_auth=('username', 'password'))

issues = jira.search_issues('your-jql-query')

issue_data = []
for issue in issues:
    issue_data.append({
        'Issue Key': issue.key,
        'Summary': issue.fields.summary,
        'Assignee': issue.fields.assignee.displayName,
        'Status': issue.fields.status.name
        # 添加其他需要的字段
    })

df = pd.DataFrame(issue_data)

# 查看前几行数据
print(df.head())

# 根据条件筛选数据
filtered_df = df[df['Status'] == 'Open']

# 对数据进行排序
sorted_df = df.sort_values(by='Assignee')

# 对数据进行分组和聚合
grouped_df = df.groupby('Assignee').size().reset_index(name='Issue Count')

# 其他DataFrame操作...