Arsenal | Extensible Red Team Framework | Chat library

My data frame

Im learning JS and have set myself the challenge to re-create a football league table, from an array of match results.

Everything is going really well and I'm almost complete, but I can't filter my 'FORM GUIDE' array to their corresponding Letters.

I have the points scored over the last 5 games ONLY outputted as an array (below);

I want get the value of a cell in Dataframe based on string that is not equal but so similar. This is the dataframe

I have this table:

I have a parent table like this:

clubs

And a child table like this

players

The club_id is the foreign key that refer to the clubs table id column

Club Model

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 have a dataframe (results) of EPL results from the past 28 years, and I am trying to calculate the average home team points (HPts) from their previous 5 home games within the current season. The rows are already in chronological order. What I am effectively looking for is a version of the starter code below that partitions by HomeTeam and Season and calculates the mean of HPts using a window of the previous 5 rows with matching HomeTeam and Season. Clearly the existing code as written does not do what I need (it looks only at last 5 rows regardless of team and season), but is just there to show what I mean as a starting point.

This is the structure of BSON document I have in mongodb.

I am trying to group row by different condition and here is the example. Basically, what I want to try is group the Team name and put it into a new Dataframe with the sum of goal. I have try groupby but somehow cannot do what I want. How can I get the expected result? Thanks!