0

Question:

input variable

a = [{"job_id": 3535, "cvs_score":[[22,33,44], [54,76,64], [21,32,14], [22,45,42] ]}, { "job_id": 4355, "cvs_score":[[22,33,41], [55,66,77],[66,90,80 ], [1,2,3] ] } ]

Dataframe of first index dictionary in list

d = pd.DataFrame(a[0])
d

output

    job_id   cvs_score
0   3535    [22, 33, 44]
1   3535    [54, 76, 64]
2   3535    [21, 32, 14]
3   3535    [22, 45, 42]

my code to get desire output but fail

dti = []

for i in range(len(a)):
    #print("-----Data-Frame No :",i)
    dt = pd.DataFrame(a[i])    
    dt["score"] = dt["cvs_score"].str[1]
    dt["cvs_id"] = dt["cvs_score"].str[0]
    last = len(range(2))-1

    dt = dt[["score","cvs_id"]]
    dti.append(dt)
   
dti

Ouptut for above code

[   score  cvs_id
 0     33      22
 1     76      54
 2     32      21
 3     45      22,
    score  cvs_id
 0     33      22
 1     66      55
 2     90      66
 3      2       1]


but i want the below output


score   cvs_id
0   33  22
1   76  54
2   32  21
3   45  22
4   33  22
5   66  55
6   90  66
7   2   1

any help would be appriciated

0 Answers0