I have a file with data separated by spaces like this:
2017-05-16 00:44:36.151724381 +43.8187 -104.7669 -004.4 00.6 00.2 00.2 090 C
2017-05-16 00:44:36.246672534 +41.6321 -104.7834 +004.3 00.6 00.3 00.2 130 C
2017-05-16 00:44:36.356132768 +46.4559 -104.5989 -004.2 01.1 00.4 00.2 034 C
and I want to convert it into JSON format like this:
import json
import sys
def convert(filename):
dataDict = {}
txtFile = filename[0]
print "Opening TXT file: ",txtFile
infile = open(txtFile, "r")
for line in infile:
lineStrip = line.strip()
parts = [p.strip() for p in lineStrip.split()]
date = parts[0].strip("-")
time = parts[1].strip(":")
dataDict.update({"dataset":"Lightning"})
dataDict.update({"observation_date": date + time})
dataDict.update({"location": {"type":"point", "coordinates": [parts[2], parts[3]]}})
json_filename = txtFile.split(".")[0]+".json"
jsonf = open(json_filename,'a')
data = json.dumps(dataDict)
jsonf.write(data + "\n")
print dataDict
infile.close()
jsonf.close()
if __name__=="__main__":
convert(sys.argv[1:])
I'm unsure how to remove the "-", ".", and ":" characters as well as add the "dataset":"lightning" element at the beginning.