from datetime import datetime
import sys

header = ['photoid', 'uid', 'unickname', 'datetaken', 'dateuploaded', 'capturedevice', 'title', 'description', 'usertags','machinetags','longitude','latitude','accuracy', 'downloadurl', 'marker' ]

def main(filename):
	f_out = open('new_yfcc_100', 'w')
	with open(filename) as f:
		f_out.write('\t'.join(header)+'\n')
		for line in f:
			cols = line.split('\t')
			if cols[3] == 'null':
				continue
			cols[3] = 'T'.join(cols[3].split()) + 'Z'
			cols[4] = str(datetime.fromtimestamp(float(cols[4])))
			cols[4] = 'T'.join(cols[4].split()) + 'Z'
			for idx in [2, 5, 6, 7, 8, 9]:
				cols[idx] =  ' '.join(cols[idx].split('+'))
			new_line = '\t'.join(cols[:13] + [cols[14], cols[22]])
			f_out.write(new_line.strip()+'\n')
#14, 22
	f_out.close()

if __name__ == '__main__':
	filename = sys.argv[1]
	main(filename)
