将输出转换为Pandas数据

Question

我有JIRA的以下数据。我正试着把它变成一只熊猫。

这是我的代码：

from jira import JIRA

jiraOptions = {'server': 'https://**********.atlassian.net'}

jira = JIRA(options=jiraOptions, basic_auth=(
    '*******@gmail.com', '******************'))

project = 'project = GDI'

lista = []

for issue in jira.search_issues(jql_str=project):
        print('{} | {} | {} | {} {} | {} | {} | {} | {} | {} |'.format(issue.key,
                                                                    issue.fields.project.name,
                                                                    issue.fields.summary,
                                                                    issue.fields.issuetype,
                                                                    issue.fields.status,
                                                                    issue.fields.priority,
                                                                    issue.fields.reporter.displayName,
                                                                    issue.fields.created,
                                                                    issue.fields.assignee,                                     
                                                                    issue.fields.description,))

预期输出:

issue key:      Project name:       summary:               issue type:     assignee:
GDI-6           PROJECTBLABLA       Summaryblabla          epictodo        Nova
GDI-5           PROJECTBLABLA       Summaryblabla          epictodo        Nova
GDI-4           PROJECTBLABLA       Summaryblabla          epictodo        Nova
GDI-3           PROJECTBLABLA       Summaryblabla          epictodo        Nova

有什么聪明的办法吗？我真的被困住了。我只知道我需要一份清单，对吧？所以我需要把每一个细节都放到相应的列表中，而不是打印出来，然后我就开始研究熊猫了。

提前谢谢你，

Nova

Answer 1

下面是我的代码的输出：

DI-6 | Data Integration | Create Jenkins Job to automatise the collect of data  | Task To Do | Medium | Nova | 2022-07-04T12:10:03.155+0000 | Nova | Create Jenkins Job to automatise the collect of data daily |
DI-5 | Data Integration | Create SQL Tables | Task Done | Medium | Nova | 2022-07-04T11:56:21.925+0000 | Nova | Table tickets contain The fields of Jira Ticket (like Ticket number ,Summary , Description , Sprint ,Status ,�.)

Table Ticket_History : This table contain Ticket number, user ,Date & time , Field name ,Original Value , new value  |
DI-4 | Data Integration | Create Script python | Task In Progress | Medium | Nova | 2022-07-04T11:52:57.416+0000 | Nova | * Find the API that helps you to collect and extract the data from Jira 
* Insert the collected data in SQL data base  |
DI-2 | Data Integration | Install Environnement  | Task Done | Medium | Nova | 2022-07-04T11:49:08.332+0000 | Nova | Install Environnement |
DI-1 | Data Integration | Jira Data Integration Into SQL Data Base | Epic To Do | Medium | Nova | 2022-07-04T11:47:46.636+0000 | Nova | Jira Data Integration Into SQL Data Base |

使用后：

lista = []
for issue in jira.search_issues(jql_str=project):
   lista.append([issue.key, issue.fields.project.name, issue.fields.summary ...])

这是输出：

[['DI-6', 'Data Integration', 'Create Jenkins Job to automatise the collect of data ', <JIRA IssueType: name='Task', id='10002'>, <JIRA Status: name='To Do', id='10000'>, <JIRA Priority: name='Medium', id='3'>, 'Nova', '2022-07-04T12:10:03.155+0000', <JIRA User: displayName='Nova', accountId='62c1b708ce5a604dbfb34700'>, 'Create Jenkins Job to automatise the collect of data daily'], ['DI-5', 'Data Integration', 'Create SQL Tables', <JIRA IssueType: name='Task', id='10002'>, <JIRA Status: name='Done', id='10002'>, <JIRA Priority: name='Medium', id='3'>, 'Nova', '2022-07-04T11:56:21.925+0000', <JIRA User: displayName='Nova', accountId='62c1b708ce5a604dbfb34700'>, 'Table tickets contain The fields of Jira Ticket (like Ticket number ,Summary , Description , Sprint ,Status ,�.)\n\nTable Ticket_History : This table contain Ticket number, user ,Date & time , Field name ,Original Value , new value '], ['DI-4', 'Data Integration', 'Create Script python', <JIRA IssueType: name='Task', id='10002'>, <JIRA Status: name='In Progress', id='10001'>, <JIRA Priority: name='Medium', id='3'>, 'Nova', '2022-07-04T11:52:57.416+0000', <JIRA User: displayName='Nova', accountId='62c1b708ce5a604dbfb34700'>, '* Find the API that helps you to collect and extract the data from Jira \n* Insert the collected data in SQL data base '], ['DI-2', 'Data Integration', 'Install Environnement ', <JIRA IssueType: name='Task', id='10002'>, <JIRA Status: name='Done', id='10002'>, <JIRA Priority: name='Medium', id='3'>, 'Nova', '2022-07-04T11:49:08.332+0000', <JIRA User: displayName='Nova', accountId='62c1b708ce5a604dbfb34700'>, 'Install Environnement'], ['DI-1', 'Data Integration', 'Jira Data Integration Into SQL Data Base', <JIRA IssueType: name='Epic', id='10004'>, <JIRA Status: name='To Do', id='10000'>, <JIRA Priority: name='Medium', id='3'>, 'Nova', '2022-07-04T11:47:46.636+0000', <JIRA User: displayName='Nova', accountId='62c1b708ce5a604dbfb34700'>, 'Jira Data Integration Into SQL Data Base']]

为什么要添加

Answer 2

几个小时后..。我发现我要做的就是在字段之后添加.name，如下所示：

issue.fields.summary,
issue.fields.issuetype.name,
issue.fields.status.name,
issue.fields.priority.name,
issue.fields.reporter.displayName,
issue.fields.created,
issue.fields.assignee.displayName,                                     

感谢您努力提供帮助.

Answer 3

我不太确定这是否能解决你的问题：

lista = []
for issue in jira.search_issues(jql_str=project):
   lista.append([issue.key, issue.fields.project.name, issue.fields.summary ...])

然后你就可以用这个做数据了。

df = pd.DataFrame(lista)
df.columns = ['issue key:', 'Project name:', 'summary:' ...]