title: Merging csv files in order of date created Python Pandas
body: <p>I am merging 3700 csv files with a total of 10 million rows. The files do not have a sequential naming but the date in which they were created(Descending) is sequential. I use the following code to merge them but do not know how to add pick them in that sequence.</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>import pandas as pd
  import glob
  
  path = r'C:\Users\User\' #  path
  
  all_files = glob.glob(path + "/*.csv")
  
  li = []
  
  for filename in all_files:
  
      df = pd.read_csv(filename, index_col=None, header=0)
  
      li.append(df)
  
  frame = pd.concat(li, axis=0, ignore_index=True)</code></pre>
  </div>
  </div>
  </p>
  <blockquote>
  <p>The following are names of files arranged in date modified(oldest to newest) from the os</p>
  </blockquote>
  <p><code>V100(1005).csv   V100(1).csv   V100(778).csv   V100(2).csv</code></p>
  <p>The file names are not sequential because while downloading other files were deleted in between.</p>