Parquet Data - module 'numpy' has no attribute 'bool'

Question

Hello Community,

I am trying to load parquet data into Alteryx (code below) - it all works well, till the point I want to write data into Alteryx (two last rows). Immediately, as I want to wrote output I am getting error:

module 'numpy' has no attribute 'bool'

from ayx import Alteryx
import pandas as pd

file = "C:/Users/nikolnor/Downloads/userdata4.parquet"
df = pd.read_parquet(file)
Alteryx.write(df,1)
#Alteryx.write(pd.read_parquet(par_file) ,1)

Could someone advise?

Thank you,

Nikoleta

Capture.JPG

QUESADAWILLI · Answer

I was facing a similar issue and this works, convert the bool column to string before use the Alteryx write line:

df = pd.DataFrame(items)
df[df.select_dtypes(exclude=['number']).columns] = df.select_dtypes(exclude=['number']).astype(str)
Alteryx.write(df, 1)

ajmondal · Answer

I also facing the same issue. Even while importing Linear Regression model from sklearn getting a same attribute error. I also reverted to previous numpy version 1.19.1 but no changes on the error same issue existing.

agv1800073 · Answer

Hi! I tried reverting back to 1.19 and received the following error after trying to run from ayx import Alteryx: Import Error - this version of pandas is incompatible with numpy < 1.20.3.

Were you able to resolve this error on your end and get back to using 1.19?