title: Text Merging for column header in Python for csv
body: <p>I want to create a csv file in which there are First 2 rows dedicated for heading and rest are columns for each second row header, is it programatically possible in Python ?</p>
  
  <p>I tried searching for keyword like <code>text merging</code> and <code>column header concatenation</code> in <a href="https://xlsxwriter.readthedocs.io/" rel="nofollow noreferrer"><code>xlsxwriter</code></a> official docs but nothing good came out. Had it been single header and single column thing I have already done it using python <a href="https://docs.python.org/2/library/csv.html" rel="nofollow noreferrer">CSV module</a>.</p>
  
  <p>Ex.</p>
  
  <pre><code>_________________________________________________________
  |____Big_Heading_1______|_____Big_Heading_2_______|_____|    
  |SH_1_|__SH_2_|__SH_3___|_SH_1_|__SH_2_|__SH_3____|_SH1_|
  |D1   |  D2   |  D4     | D5   |  D6   |   D7     | D8  |
  |D9   |  D10  |  D11    | D12  |  D13  |   D14    | D15 |
  </code></pre>
  
  <p>Notations : <code>SH = Small Heading, D  = Data</code></p>
  
  <p>Note: In place of third <code>Big Heading</code> there is nothing which for that particular there is no <code>Big Heading</code> ie. <code>Big Heading</code> equals to <code>Small Heading</code>.</p>
  
  <p>Thanks.</p>