title: How to append columns aligned with a loop in pandas
body: <p>Recently I've been trying to build a data frame out of the content of 3 excel files (xlxs). I made a <code>for</code> loop to look for the files and then unite them.</p>
  
  <pre><code>import pandas as pd
      import glob
      f_list = glob.glob("C:\\Users\\*.xlsx")  
      all_data = pd.DataFrame()             
      for f in f_list:                       
         df = pd.read_excel(f)             
         all_data = all_data.append(df , sort=True, ignore_index=True)
  </code></pre>
  
  <p>The 3 tables were made of a single column of a letter (a, b, and c). Therefore, the expected result was a dataframe with 3 columns with lines like: a b c.</p>
  
  <pre><code>[Result of the code][Image]
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/hWzti.png" rel="nofollow noreferrer">https://i.stack.imgur.com/hWzti.png</a></p>
  
  <p>What am I getting wrong? I must say I'm totally noob with Python and I'm just strating with pandas.</p>
  
  <p>Thank you very much!</p>