CODEWITHSUNDEEP
pythonpandascsv
user12177026
user12177026

Reputation:

combining several csv files into one with python not aligned

I have several csv files that I want to merge to one file.

import os
import glob
import pandas as pd

os.chdir('/home/yovel/PycharmProjects/fantasyfinal/stats')

extension = 'csv'
all_filenames = [i for i in glob.glob('*.{}'.format(extension))]

combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames], sort=False)
combined_csv.to_csv("statsmerger.csv", index=True, encoding='utf-8-sig')

output: enter image description here

enter image description here

Upvotes: 1

Views: 129

Answers (1)

jezrael
jezrael

Reputation: 862681

It seems you need axis=1 parameter in concat:

combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames], sort=False, axis=1)

Upvotes: 1

Related Questions