Detecting Change with Pandas

Recently, I was working with an investment management company who had an interesting problem to solve.

They had 10 years' of historical data on approximately 1500 companies. This was stored in a spreadsheet and, each month, for 10 years, they would copy the current sheet of companies, record any changes and add any new companies to the bottom. This spreadsheet had 120 worksheets - one for each month for the last 10 years - and each sheet had a at least 1000 rows - one for each company of interest at the time.

more ...

My Conference Attendance Guidelines

I regularly attend technical conferences in order to learn, make new contacts and generally participate in whatever community that conference represents.

Over the years, I have found that the best way to increase my chances of making new friends and contacts is to speak at the conference - people are far …

more ...

Process

One vital role of the leader is to define and enforce the processes that the team will follow. I've seen more projects fail as result of getting this wrong than any other single cause.

Do I have the definitive answer as to the process you should follow? No, I do …

more ...

Leading Technical Teams

Over the years, I've led, and been a member of, numerous technical teams on a wide variety of projects. Based on that experience, this series of articles documents my observations on the role of the leader in that sort of team.

Firstly, some thoughts on authority...

Says Who?

How did …

more ...


Rescue Project - New ERP System Implementation

The client for this project was a UK PLC with over 150 multi-national subsidiary companies.

They were replacing their ERP system for the whole Group and required full historical data migration at the transactional level - the new system should look like it had always been in place since the company …

more ...

Why I use LaTeX

Date Tags LaTex

When I tell people that I don't use Microsoft Word, they are generally somewhat taken aback and then assume that, because I own a Mac rather than a Windows PC, that I just use Apple's Pages instead.

I don't!

In fact, I don't use any kind of conventional word processor …

more ...

Pelican Powered Site on a Vagrant Virtual Machine

This article describes how to get a Pelican powered website up and running with minimal effort using a Vagrant virtual machine.

Pelican is a static html generator for creating blog style websites from simple text files in markdown, rst or creole syntax.

Vagrant is a tool for managing isolated development …

more ...

Managing Agresso Environments

Date Series Part 1 of Agresso Management Tags ERP / Agresso

This series of articles presents how an Agresso system may be managed in such a way as to minimise risk and provide assurance, traceability and accountability to an organisation, its managers and auditors.

The objectives of the ideas presented here are:

  1. To ensure that all configuration changes to a live …
more ...

Requirements

Date Series Part 2 of Agresso Management Tags ERP / Agresso

A ‘requirement’ is considered to be the definition of a change to a system requested by an end user. It could describe a defect in existing functionality, a proposed enhancement or entirely new functionality.

Systems to store and manage requirements definitions typically provide the following capabilities:

  • Track a requirement through …
more ...