More than 3 years have passed since last update.

フォルダ内にある全てのCSVを一つのCSVにまとめる方法

Python
pandas

Posted at 2020-05-23

inputフォルダ内に複数のCSVファイルがあり、それを一つのCSVにまとめて出力させている

import glob
import pandas as pd 

files = glob.glob('input/*.csv')
files.sort()

df_list = []
for file in files: 
    df_next = pd.read_csv(file)
    df_list.append(df_next)
df = pd.concat(df_list, ignore_index=True)
df.to_csv('output.csv')

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up