I've recently got stuck in to Python to automate some repetitive tasks.

My script gathers two sets of data using APIs and using pandas, merges them into one data file where it does a series of checks then manipulates the data based on set criteria. It's taken me a solid 8 hours to figure this out and get something working but I've stumbled at the final hurdle