i have the following csv file, which i generated with Java's Writer class:
Writer writer = new BufferedWriter(new OutputStreamWriter(
ePath + ".csv"), "UTF-8"));
however, when i try to read it with a python script, i get this:
Exception: E10001: ('The provided timestamp 07/14/2015 1:30:14 PM is malformed. The supported formats are: [%Y-%m-%d %H:%M:%S.%f, %Y-%m-%d %H:%M:%S:%f, %Y-%m-%d %H:%M:%S, %Y-%m-%d %H:%M, %Y-%m-%d, %m/%d/%Y %H:%M, %m/%d/%y %H:%M, %Y-%m-%dT%H:%M:%S.%fZ, %Y-%m-%dT%H:%M:%SZ, %Y-%m-%dT%H:%M:%S]',): Traceback (most recent call last):
if i open the csv file in MS Excel, and immediately resave it, the the python script runs fine. there must be something Excel is reformatting/removing that Java's Writer is NOT doing. I am just not sure what it is. Thanks.