title: data frame and series in python to create excel column
body: <p>is there a way to create either data frames or series in python from an excel sheet that has multiple rows and columns such as </p>
  
  <p><a href="https://i.stack.imgur.com/hrnFc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hrnFc.png" alt="enter image description here"></a></p>
  
  <p>and expect the output to be all in one column</p>
  
  <p><a href="https://i.stack.imgur.com/uI2Qi.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uI2Qi.png" alt="enter image description here"></a>
  tried different codes for data frames and series non did what I expected and series are doing letter by letter in the code that I used </p>
  
  <pre><code>import numpy as np
  sr=pd.read_excel('eng.xlsx')
  s1=pd.Series(sr, expand=True)
  print s1  
  </code></pre>