How to use Python / Pandas with Google Analytics + Crawl data to find useless URLs to delete. #SEO
Channel: Tobias Willmann
Date: 31/03/2020

This is more about showing Python / Pandas and explore the data than to get the perfect delete list (and it's a test how these videos work)

Using Pandas with the most common things you would do in Excel / Google Sheets probably: 

pd.read_excel
pd.concat
.copy()
.str.extract()
.to_csv()
.pd.merge()
.drop()
.pd.pivot_table()
.sort_values()

Here's the jupyter notebooks .ipynb file https://github.com/Zrce/Python-Pandas-SEO-Videos/blob/master/Cleanup.ipynb 

Screaming Frog used to crawl