This is regarding a simple code in python

I have two tables here

The first table contains marks ,sub1 and sub2.. and the second table contains IA,OA ,Others as rows based on the subjects.

I need to split the column Marks of the first table based on the second table into 3 new columns. The first column is the IA column, if its sub1 in the first table, it should split based on the sub1 column of second table example: IA=table1.marks*table2(IA)(sub1) i.e 100*0.50

Please tell me how to code for this