Sometimes you just need a quick and dirty python command to do something accurately to assist in the creation / population of templates which saves manual effort and checking. Now I do use python extensively and often write fairly complex scripts for certain tasks but sometimes you just need a quick command to perform a specific task so you can get something else done ASAP. I’ll include these useful code snippets on this page as I use them as they can be quite helpful and saves me figuring them out as I need them.

Create switch ports in order to populate excel spreadsheets

This is quite a straightforward example to create strings to populate cable map excel spreadsheets, effectively A – B mappings for device installs.

>>> l = [ x for x in range(49)]
>>> l.pop(0)

>>> l1 = l[0:48:2]
>>> l2 = l[1:48:2]


>>> for x, y in zip(l1, l2):
...     print('Eth1/0/' + str(x))
...     print('Eth1/0/' + str(y))
...     print('Eth1/0/' + str(x))
...     print('Eth1/0/' + str(y), '\n')

The code is quite straightforward, create a list reperesenting the 48 ports of the switch, then create 2 new lists using slicing to only get odd or even ports. Final stage is using a for loop to print out the results as required in a block of four ports. Of course this last stage can of course be changed to include a different string if required plus different ordering as required.

Useful Python Snippets
Tagged on:     

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.