I quite frequently get pandas DataFrames that are lists of items — usually these come from data queries converted to a DataFrame. These are a bit painful to process — imagine a DataFrame like this one where multiple IP addresses are packed into a single column.

Extracting individual IP address to do something like Threat Intelligence or geo-location lookups is tricky to do — especially in a nice, pandas-like way. In particular, I wanted a solution that I could put into a pandas pipeline without loose bits of Python code cluttering up the place. …

Ian Hellen

Principal security engineer @ Microsoft. Python and Jupyter notebooks in Cybersecurity.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store