furnace | system chiptune tracker compatible with DefleMask modules | Emulator library

Below iam trying to add the values from FireStore to LineChart but chart shows blank,Where as reference.get methods is retreiving data and saving in my model but its not adding up in series data

if i manually add data in the seriesData.add() it populates in the chart, i dont know where i am doing wrong

Please help me guys.

I'm trying to make a program to display some time and temperature numbers on a web page. I have two html templates, "index.html" and "set.html" in a "templates" directory under the main "furnace" directory. The index part works as it should when called by flask but the "set" link (to go to a page to enter a new time and date) results in a "404 Not found" error. I've stripped everything out of the Python program that isn't part of flask and displaying the html, and I still get the error. At this point, all that's left is about the same as simple examples I've found; I've compared my program to the examples and I just can't see what's going wrong. Can some sharp eyes spot my mistake?

furnace-9x.py

I'm trying to display time and temperature and other variables on an LCD display, and on a web page (local network only) when it's accessed. This is running on a Raspberry pi Zero 2 W, using python. My thinking is, the flask app should be running in the background, and serving up the template when it's called. Meanwhile, the timer should interrupt every second and cause the LCD display to be updated.

The LCD display works as it should, with the data refreshed every second, as long as the flask server is not active (commented out the "flask_app.run..."). But when flask is enabled, the web page works but the display does not.

I'm about at my limit of understanding python and flask -- can you see what's wrong here? Thanks.

I am trying to scrape data, write it to a pd series then go into a while loop for the remaining pages of the website appending to the original series (located outside of the while loop) after each iteration. I'm not sure why this isn't working. Here's where I'm stuck:

Let's say I have some code:

I have a JSON that has around 50k items where each has an id and name as follows (I cut the data):

So I am working on a code where I take values from the csv file and multiply them with some numbers but when I save and export the results the values from the imported file are also copied to the new file along with the results. I just want the results in the output file.

Sorry if this is a noobish question. I have searched and seen similar questions about removing a noise signal, but I didn't understand the answer and I'm not sure if it applies to my problem. I have only a tiny bit of formal signal processing experience.

In this case, I have one time series which is my gas usage in therms per day over a year. The other time series I have are the max and min observed temperatures for my location in degrees.

There is appears to be an obvious correlation that as temperatures go down, gas use goes up.

I have both a gas furnace and a gas water heater. What I would like to do is find the baseline usage per day in therms, without the part that fluctuates with temperature. I am assuming that temperature related fluctuation is mostly the furnace and what is left is the water heater. I know that the water heater will fluctuate with outside temp too, but I am assuming it is nominal for this analysis.

I have looked at correlation funcions in numpy and pandas and done stuff like this:

I am trying to write a stored procedure that will take @start_dt and @end_dt parameters from a view and use them as parameters in a WHERE clause on another table.

I am trying to get the total number of HEATS between @start_dt and @end_dt. Then I need to insert the result of this SELECT statement into a table.

How do I declare @start_dt and @end_dt in the procedure? How do I use a cursor that will navigate through each pair of @start_dt and @end_dt and do the COUNT on heats?

This query is half the way done: