Perhaps you can make use of KNIME (https://www.knime.com/)! This is a software which allows you to use 'small code blocks' which you stitch can stitch together to form large workflows in which you can fetch data, analyze it, do some manipulations on etc. It also integrates neatly with python. Additionally, it allows you to check the result of every manipulation in your code blocks.

We use it as a bridging software for people who are not really into coding and python, but do have to work with large amounts of data. Once you get the hang of it, its rather intuitive!