Skip to content

Instantly share code, notes, and snippets.

@manashmandal
Created October 21, 2016 06:38
Show Gist options
  • Save manashmandal/a9e23ea9b8c6339e296d2698a7bc0f48 to your computer and use it in GitHub Desktop.
Save manashmandal/a9e23ea9b8c6339e296d2698a7bc0f48 to your computer and use it in GitHub Desktop.
import pandas as pd
import geoip2.database
mmdb_path = 'C:\\Users\\Manash\\Downloads\\Compressed\\GeoLite2-Country.mmdb\\GeoLite2-Country.mmdb'
ipaddress_path = 'C:\\Users\\Manash\\Downloads\\IP_Address.csv'
ipdf = pd.read_csv(ipaddress_path)
reader = geoip2.database.Reader(mmdb_path)
for ip in ipdf['IP Address']:
try:
print(reader.country(ip).country.name)
except:
pass
@manashmandal
Copy link
Author

manashmandal commented Oct 21, 2016

Output:

United States
Japan
China
France
China
Spain
United States
United States
United States
France
Australia
United States
United States
United States
Japan
Germany
United States
India
Republic of Korea
United States
United States
United States
United States
Brazil
Russia
Mexico
United States
United States
Russia
United States
United States
United Kingdom
United States
Taiwan
Germany
United States
Pakistan
Japan
Zambia
Egypt
United States
United Kingdom
Japan
United States
China
United States
United States
China
Mexico
China
India
United States
United States
India
China
Netherlands
United States
United States
China
United States
Belgium
Russia
United States
Argentina
United States
China
United States
Brazil
Brazil
Georgia
Japan
Canada
United States
United States
Slovak Republic
United States
Norway
India
Japan

Missing: 21

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment