Louis | Miasto Kreatywne | iOS library

So I have the following data:

And I have read it into python using read_excel() and done some transformations giving me the following pandas dataframe:

Now I want to make a dictionary where all pairs in each row returns the "Pr Unit Cost" of the row as the value like so:

I'm working on a dataset that can have a lot of duplicates, and I want to deduplicate it based on 2 columns, and take the first non null value of each row in every 'group' of duplicates. The only problem is that there are two 'ID' columns that I don't want to lose any information from.

EDIT: to explain it a bit better. We assume that all rows that have the same combination of name/city are the same person. I want to have as few rows as possible in the dataset without losing any information from my_first_id and my_second_id.

Here is an example of my data:

I have a text file containing x,y,z coordinates of different points. Following is the format of the input file:

I am looking for a way to apply different Pandas groupby functions (like "mean", "min" or "max") on columns, depending on the beginning of their names.

The way I proceed at the present time is described as follows:

• dynamically create lists of columns that start with X, Y or ...
• dynamically create lists of functions to apply to each group of columns
• merge the lists of columns with their corresponding functions into dictionaries
• merge the dictionaries into the "agg" function:

My problem is pretty simple but I want your advice on the matter! I have an excel document that contains 2 sheets... The first sheet look like this :

I've been trying to solve the following problem : I try to upgrade this Frontend Mentor project https://haydee75.github.io/galleria/ from React Router v5 to v6. I tried to replace the code between with :

Im working through some self-join examples and I am drawing a blank on the following example. Its the last example at the following link Self-Join Example

I have to manipulate data in this wonderful language which is javascript. Until there I managed to achieve what I needed on my own but I reached my limits there.

It's quite hard to explain how my data is structured so let's make a schema. This is what I have :

I've read in two .jpg files using image_read (from the magick package) and then used cat and image_ocr to extract text from both and combine them into one return. This does return the text, but with quite a few errors that will need rectified using regular expressions. However, I can't seem to use the regular expressions and have it return the text again. This was originally showing the class of the vector as "NULL", so I added in the as.character function to my preceding code hoping that would allow me to return the text after using regular expressions, but it only returns "character(0)" now. I have tried using lapply to convert the vector to character, and tried using unlist(text) to see if that helped, but got similar results. Here is what I have currently: