New column based on values from other columns in python

Question

I have a dataframe df which looks like this

min	max	value
3	9	7
3	4	10
4	4	4
4	10	3

I want to create a new column df['accuracy'] which tells me the accuracy if the df['value'] is in between df['min'] and df['max'] such that the new dataframe looks like

min	max	value	Accuracy
3	9	7	Accurate
3	4	10	Not Accurate
4	4	4	Accurate
4	10	3	Not Accurate

AnhPC03 · Accepted Answer · 2022-08-01 09:32:36Z

4

Use apply() method of pandas, refer link

def accurate(row):  
    if row['value'] >= row['min'] and row['value'] <= row['max']:
        return 'Accurate'
    return 'Not Accurate'

df['Accuracy'] = df.apply(lambda row: accurate(row), axis=1)
print(df)

answered Aug 1, 2022 at 9:32

AnhPC03

6485 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Adam Richard Over a year ago

Worth mentioning that there's no need to use a lambda function here. Instead, just pass it like so: df.apply(accurate, axis=1)

Collectives™ on Stack Overflow

New column based on values from other columns in python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related