Advertisements I’m having difficulty filling missing values in my tibble based on some conditions. I’m trying to fill NA values in the manufacturer column based on the condition field either being YES or NO, I’m only interested in filling NA values for groups where the condition column contains YES. I’m getting the following error which… Read More filling missing values using tidyverse syntax based on conditions within the tibble

Advertisements Given the following: import pandas as pd import numpy as np df = pd.DataFrame({‘a’:[‘a’,’a’,’b’,’b’,’c’,’c’],:[1,1,np.nan,np.nan,1,1]}) df a b 0 a 1.0 1 a 1.0 2 b NaN 3 b NaN 4 c 1.0 5 c 1.0 I need to create a new column ("c") by grouping by "a" and shifting the values of "b" down… Read More Pandas Groupby Get Values from Previous Group

Advertisements I have the following dataframe df (dput below): group date1 date2 value 1 A 2022-01-01 2022-01-07 NA 2 A 2022-01-02 2022-01-07 1 3 A 2022-01-04 2022-01-07 NA 4 A 2022-01-10 2022-01-07 NA 5 B 2022-01-01 2022-01-06 3 6 B 2022-01-03 2022-01-06 NA 7 B 2022-01-04 2022-01-06 NA 8 B 2022-01-06 2022-01-06 NA 9 C… Read More Fill NA until certain date based on different column per group

Advertisements I have a pandas dataframe with an id column called doc_ID and a boolean column that reports if a certain value is below a threshold, like so: df = pd.DataFrame({‘doc_ID’: [1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 3, 3, 3, 3, 3, 3, 3, 3], ‘below_threshold’: [False, False, False,… Read More Fill grouping varible pandas dataframe

Advertisements I have a time shift column in my tblCalendar table called TimeShift and need to fill two other columns in the same table, both columns have Null values and their names are StartTime and EndTime. This serves as an example: TimeShift StartTime EndTime 8:00AM – 4:00PM Null Null 10:00AM – 6:00PM Null Null 11:00AM… Read More Fill two columns in SQL table as a result of an operation done on another (third) column

Advertisements I´ve got this dataset (something like below) db <- as.data.frame(cbind(c(1,2,2,3,3,4,4,4,5,5),c(‘a’,’b’,NA,NA,’i’,NA,’d’,NA, NA, NA))) I´d like to fill the V2 NA with same correpondance from ID column V1. At the end I expect this result db <- as.data.frame(cbind(c(1,2,2,3,3,4,4,4,5,5),c(‘a’,’b’,’b’,’i’,’i’,’d’,’d’,’d’, NA, NA))) I´ve tried to make a list with unique ID db_aux <- as.data.frame(cbind(c(1,2,3,4),c(‘a’,’b’,’i’,’d’))) but I guess it´s… Read More Fill NA in R: imput NA in a column X with values from same ID (column Y ) correspondance