Posts by Roger Regor • 25 points
14 posts
-
0
votes0
answers32
viewsQ: Iteration Googleappscript
I made the following code to iterate and take the value of two columns, B and E. If "B" contains the value SIM and "E" is empty, it adds "1" to the counter, and returns the sum at the end. However,…
-
-2
votes1
answer55
viewsQ: Repeat code for the same product group
I have a spreadsheet with thousands of products according to the example below, where the code is only in the type of service (left column), and I want it to be in all products of the same type…
-
0
votes1
answer21
viewsA: MAP function applied to only one column
I solved with ifs by applying a function in the column. row = aip['Carreira'] def get_description(row): if row == 'Ajudante': return 'Outros' elif row == 'Auxiliar Geral': return 'Outros' elif row…
-
-1
votes1
answer21
viewsQ: MAP function applied to only one column
I’m trying to map the value "Others" to a "Career" column, according to some criteria. For example, when the column contains the Recycle Bin or Helper value, I want that value replaced by the Other…
-
0
votes1
answer35
viewsA: Graphic description in overlapping pizza
I settled this with: counts.plot(kind='pie', labels = None, figsize=(11,8), legend=True)
-
-2
votes1
answer35
viewsQ: Graphic description in overlapping pizza
How to solve this? Captions of the pie chart overlapping with others.…
-
0
votes1
answer290
viewsQ: groupby - add according to criteria
I intend to sum up all the earnings of an employee, by his Cpf, but only when he wins 100, disregarding other amounts. I’m using this code, but it’s not right: aip.groupby(['CPF']).sum()…
pandasasked Roger Regor 25 -
0
votes0
answers38
viewsQ: Sum earnings of the same employee
I’m trying to sum up all the earnings of an employee (cumulative sum), but I’m not getting it. The code is following: function teto() { var ss = SpreadsheetApp; //seta a planilha var planilhaAtiva =…
-
1
votes1
answer22
viewsQ: Send email if value meet a criterion in the column
I have a code that reads a "yes" value in a column and sends an email if that value is there. However, the if that I created for this sends even if the value "yes" is not there. The code is below.…
-
1
votes0
answers33
viewsQ: Send string to spreadsheet via email
Hello, I have a spreadsheet in Googledocs, which sends, via script, an email alert to the user when the deadline for a task is expiring. I would like the user, when receiving this message, to have…
-
1
votes0
answers330
viewsQ: script to insert formula
Well, I’ve come up with a script to check if a column contains a formula, and if it doesn’t, it inserts. I’m doing this because every time I fill out a form, the formula that was before in the cell…
-
0
votes2
answers68
viewsA: script le email field in googledocs
Here’s my code. I adapted it with your solution, but it’s giving an error: function sendEmails() { var sheet = SpreadsheetApp.getActiveSheet(); var startRow = 0; // First row of data to process var…
-
0
votes2
answers68
viewsQ: script le email field in googledocs
Hello, I have a spreadsheet in Googledocs, which has a field with one or more emails, in this case, seperados by comma. The script reads the field and sends an email to the registered destination in…
-
0
votes1
answer71
viewsQ: How to change color in html
I am trying to change a snippet of HTML code to red, but the code below is not right. I thought that color="red" would work. Note: this is html embedded in javascript. When I remove the color…