create multiple dataframes with python

Question

I have a list filepath with the ubication of the files I need to read (115 files), I need to read those files and add columns header (same for all files), also I have a list with the files names I want to use but no idea in how make it.

filepath look like this

['drive/My Drive/forex/DAT_MT_BCOUSD_M1_2015.csv',
 'drive/My Drive/forex/DAT_MT_BCOUSD_M1_2016.csv',
 'drive/My Drive/forex/DAT_MT_BCOUSD_M1_2017.csv',
 'drive/My Drive/forex/DAT_MT_BCOUSD_M1_2018.csv',
 'drive/My Drive/forex/DAT_MT_BCOUSD_M1_2019.csv']

filename is like this

['DAT_MT_BCOUSD_M1_2015',
 'DAT_MT_BCOUSD_M1_2016',
 'DAT_MT_BCOUSD_M1_2017',
 'DAT_MT_BCOUSD_M1_2018',
 'DAT_MT_BCOUSD_M1_2019']

and I was adding the columns header like this

DAT_MT_BCOUSD_M1_2015= pd.read_csv("drive/My Drive/forex/DAT_MT_BCOUSD_M1_2015.csv",
                                    names=["Date","Time","Bar OPEN Bid Quote","Bar HIGH Bid Quote","Bar 
                                    LOW Bid Quote","Bar CLOSE Bid Quote","Volume"])

any ideas on how aproach the problem?

Does this help ? : stackoverflow.com/questions/30635145/…

Grayrigel
– Grayrigel

2020-10-19 00:46:47 +00:00
Commented Oct 19, 2020 at 0:46 — Grayrigel
– Grayrigel, Commented Oct 19, 2020 at 0:46

Jahziel Rae Arceo · Accepted Answer · 2020-10-19 01:40:31Z

1

I'd suggest you create a Python dictionary with the dataframes inside, and access them using their filenames as the dictionary keys.

new_dict = {filename: pd.read_csv("drive/My Drive/forex/{}.csv".format(filename),
                                  names=["Date","Time","Bar OPEN Bid Quote",
                                         "Bar HIGH Bid Quote","Bar LOW Bid Quote",
                                         "Bar CLOSE Bid Quote","Volume"]) \
            for filename in filename_list}

answered Oct 19, 2020 at 1:40

Jahziel Rae Arceo

1111 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

create multiple dataframes with python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related