How to get IP addresses from ip2location database?

Question

I have downloaded IP2Proxy™ LITE database in csv format, below is the data in it

could anybody please help me how to read the ip addresses using python or powershell as it seems in plain number. Also please explain what does 1st to column represents.

is your question: how to read a csv in python? https://stackoverflow.com/questions/41585078/how-do-i-read-and-write-csv-files-with-python — Sembei Norimaki, Nov 02 '22 at 13:57
@SembeiNorimaki No it's about the 1st and 2nd column in image if they represent ip then how to convert them from correct format e.g. 10.10.10.10 — Naveen Kumar, Nov 02 '22 at 17:13
@NaveenKumar Did you read the FAQ? It explains how you convert those values — DarkKnight, Nov 02 '22 at 17:35

DarkKnight · Accepted Answer · 2022-11-04T07:50:44.867

1

Here's how you can convert those values into a string representation of an IPv4 address:

def convert(ip):
        def _genip(n):
            for shift in range(24, -8, -8):
                yield f'{(n >> shift) & 0xff:03d}'
        return '.'.join(list(_genip(int(ip))))
print(convert('34676992'))

Output:

002.017.033.000

edited Nov 04 '22 at 07:50

answered Nov 02 '22 at 18:54

DarkKnight

19,739
3
6
22

Thanks @Cobra just want to know what 1st and 2nd column represents, as it seems both are ip's – Naveen Kumar Nov 04 '22 at 07:47
I am using `$number = 2147483648 $w = [int]($number/16777216)%256 $x = [int]($number/65536)%256 $y = [int]($number/256)%256 $z = [int]$number%256 $ipAddress = "$w.$x.$y.$z"` But getting **Cannot convert value "2147483648" to type "System.Int32". Error: "Value was either too large or too small for an Int32."** – Naveen Kumar Nov 23 '22 at 12:40
@NaveenKumar Your question is tagged for Python. The INT32 limitation is nothing to do with Python – DarkKnight Nov 29 '22 at 11:15

How to get IP addresses from ip2location database?

1 Answers1