Hi, [python]I have belwo DataFrame: Input1: first_name pre_score mid_score post_score UAT_F3 4 25 5 UAT_F5 24 94 43 UAT_F2 31 57 23 UAT_F6 2 62 23 UAT_F8 3 70 51 Input2: first_name pre_score mid_score post_score UAT_F3 4 25 5 UAT_F5 24 94 43 UAT_F2 31 57 23 UAT_F6 2 62 23 UAT_F8 3 70 51 I want to loop through the rows of the input1&Input2 data and on each iteration, copy the current rows from Input2(first_name store &pre_score) and previous row =(i-1th row) from Input1, and do something.I use the below code, but I could not be able to access & store.
[python] newData=[] for index, row in Input1.iterrows(): print(index) tempData1=Input1.loc[[index-1,:]] tempData2=Input2.loc[[index,:]] temp=[tempData1,tempData2] newData.append(temp)
Desired Output: first_name pre_score mid_score post_score UAT_F5 4 25 5 UAT_F2 24 94 43 UAT_F6 31 57 23 UAT_F8 2 62 23 Kindly someone help, and many thanks in advance,[/python]