manners | A polite Go HTTP server | HTTP library

I'm trying to create several new columns in a pandas dataframe that merge portions of multiple other columns based on year (yet another column) and column headers. The layout of the dataframe currently is:

2000_A1 2000_A2 2001_A1 2001_A2 Year Latitude Longitude 2 8 0 3 2000 43.65 -76.26 3 8 9 4 2000 43.66 -76.26 3 2 5 3 2000 43.67 -76.26 4 6 5 1 2001 43.68 -76.26 7 8 2 0 2001 43.69 -76.26 1 3 1 1 2001 43.70 -76.26

I would like to create a dataframe that has two new columns (A1 and A2) that combine values based on year, as long as the year matches the column header. Originally, these were two separate dataframes that I merged (pd.merge()) based on coordinates (lat/long), which is why they're organized in different manners. Ideally, the new dataframe would look like this:

2000_A1 2000_A2 2001_A1 2001_A2 Year A1 A2 Latitude Longitude 2 8 0 3 2000 2 8 43.65 -76.26 3 8 9 4 2000 3 8 43.66 -76.26 3 2 5 3 2000 3 2 43.67 -76.26 4 6 5 1 2001 5 1 43.68 -76.26 7 8 2 0 2001 2 0 43.69 -76.26 1 3 1 1 2001 1 1 43.70 -76.26

If possible, I would like to use a for loop to create these new columns - in my actual dataset, I have about 20 years and either 7 or 9 'A's for each year, so some sort of iterative loop would be great. I'm new to python and struggling to figure out how to approach this, so any help would be much appreciated.

...

I am looking to combine 10 audio samples in various manners (format - wav probably, but this can be changed to any format as they will be pre-recorded).

...

I'm trying to remove specific numbers and characters from the column names in a data frame in R but am only able to remove the numbers, have tried different manners but still keep the characters at the end.

Each column is represented as letters and then a number in parenthesis; e.g. ASE (232)

DataFrame ...

I have 2 arrays of the following format:

...

I want to create an Excel Table where the first column is the "SL" (serial number) column that starts from 1 and then increases by 1 for each subsequent entry. I want the serial number to automatically increase as I add more rows to the table.

I have tried using all manners of "=ROWS" functions, all manners of "=COUNTA" functions, and all other functions used in tutorial that I found in the web. None of them are immune from sorting or filtering. That is, if I sort the "Name" column from A to Z, the serial number that was assigned to its respective row entry changes because of how these formulae are written. For example:

This is the Original List. As you can see, Dragon Fruit's serial number is 1. I have used the "=COUNTA(B$2:[@[NAME]])" function in this example.

As you can see, when I sorted the "Name" column from A to Z, Dragon Fruit's serial number went from 1 to 2, Acai went from 4 to 1, Guava went from 9 to 3, and so on. But I want the serial numbers to be static and locked to their corresponding "Name".

Is this possible to do in Excel without manually typing the numbers in the SL column?

...

I wouldn't mind so much but this is associated with all manners of spontaneous graphical glitches:

...

I am working on a Information Retrieval model called DPR which is a basically a neural network (2 BERTs) that ranks document, given a query. Currently, This model is trained in binary manners (documents are whether related or not related) and uses Negative Log Likelihood (NLL) loss. I want to change this binary behavior and create a model that can handle graded relevance (like 3 grades: relevant, somehow relevant, not relevant). I have to change the loss function because currently, I can only assign 1 positive target for each query (DPR uses pytorch NLLLoss) and this is not what I need.

I was wondering if I could use a evaluation metric like NDCG (Normalized Discounted Cumulative Gain) to calculate the loss. I mean, the whole point of a loss function is to tell how off our prediction is and NDCG is doing the same.

So, can I use such metrics in place of loss function with some modifications? In case of NDCG, I think something like subtracting the result from 1 (1 - NDCG_score) might be a good loss function. Is that true?

With best regards, Ali.

...

I've been recently hired as an intern, and a challenge my area has come accross is how to highlight the closest available medical appointment.

Of course, I know that in excel such a thing would be pretty simple, with a matrixial formula like {=MIN(IF( range > current_date_and_time ; range ))} and as such, in PowerBi it should be just as simple.

However, the PowerBi table the area is dealing with shows the entire agenda and another column indicates if it has been reserved or not (with a 1 and 0). So, I'm wondering how to incorporate this condition toe excel formula, and in the end, how to get the closest AVAILABLE appointment in the agenda.

Eventually, the idea is to apply this "filter" for each doctor, and then aggregate by area.

I also know that good manners dictate I show you the data, but this is work related, so I can't do that.

Thanks beforehand, and sorry for the trouble

...