title: csv table stack to one column
body: <p>I'm new to python and new to this website.</p>
  <p>I'm trying to import a csv table to my jupyter Notebook. The Problem is, that the header (quarterly hours of each day) and the first column (date) actually belong to each other and should be kept together (see picture).</p>
  <p><img src="https://i.stack.imgur.com/L4kqW.png" alt="cutout of csv file" /></p>
  <p>As a result i would like to receive a Dataframe which contains the 3 columns: 'Date', 'Quarterly Hour ID', and the belonging 'Price'.</p>
  <pre><code>data = {'Date':  ['09.11.2020', '09.11.2020','09.11.2020','09.11.2020'],
      'Quarterly Hour ID': ['Hour 1 Q1', 'Hour 1 Q2','Hour 1 Q3', 'Hour 1 Q4'],
       'Price':[46,30,50,20]
      }
  </code></pre>
  <p><code>data = pd.DataFrame(data, columns = ['Date','Quarterly Hour ID','Price' ])</code></p>
  <p>I couldnt find any solution which does that.. I tried stack, which almost did the job but the Date was in a line with the prices.</p>
  <p>i hope somebody can help me with that. Im sure there must be a easy solution, i just dont know, where to look for it.</p>