Tag: a

In Excel, how do i check if cell contains at least twice the same character from a list

Post author By How To
Post date October 28, 2020
No Comments on In Excel, how do i check if cell contains at least twice the same character from a list

I have a list: "2","3","4","5","6","7","8","9","A","K","J","Q","T" Then I have cells: 6s 3d 3c yes (2) 6s 3s 2d no 6s 3s 2s no 2s 2d 2c yes (3) ….. I want to check if the cell A6 (here 6s 3d 3c) contains at least 2 times the same character from the list above and returns yes […]

Tags "T" Then I have cells: 6s 3d 3c yes (2) 6s 3s 2d no 6s 3s 2s no 2s 2d 2c yes (3) ..... I want to check if the cell A6 (her, 3, 4, 5, 6, 7, 8, 9, a, I have a list: "2", j, K, Q

Mastering Development

Python numpy groupby multiple columns

Post author By Full Stack
Post date October 28, 2020
No Comments on Python numpy groupby multiple columns

Is there a way to make a group by aggregation by multiple columns in numpy? Im trying to do it with this module: https://github.com/ml31415/numpy-groupies Goal is to get a faster groupby than pandas. for example: group_idx = np.array([ np.array([4, 3, 3, 4, 4, 1, 1, 1, 7, 8, 7, 4, 3, 3, 1, 1]), np.array([4, […]

Tags 'column2', 'column3']).sum().reset_index(), 1, 1]) ] a = np.array([1, 1]) result = aggregate(group_idx, 14.1, 2, 3, 4, 5, 7, 8, a, func='sum') It should be like pandas df.groupby(['column1', Is there a way to make a group by aggregation by multiple columns in numpy? Im trying to do it with this module: https://github.com/ml31415/n, np.array([(1, np.array([4

User Help Web Apps

Case statements in SWITCH statements in Google Sheets

Post author By Math Dev
Post date October 27, 2020
No Comments on Case statements in SWITCH statements in Google Sheets

I’m updating a Google Sheet. In that Google Sheet, I need to display a student’s grade based on specific cut offs. I thought a SWITCH statement would be the correct approach. However, based on that documentation, it looks like the case statements are mappings instead of conditionals. This seems incorrect. I feel like I’m misunderstanding […]

Tags 85, a, B, based on that documentation, c--, d, f: '' }, I have the following SWITCH statement. =SWITCH(85, I need to display a student's grade based on specific cut offs. I thought a SWITCH statement would be the correct approach. However, I'm updating a Google Sheet. In that Google Sheet, it looks like the case statements are mappings instead of conditionals. This seems incorrect. I feel like I'm misunderstanding something. At

Arduino Ask Engineering

Send custom HID values instead of keys

Post author By Marcia D.
Post date October 27, 2020
No Comments on Send custom HID values instead of keys

I’ve been building a small macro keypad based on the ATmega32U4. So far, I’ve been able to send standard key presses to the host. But since I want a program on the host system to react to the key presses, I only send the keys to serial to avoid typing anything. For now, this does […]

Tags 'g' } }; byte rowPins[rows] = { 10, "\t", "rows": [ [ "", "w", 14 }; byte colPins[cols] = { 9, 16, 2, 3, 4, 5, 5 }; Keypad keypad = Keypad( makeKeymap(keys), 6, 7, 8, a, colPins, cols ); void setup(){ Serial.begin(9600); } void loop(){ char key = keypad.getKey(); if (key != NO_KEY){ Serial.println(key);, d, e, f: '' }, I only send the keys to serial to avoid typing anything. For now, I've been able to send standard key presses to the host. But since I want a program on the host system to react to the key presses, I've been building a small macro keypad based on the ATmega32U4. So far, most of them are just about building a regular keyboard or gamepad but don't go into how to make use of anything else. This is what I got so, Q, r, rowPins, s, this does work. I want to send custom HID values to the host which won't result in regular key presses. As I've been reading around differen

Mastering Development

Gettng the indexes of items and putting the indexes in a different array

Post author By Full Stack
Post date October 27, 2020
No Comments on Gettng the indexes of items and putting the indexes in a different array

I am specifically wondering why this solution does not work. You are supposed to create a function that returns the indices of all occurrences of an item in the array. Given the array [‘a’, ‘a’, ‘b’, ‘a’, ‘b’, ‘a’] I am wanting to find all the indexes of the element ‘a’, and put it in […]

Tags 'a'] I am wanting to find all the indexes of the element 'a', 0, 0] Why is this?, a, and put it in another array I know there are different ways to do this, B, but i did this function getIndices(arr, el) { a = []; for(i of arr){ if(i === el) a.push(Number(arr.indexOf(i))); } return a; } but when i ran it all that r, I am specifically wondering why this solution does not work. You are supposed to create a function that returns the indices of all occurrenc

Mastering Development

sorting along multidimensional index in numpy

Post author By Full Stack
Post date October 26, 2020
No Comments on sorting along multidimensional index in numpy

I have a three dimensional array, that I need to sort. I also have a 2 dimensional index that I got with a lexsort that I would like to use for sorting. I cannot find how to apply the index to the array without extra dimensions sprouting up… import numpy as np a = np.array([ […]

Tags :, [2 0 3 5 4 1], [5 4 1 2 0 3]] the end result should be a_sorted = np.array([ [ [-1, ], ]) I tried. a[sorted_index] a[sorted_index, ]) sorted_index = np.lexsort((a[:, 0, 1, 2, 3, a, axis=1) sorted_index is [[3 0 2 1 4 5], but I would like to do it properly., I have a three dimensional array, sorted_index] I am about to loop through the thing, that I need to sort. I also have a 2 dimensional index that I got with a lexsort that I would like to use for sorting. I cannot find how to a

Mastering Development

How do I update a table inside a python interface on Tkinter with input?

Post author By Full Stack
Post date October 24, 2020
No Comments on How do I update a table inside a python interface on Tkinter with input?

I am developing a python interface with login and an information table, but I found an obstacle that is preventing me from moving. I have tried to make the user able to modify (or update) a data table. At first I thought I would just need to give the row id and the chosen column […]

Tags ?, ?)""" entrada1 = entrada, 'height'=>'120']], 'id', 'nome', "14", "bold"), "Idade" INTEGER, "QDM" TEXT, "Quantidade" TEXT, "Situação" TEXT, "TOX" TEXT NOT NULL, "User" TEXT NOT NULL, 10, 16, 20, a, as data entry and deletion work normally(The WHERE command is not recognized either.). How can I update the table with data entered by the u, B, bg="#585858", bg="#cfc91c", bg="#cfc91c") buttonFrame.place(x=140, bg="#cfc91c") label1Frame.place(x=85, bg="#cfc91c") label2Frame.place(x=85, bg="#cfc91c") LeftFrame.place(x=85, but I found an obstacle that is preventing me from moving. I have tried to make the user able to modify (or update) a data table. At first I, but unfortunately for some reason, c--, columns=['A', columns=['x', command=change) botao4.place(x=441) change = Button(centerframe, command=change2) change.place(x=441) botao5 = Button(centerframe, command=changeconfirmed) botao7.place(x=441) botao71 = Button(centerframe, command=changeconfirmed2) botao71.place(x=441) botao8 = Button(centerframe, command=insert) botao3.place(x=441) insert = Button(centerframe, command=insert2) insert.place(x=441) botao4 = Button(centerframe, command=insertconfirmed) botao6.place(x=441) botao61 = Button(centerframe, command=insertconfirmed2) botao61.place(x=441) botao7 = Button(centerframe, command=login, command=Return) fecharb.place(x=20, command=tox) botao2.place(x=112, command=trash) botao5.place(x=441) excluirtrash = Button(centerframe, command=trash2) excluirtrash.place(x=441) # botoes para confirmar botao6 = Button(centerframe, command=trashconfirmed) botao8.place(x=441) botao81 = Button(centerframe, command=trashconfirmed2) botao81.place(x=441) # termina aqui botoes para confirmar # termina aqui botões, command=trip) botao1.place(x=20, end=''), entrada) Banco.conn.commit() print("deu certo idade!") elif escolha == "Q. Despejada, entrada) Banco.conn.commit() print("deu certo situação!") def trash2():, entrada1) conn.commit() print("deu certo nome!") def change(): botao7.place(x=80, entrada1) conn.commit() print("deu certo nome!") def change2(): botao71.place(x=, entrada2, entrada3 cursor.execute(banco, especially this one using "% s", fg="#585858") Acessolabel.place(x=3, fg="#585858") labelid.place(x=401) labelid2 = Label(centerframe, fg="#585858") labelid11.place(x=401) labelid21 = Label(centerframe, fg="#585858") labelid2.place(x=401) labelid11 = Label(centerframe, fg="#585858") labelid21.place(x=401) labelid3 = Label(topFrame2, fg="#585858") labelid3.place(x=441) labelid4 = Label(centerframe, fg="#585858") labelid4.place(x=401) labelid41 = Label(centerframe, fg="#585858") labelid41.place(x=401) labelid5 = Label(centerframe, fg="#585858") labelid5.place(x=401) MT = Label(centerframe, fg="#585858") MT.place(x=401) QT = Label(centerframe, fg="#585858") QDM.place(x=441) # termina aqui labels da entrada TABELAS # entrada TABELAS en, fg="#585858") QT.place(x=401) QDM = Label(topFrame2, fg="#585858") texto1label.place(x=3, fg="#585858") texto2label.place(x=3, fg="#585858") titulolabel.place(x=55, fg="#585858") userLabel1.place(x=17, fg="#585858") userLabel2.place(x=18, fg="#cfc91c", fg="#cfc91c") EntrarBotao.place(x=35, fill=BOTH) tree1.place(x=500) tree1.heading("#0", fill=BOTH) tree2.place(x=500) tree2.heading("#0") tree2.column("#0", font=("Arial", funcao) Banco.conn.commit() print("deu certo idade!") elif escolha == "Situação":, funcao) Banco.conn.commit() print("deu certo situação!") def trash(): bo, funcao) Banco.conn.commit() print("update successfully") elif escolha == "Idade":, funcao) Banco.conn.commit() print("update successfully") Some words are in Portuguese because I'm Br, funcao) Banco.cursor.execute(banco, height:100}}, height=10) tree1.pack(expand=YES, height=10) tree2.pack(expand=YES, height=227, height=50, height=False) # mapa LeftFrame = Frame(jan, highlightbackground="#cfc91c", highlightcolor="#cfc91c", highlightthickness=10) jan.resizable(width=False, I am developing a python interface with login and an information table, Id banco = (""" UPDATE Navio SET Nome = %s WHERE Id = %s """), Id cursor.execute(banco, idade: '', message="ACESSO NEGADO. POR FAVOR MANTENHA DISTÂNCIA DO NAVIO.") # termina aqui login comando # botao EntrarBotao = Button(buttonFrame, minwidth=0, nome TEXT, none of my attempted commands worked. Below is my last failed attempt: def changeconfirmed(): escolha = entry.g, none worked :(, Password TEXT NOT NULL, password)) print("Clicou!") verifylogin = Banco.cursor.fetchone() try: if user in verifylogin and password in verifylogin, PRIMARY KEY("Id" AUTOINCREMENT) );, PRIMARY KEY("Id" AUTOINCREMENT) ); CREATE TABLE "TOXICO" ( "Id" INTEGER, PRIMARY KEY("Id") ); CREATE TABLE "Users" ( "Id" INTEGER NOT NULL, QDM FROM TOXICO" cursor.execute(sql2) rows2 = cursor.fetchall() total1 = cursor.rowcount prin, QDM) VALUES(?, Quantidade, relief="raise") centerframe.place(x=20, relief="raise") centerframe2.place(x=170, relief="raise") topFrame.place(x=20, relief="raise") topFrame2.place(x=20, selectmode="extended", show="*") userSenha.place(x=105, Situação FROM Navio" cursor.execute(sql) rows = cursor.fetchall() total2 = cursor.rowcount pr, Situação) VALUES(?, stretch=NO) tree2.heading("A", text="") tree1.column("#0", text="←", text="Acesso Restrito", text="Alterar:", text="Entrada:", text="Entrar", text="Este programa é de uso restrito ", text="Excluir Linha Id:", text="Excluir:", text="Id:", text="Id") tree1.column("x", text="Idade:", text="Idade") tree1.column("A", text="Inserir:", text="Material Tóxico:", text="Material Tóxico") tree2.column("A", text="Nome da Coluna:", text="Nome:", text="Nome") tree1.column("z", text="para somente pessoas autorizadas.", text="Q. Despejada no Mar") tree2.column("C", text="Q.D.M.:", text="Quantidade:", text="Quantidade") tree2.column("B", text="Senha:", text="Sistema de Informações", text="Situação:", text="Situação") tree1.column("B", text="Sub. Tóxicas", text="Tripulação", text="Usuário:", the interpreter says that it does not recognize the '%'. Unfortunately that's all that prevents me from finishing the interface, update) jan = Tk() jan.title("RESTRITO") jan.geometry("500x405") jan.configure(background="#585858", update) jan.update() jan.mainloop() References: Inserir = Insert Alterar = Change Excluir = Delete Entrada = Input Escolha = Choice DataBas, User>();, values=i) except: messagebox.showinfo(title="", values=i) for i in rows2: tree2.insert('', width: 1, width=-1) tree1.heading("x", width=125) # termina aqui tabela # função sql for i in rows: tree1.insert('', width=15, width=150, width=152) # termina aqui tabela # tabela TOXICO tree2 = ttk.Treeview(centerframe2, width=19) entry.place(y=500) entry1 = ttk.Entry(centerframe, width=19) entry2.place(y=500) entry3 = ttk.Entry(centerframe, width=19) entry4.place(x=500) # termina aqui entrada # tabela TRIPULAÇÃO tree1 = ttk.Treevie, width=20) tree1.heading("A", width=200, width=290, width=3) entry1.place(y=500) entry2 = ttk.Entry(centerframe, width=3) entry3.place(y=500) entry4 = ttk.Entry(topFrame2, width=30, width=30) userUsuario.place(x=105, width=310, width=40) tree1.heading("B", width=440, width=72) tree2.heading("C", width=92) tree2.heading("B", width=96) tree1.heading("z", y=10) botao2 = Button(topFrame2, y=10) botao3 = Button(centerframe, y=10) texto1label = Label(LeftFrame, y=10) userLabel2 = Label(label2Frame, y=11) # termina aqui usuario e senha entrada # login comando def login(): user = userUsuario.get() password = userSenha.get() B, y=12) # esconder botao6.place(x=401) labelid41.place(x=401) botao8.place(x=4, y=12) # esconder botao7.place(x=401) botao8.place(x=401) entry1.place(x=401, y=12) # termina aqui botao l = tk.Label() l.pack() l.place(x=501) jan.after(1000, y=12) botao71.place(x=441) botao81.place(x=441) labelid5.place(x=401) entry1, y=12) labelid.place(x=15, y=12) labelid5.place(x=80, y=12) MT.place(x=15, y=125) # esconder botao7.place(x=401) botao6.place(x=401) botao61.place(x=40, y=125) labelid2.place(x=15, y=125) labelid21.place(x=15, y=125) QT.place(x=15, y=13) userSenha = ttk.Entry(label2Frame, y=140) # termina aqui mapa # labels titulolabel = Label(topFrame, y=140) centerframe2 = Frame(jan, y=15) botao4.place(x=15, y=15) change.place(x=15, y=15) entry.place(x=15, y=150) entry2.place(x=15, y=150) labelid41.place(x=15, y=170) # esconder botao6.place(x=401) botao8.place(x=401) botao61.place(x=40, y=170) labelid3.place(x=220, y=170) QDM.place(x=220, y=180) label2Frame = Frame(jan, y=195) entry3.place(x=110, y=195) entry4.place(x=280, y=195) entry4.place(x=285, y=20) botao1 = Button(topFrame2, y=20) topFrame2 = Frame(jan, y=220) buttonFrame = Frame(jan, y=25) # termina aqui labels # "#585858" "#cfc91c" # funções def Return():, y=280) # termina aqui mapa # titulo e texto Acessolabel = Label(LeftFrame, y=50) label1Frame = Frame(jan, y=50) texto2label = Label(LeftFrame, y=55) botao5.place(x=15, y=55) entry.place(x=15, y=55) excluirtrash.place(x=15, y=8) userUsuario = ttk.Entry(label1Frame, y=80) # temina aqui titulo e texto # usuario e senha entrada userLabel1 = Label(label1Frame, y=90) centerframe = Frame(jan, y=95) # termina aqui botões # puxar tabela TOXICO tree2.place(x=0) # termina, y=95) # termina aqui botões # puxar tabela TRIPULAÇÃO tree1.place(x=0) # ter, y=95) entry1.place(x=15, y=95) entry4.place(x=280, y=95) labelid11.place(x=15, y=95) labelid5.place(x=80, y=95) MT.place(x=15, z

User Help Web Apps

Case statements in SWITCH statements in Google Sheets

Post author By Math Dev
Post date October 24, 2020
No Comments on Case statements in SWITCH statements in Google Sheets

Tags "Unknown") 85 is the value in a cell. I manually put it in to debug. However, 85, a, B, based on that documentation, c--, d, f: '' }, I have the following SWITCH statement. =SWITCH(85, I need to display a student's grade based on specific cut offs. I thought a SWITCH statement would be the correct approach. However, I'm updating a Google Sheet. In that Google Sheet, it looks like the case statements are mappings instead of conditionals. This seems incorrect. I feel like I'm misunderstanding something. At, this statement always results in "Unknown". Is there a way to use conditional statements in a SWITCH statement? Thank you.

Android User Help

What happened to my dotted underline in the keyboard suggestion strip?

Post author By Jessica Alba
Post date October 24, 2020
No Comments on What happened to my dotted underline in the keyboard suggestion strip?

I’ve recently upgraded my phone, and have mostly managed to get the keyboard back to how it was, with one exception. When I used glide typing before on my old phone (AOSP keyboard), the middle word in the suggestion strip had a dotted line underneath that allowed me to long-press on a suggestion (‘be’, ‘a’, […]

Tags a, and have mostly managed to get the keyboard back to how it was, I've recently upgraded my phone, or 'so') and get a popup list of more suggestions: On my new phone (Gboard), the middle word in the suggestion strip had a dotted line underneath that allowed me to long-press on a suggestion ('be', this no longer happens and a long-press merely prompts me to remove the suggestion: What happened to this functionality and can I get it bac, with one exception. When I used glide typing before on my old phone (AOSP keyboard)