#!\/usr\/bin\/env python
\nimport csv
\nimport socket<\/p>\n
reader = csv.reader(open(“.\/test.csv”, “rb”), delimiter=”\t“)
\nfor row in reader:
\nhost, aliases, ips = socket.gethostbyaddr(row[1])
\nprint row[0] + ”\t” + host + ”\t” + row[2] + ”\t” + row[3]<\/p><\/blockquote>\n
First we import the necessary libs. (socket and csv)<\/p>\n
Then we open the file to read with as a csv object. (Careful because our delimiter is not comma, but TAB)<\/p>\n
for each row we get the second row (row[1]), convert it to host, alias and ip by gethostbyaddr method.<\/p>\n
The last line is to create the new tab separated format. (Just pipe it to a file and you have your new CSV file. [tab separated… but oh well..])<\/p>\n
Done!<\/p>\n","protected":false},"excerpt":{"rendered":"
Problem: I have a CSV file where I have source and destination IPs. I want to resolve only destination IPs. Format of my CSV file: (let`s call it test.csv) (it`s tab separated…) 99.88.77.66 11.22.33.44 118340.86 187 The solution is pretty simple with python: #!\/usr\/bin\/env python import csv import socket reader = csv.reader(open(“.\/test.csv”, “rb”), delimiter=” “) … Continue reading python and resolving ips from a csv file.<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[13,9],"_links":{"self":[{"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/posts\/307"}],"collection":[{"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/comments?post=307"}],"version-history":[{"count":3,"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/posts\/307\/revisions"}],"predecessor-version":[{"id":748,"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/posts\/307\/revisions\/748"}],"wp:attachment":[{"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/media?parent=307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/categories?post=307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emresaglam.com\/blog\/wp-json\/wp\/v2\/tags?post=307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}