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 5 years have passed since last update.

Pandasでcsvの複数カラムの変更方法(Unixtime -> Japan Time)

Posted at
import glob
import os
import pandas as pd
import pandas as pd
from datetime import datetime
from pytz import timezone


# CSVデータを変えるスクリプト (カラム 'starttime', 'endtime' をUnixtimeから日本時刻に変更)

# プログラム実行場所の直下に目的のcsvファイルがある
csv_list = os.listdir()

# !!適時 .remove()などでcsvじゃないファイルを抜いてあげてください。
# !!今時間がないのですが、修正してくれる人いたら大歓迎です!
# (↑csv以外をlistから削除 or listに入れない部分)



tz = timezone('Asia/Tokyo')


for csv_file in csv_list:
    
    
    
    japan_starttime_list = []
    japan_endtime_list = []
    
    
    print(csv_file, "を読み込む...")
    
    df = pd.read_csv(csv_file)
    
    starttime_series = df.starttime
    endtime_series = df.endtime
    
    
    for starttime in starttime_series:
        starttime_str = str(starttime)[:10]
        starttime_int = int(starttime_str)
        
        # Unixtime -> Japan time(str) -> listに格納
        utc_time = datetime.fromtimestamp(starttime_int)
        japan_time = utc_time.astimezone(tz)
        japan_time_str = japan_time.strftime('%H:%M:%S')
        japan_starttime_list.append(japan_time_str)
        
        
    # endtimeでも同じことを
    for endtime in endtime_series:
        endtime_str = str(endtime)[:10]
        endtime_int = int(endtime_str)
        
        # Unixtime -> Japan time(str) -> listに格納
        utc_time = datetime.fromtimestamp(endtime_int)
        japan_time = utc_time.astimezone(tz)
        japan_time_str = japan_time.strftime('%H:%M:%S')
        japan_endtime_list.append(japan_time_str)
        
    
    # dataframe の2つのカラムのデータ変更
    df.starttime = japan_starttime_list
    df.endtime = japan_endtime_list
    
    
    # 新たな csv を作成
    df.to_csv('rev_' + csv_file)
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?