A conversion script for SleepBot CSV data. Merges multiple rows on for the same date.

sleepbot_csv.py

#:coding=utf-8:

import sys
import csv
import collections
import decimal
import datetime


def main(csv_path, output_path):
    with open(csv_path) as csv_file:
        reader = csv.reader(csv_file)

        # ヘッダーをスキップ
        reader.next()

        dates = collections.defaultdict(lambda: 0)

        for line in reader:
            date = datetime.datetime.strptime(line[0], "%m/%d/%y")
            hours = line[3]

            dates[date] += decimal.Decimal(hours)

    with open(output_path, "wb") as outfile:
        writer = csv.writer(outfile)

        for date, hours in sorted(dates.items(), reverse=True):
            writer.writerow([date.strftime("%Y/%m/%d"), hours])


if __name__ == '__main__':
    main(sys.argv[1], sys.argv[2])