elliott | automating several aspects of the errata lifecycle | Web Framework library

I have a collection of documents containing information about movies by following format:

I have Datatables filtering records with checkboxes. The problem is that if a column has 2 values within it, then the checkbox filter does not find the row.

For example, there are 3 checkboxes for 'Call', 'Meeting' and 'Email'. If a row in the table has values of 'Call' AND 'Email', if you then want to filter by 'Email', this row doesn't display. It can't see it because it doesn't just say 'Email'. It says 'Call Email'

Hello I have this Pandas code (look below) but turn out it give me this error: TypeError: can only concatenate str (not "int") to str

Im working through some self-join examples and I am drawing a blank on the following example. Its the last example at the following link Self-Join Example

Before I start questioning let me give you a simplified example of my case:
Imagine you have Views:

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

I will be able to accept an answer in 6 minutes. For now going to state that my answer has successfully been solved by Elliott Frisch. He provided a solution to fix the problem I ran into.

When attempting to do the "Equation" it correctly performs the action but seems to be off. Off being that it doesn't really display it in a way I want it to. An example is this:

Equation = √ N ≈ ½(N/A + A)

I've read an answer and stumbled upon sample code below which is Elliott's answer from other SO question HERE

I have issue trying to understand two things (and to know how this syntax is called) :

I have a dataset that contains several columns, as shown below:

I want to transform the data into a longer format with the names: Trade Value, Position, Player Name, and Trend Value

Here's what I tried.... But the code tries to combine the Trend and Player Name columns. How to have specify that those should be two separate columns represented by the same Position?