Advertisements 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… Read More Replace multiple values using another dataframe

Advertisements 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… Read More generating a table in R, with defined parameters

Advertisements 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… Read More Sum values of two different datasets but following the same date in R

Advertisements 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 :… Read More Count advanced in SQL Server group by 1 column

Advertisements 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.… Read More How to add columns with the same name into last line in order to have only one column pandas

Advertisements 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… Read More Create multiple-columns pandas dataframe from list

Advertisements I have been trying to create a website divided into 3 Columns of unequal length, being more specific two of 15% in the sides, and one of 70% in the centre. However I am not being able to manage that the 3 columns take 100% width of the space of my wesbite. Here’s my… Read More How to divide a website into three unequal length columns

Advertisements I have a pandas dataframe and a function that returns a dictionary. I want to assign the result of the function to multiple columns. But the problem is, the function returns a dictionary that I want to save only the values to columns. I can do this by sending only the values from the… Read More How to assign multiple column in one go with dictionary values?

Advertisements Following are the standard values for score and grades. Grade Grade1 Grade2 Grade3 Grade4 B1 A1 IA1 D1 ID1 B2 A2 IA2 D2 ID2 B3 A3 IA3 D3 ID3 B4 A4 IA4 D4 ID4 B5 A5 IA5 D5 ID5 Input :- Grade Grade1 Grade2 Grade3 Grade4 B5 A1 IA4 D3 ID2 Output:- Tiers Grade… Read More Convert dataframe to 5*5 grid of choice

Advertisements Name Date A 1990-10-7 B 1997-11-20 and i want to add column age the convert the date to the age i try this data$age <- age_calc(as.Date(data$dob, "%Y/%m/%d"), units = "years") but i got this error Error in if (any(enddate < dob)) { : missing value where TRUE/FALSE needed >Solution : The error is in… Read More add column age from column birthdate in R