In my last post, I wrote about some basic functions of Pandas and DataFrames. Today, I show you how to read DataFrames from Excel. The Scenario is (again) about configuration generation, but this time I like to focus on the data gathering part.

I like to write today about a topic that I used quite frequently within the last weeks/months: pandas DataFrames. At some point in your automation story, you need some data for whatever reason. One example are connection data for some devices. Another example might be the collection of configuration information. I think you know that many people use Excel for this purpose and today, I like to show you, how you can work with DataFrames. In my next post, I show you how to read and work with data from an Excel file.

Today, I like to write about a small and very basic topic. I think everybody requires from time to time the output of certain CLI commands on a set of devices, e.g. for troubleshooting. Quite often, no direct access to the devices is possible, therefore you need to ask somebody else to collect the data. In many cases, you just get plain session logs from e.g. putty and they are in many cases quite unstructured.

This post is the last one within a series that I’ve created primarily at the beginning of 2016. The topic was on How to build your own Network Config Generator. The last post within the series was some time ago and I like to finish it today with a short review of the process and my experience during the time.

Almost a year ago, I start a side project to create a web service that automates End-of-Life (EoL) checks. It targets primarily to equipment from Cisco Systems. My primary intention was to learn Django and some other web technologies. Furthermore, I liked to play with the Cisco API console (more specific the Cisco EoX API). I used the first version now for quite some time. Some months ago, I decided to extend this Project a little bit. The first step was a review of what I’ve done last year. I recognized fast that the code needs some updates...