Author Archives: Dan

Distances between places as the crow flies

Challenge: I have two the latitude and longitude of two places. I want to know the distance between them, as the crow flies. This took a lot of trial and error, made more tricky by having to also accommodate two … Continue reading →

Frequency count on a range of data

Challenge: I have thousands of rows of data, each containing multiple columns of piece of information. I want a frequency count of each piece of information that appears. I received some data the other day. In total, there were 1,000 … Continue reading →