Why Am I Writing This? Well I would like to say its for the benefit of mankind but that would be a lie. Its pretty much for the benefit of me be it learning new technologies and keeping a record, discussing fantasy football, or business talk. I wanted to start using a static site generator and become more proficient in markdown as well. So I picked Hugo to start using for a static site generaor since GOlang is the new hotness for me.

Combining Spreadsheets With Pandas I was tasked with combining a bunch of spreadsheets that are automatically generated everynight. The task is super easy with Pandas and Python. So I took those 18 spreadsheets and made each one a different tab in one spreadsheet. WHAM BAM I thought I was done and then I found out the requestor wanted each spreadsheet on the same tab just shoved together one after another. So after some research I figured out Pandas can do this too!

Creating A TweetBot With Tweepy If you want to create a twitter bot you can easily with python and tweepy. It takes very little time to get one setup. We will be using two files for this example. Our python file wil be called twitbot.py and our file full of links (or whatever you want to tweet) in our list.txt file in the same directory. Let’s start this off with our python file named twitbot.

Connecting to a SQLite Database using Golang Connecting to a SQLite database is pretty easy with Golang. Below I will show you a basic example of how to access data and print it out to the command line. Here will we will need to import the necessary packages so we can access the database in our code. We need to use the underscore notation for the sqlite3 package since we only need it for side-affects in our program.

This article goes through connecting Golang to SQLite3.