Python programming tutorials

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 →
Card image cap

List/dictionary comprehensions and generators in Python

In this post we take a look at list comprehension, dictionary comprehension and generator expressions including their differences and use cases.

Read More →
Card image cap

Python functions

Take a deep dive into functions in Python. This post covers: basics, nested functions, scope, *args & **kwargs, lambdas and anonymous functions and finishes on using functions within a Pandas DataFrame.

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 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.