valent | Connect , control and sync devices | Data Processing library

Use defineComponent on the component definition object to get type inference:

Your entire approach is very inefficient. Just use a collections.Counter object. Supposing you have a dataframe like:

Try this below code. I have added an if condition, if (!str.includes(".")) which will now only replace 0, if there is no decimal.

The problem with your regex is that the second ^General absorbs those characters and prevents them matching on the second group. Also I'm not sure what you are trying to achieve with [\s] as that will match any space character when not matching the first part of the regex. I think what you actually want is to use a positive lookahead for General at the start of the line (or end of string) i.e.

You change iStart when checking for a prime but you never reset it back to 3 for the next check.

Since the data that you specified is nested pretty deeply in the JSON-response, you have to loop through it and save it to a list temporarily. To understand the response data better, I would advice you to use some tool to look into the JSON structure, like this online JSON-Viewer. Not every entry in the JSON contains the necessary data, therefore I try to catch the error through a try and except. To make sure that the id and committees are matched correctly, I chose to add them as small dicts to the list. This list can then be read into Pandas with ease. Saving to .dta requires you to convert the lists inside the committees column to strings, instead you might also want to save as .csv for a more generally usable format.