python - How to apply If Else statements in Pandas Dataframe?

Question

I have a Pandas Dataframe and I am trying to add a new column where the value in the new column is dependant on some conditions in the existing Dataframe. The Dataframe I have is as follows:

Date / Time	Open	High	Low	Close	Volume
2020-06-02 16:30:00	1.25566	1.25696	1.25439	1.25634	2720
2020-06-02 17:00:00	1.25638	1.25683	1.25532	1.25614	2800
2020-06-02 17:30:00	1.25615	1.25699	1.25520	1.25565	2827
2020-06-02 18:00:00	1.25565	1.25598	1.25334	1.25341	2993
2020-06-02 18:30:00	1.25341	1.25385	1.25272	1.25287	1899
2020-07-03 07:00:00	1.24651	1.24673	1.24596	1.24603	600
2020-07-03 07:30:00	1.24601	1.24641	1.24568	1.24594	487
2020-07-03 08:00:00	1.24593	1.24618	1.24580	1.24612	455
2020-07-03 08:30:00	1.24612	1.24667	1.24603	1.24666	552
2020-07-03 09:00:00	1.24666	1.24785	1.24623	1.24765	922

Answer 1

Try:

df['Signal'] = np.where((df['Open'] <= df['Close'].shift(1)) &
                        (df['Close'] > df['Open'].shift(1))  &
                        (df['Close'].shift(1) < df['Open'].shift(1)),
                        'Open', '0')