accounting | bookkeeping data according to Swedish standards | Dataset library

I am creating an accounting module with laravel and mysql. For that, I've master table called 'bills' which has some columns regarding invoice informations and id as primary key. Now I've two different tables called 'payments' having bill_id as foreign key and 'debitnotes' also having bill_id as foreign key.

Now I want to show payment history of particular bill which is paid. In order to that, I've to retrieve information from both payments table and debitotes table based on bill id at once! Now, my question is: How can I achieve this without writing multiple queries?

bills table has columns:

payments table has columns:

debitnotes table has columns:

I want to show both payments and debitnotes of particular bills in single page. How can i achieve this?

I have a data list like this

I'm a bit new to NodeJS and using Javascripts for these types of problems, so am feeling a bit stuck here. I'm working with a traditional relational database backend (Postgres) that has a fairly typical hierarchical (i.e. normalized) table/entity structure. One of my requirements for my NodeJs application is to pull data for a page (HTML report) that essentially incorporates all tables, but the page needs to show the data very hierarchically as well. Imagine a query result like this:

I'd have to ' \\n, *, ' ==> '\n *' but I tried using df['Course_content']=df['Course_content'].replace(' \\n, *, ','\n *',regex=True) but it's not working for me

I am having trouble finding a way to display a time accounting for daylight savings changes. This script is supposed to return the time for Dusk on any specified date at a specific place in the Eastern time zone. It works, but, it doesn't give the correct time in the winter (it's off by an hour). I've tried a variety of ways to deal with it, but nothing seems to work. I thought that simply setting the timezone to NY would do it, but it's still wrong. Help?

I have a panel data set of 34 banks from 2007 to 2020. I need to calculate the yearly log return from the daily adjusted closing stock prices of these banks. The data structure is as follows:

The date after importing to R is in POSIXct format while prices are in number format. There are in total 121323 observations.

Can anyone help me with the codes to calculate annual returns from daily prices? One of the problems is accounting for the panel data structure, the return calculation for Bank A has to end on the last date and the process has to repeat for Bank B and end on the last date so on. In the above data structure, the return calculation has to end on 07-01-2007 for Bank A. I have tried using quantmod but was unsuccessful. Any help is much appreciated.

Thanks

I want the updated value to pass into a new components "ExpandDevelopment" after making a selection "Development" in the Department selection field.

This is a list that populates the Department Field

I'm creating a Shiny dashboard app. One of the features on this app is a stat table that shows the MSE, MAE and either AUC or R2 depending on which is relevant.

These stats are currently just based on the data, treating each row equally. However, the data contains a weighting column. Some have a weight of 1, but most have a weight of a messy number (i.e. 3.4241). I'm unsure how to approach allowing for this functionality.

I'm using the functions mse, mae and auc from the ModelMetrics package. They take a vector of actual values and a vector of predicted values. There doesn't appear to be any option for accounting for weighting.

Does anyone have any ideas? I'm guessing I will need to make my own version of the functions, but I'm unsure how to go about doing this.