[
https://issues.apache.org/jira/browse/ARROW-9907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joris Van den Bossche closed ARROW-9907.
----------------------------------------
Resolution: Duplicate
> [Python] Failed to parse string into timestamp
> ----------------------------------------------
>
> Key: ARROW-9907
> URL: https://issues.apache.org/jira/browse/ARROW-9907
> Project: Apache Arrow
> Issue Type: Bug
> Components: Python
> Reporter: Gary
> Priority: Minor
>
> Hi,
> Not sure if I am missing something, but I am unable to get pyarrow to parse
> my datetimes that are being inferred as strings, to be timestamps.
> My strings are arriving in CSVs with this format: '2015-01-09 00:00:00.000'
> I have tried:
> ```
> convert_ops = csv.ConvertOptions(timestamp_parsers=['%Y-%m-%d %H:%M:%S.%f])
> df = csv.read_csv('path_to_csv', convert_options=convert_opts)
> print(df.schema)
> ```
> This yields no change and has my columns with these formatted timestamps
> still showing as strings.
> Additionally, I have tried casting as well:
> ```
> dfschema = pa.schema([
> ('date_column', pa.timestamp('ms'))
> ])
> df = csv.read_csv('path_to_csv')
> df.cast(target_schema=dfschema)
> ```
> This way yields the error: "pyarrow.lib.ArrowInvalid: Failed to parse string:
> 2015-01-09 00:00:00.000"
> I am using pyarrow=1.0.1 on a linux docker container.
> I tried to send an email to the users email list but it keeps returning a
> Mailer Daemon error.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
