title: Pandas - Appending data from one Dataframe to
body: <p>I have a Dataframe (called <code>df</code>) that has list of tickets worked for a given date. I have a script that runs each day where this df gets generated and I would like to have a new master dataframe (lets say <code>df_master</code>) that appends values form df to a new Dataframe. So anytime I view df_master I should be able to see all the tickets worked across multiple days. Also would like to have a new column in df_master that shows date when the row was inserted.</p>
  
  <p>Given below is how df looks like:</p>
  
  <pre><code>1001
  1002
  1003
  1004
  </code></pre>
  
  <p>I tried to perform <code>concat</code> but it threw an error </p>
  
  <pre><code>TypeError: first argument must be an iterable of pandas objects, you passed an object of type "Series"
  </code></pre>
  
  <p><strong>Update</strong></p>
  
  <pre><code>df_ticket = tickets['ticket']
  df_master = df_ticket
  df_master['Date'] = pd.Timestamp('now').normalize()
  L = [df_master,tickets] 
  master_df = pd.concat(L)
  master_df.to_csv('file.csv', mode='a', header=False, index=False)
  </code></pre>