Q: Can I convert a #WordPress website into a simple table with two lines of #Python code?
A: Yes.

It's better than crawling, because you get much more information this way. Takes a fraction of a fraction of the time.

Go to blog_url/wp-json/, if the website enabled it, you should see the content as a JSON string.

requests.get sends a GET request & the response object has a .json() method that converts JSON to a Python dict.
pandas.json_normalize unpacks it as a DataFrame.

Done.

Interactive #SERP heatmap for the tough #loan keywords. Select countr(ies) & number of domains to display.

18 loan types
3 keyword variations (best loan, loan calculator, loan rates)
4 countries

18 x 3 x 4 = 216 SERPs (2,160 results)

Overview: https://bit.ly/3xoFIX5

Code: https://bit.ly/3HWGnUy

Data: https://bit.ly/3ZVzfQB

#DataScience #advertools #SEO #DigitalMarketing #DataVisualization

#Python