title: ValueError: Length mismatch: Expected axis has 13 elements, new values have 2 elements
body: <p>I have looked at the <a href="http://pandas.pydata.org/pandas-docs/stable/advanced.html" rel="nofollow noreferrer">documentation</a> about the hierarchical indexing in Pandas. I tried testing it with extracted data from an URL, but I am, clearly, missing something:</p>
  
  <pre><code># creating an array of rows
  rows = []
  
  # making a for loop to append every player from every 'td' instance
  for r in container.select('tr'):
      rows.append([col.text.strip() for col in r.select('td')])
  
  zipped = zip(*rows)
  
  # first row needs to have the header of the table on the website
  csvfile = pd.DataFrame(zipped)
  csvfile.columns = rows[0]
  </code></pre>
  
  <p>I thought about creating an empty dataframe of 13 columns, but I am not sure whether that will solve my problem</p>
  
  <p>What I am trying to do is to create 13 columns, where each column has some data, which I have already extracted.</p>
  
  <p>EDIT:</p>
  
  <p>The extracted data looks like:
  <a href="https://i.stack.imgur.com/1paff.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1paff.png" alt="enter image description here"></a></p>
  
  <p>What I want, more specifically, is to put the left side (Column A) as a row instead, and put the right side under each.</p>