I've tried reading similar questions before asking, but I'm still stumped. Any help is appreaciated.
Input: I have a pandas dataframe with a column labeled 'radon' which has values in the range: [0.5, 13.65]
Output: I'd like to create a new column where all radon values that = 0.5 are changed to a random value between 0.1 and 0.5
I tried this:
df['radon_adj'] = np.where(df['radon']==0.5, random.uniform(0, 0.5), df.radon)
However, i get the same random number for all values of 0.5
I tried this as well. It creates random numbers, but the else statment does not copy the original values
df['radon_adj'] = df['radon'].apply(lambda x: random.uniform(0, 0.5) if x == 0.5 else df.radon)