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
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 460 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 187 Visualize
- 251 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive