[ARROW-12657] [C++][Python][Compute] String hex to numeric conversion and bit shifting

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 6.0.0
• Component/s: C++, Python
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/18653
• Assignee: William Malpica
• Reporter: Franz
• Created: 05/May/21 12:27
• Updated: 11/Jan/23 08:27
• Resolved: 16/Sep/21 10:12

Description

Hi Apache Arrow Community,

thanks for the great work on this project - it is really a game changer. I've started to use it more frequently since more and more compute kernels became available.

However, I have a current requirement which I can't fulfill, yet. More concretely, I have hex values as strings. I need to convert them to numeric type (int) and apply bit shifting.

Currently, I can't find a way to do so. I tried type casts (string to int) like 

import pyarrow as pa

array = pa.array(["0x2001591", "0x2000848", "0x2000123"])
array.cast(pa.uint32())

However this results in ArrowInvalid: Failed to parse string: '0x2000123' as a scalar of type uint32. 

Moreover, I will need to apply bit shifting once converted. I'm not sure if there is anything comparable in the compute kernels, yet.

Thanks for any help in advance.
 
 

Issue Links

• is a child of: ARROW-555 [C++] String algorithm library for StringArray/BinaryArray
• is related to: ARROW-13774 [C++][Python][Compute] Number to string hex conversion
• links to: GitHub Pull Request #11064
• links to: GitHub Pull Request #11160
• links to: GitHub Pull Request #11161