Skip to content

Instantly share code, notes, and snippets.

@simonsickle-old
Created August 7, 2017 15:29
Show Gist options
  • Save simonsickle-old/c1af31566f09b1ddb56047b855217fd7 to your computer and use it in GitHub Desktop.
Save simonsickle-old/c1af31566f09b1ddb56047b855217fd7 to your computer and use it in GitHub Desktop.
Convert longIP to standard human readable IPs
#!/usr/bin/python
import csv
from socket import inet_ntoa
from struct import pack
def long2ip(ip):
return inet_ntoa(pack("!L", ip))
with open('demo.csv', 'rb') as infile, open("ip-correct-2.csv", "wb") as outfile:
data = csv.DictReader(infile, delimiter=',')
header = data.fieldnames
writer = csv.DictWriter(outfile, fieldnames=header, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL)
writer.writeheader()
# Skip header
next(data, None)
for row in data:
ip = int(row['ip'])
new_ip = long2ip(ip)
row['ip'] = new_ip
writer.writerow(row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment