script to clean SDK log

sdk.py

locations = filter(lambda line: line.split("|")[-1] == "loc-bg\r\n", open("log.csv"))
def extract(line):
  items = line.split(",")
  timestamp = items[0].split("|")[0]
  lon = items[1]
  lat = items[2]
  return ";".join([timestamp, lon, lat])
locations = map(extract, locations)

out = open("out.csv","w")
out.write("ts;lon;lat\n")
out.write("\n".join(locations))
out.close()