Posts by Rogér • 27 points
12 posts
-
0
votes1
answer251
viewsQ: Additional filter for groupby
The following code groups my DF by some columns f0219.groupby(['Matricula', 'Nome', 'Rubrica', 'Valor', 'CodigoRendimentoDesconto', 'Tiporubrica']).Rubrica.count() and counts how many times the…
-
0
votes0
answers36
viewsQ: Criteria for sending email - google-appscript subtraction module
The goal of the following code snippet is to take a date that is in column 5 subtract it from today’s date and, if the module of this division is equal to zero, an email is sent. In case, I want an…
-
-1
votes1
answer60
viewsQ: JOIN - Beginner’s Question
I have a question about full outer join, I researched and still do not understand. The last figure below explains, graphically, the operation of full outer join, that returns only the data not…
-
-1
votes1
answer98
viewsQ: Join three functions in one (one file)
I have three independent functions, which perform separate tasks. I would like to combine these three functions into one, but to do the same thing that the three of you do independently. How can I…
javascriptasked Rogér 27 -
1
votes0
answers99
viewsQ: Record date of change of two cells in one
The following code detects whether a change has been made to a cell in column I or J, and records the date and time the change occurred in column M and N. I want there to be only one record, that…
-
0
votes0
answers84
viewsQ: Script sends email
I created a script in a google sheet, with the following code, which should send an email, when the type of alert is daily, and sending, which takes the email from column F, should only happen if…
javascriptasked Rogér 27 -
1
votes1
answer36
viewsQ: Copy URL to a column according to a criteria
I am trying with the following code to take the URL of an entire row and store it in a "J" column if another "E" column contains some value, that is, it is not empty. The code executes, however,…
javascriptasked Rogér 27 -
-3
votes1
answer41
viewsQ: Several functions in one
I have two independent functions that apply spreadsheet formatting to googledocs, and I would like to merge them into one. These are functions 1 and 2 below. FUNCTION 1 function nomeColunas() { var…
javascriptasked Rogér 27 -
1
votes1
answer562
viewsQ: Stacked dice. How to work this on pandas?
I have a table that is structured with "stacked" data, that is, all the information of a customer occupies a few first lines. Once the customer’s information is complete, the next client takes the…
-
0
votes2
answers65
viewsA: Difference between tables, criteria
I got what I wanted with this solution I mentioned on the link. As I wanted q me return the table of the left q is not on the right, I used current.Where(~current['Favored CPF'].isin(next['Favored…
-
0
votes2
answers65
viewsA: Difference between tables, criteria
Well, I did so: I named the left dataframe as "newPas" and the right as "newFolla", and created the newResult variable, with the result of the difference between the two. It looked like this:…
-
0
votes2
answers65
viewsQ: Difference between tables, criteria
I have two tables like the following:I want to get the data that are in the Table on the left and that are not in the right. Since the two tables have a common field, CPF, I want to generate another…