Python Rearrange The Column Values

Question

My input dataframe:

    A         Min Thresh   Max Thresh
    0          1          
    0                          10
    15.5       1               11
    13.3                       15
    10         0               15

Desired output:

A
1
0
11
13.3
10

Could you please help me about this?

Possible duplicate of How to get the first column of a pandas DataFrame as a Series? — micharaze
– micharaze, Commented Oct 22, 2019 at 9:06
@Erfan He meant that if the value in column 'A' is below the value in column 'Min Thresh' then is should recieve the value of 'Min Thresh', and the same for 'Max Thresh'. — Aryerez
– Aryerez, Commented Oct 22, 2019 at 9:21

Aryerez · Accepted Answer · 2019-10-22 09:09:23Z

2

You can do:

df['A'] = df[['A', 'MinThresh']].max(axis=1)
df['A'] = df[['A', 'MaxThresh']].min(axis=1)

It ignores np.nan, as you need.

answered Oct 22, 2019 at 9:09

Aryerez

3,5052 gold badges12 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Python Rearrange The Column Values

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related