Simple script to transform libra csv file to openscale format

libra2openscale.py

#!/usr/bin/env python
"""
Simple script to transform libra csv file to openscale format
"""
import sys
import csv
from dateutil.parser import parse

if len(sys.argv) != 2:
    print "Missing file to transform\n"
    sys.exit(1)

r = csv.reader(file(sys.argv[1]), delimiter=";")
writer = csv.writer(file("openScale_data_Libra.csv", "w"), delimiter=",")

for w in r:
    if len(w) == 0 or w[0].startswith("#"):
        continue
    time = w[0]
    weight = w[1]
    comment = w[5]
    d = parse(time)
    writer.writerow([d.strftime('%d.%m.%Y %H:%M'), weight, 0.0, 0.0, 0.0, 0.0, 0.0, comment])