Menu
Is there a way to read multiple csv files into Pandas through a loop and define them as such?
for i in ['a', 'b', 'c', 'd']:
csv_(i) = pd.read_csv('C:/test_{}.csv'.format(i))
I see multiple questions about reading and appending multiple csvs into a single dataframe. Not the other way around.
924
Sometimes you may need to read or import multiple CSV files from a folder or from a list of files and convert them into pandas DataFrame. You can do this by reading each CSV file into DataFrame and appending or concatenating the DataFrames to create a single DataFrame with data from all files.
Code explanation Here, the glob module helps extract file directory (path + file name with extension), Lines 10–13: We create a list type object dataFrames to keep every csv as a DataFrame at each index of that list. Line 15: We call pd. concat() method to merge each DataFrame in the list by columns, that is, axis=1 .
In order to read multiple CSV files or all files from a folder in R, use data. table package. data. table is a third-party library hence, in order to use data.
You can use dict comprehension for dict of DataFrames:
dfs = {i: pd.read_csv('C:/test_{}.csv'.format(i)) for i in ['a', 'b', 'c', 'd']}
print (dfs['a'])
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
