NKMatha opened a new issue, #39205:
URL: https://github.com/apache/arrow/issues/39205
### Describe the bug, including details regarding any error messages,
version, and platform.
Hi team,
Am trying to save a csv to parquet using Pandas, but some times am facing
issues like type conversations where a column is object but most the values are
numeric. If one value in that column is alphanumeric then its causing issue
like` ("Could not convert 'A5000' with type str: tried to convert to double",
'Conversion failed for column REFERENCE_KEY3 with type object')`.
But explicitly i defining individual column types before saving to parquet
and REFERENCE_KEY3 is a object. Please help for this scenario.
**sample script:**
```
merged_df = merged_df.astype({col: typ_conv[oracle_type] for col,
oracle_type in m.items()})
merged_df['REFERENCE_KEY3'].dtype # dtype('O')
merged_df.to_parquet('sample.parquet', index=False)
```
**Info**:
Name: pandas
Version: 1.1.5
Name: pyarrow
Version: 6.0.1
### Component(s)
Parquet, Python
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]