Please see image below, I am looking to populate cells G8-G12 with a value of how many times the day appears in Column B and has a unique date in Column A. So as an example, Wednesday would count 2 as it appears on 28/02/2024 and 06/03/2024. How do I do this? I’ve tried SUMPRODUCT… Read More Excel – Count only instances of unique values in two columns
I have data.frame df1: df1 <- data.frame(apple = c(‘0’, ‘0’, ‘0’, ‘1’, ‘0’, ‘1’, ‘0’, ‘0’, ‘0’, ‘1’), banana = c(‘1’, ‘0’, ‘0’, ‘0’, ‘1’, ‘0’, ‘1’, ‘0’, ‘0’, ‘0’), cherry = c(‘0’, ‘1’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘1’, ‘0’, ‘0’), date = c(‘0’, ‘0’, ‘1’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘1’, ‘0’)) rownames(df1)… Read More Collapse multiple columns into one column based on values in R
I have a column of character string with each row containing information for multiple columns, including the column names. Every cell is structured so one can easily see the different pieces of information, but it is not easy to work with in this format. A cell is formatted like ‘variable: value’, with multiple inputs separated… Read More Using R to split a structured string into multiple columns and set column names based on string values
I want to find out if any of the value in columns mark1, mark2, mark3, mark4 and mark5 are the same, column-wise comparison from a dataframe below, and list result as True or False import pandas as pd df = pd.DataFrame(data=[[7, 2, 3, 7, 7], [3, 4, 3, 2, 7], [1, 6, 5, 2, 7],… Read More Pandas compare values of multiple columns
I want to replace different values in different columns using another data frame df1 v1 v2 v3 v4 RDA NA ILL NA OPCS NA NA NA OJK BR ILL PE df2 v1 v2 v3 v5 RDA COL ILL P3 OPCS BR ILL P2 and I would like the output data frame to look like this:… Read More Replace multiple values using another dataframe
I would like to generate a table with 2 columns, with pre-defined parameters for each column, like the picture below: What I have in R code so far for the first column is: current_point<-50 lower_bound<-40 upper_bound<-60 size<-2 seq(start,end,by=size) I am able to generate an array from the lines, however, I am stuck when it comes… Read More generating a table in R, with defined parameters
I have two datasets called ‘ro’ and ‘rt’ with different lenght, in each dataset we have a column called ‘price’ and a col called ‘date’. I want to sum the prices following the same date. so i would like to create a new dataset in which, for example in date 6/1/22 (which is in both… Read More Sum values of two different datasets but following the same date in R
I have 1 table like the picture I want to count column number the output as follows I try but it not show column ID and name as I want. select id, name, number, count(number) from table_demo group by id, name, number My result Can’t help you with the SQL Server 2019 >Solution : Something… Read More Count advanced in SQL Server group by 1 column
There is a dataframe that contains several columns with the same name and I don’t know the exact number of columns with the same. I want to keep only one column on my dataframe and add the the values of the other to the last line. I don’t know the best way to proceed. Simple… Read More How to add columns with the same name into last line in order to have only one column pandas
I can’t figure out how to create pandas dataframe (multiple-columns) from list. Some lines contains character ">" at the beggining. I want them to be column headers. Number of lines after each header is not the same. My list: >header a b >header2 c d e f >header3 g h i Dataframe I want to… Read More Create multiple-columns pandas dataframe from list