Feb-07-2021, 03:52 PM
(This post was last modified: Feb-08-2021, 01:45 AM by Larz60+.
Edit Reason: output tags work for input as well
)
Given:
you have two columns ID , Status
ID 1 has the following Status value
ID PASS FAIL ABORTED
---------------------------
1 1 0 0
2 2 3 4
'statusCount' is the value used to fill out pass,fail ad aborted counts
and
'name' key became column name
Note: checked type of 'status' calumn - it is series
thanks in advance
you have two columns ID , Status
ID 1 has the following Status value
Output:[
{
'id': 0,
'name': 'PASS',
'description': 'The test run has passed',
'isFinal': True,
'color': '#95C160',
'isNative': True,
'statusCount': 1,
'statusPercent': 100.0
},
{
'id': 3,
'name': 'FAIL',
'description': 'The test run has failed',
'isFinal': True,
'color': '#D45D52',
'isNative': True,
'statusCount': 0,
'statusPercent': 0.0
},
{
'id': 4,
'name': 'ABORTED',
'description': 'The test run was aborted',
'isFinal': True,
'color': '#111111',
'isNative': True,
'statusCount': 0,
'statusPercent': 0.0
}
similarily
ID 2 has the following status value:
[
{
'id': 0,
'name': 'PASS',
'description': 'The test run has passed',
'isFinal': True,
'color': '#95C160',
'isNative': True,
'statusCount': 2,
'statusPercent': 100.0
},
{
'id': 3,
'name': 'FAIL',
'description': 'The test run has failed',
'isFinal': True,
'color': '#D45D52',
'isNative': True,
'statusCount': 3,
'statusPercent': 0.0
},
{
'id': 4,
'name': 'ABORTED',
'description': 'The test run was aborted',
'isFinal': True,
'color': '#111111',
'isNative': True,
'statusCount': 4,
'statusPercent': 0.0
}
whats needed is:ID PASS FAIL ABORTED
---------------------------
1 1 0 0
2 2 3 4
'statusCount' is the value used to fill out pass,fail ad aborted counts
and
'name' key became column name
Note: checked type of 'status' calumn - it is series
thanks in advance