Hello Stackoverflow Community, I was wondering if it is possible to filter with in a groupby function in pandas and the reason why is because I want to find out for each gender what is the total number of mobile users. In my dataset we have a Boolean column named mobile where if a customer… Read More Can you filter with in a groupby function in pandas?

I am looking for an algorithm that counts a given number of states in Python. There is a string like this: 10?01?011 with "0, 1, ?" it was made. The question mark can be 0 or 1. The program should enumerate all the states that question marks can have in a string. For example, in… Read More Count algorithm

I’m a beginner with google sheets/exel formulas so i’m having trouble to count how many rows there are until I get a specific value, and this, multiple times in a same column. Example bellow, I would like to set an ARRAYFORMULA in B1 so I can get those results: Row\Column A B 1 Value Result… Read More How to use an ARRAYFORMULA to count how many rows there are untill I get a specific value at multiple times?

What I want to do is to count the amount of each word in array, but my code also adds the index number of element which amount it counts let array = [‘brown’, ‘apple’, ‘engine’, ‘engine’, ‘engine’, ‘brown’, ‘cell’, ‘Derek’] let shortened = […new Set(array)].sort() for (let i = 0; i < shortened.length; i++) {… Read More Array Elements Repetition Counting

I want to count the number of times a word appears but only once per row. How do I complete the code? library(stringr) var1 <- c("x", "x", "x", "x", "x", "x", "y", "y", "y", "y") var2 <- c("x", "x", "b", "b", "c", "d", "e", "y", "g", "h") var3 <- c("x", "x", "b", "b", "c", "d",… Read More Counting the occurrence of a word but only once per row (R)

In a table I have two fields, an aircraft type code and a serial number. I’d like to count how many times a combination of these exist in the table. As aircraft sometimes get reregistered doubling is unavoidable. Is there a method that I can use to see how many times combinations of the same… Read More How to count existing field combinations in SQLIte

Hello I was trying to count words in a text but there’s a problem. If I write code like def popular_words(text:str, list:list)-> dict: text=text.lower() splited_text=text.split() answer={} for word in list: answer[word]=splited_text.count(word) return answer print(popular_words(”’ When I was One I had just begun When I was Two I was nearly new”’, [‘i’, ‘was’, ‘three’, ‘near’])) ‘… Read More What is the difference between two codes that count words in a text?

I have a python list containing zeros and ones like this: a = [1.0 1.0 0.0 0.0 1.0 0.0 1.0 0.0 0.0] I know how to count the ones and zeros in this, but what I can’t manage to figure out is how to count the last zeros after the last 1.0 in that list.… Read More How do I count the last elements in a list after a certain element?

I want to know the way of counting the number of observations using R. For example, let’s say I have a data df as follows: df <- data.frame(id = c(1,1,1,2,2,2,2,3,3,5,5,5,9,9)) Even though the biggest number of id is 9, there are only 5 numbers: 1,2,3,5,and 9. So there are only 5 numbers in id. I… Read More Count the number of observations in the data frame in R

I apologize if this has been asked before, I tried searching but couldn’t find exactly what I’m looking for. I want to highlight rows in Google Sheets using conditional formatting if two different rows have duplicate data in column E, and they also have duplicate data in column F. I’m currently using =AND(countif($E:E,$E1)>1,countif($F:F,$F1)>1) which seems… Read More Highlight row using conditional formatting if duplicate in two different columns of same row in Google Sheets