Highlight Rows with 2 conditions in a dataframe

Asked Mar 24 '23 at 18:46

Active Apr 10 '23 at 18:03

Viewed 29 times

I need to highlight in red the shipments that are over 4 days in-Transit and also mark in green everything that is delivered (no matter the time in transit). The rest of the data should remain white as default. I just start using Python and I need some help to figure this out.

I tried some random formulas but none of them applied to my case. So I really appreciate it if someone can assist.

Example = pd.DataFrame({'Tracking': ['1006879694', '2993851011', '7589912853','9833130823','2977450965','5811747185','9350589150','9350589161'], 'Transit Time':[12,4,2,1,6,4,1,10], 'Status':['In-Transit','In-Transit','In-Transit','In-Transit','Delivered','Delivered','Delivered','Delivered']})

edited Apr 10 '23 at 18:03

asked Mar 24 '23 at 18:46

Luciana Teles

3

Please provide a reproducible example, an image is not. – mozway Mar 24 '23 at 19:06
[How to make good reproducible pandas examples](https://stackoverflow.com/questions/20109391) – AlexK Mar 25 '23 at 06:06

Highlight Rows with 2 conditions in a dataframe

0 Answers0