alf | world super fast and configurable framework | Command Line Interface library

just group by them:

You can do:

To get the missing fruits for each person, we can use a list of all possible fruits in the database and remove each fruit that exists for the person as a Diet row in the database.

So that we can render the data in an HTML template, we'll write our missing fruit logic inside of a view: https://docs.djangoproject.com/en/4.0/intro/tutorial03/

Go to CRAN and try the examples in the official OECD R library manual.

When a library or library documentation on CRAN is out-of-date or not working properly it gets flagged. The author then has limited time to fix it, or it gets removed from CRAN. CRAN should always be the first place you look to try to understand the functions of a library. The documentation on CRAN is usually up-to-date.

Try the examples in the manual.

CRAN - OECD OFFICIAL R MANUAL

Welcome to the site. You are getting bitten by a couple things here. But before that, if you have a piece of code that is producing an error, it is customary to include a minimum reproducible example such that somebody can copy/paste it and get the error you are working with. Your odds of getting a decent reply are a lot higher if you do so!

So what is happening w/ your code... You have misspelled the word "customer" several times in your objective function as custmer. So when python tries to run the summation, it cannot find a local variable called customer for the indexing of things, so it goes back up in scope to your overall program and the stuffs in your original data list customer into the index and the bogus custmer variable does nothing you want it to do. But, there is no syntax error in your code, just an unfortunate typo, so you probably aren't seeing any static errors.

So what can you do?

1. Fix the typos
2. Break up your ridiculously long objective function into individual expressions (see mine below). This will make them much easier to troubleshoot, and you get the added benefit of being able to see their value after you solve by doing things like pe.value(z2).
3. Choose the names of your data elements more carefully. If you stick with the convention of naming collections of things as plural names you would have caught this much earlier... you have nodes, edges... why not customers as a data source?

The below is a suggested approach, which builds without errors. I did not change customer --> customers though for clarity.

You can try using pandas, a well-known library for data processing.

Sample code:

In using the read_excel method, if you give the parameter sheet_name=None, this will give you a OrderedDict with the sheet names as keys and the relevant DataFrame as the value. So, you could apply this and loop through the dictionary using .items().

The code would look something like this,

Try this: