Vlookup in Python 100X faster
Vlookups are a very powerful excel formula and they are used a lot to blend & match data in excel. In this example I am going to show you how you can do a Vlookup in python in a few lines of code. Why? Excel vlookups over complex strings and large datasets are very compute […]
Spinning text with python
As you may know I started programming because I work in SEO. I’ve been doing SEO for over 12 years and back when I started I was using software called scrapebox. It was really effective at discovering blogs based on keywords you provided and then posting comments on people’s websites. With this and the discovery […]
Multiprocessing in python to speed up log file processing
I have a love hate relationship with the optimisation of code, essentially because it can be very rewarding or soul destroying. As part of log file processing one area which could be improved is the speed at which you can processes the lines in the log file. First a quick recap as to how python […]
Iterating in chunks over a large dataset in Django
I came across a bit of a challenge today when building my log file parsing tool. The client demo I’d built the dataset on was almost 1TB. With a total of 2.5billion rows, I’ll let that sink in for a minute, 2.5 BILLION! Googlebot has been busy over the last 20 months. I needed to […]
Switching host to speed up wordpress by 300%
I was working on one of my blogs and noticed in search console that the website load times in search console were very poor. I’d been adding lots of great content but some of it just wasn’t being indexed. Yes it was a new site but usually a week after submitted to Google unique content […]