Skip to content

Instantly share code, notes, and snippets.

@kevchentw
Last active June 12, 2016 06:14
Show Gist options
  • Select an option

  • Save kevchentw/fb859a1732d28786fa587ed7cb66112d to your computer and use it in GitHub Desktop.

Select an option

Save kevchentw/fb859a1732d28786fa587ed7cb66112d to your computer and use it in GitHub Desktop.
easy parser to get data
import dateutil.parser
from datetime import timedelta
f = open("xml2csv.csv")
data = f.readlines()
time_data = []
value_data = []
speed_data = []
for line in data:
if(line[0:4]=="Time"):
time = line.split(",")[1].strip()
try:
time = dateutil.parser.parse(time)
time_data.append(time)
except:
pass
elif(line[0:14]=="AltitudeMeters"):
altitude = float(line.split(",")[1])
elif(line[0:5]=="Value"):
value = int(line.split(",")[1])
value_data.append(value)
elif(line[0:5]=="Speed"):
speed = float(line.split(",")[1])
speed_data.append(speed)
print(str(time+ timedelta(hours=8))+","+str(value)+","+str(speed)+","+str(altitude))
f.close()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment