df 1:

0         AREA
1       DETAIL
2             
3       ACTION
4     COMMENTS
5        MEDIA

df 2:

                     0  ... 6
0  BacknYard/Exterior  ...  
1          Dining Room  ...  
2                Entry  ...  
3                Entry  ...  
4     Garage/Parkinng  ...  
5     Garage/Parkinng  ... 

code:

df1 = table1[0].df
header = df1.iloc[0]
headers = header.values.tolist()
df2 = table2[0].df
df2.to_csv('my_csv.csv', columns=headers)

Required solution:

    AREA                DETAIL                ACTION     COMMENTS     MEDIA
    
   BacknYard/Exterior  ...  
          Dining Room  ...  
                Entry  ...  
                Entry  ...  
     Garage/Parkinng  ...  
     Garage/Parkinng  ... 

Is there any solution to get df1 as the header by combining df1 and df2. df2.to_csv(‘my_csv.csv’, columns=headers) is showing error KeyError: “None of [Index([‘uf279 AREA’, ‘uf276 DETAIL’, ‘uf2c8’, ‘uf7d9 ACTION’, ‘uf27a COMMENTS’, ‘uf87c MEDIA’], dtype=’object’)] are in the [columns]”. Is there any solution