How to create a Csv file from multiple dataframes in pandas with the name of the dataframe as a header of each column?

Question

Suppose I have a dataframe A, a dataframe B, a dataframe C,with the following data:

Dataframe A:

Name   |  ID | Birthda  | Age   | Hobbies| WebPage |  
 ------|-----|----------|-------|--------|---------|-- 
  ...  | ... | ...      | ...   | ...    | ...     |  
  ...  | ... | ...      | ..... | ....   | ....    |  
  ...  | ..  | ...      | ...   | ...    | .....   |

Dataframe B

 Name  | Experience | Places | Foods | Languages 
 ------|------------|--------|-------|----------- 
  ...  | .......    | ...... | ..... | .......   
  ...  | .....      | .....  | ..... | ......    
  ...  | ...        | ....   | ....  | .....     
       |            |        |       |

Dataframe C

Actor   | Movies | Places | Date | Animals | Music 
 -------|--------|--------|------|---------|------- 
  ...   | ....   | ....   | ...  | ....    | ....  
  ....  | ....   | ....   | .... | ....    | ....

So, I'm only interested in the headers( columns names), I need to crate a csv that contains the dataframe's names as the csv file header and the headers as elements of each csv columns. The csv file must be Like this:

DataframeA   | DataframeB | DataframeC  |  
 ------------|------------|------------|-- 
  Name       | Experience | Actor      |  
  ID         | Name       | Movies     |  
  Birthday   | Places     | Places     |  
  Age        | Foods      | Date       |  
  Hobbies    | Languages  | Animals    |  
  WebPage    |            | Music      |

rafaelc · Accepted Answer · 2018-09-21 02:03:51Z

1

Simply

pd.DataFrame({'DataFrame A': dfa.columns, 
              'DataFrame B': dfb.columns, 
              'DataFrame C': dfc.columns}).to_csv('file.csv')

if you have same length.

For different lengths,

pd.DataFrame([dfa.columns, 
              dfb.columns, 
              dfc.columns], index=['DataFrame A', 'DataFrame B', 'DataFrame C']).T.fillna('').to_csv('file.csv')

edited Sep 21, 2018 at 2:03

answered Sep 21, 2018 at 1:58

rafaelc

59.4k15 gold badges64 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a Csv file from multiple dataframes in pandas with the name of the dataframe as a header of each column?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related