How to merge multiple .csv in a folder using python

Question

I have a folder with 12 .csv files which I wish to merge row by row.

This is the code I have to load one of the .csv

Code

test = pd.read_csv("D:\DAT_ASCII_EURUSD_T_201612.csv", header=None, names=['Date', 'sell_A', 'buy_A', 'unknown'], parse_dates=["Date"])

How would I merge all 12 which have the names shown below (current one is 201612);

DAT_ASCII_EURUSD_T_201601.csv DAT_ASCII_EURUSD_T_201602.csv DAT_ASCII_EURUSD_T_201603.csv DAT_ASCII_EURUSD_T_201604.csv DAT_ASCII_EURUSD_T_201605.csv DAT_ASCII_EURUSD_T_201606.csv DAT_ASCII_EURUSD_T_201607.csv DAT_ASCII_EURUSD_T_201608.csv DAT_ASCII_EURUSD_T_201609.csv DAT_ASCII_EURUSD_T_201610.csv DAT_ASCII_EURUSD_T_201611.csv DAT_ASCII_EURUSD_T_201612.csv

you could append of the files together without python, no ? or do you want to do it with python to train yourself ? — MSR974
– MSR974, Commented Aug 7, 2020 at 21:31
Partially to train myself but if there is a simple way not through python them open to suggestions — InvestingBetter
– InvestingBetter, Commented Aug 7, 2020 at 21:37

YOLO · Accepted Answer · 2020-08-07 21:33:47Z

3

You can do using concat:

from pathlib import Path

# set your file path
pt = Path("your_file_path/")

name = ['Date', 'sell_A', 'buy_A', 'unknown']
df = pd.concat([pd.read_csv(file, header=None, names=name, parse_dates=["Date"]) for file in pt.glob("*.csv")])

answered Aug 7, 2020 at 21:33

YOLO

22k5 gold badges25 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

How to merge multiple .csv in a folder using python

Code

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Code

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related