Domo Python error
i am using the python tile in domo magic etl
i am trying to cast a column to a category
but when i try and read the dataframe to the write_dataframe i get an error
# Import the domomagic package into the script
from domomagic import *
# read data from inputs into a data frame
raw = read_dataframe('Source 2')
#print('Before Cast')
#print(raw.dtypes)
#cast to correct dtypes to save space
raw = raw.astype({'VEEVA Entity ID': 'category'}, errors='raise')
print(type(raw))
write_dataframe(raw)
The error i get is has anyone else had a similar issue. it seems like domo specific outside of domo in pure python the code works.
Traceback (most recent call last): 00:00:10.604 File "<stdin>", line 25, in <module> 00:00:10.606 File "/home/domo/domomagic/io.py", line 46, in write_dataframe 00:00:10.606 write_array_dict(d) 00:00:10.606 File "/home/domo/domomagic/io.py", line 59, in write_array_dict 00:00:10.606 raise ValueError('domomagic: Array dict values must be numpy.ndarrays') 00:00:10.606 ValueError: domomagic: Array dict values must be numpy.ndarrays
Comments
-
Try converting the series itself as a category:
raw['VEEVA Entity ID'] = raw['VEEVA Entity ID'].astype('category', errors='raise')
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
raw['VEEVA Entity ID'] = raw['VEEVA Entity ID'].astype('category', errors='raise')
does not work but
raw['VEEVA Entity ID'] = raw['VEEVA Entity ID'].astype(str, errors='raise')
does work
leads me to believe
some sort of problem between numpy datatype and a dataframe datatype
this happens on the write_dataframe(raw) some sort of bug from the looks of it .
it doesn't matter we will recreate the dataflow in adrenaline
0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部