title: Combining two series into a dataframe row wise
body: <p>I'm trying to merge two series into one single row in a new dataframe and then add more rows into it. For example, I have series as below:</p>
  
  <pre><code>s1
  
  var1       10
  var2        9
  var3        2
  
  s2
  var4        1
  var5       81
  var6       13
  </code></pre>
  
  <p>I want to make them into a dataframe like this:</p>
  
  <pre><code>    df
      var1  var2  var3  var4  var5  var6
   0    10     9     2     1    81    13
  </code></pre>
  
  <p>The closest solution I can find is this: <a href="https://stackoverflow.com/questions/36488270/how-to-append-two-series-into-a-dataframe-row-wise">How to append two series into a dataframe Row wise</a></p>
  
  <p>However if we do this we'll get something like this:</p>
  
  <pre><code>result = pd.concat([s1, s2], axis=1).T
  print(result)
  
      result
  
      var1  var2  var3  var4  var5  var6
   0    10     9     2   NaN   NaN   NaN
   1   NaN   NaN   NaN     1    81    13
  </code></pre>
  
  <p>which is clearly not what we want.</p>
  
  <p>Thanks!</p>