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