SEO, Python programming and web development

Card image cap

Building a simple web crawler with Python

In this post we build a simple web crawler using the Python packages Requests, BeautifulSoup and store the scrapped data in an SQLite database.

Read More →
Card image cap

Categorising keywords at scale using Python, Pandas and NLTK

In this post we look at how we can use NLTK to categorise keywords at scale.

Read More →
Card image cap

SQLite & MySQL with Python

In this post we'll take a look at using Python with SQL - more specifically a SQLite datebase and MySQL to do simple CRUD functions.

Read More →
Web development
About me

My name is Charlie Jackson, and I currently work as a technical SEO in a small digital marketing agency. Through working in SEO I discovered Python, and all the beautiful applications that it could be used for; in the world of SEO we are often crawling websites, scraping data, text mining and much more, which Python is fantastic for. I am only fairly new to programming, and there are a number of topics I am hoping to blog about including:

  • Data science; with python, SQL and possibly R
  • Machine learning with python
  • Natural language processing
  • SEO
  • Web development

As noted, I am not a developer(if you haven't guest by my website) or data scientist although I am eager to learn as much as possible, and apply to my background in SEO. I am largely writing this blog for myself to document my studies (and use as a code base), although it it happens to help somebody else that would be great.

Feel free to drop me a line: charlieojackson at gmail dot com.