how to merge two data frames with different dataframe
i have two data frames whose structure as per below. in need to fill value from one data frame to another on the basis of verification.

Data Frame1 =
id   a   b       c     c1      d      d1     e      e1    f
0  al    al1    -     1        K       10    _       _       File1
1  al   al2     -     1        _         _      _      _       File2
2  al   al3     ma  1        P        1      L      100   File3

dataframe2 =
Column      Column1       Column2      
c                  cal                    ca
c1                cal1                  ca1
d                  dal                   da
d1                dal1                 da1
e                  eal                    ea
e1                eal1                  ea1

Excepted output of dataframe 2 = it should be run on the basis of column F and create csv one by one with updated data like File1.csv and fill value only for file1 in csv 

Column      Column1       Column2      Value
c                  cal                    ca                 _
c1                cal1                  ca1              1
d                  dal                   da               K
d1                dal1                 da1             10
e                  eal                    ea               _
e1                eal1                  ea1             _

dataframe3 =

Column1   Column2    Column Value      Column1 Value

excepted output dataframe 3= for file1.csv , here file1.csv should updated in file1df3.csv with below output

Column1   Column2    Column Value      Column1 Value
cal                    ca                                            1
dal                   da                 k                          10


in dataframe 3, in we need to fill data from data frame 1 & data frame2. only those data should be filled in column1 column2 in which contains value in X1 column greater then 0.


