We need to parse the data in this format into Python dictionaries. ... Let’s start by loading a Screaming Frog crawl into a pandas dataframe. import pandas as pd df = pd.DataFrame ...

Users with the Public Preview will be able to see Python in the Excel ribbon menu. Those users can bring external data into Python using Power Query and built-in Excel workflows.