Finding text matches in Reddit comments

I’m currently trying to write scripts for Google Apps that poke around with Reddit API and save results in Google Spreadsheets. I’m finding hard to learn both the Reddit API and Google Scripts at the same time (despite much appreciated help from @mhawksey and @brucemcpherson) .  In an attempt to keep my sanity I am…

A quick Reddit autoreply bot

Similar to my last *nix style project I wanted to write something in Python that could interact with Reddit and can be ran from a Raspberry Pi. At this stage I only wanted to see what was possible and start early, so I borrowed some code to make a bot that scanned a subreddit for…

Creating a Twitter Question/Revision Bot

I recently wanted to a CSV of questions and answers in to a Twitter account that tweeted questions followed by the correct answers every hour like so: My CSV looks like this when opened in excel. There are 5 columns in each row, the first of which is the question, followed by a description of…

Visualising Blog comments

Yesterday I had a chat with old Cetis friend Sheila, we got on to the conversation of visualising text, something I am really interested in but also really struggle with. Sheila had been playing with Textexture  a tool to visualise any text as a network, I was intrigued by Sheila’s post and decided to do…

Problems with quick Wikipedia heatmaps of birth locations

This doesn’t tell you how many people of that profession there are, it tells you how many people of that profession are in Wikipedia, with structured data on both the persons birthplace and profession. It might tell us as much about how Wikipedia is being used as how many people from that profession are actually…

Testing creation of intensity maps from Wikipedia

I wanted to come up with a quick method that I could reuse where I could ask Wikipedia a quick question, get some numbers and create a heat map. I still haven’t come up with the quick process, and when I mess with data I tend to stick with what I know for a ‘first…

VBA script to loop through directory of CSVs and create separate PowerPoint presentations for each file

As per the very long title, this is a Visual Basic for Application that will loop through directory of CSVs and create separate PowerPoint presentations for each file script which I am saving this for future reference.  VBA script to loop through directory of CSVs and create separate PowerPoint presentations for each file based on…

Auto generating PowerPoint presentations from CSV

I recently held an activity that captured responses to questions from a questionnaire in CSV format. I wanted to be able to convert these answers in to slides on a PowerPoint presentation. Rather than rewrite them all I remembered that Visual Basic for Applications used to be able to do this thing so I jumped…