Excel is one of the primary data sources that we network engineers have to deal with. While you will find a lot of people with very proficient skills with excel when it comes to manipulating data and making sense of it but now there is a need to be able to programmatically access the data in excel sheets and analyze that data to answer some business-critical questions. We are going to leverage Pandas library to see how to do data analysis with python for network engineers.
I have an excel sheet with inventory data and almost all of you will have similar inventory sources.
Pandas for Network Engineers
The code blocks below were written on Jupyter notebook and exported to HTML to publish here. Methods below are extremely basic introduction level techniques to pandas that as a network engineer you will find useful. However, what you see below is probably just a tiny fraction of what all pandas can do for data analysis and data visualization.
If you have more questions or more such requirements to filter data, please drop a comment to me.
Click here to see the below dataframe in fullscreen
1 thought on “Data Analysis with Python For Network Engineers.”