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 … 

 

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 … 

 

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 … 

 

The python lambda

Recently I learned how to use the lambda function, a simple, unbound one liner function. A lambda is similar to a normal Python function, the only difference is in the way it is used. The example below will explain better: The poww function defined above takes an argument x and squares it. So if we … 

 

Python 101: Your first python program

This post is part 2 of Get started with Python programming series, in which I do my best to share my experiences in learning python and hope that this becomes some sort of guide to help you become a Python programmer. In today’s post, I explain how to write your first Python program. If you …