Basically I have a panda dataframe looking like this:
time price trend related_price
1 2019-10-23 15:00:01 6748.9 no trend
2 2019-10-23 15:00:02 6749.1 increasing 6749.1
3 2019-10-23 15:00:03 6749.0 no trend
4 2019-10-23 15:00:04 6749.0 no trend
5 2019-10-23 15:00:05 6748.0 decreasing 6748
6 2019-10-23 15:00:06 6749.0 no trend
What I would like is to plot the column price over time, and when the column trend becomes increasing then the line price becomes green and when the column trend becomes decreasing then the line price becomes red. I went through the documentation, but did not find any way to do so, any clue? thanks!