Learn to Parse CSV file using Python for Cisco Configuration : CSV DictReader Tutorial |Part 4

#PythonCSV #CSVDictReader #CSVCisco

Playlist: Learn to Read Data From CSV Using Python

Playlist: Paramiko detailed explanation with Example for Network Engineers

Playlist: Python Learning for Network Engineers

This video demonstrates how to parse csv file for Cisco device configuration.
Add device IP adnc configuration in row and column format and create python dictionary key value pairs from the csv data using python library csv DictReader methos
Difference between csv reader and csv dict reader
how to configure cisco devices from csv file, initiate ssh using paramiko libbrary
Fetch IP address and configuration from csv
Script
-------------
from csv import DictReader
from pprint import pprint
import paramiko
import time

conf_dict ={}
csv_content = DictReader(csv_file)
for row in csv_content:
for column_name in column_names:
if not column_name:
continue
if not row[column_name]:
continue
conf_dict[column_name] = []
conf_dict[column_name].append(row[column_name])

session = paramiko.SSHClient()

try:
print(f"\n{'#' * 50}\nConnecting to the Device {ip}\n{'#' * 50} ")
username='admin1',
# password='admin',
pkey=key_file,
)
print(f"\nExecuting Commands are\n{'~'*22}\n{conf_dict[ip]}")
for conf in conf_dict[ip]:
DEVICE_ACCESS.send(conf+'\n')
output = DEVICE_ACCESS.recv(65000)
except :
print('Can not connect to the device')
print (f"\n{'#' * 50}\nCOMMAND EXECUTION COMPLETED\n{'#' * 50}\n")
------------------
csv dict reader python tutorial,csv key value in dict,csv readert python example,python csv parsing tutorial, how to read csv row column in python,create key value pair from csv python,exvel read python csv reader,row colum parsing dictionary and list python,cisco configuration from csv,device ip from csv python example,config demo csv python paramiko csv,paramiko ssh using csv,field names in dictreader,python cisco automation example,scv script example python

[NetworkEvolution]

𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗣𝘆𝘁𝗵𝗼𝗻 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗳𝗼𝗿 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝘀(𝟭𝟮𝟬+ 𝗩𝗶𝗱𝗲𝗼𝘀)
☸𝗣𝗹𝗲𝗮𝘀𝗲 𝗳𝗼𝗹𝗹𝗼𝘄 𝗯𝗲𝗹𝗼𝘄 𝗚𝗶𝘁𝗛𝘂𝗯 𝗣𝗮𝗴𝗲 𝗳𝗼𝗿 𝘁𝗵𝗲 𝗹𝗮𝘁𝗲𝘀𝘁 𝗰𝗼𝗱𝗲𝘀:
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗖𝗶𝘀𝗰𝗼 𝗡𝗫𝗔𝗣𝗜-𝗖𝗟𝗜 𝗣𝘆𝘁𝗵𝗼𝗻 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻: 𝗡𝗲𝘅𝘂𝘀 𝟵𝗸 :𝗣𝗮𝗿𝘀𝗲 𝗷𝘀𝗼𝗻 𝗫𝗠𝗟 𝗖𝗼𝗻𝗳𝗶𝗴𝘂𝗿𝗮𝘁𝗶𝗼𝗻 𝗗𝗮𝘁𝗮
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗟𝗲𝗮𝗿𝗻 𝘁𝗼 𝗣𝗮𝗿𝘀𝗲 𝗖𝗶𝘀𝗰𝗼 𝗖𝗼𝗻𝗳𝗶𝗴𝘂𝗿𝗮𝘁𝗶𝗼𝗻 𝘂𝘀𝗶𝗻𝗴 𝗣𝘆𝘁𝗵𝗼𝗻 𝗥𝗲𝗴𝗘𝘅:𝗿𝗲 𝗧𝘂𝘁𝗼𝗿𝗶𝗮𝗹(𝟭𝟱+ 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗖𝗶𝘀𝗰𝗼 𝗜𝗻𝘁𝗲𝗿𝗳𝗮𝗰𝗲 𝗖𝗼𝗻𝗳𝗶𝗴𝘂𝗿𝗮𝘁𝗶𝗼𝗻 𝗣𝗮𝗿𝘀𝗶𝗻𝗴 𝘄𝗶𝘁𝗵 𝗠𝘂𝗹𝘁𝗶𝘁𝗵𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗣𝘆𝘁𝗵𝗼𝗻 𝗥𝗲𝗴𝗘𝘅 𝗦𝗰𝗿𝗶𝗽𝘁:𝗧𝗮𝗯𝘂𝗹𝗮𝘁𝗲 𝗧𝗮𝗯𝗹𝗲 𝗲𝘅𝗮𝗺𝗽𝗹𝗲(𝟰 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗘𝗻𝗮𝗯𝗹𝗲 𝗣𝘆𝘁𝗵𝗼𝗻 𝗠𝘂𝗹𝘁𝗶𝘁𝗵𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗶𝗻 𝗖𝗶𝘀𝗰𝗼 𝗖𝗼𝗻𝗳𝗶𝗴 𝗕𝗮𝗰𝗸𝘂𝗽 𝗦𝗰𝗿𝗶𝗽𝘁 𝗳𝗼𝗿 𝗣𝗮𝗿𝗮𝗹𝗹𝗲𝗹 𝗲𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻:𝗧𝗵𝗿𝗲𝗮𝗱𝗶𝗻𝗴 𝗧𝘂𝘁𝗼𝗿𝗶𝗮𝗹(𝟰 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗔𝗻𝘀𝗶𝗯𝗹𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗙𝗼𝗿 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝘀 : 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝘁𝘂𝘁𝗼𝗿𝗶𝗮𝗹 𝘄𝗶𝘁𝗵 𝗖𝗶𝘀𝗰𝗼 𝗘𝘅𝗮𝗺𝗽𝗹𝗲𝘀(𝟯𝟬+ 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗔𝗻𝘀𝗶𝗯𝗹𝗲 𝗧𝗼𝘄𝗲𝗿/𝗔𝗪𝗫 𝗖𝗜𝗖𝗗 𝗧𝘂𝘁𝗼𝗿𝗶𝗮𝗹 𝗳𝗼𝗿 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 : 𝗖𝗶𝘀𝗰𝗼 𝗜𝗢𝗦 𝗣𝗹𝗮𝘆𝗯𝗼𝗼𝗸𝘀 + 𝗚𝗶𝘁𝗟𝗮𝗯 𝗥𝗲𝗽𝗼𝘀𝗶𝘁𝗼𝗿𝘆 + 𝗖𝗜𝗖𝗗 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲 + 𝗚𝗶𝘁𝗟𝗮𝗯 𝗥𝘂𝗻𝗻𝗲𝗿(𝟭𝟬+ 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗔𝗻𝘀𝗶𝗯𝗹𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗙𝗼𝗿 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝘀 : 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝘁𝘂𝘁𝗼𝗿𝗶𝗮𝗹 𝘄𝗶𝘁𝗵 𝗖𝗶𝘀𝗰𝗼 𝗘𝘅𝗮𝗺𝗽𝗹𝗲𝘀(𝟯𝟬+ 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗘𝗩𝗘-𝗡𝗚 𝗔𝗣𝗜 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝘂𝘀𝗶𝗻𝗴 𝗣𝘆𝘁𝗵𝗼𝗻 :𝗛𝗼𝘄 𝘁𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗲 𝗗𝗲𝘃𝗶𝗰𝗲 𝗣𝗿𝗼𝘃𝗶𝘀𝗶𝗼𝗻𝗶𝗻𝗴 𝗶𝗻 𝗘𝗩𝗘-𝗡𝗚:𝗖𝗶𝘀𝗰𝗼 𝗗𝗲𝘃𝗶𝗰𝗲(𝟱 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗗𝗲𝗺𝗼_𝟬𝟭
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗡𝗲𝘁𝗯𝗼𝘅 𝗮𝘀 𝗮 𝗦𝗼𝘂𝗿𝗰𝗲 𝗢𝗳 𝗧𝗿𝘂𝘁𝗵 𝗙𝗼𝗿 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗛𝗼𝘄 𝘁𝗼 𝘃𝗮𝗹𝗶𝗱𝗮𝘁𝗲 𝗜𝗣 𝗔𝗱𝗱𝗿𝗲𝘀𝘀/𝗦𝘂𝗯𝗻𝗲𝘁 𝘂𝘀𝗶𝗻𝗴 𝗣𝘆𝘁𝗵𝗼𝗻 : 𝗶𝗽𝗮𝗱𝗱𝗿𝗲𝘀𝘀 𝗺𝗼𝗱𝘂𝗹𝗲 𝘁𝘂𝘁𝗼𝗿𝗶𝗮𝗹 𝗳𝗼𝗿 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝘀
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗡𝗘𝗧𝗖𝗢𝗡𝗙 𝗣𝘆𝘁𝗵𝗼𝗻 𝗘𝘅𝗮𝗺𝗽𝗹𝗲 𝘄𝗶𝘁𝗵 𝗖𝗶𝘀𝗰𝗼 𝗗𝗲𝘃𝗶𝗰𝗲𝘀 𝗖𝗼𝗻𝗳𝗶𝗴𝘂𝗿𝗮𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗡𝗖𝗖𝗟𝗜𝗘𝗡𝗧
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗙𝗼𝗿𝘁𝗶𝗴𝗮𝘁𝗲 𝗖𝗟𝗜 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝗨𝘀𝗶𝗻𝗴 𝗣𝘆𝘁𝗵𝗼𝗻 : 𝗡𝗲𝘁𝗺𝗶𝗸𝗼 𝗧𝘂𝘁𝗼𝗿𝗶𝗮𝗹(𝟳 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗙𝗼𝗿𝘁𝗶𝗴𝗮𝘁𝗲 𝗔𝗣𝗜 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝗨𝘀𝗶𝗻𝗴 𝗣𝘆𝘁𝗵𝗼𝗻 𝗣𝗼𝘀𝘁𝗺𝗮𝗻 𝗮𝗻𝗱 𝗖𝘂𝗿𝗹(𝟵 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗡𝗲𝘁𝗺𝗶𝗸𝗼 𝗧𝘂𝘁𝗼𝗿𝗶𝗮𝗹𝘀 𝗙𝗼𝗿 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝘀(𝟭𝟮 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗣𝗮𝗿𝗮𝗺𝗶𝗸𝗼 𝗧𝘂𝘁𝗼𝗿𝗶𝗮𝗹 : 𝗣𝗮𝗿𝗮𝗺𝗶𝗸𝗼 𝗱𝗲𝘁𝗮𝗶𝗹𝗲𝗱 𝗲𝘅𝗽𝗹𝗮𝗻𝗮𝘁𝗶𝗼𝗻 𝘄𝗶𝘁𝗵 𝗘𝘅𝗮𝗺𝗽𝗹𝗲 𝗳𝗼𝗿 𝗡𝗲𝘁𝘄𝗼𝗿𝗸 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝘀(𝟮𝟲 𝗩𝗶𝗱𝗲𝗼𝘀)
𝗣𝗹𝗮𝘆𝗹𝗶𝘀𝘁: 𝗘𝗻𝗮𝗯𝗹𝗲 𝗣𝘆𝘁𝗵𝗼𝗻 𝗟𝗼𝗴𝗴𝗶𝗻𝗴 : 𝗟𝗼𝗴 𝗦𝗰𝗿𝗶𝗽𝘁 𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 :𝗖𝗶𝘀𝗰𝗼 𝗦𝗦𝗛 |𝗔𝗱𝗱 𝗧𝗶𝗺𝗲𝘀𝘁𝗮𝗺𝗽, 𝗟𝗲𝘃𝗲𝗹𝘀, 𝗙𝗼𝗿𝗺𝗮𝘁𝘁𝗲𝗿𝘀, 𝗛𝗮𝗻𝗱𝗹𝗲𝗿𝘀(𝟳 𝗩𝗶𝗱𝗲𝗼𝘀)