I can't use pandas.json_normalize() within a python query

Support Usage Support
1

Hi there!

I’m using python as data source for a query. I’ve tried to transform a nested json to a pandas dataframe by using the pandas.json_normalize() but I get the error:

Error running query: <type ‘exceptions.AttributeError’> ‘module’ object has no attribute ‘json_normalize’

I’ve already added pandas to the python data source as shown in the picture:

image

What am I doing wrong? I really appreciate your help! Thanks

redash Version: 8.0.0+b32245 (a16f551e)

2

Redash V8 uses Python 2.7. json_normalize probably isn’t supported that far back.

You should upgrade to V10.1 which uses Python3 and a more recent version of Pandas.

1 Like
3

Thank you very much! I’ll upgrade my version to v10.1. Appreciated!