Nicobar | dynamic scripting framework for java | Build Tool library

One of the solutions could be this.

Let the dictionary that is meant to be filled be a_dict and the dict that has to be inserted a as b_dict, you can use the following statement for the above mentioned problem,

The SyntaxError is because you need a else condition, so something like value = "Severe", if data3["Active"] > 91874 else 'OTHER' would remove the error. That said, it won't work in this case and return another error of using a Series - in this case data3["Active"] > 91874 - in a if statement.

I believe you can use np.where here

Because the data you are getting has the following format: stringKey: listValue, and inside the list, you have each dictionaries, so you need to access the key of the dictionaries inside the value list.

I think you need pivot_longer twice with a proper names_pattern regex argument.

The dictionary is actually quite simple. We have the key states, and it's value is a list containing sub dictionaries. If we iterate through this list we can easily index state_id and state_name. Now I don't know how you want to store this gathered data, so I assumed it would be best to put each group of "state_id" & "state_name" in a tuple.

Does that help?

The issue was in the application of df.apply

df.apply needs to be given a function taking in the value from each row it is being iterated over. You also need to clean the return of get_close_matches which returns a list, so you need to take the first element

You make headers but never include them in your call to GET. Use them there.