boston | Census Data Choropleths | Map library

I have a dataset with multiple levels:

1. Categories (e.g., "Countries")
2. Countries (e.g., "USA")
3. Cities (e.g., "New York")
4. Counties (e.g., "Manhattan")
5. Places (e.g., "Times Square")

Each row (except for LVL 1 entries) is linked to a parent a level above.

For example: Times Square->Manhatten->New York->USA->Countries

My question: how to sort this dataset:

Assume, there are two pandas DataFrame: df1 & df2. The df1 is a square data frame such as following

I am working with a computer that can only access to a private network and it cannot send instrunctions from command line. So, whenever I have to install Python packages, I must do it manually (I can't even use Pypi). Luckily, the NLTK allows my to manually download corpora (from here) and to "install" them by putting them in the proper folder (as explained here).

Now, I need to do exactly what is said in this answer:

We know in Python you can do

I have some following codes. I met error when save trained model. It's only error when i using lightgbm.

I have two columns and I want to reshape the table for a cross-count. How may I achieve this through Pandas?

I would like to make a prediction of a single tree of my random forest. However, if I wrap my pipeline around TransformedTargetRegressor .set_params does not seem to work.

Please find below an example:

If I run my regex on the data as a string I have no issues my three lines get matched.

https://regex101.com/r/pHsTvV/1

I am trying to work through the example from Chapter 5 of the Leaflet.js succinctly book - but cannot get any of the coffee shops to show on my map.

Some of the commands give me errors so I've looked for workarounds, and I suspect the problem could be as simple as files not being in the correct place. Is there an idiot's guide to using databases with leaflet I could follow? Or can someone see the error I am making?

My set up:

• using XAMPP on a Mac - the MySQL Database and Apache Web Server are running
• I created the leafletDB database using the terminal /Applications/xampp/xamppfiles/bin/mysql -u root -p create database leafletDB
• I filled the database by copy paste into the terminal the contents of the CoffeeShops.sql file (I could not get the from CSV command mysql –uroot –pleaflet < "C:\CoffeeShops.sql"; to work, even changing the path to CoffeeShops.sql)
• Checking the database using USE leafletDB; SHOW TABLES; and SELECT COUNT(*) FROM coffeeshops; all gave the expected results.
• The leaflet database is located in /Applications/XAMPP/xamppfiles/var/mysql/
• I copied the coffee.php file to the /Applications/XAMPP/xamppfiles/htdocs/CoffeeExample folder, which is the same file as the listing43.html file (the file that creates the map)
• The only change I made to the listing43.html file was the path to the mugIcon (put in the same folder). I also tried simply removing the icon command - it made no difference.

The map displays, any markers coded directly into the html file display - but nothing from the database.

What have I got wrong?

As requested here is a copy of all the code - sorry for how long this is

listing43.html