airtime | open source radio software for scheduling and remote

Gurus, I need your support to skip all Less than or Equal to 0 values for each customer in following data. Specifically script should skip all columns which contain less than or equal to 0 values.

Input Data and Required Output is available in screenshot for reference

so the idea is, values in all columns from column C to H should remain as is until the SUM of these columns exceed the value mentioned in B column (TOTAL DEPOSIT) and then remaining should be adjust for last value (see attached screenshot for reference)

I have a code snippet which works great in Pandas, however my data size quite high and Pandas consumes a lot of memory. This is where I am trying to have a solution based on either PySpark or Koalas since both are Spark based and Highly scalable. Since I am new to Spark, I'm not sure how regex and replace strings can be optimized of this scale.

My Code snippet:

I have a dataframe(original_df) with column description, and I want to create another column Label by searching for keyword in the description using regular expression e.g

I tried searching other similar issues but couldn't find the solution for me, so apologies if the question is duplicated, I am also just 2 months old at this so any learning opportunity from my seniors is a blessing . Working on a web application that is supposed to keep records of operators in the field and their equipment, the frame work is up but I am facing some issues: 1. The login has 2 authentication levels, 'admin' and 'op', I got this to work better than I had hoped for, until I realized if someone copied the links to pages only accessible after login, they had access. I checked here and other places and found out it had to do with sessions, I wasn't using them because I mistakenly thought I had set the php.ini auto sessions on, but that was before I switched from the free server I was using where I controlled the files to a paid shared server, so I included sessions now and wrote a script(header.php), to check whether user has a session registered or else redirect them to the login page. The issue is when I include the script at the top of the pages I want to protect, even authenticated users are redirected back to the login page, if I don't include the script, authentication is fine but the restricted pages are not protected from using direct links. Below is the code;

authentication code(authentication3.php)

I am trying to import csv into pgadmin4.

I keep getting an error code 1, but no details.

the command log:

Here are the tables

TAGS :

TRANS_TAG

The following are default tags (SENT, AIRTIME, RECEIVED, PAID), the rest are not default tags. The TRANS_TAG table tracks a transaction id and the tags attached to it.

I would like to write a select SQL statement that selects from these two tables and achieves the following result. - it returns a list of all the tags that have been attached to at least one transaction. it then orders them alphabetically but grouped with the default tags first.

This is the desired result

This is the code that I have so far

I have a request to develop an inventory system for a warehouse that deals in airtime recharge cards. Per the requirement they can load serial numbers into the database which can be a minimum of about 100 million individual records. I need to get a function that can accept two strings and use that to generate the individual records within that range as below. But I know this is not an effective way of generation and insertion into the database, kindly help

I am using the google-cloud/logging-winston nodejs package for logging, and I created my custom formatter for output this way:

I have this challenge. I want to make use of the username gotten from the login component, once the user Logs in and authenticates successfully, it should inturn save the username so it can used on all pages in the application. I am kind of new to React Native development, so to use sessions i am not really conversant with it.

I would like to know How do I save the username from the Login form, so I can use it in all pages in the application. I tried doing something like