Convert iOS Weight Recorder / WeightRecord XML file into CSV

convertWeightRecorderXMLtoCSV.py

#!/usr/bin/env python3
from bs4 import BeautifulSoup
import dateparser
import csv

soup = BeautifulSoup(open('WeightRecorder - 2016-09-18.xml'), "lxml")

def kgtolbs(kg):
    return float(kg) * 2.20462262185

weights = []
for i, entry in enumerate(soup.array.find_all('real')):
    if (i - 1) % 2 == 0: 
        weights.append(kgtolbs(entry.contents[0]))
        
dates = []
for i, entry in enumerate(soup.array.find_all('date')):
    dates.append(dateparser.parse(entry.contents[0][0:10]))
    
with open('weight_output.csv', 'w') as f:
    fieldnames = ['date', 'weight']
    writer = csv.DictWriter(f, fieldnames=fieldnames)
    writer.writeheader()
    for i in range(len(weights)):
        writer.writerow({'date': str(dates[i].date()), 'weight': weights[i]})