Reading multiple csv files, concatenate list of file names them into a singe DataFrame
<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>