title: Read title of CSV's from a folder path , and write the header rows to another csv with structure as Table Name and Column Names
body: <p>Issue: I have two CSV files names File1.CSV and File2.CSV in one folder where the structure of the csv is like</p>
  <pre><code>File1.csv
  Column1 Column2
  Data.    Data.
  
  File2.csv
  Column3 Column4
  </code></pre>
  <p>The final file .csv structure should look like this:</p>
  <pre><code>Table Name.    Column Names
  File1.           Column1
  File1.           Column2
  File2            Column3
  File2            Column4
  </code></pre>
  <p>I have written something like this</p>
  <pre><code>all_files = glob.glob(path + &quot;/*.csv&quot;)
  
  list1 = []
  
  for filename in all_files:
      df = pd.read_csv(filename, index_col=None, header=0)
      list1.append(df)
  
  frame = pd.concat(list1, axis=0, ignore_index=True)
  
  print(frame)
  </code></pre>
  <p>Kindly suggest I want to write this into a new csv file.</p>