Read multiple csv's and concat to multiple dataframes based on filenames python

Question

I have a list of csv's with the same columns. Here is how the list looks like,

C:/Users/foo/bar/January01.csv
C:/Users/foo/bar/February01.csv
C:/Users/foo/bar/March01.csv
C:/Users/foo/bar/January02.csv
C:/Users/foo/bar/March02.csv

I want something like this, all csv's that start with January should copy the data into January dataframe and likewise for all months.

Can anyone help me on this?

Bruno Mello · Accepted Answer · 2020-04-06 20:09:23Z

2

You can first iterate trough your directory to find all months you have, then you pass again appending the dataframes and finally saves them:

import os
dir_name = #your dir
months = set()
for file in os.listdir(dir_name):
    months.add(file[:-2])

month_df = {month: pd.DataFrame() for month in months}
for file in os.listdir(dir_name):
    month_df[file[:-2]] = month[file[:-2]].append(pd.read_csv(os.join.path(dir_name, file)))

for month in month_df.keys():
    month_df[month].to_csv(month + '.csv', index=False)

answered Apr 6, 2020 at 20:09

Bruno Mello

4,6881 gold badge16 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Read multiple csv's and concat to multiple dataframes based on filenames python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related