0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

フォルダ内のすべてのcsvファイルをpandasで処理

Posted at

ソースコードを置いているディレクトリ内のすべてのcsvファイルに対して、PandasライブラリのDataFrameで読んで何らかの処理をする方法です。

import pandas as pd
import glob

files = glob.glob('./*.csv')
    for file in files:
        # csvファイルを試験データを読込む
        df = pd.read_csv(file, encoding='shift_jis’')
        # なにかの処理

WindowsのExcelで作成したCSVファイルだとencodingにshift_jisを指定しないと上手く扱えない場合が多いです。

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?