Pandas read_csv multiple files
<p>What's the best way to loop through a bunch of files and create separate data frames for each file? I've looked through other questions, but it seems the point in each of those is to concatenate files into one data frame.</p>

<p>For example, if I have mylist = ['a.csv','b.csv','c.csv'], and I want each of my data frames to take the name of the file (a, b,c), I can't do this because the left side of the assignment statement is treated as a string. How do I correct this so that it is interpreted as a dataframe assignment?</p>

<pre><code>mylist = ['a.csv','b.csv','c.csv']
import pandas as pd
for file in mylist:
    file.rsplit('.csv',1)[0] = pd.read_csv(file)
</code></pre>