Working With Excel Spreadsheets using Python

Microsoft Excel is a popular application for Windows that is used to work with spreadsheets, tables and charts. Spreadsheets are used extensively in the business world to record budgets, create reports, manage inventory or perform calculations. Working on Excel tasks in your day to day work can be boring, mind-numbing and even daunting especially if … 

 

How to install 3rd party python modules

Python follows a “batteries included” philosophy, which means that a lot of functionality you may need is built in to the language itself.Python developers have developed their own modules to extend Python’s capabilities even further. These third party modules are kept in the Python Package Index or PyPI which is similar to an app store … 

 

My solution to the FizzBuzz challenge.

The “FizzBuzz Test” is an interview question meant to filter out candidates that cannot program their way out of a paper bag. When I first read about this test on codinghorror, I assumed that it must be a very difficult challenge for it to filter out 99% of software development job candidates but it turns … 

 

Python: Storing Objects Using Shelve

The shelve is used to store Python objects to a file in a dictionary like format.shelve is used where using a relational database would create too much overhead or is unnecessary for example to persist data between program runs. Shelve is part of the Python Standard Library so getting it to work in your programs … 

 

Debugging Python Code

The Python programs I have written from the time I started learning Python up to now are very simple scripts. I still consider myself a beginner, but I have started to write not so simple code that is usually very brittle and buggy. I have a Github repo of scripts that automate common tasks on … 

 

Set Comprehension in Python

In a previous article I discussed list comprehensions. Today I will talk about set comprehensions. Set comprehensions were added to Python in version 2.7 and they are similir to List Comprehensions, the only difference is that we use curly braces instead of square brackets when making them. A set is an un-ordered collection in which … 

 

Python List Comprehensions

A special syntax form in the Python language is the list comprehension. List comprehensions allow programmers to make their code more compact and (sometimes) harder to read if they push the comprehensions too far! The syntax consists of an expression in square brackets to create a new list. In order to show the beauty of …