title: Appending pandas dataframes generated in a for loop
body: <p>I am accessing a series of Excel files in a for loop. I then read the data in the excel file to a pandas dataframe. I cant figure out how to append these dataframes together to then save the dataframe (now containing the data from all the files) as a new Excel file.</p>
  
  <p>Here's what I tried:</p>
  
  <pre><code>for infile in glob.glob("*.xlsx"):
      data = pandas.read_excel(infile)
      appended_data = pandas.DataFrame.append(data) # requires at least two arguments
  appended_data.to_excel("appended.xlsx")
  </code></pre>
  
  <p>Thanks!</p>