topic Re: Python script depot - getting a KeyError when inputing key values in Discussions

Python script depot - getting a KeyError when inputing key values

eranraz100 — Sat, 10 Jun 2023 23:23:07 GMT

I got a python score script generated by the JMP depot ,

When I send a dict of values (taken from a json file) to the score formula, I t ends up with KeyError (as if the key doesn’t exist , but it is )Could that be a backspace issue?

I attached the JMP file and the json file

thanks

Eran

Re: Python script depot - getting a KeyError when inputing key values

nascif_jmp — Tue, 01 Dec 2020 16:17:54 GMT

Hi @eranraz100,

Glad to see you deploying our models to production!

The KeyError is about a string used as key in the input dictionary, that in turn is generated from the JMP column names used as input in your model. JMP supports spaces in column names, and the strings used as keys in the generated Python code also have embedded spaces:

def getInputMetadata():
    return {
        # ...
        u"SURFACE FINISH CS": "str",
	}

It looks like the process that is generating the JSON input data is replacing these spaces with underscores:

{
  "SURFACE_FINISH_CS":"FULL_HGLD",
}

I hope this is easy to fix on the JSON generation side, but if not, changing the column names to replace the spaces with underscores and regenerating the model would do the trick.

Re: Python script depot - getting a KeyError when inputing key values

eranraz100 — Wed, 02 Dec 2020 06:03:13 GMT

Hi, thank you for the quick response

as you mention , I used a function to alter the json generated - and it worked.

you can mark the issue as solved

thanks again

Eran

Re: Python script depot - getting a KeyError when inputing key values

nascif_jmp — Wed, 02 Dec 2020 14:46:25 GMT

Hi again @eranraz100,

Welcome to the JMP Community, looks like you just joined.

I am curious about your usage of our Python scoring code - you are the first customer who asked about using JSON as input.

I always thought this would be a prime usage scenario as it makes it easier for our models to consume data from web-based processes.

For example, this is a web application created for a JMP Discovery 2017 conference tutorial.

The frontend is a static app based on Leaflet and the backend is one of our models exported to Python and running on AWS Lambda.

Are you doing something along those lines?

Re: Python script depot - getting a KeyError when inputing key values

eranraz1 — Thu, 04 Feb 2021 14:07:25 GMT

Hi, yes that’s the sort of solution we are trying to implement

I’m using Flask web-framework as REST API, the purpose is to let SAP consume that API during price quotation- calculation

The API does some data validation and conversion, and then address the score function with parameters

thanks for your help and the useful data you attached

cheers

Eran