TWC | C Code to talk to the Tesla Wall Connector

• Because the desired result is for the data from each dict in the 'icdcodes' key to have a separate row, the best option is to use pandas.json_normalize.
• First create the main dataframe and use pandas.DataFrame.explode('icdcodes'), which will expand the dataframe to have the appropriate number of rows for each 'clientid' based on the number if dicts in 'icdcodes'.
• Use .json_normalize() on the 'icdcodes' column, which is a list of dicts, where some the values may also be dicts.
• .join the two dataframes and drop the 'icdcodes' column
• Use pandas.DataFrame.rename() to rename columns, and pandas.DataFrame.drop() to drop unneeded columns, as necessary.
• Also see this answer from SO: Splitting dictionary/list inside a Pandas Column into Separate Columns

I don't quite understand what you try to do, but in this view function mypage:

You should not open a cv::namedWindow from a thread that isn't the main thread. It might work, but I wouldn't recommend it.

INSTR might be one option; I presumed that you want any "co" string, regardless its letter case (that's why I used lower function). If you don't need it, remove it.

Your solution is absolutely fine. You won't make it much better if you want to rely on auto width, which you do. I would just replace

with another

You've done a good job so far, +1 for the effort you've put in this!

I would like to take it one step further, if you don't mind.

Firstly, you have to keep in mind that what you see when you inspect an element in your browser's developer tools is not necessarily what you'll see in the source HTML of the page.

Indeed, in this case if you actually right click and view the source code of the page, you will not find the HTML snippet that you posted. You will find it however if you inspect the element of interest.

This happens because this part of the HTML code is generated by a script. You will find this script in the Page's source code inside a tag (just search for "sunrise" for example). This tag contains a huge string and a second small one, both in JSON format.

The script tag looks like this:

I have replaced most of the string with ... for the sake of readability.

All the data you need is in the first JSON string (window.__data) between the curly brackets {...}. You will not be needing the second string (window.experience).

So basically what you need is to isolate this string from the response and then parse it to get the info you want.

You can inspect the JSON string's structure using a tool like this. Here's how it looks like:

To parse a string like this you will need to add this JSON parser to your project. Follow the installation instructions in the link and you should be set to go.

You will also need to add the following references to your project (VBE>Tools>References):