title: Reading multiple csv files, concatenate list of file names them into a singe DataFrame
body: <p>I have multiple csv files in directory and I would loop thru to csv files find a list of files names and read each one in and concatenate them into a single data frame. In the case of a single, just read the dataset in.</p>
  
  <p>Here example of csv files I have in my Directory:</p>
  
  <ul>
  <li>2013_nba.csv</li>
  <li>2014_nba.csv</li>
  <li>2015_nba.csv</li>
  <li>2013_basketball.csv  </li>
  <li>2014_basketball.csv</li>
  <li>2015_soccer.csv</li>
  </ul>
  
  <p>This is what I have so far. But this basically reads all csv files and concatenate them into a single DF. I need help one how to loop thru to find find list of strings(csv)</p>
  
  <pre><code>path = 'C:\\Users\csvfiles\\'
  csvFiles = glob.glob(path + "/*.csv")
  
  list_ = []
  
  for files in csvFiles:
       df = pd.read_csv(files, index_col=None, header=0)
       list_.append(df)
  
  frame = pd.concat(list_, ignore_index=True)
  </code></pre>
  
  <p>I am newby in python, I try to do "for "nba" in files" to pull all csv files names have "nba" in and then make one DF, but wasn't successful.</p>