hector | The Hector Simple Climate Model

This gives the expected output; does it solve your problem?

I tried to proceed as per the comment on my question and recommending to install jupyter and all the rest with pip3.

I had a doubt about my overall installation because there was nothing available as 'pip3' on my system.

In fact the issue was related to the fact that I initially installed jupyter notebook with the apt package provided with Ubunutu, and I actually should not have.

This Ubuntu apt package delivers a 'snap' installation wich is very bounded and separated from other python instances on the computer. It 'messes up' python, in such a way that one really gets situation like described in my question.

My first step has been to remove apt installation of jupyter:

Your inner SELECT returns this:

You are using Code Runner, isn't it?

You can avoid using the Code Runner. After you selected the proper python interpreter, you can click the Run Python File button, or right-click and select Run Python File In Terminal command.

If you insist on using the Code Runner, you can add "code-runner.runInTerminal": true, in the settings.json file. This is because if you run the Code Runner directly in the OUTPUT panel, it will take advantage of the global python, ignoring the python interpreter selected by the Python extension.

you need to add an "order" column to get expected result. Here is a solution with row_number.

Try np.argmax:

Honestly, your best bet is to get good data from the supplier. Trying to work around a mess will just cause problems later on. Garbage in, garbage out. Since it's you who wrote the garbage data in the database, congratulations, it's now your fault that the DB data is of poor quality. Please talk with your manager and the stakeholders first, so that you have in writing an agreement that you didn't break the data and it was broken to start with. I've seen such problems on ETL processing all too often.

A quick and dirty pseudocode without error handling, edge case processing, substring index assumptions, performance guarantees and whatnot goes like so,

Several problems with your code:

• You define an RV class, but you never use it
• The data that you define in the __init__() method of the RV class is a dictionary, but the data is expected to be a list of dictionaries. See documentation.
• The keys of the data dictionaries must be properties of the viewclass, but your keys are peoples names.
• You have not specified a viewclass for the RV.

To fix this change the BoxLayout in your kv to RV, and add a viewclass: