There are 341 wikipedia users who have added themselves to Category:Wikipedians in London. I wanted to know which of these people had been active recently. My guess was that a small minority of these people were actually still around in the wikipedia community.
I wrote a little bot in java which harvested the information. I needed the date of their most recent wiki edit. Ranking the users by this metric, it turns out I was wrong. About half of these people have edited this month (pretty recently), and the vast majority have made edits within the last year. I guess people who go to the trouble of adding a ‘Living in London’ userbox, tend to be quite dedicated, and likely to stick around in the community.
My plan was to send direct messages to the active users, to make sure they know about the next London Wikipedia Meetup. My original idea was to whittle down the list, to eliminate what I thought would be the large majority of inactive users. But this hasn’t helped me whittle down the list at all! It’s a more helpful ranking than an alphabetical list though:
Fun to play with developing bots too.