Comparing 2 Columns to determine if higher or lower

Question

trying to Compare 2 Columns lag2open to MGC=F and return if it is higher and returning it as Higher than 0

using GCClose["Higher than 0"] = [GCClose.columns[1]]>= [GCClose.columns[0]] it always returns True, while the validation column diff doesn't support that idea

Anyone can Explain to me what i am doing wrong?

Isn't column 0 the date?

SR3142
– SR3142

2025-07-16 17:03:00 +00:00
Commented Jul 16 at 17:03 — SR3142
– SR3142, Commented Jul 16 at 17:03
column 0 is MGC=F Double checked both columns

Rafael Alexandre Sousa
– Rafael Alexandre Sousa

2025-07-16 17:10:40 +00:00
Commented Jul 16 at 17:10 — Rafael Alexandre Sousa
– Rafael Alexandre Sousa, Commented Jul 16 at 17:10

furas · Accepted Answer · 2025-07-16 19:19:50Z

3

If I understand your intention:

GCClose.columns[1] is the NAME of the column not its contents (try printing it)

You could use either:

 = GCClose[GCClose.columns[1]] >= GCClose[GCClose.columns[0]]

or

 = GCClose.iloc[:,1] >= GCClose.iloc[:,0]

or simplest

 = GCClose['lag2Open'] >= GCClose['MGC=F']

edited Jul 16 at 19:19

furas

149k12 gold badges121 silver badges171 bronze badges

answered Jul 16 at 17:30

user19077881

5,5792 gold badges8 silver badges22 bronze badges

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

1 Comment

Rafael Alexandre Sousa Jul 16 at 17:39

Thank you very much, used the first example

Collectives™ on Stack Overflow

Comparing 2 Columns to determine if higher or lower

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related