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.

@Robwatts I'm steadily getting faster too bit by bit plus much more stamina. All good.

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

@Robwatts Aargh. Hill running is a nightmare. We do it every other week with the running club. Hills affectionately named 'killer hill' and 'donkey hill' and 'angina hill' by the club members. They are not kidding. Good luck with the races.

@Robwatts I am. Manchester Marathon in April

@LilyRay ❤️ ❤️ ❤️

That time @geekonaut and I carried on about robots directives. Enjoyed it Martin! https://youtu.be/5nK-WtNJqQ0 #SEO #ModelHands

@LilyRay A revival time for well-curated real UGC

@ebbingcasa Thank you :)

@thetafferboy 😂

@thetafferboy Oh wow. ie they returned anything you mean? Ha ha. Never saw that

@thetafferboy They're still there? https://uk.indeed.com/Test-Analyst-jobs-in-London - They just don't link from the main hub to them like they used to

Is Mastodon still benefitting from a Twitter migration? I get the impression peopler are not leaving Twitter after all mostly. It's very quiet here in Mastodon. Hope it's not going to go the way of Google+ etc as a serious alternative to Twitter seemed like such a good idea

@davidr Thanks. That is a very good point indeed

Why do I keep getting multiple instances of the same people following me. Is it that they're on more than one Mastodon Server?

Focusing my 'Days of Code' with the challenge to do 350 Days of Code' New Years Resolution item on Python solely this year. I've got Pandas, Matplotlib, BeautifulSoup, Requests, Numpy. What else should I be learning with Python? #Python

Google's @dannysullivan said that the volatility we are seeing today is likely from the two updates (helpful content and link spam) that are "continuing to rollout" - more details added to https://www.seroundtable.com/google-search-ranking-algorithm-update-34682.html

Final update on NY resolutions 2022. 100% vegetarian + 90%+ vegan now. Did Dry Jan till May. 358 days of code in 2022. Got my 50 Parkrun tee. Did so many 10k runs I lost track plus a 1/2 marathon. Less time on Twitter & kept learning about IR. 100% NY resolutions achieved

Ok. There’s going to be a lot of running in the New Year

@murphystout I saw it in a video from a Googler in an SMX video but also it’s evident when the page titles and meta descriptions show up as snippets on redirected to and from UrLs