title: Python importing csv files within subfolders
body: <p>Is there a way of importing all the files within folder1? Each csv file is contained within a subfolder. Below is the file structure.</p>
  <p>C:/downloads/folder1 &gt; <strong>tree /F</strong></p>
  <pre><code>C:.
  │   tree
  │
  ├───2020-06
  │       test1.csv
  │
  ├───2020-07
  │       test2.csv
  │
  ├───2020-08
  │       test3.csv
  │
  ├───2020-09
  │       test4.csv
  </code></pre>
  <p>I'm aware of glob, below, to take all files within a folder. However can this be used for subfolders?</p>
  <pre><code>import glob
  import pandas as pd
  
  # Get a list of all the csv files
  csv_files = glob.____('*.csv')
  
  # List comprehension that loads of all the files
  dfs = [pd.read_csv(____) for ____ in ____]
  
  # List comprehension that looks at the shape of all DataFrames
  print(____)
  </code></pre>