Generating configuration files is quite simple, but how to ensure that the result of a configuration template is useful?
Within last months I moved my blog page to a static site generator. There are also some changes to the blog in general (from a style and content perspective).
Today, I released the next version of the Product Database. There are two primary new features: the product replacement options and the new Product Check. The previous Bulk EoL check was removed and replaced by the Product Check. These product replacement options (or product migrations) are created based on the data provided by the Cisco EoX API or using an Excel upload.
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.