In [5]:
import matplotlib.pyplot as plt
import seaborn as sns
import numpy as np
import pandas as pd
from pymongo import MongoClient
from geopy.geocoders import Nominatim
locate = Nominatim()
client = MongoClient()
db = client.twitterCleanDb
tweetCollection = db.tenKtweetsCleaned
times = []
polarities = []
subjectivities = []
locations = []
locationPolarities = []
lats = []
longs = []
modiTweets = tweetCollection.find({'cleantest' :{'$regex': '.*a*.'}})
for tweet in modiTweets:
times.append(tweet['created_at'])
polarities.append(tweet['polarity'])
subjectivities.append(tweet['subjectivity'])
latlong = locate.geocode(tweet['user']['location'], timeout = 10)
if latlong is None:
latlong = locate.geocode(tweet['user']['time_zone'], timeout = 10)
if latlong is None:
print('appended')
else:
locations.append([latlong.latitude, latlong.longitude])
print('appended 1', latlong, latlong.latitude, latlong.longitude)
locationPolarities.append(tweet['polarity'])
else:
locations.append([latlong.latitude, latlong.longitude])
print('appended 2', latlong, latlong.latitude, latlong.longitude)
locationPolarities.append(tweet['polarity'])
appended 2 Nederland 52.2379891 5.53460738161551 appended 2 Harris County, Texas, 77449, United States of America 29.8207822747902 -95.7366129150998 appended 2 Tarpon Springs, Pinellas County, Florida, 34689, United States of America 28.1477885 -82.7774086726313 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 Mabunda, Município de Luanda, Luanda, 64346, Angola -8.8483112 13.2076618 appended 2 Santa Marta, Magdalena, Colombia 11.0869172 -73.8806606343634 appended 2 Kalamazoo, Kalamazoo County, Michigan, United States of America 42.291707 -85.5872286 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 United States of America 39.7837304 -100.4458825 appended 2 नेपाल 28.1083929 84.0917139 appended 2 Nigeria 9.6000359 7.9999721 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 Niort, Deux-Sèvres, Nouvelle-Aquitaine, France métropolitaine, 79000, France 46.3239455 -0.4645212 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Campana, CS, CAL, Italia 39.4124481 16.8225645 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 2 Maryland, United States of America 39.5162234 -76.9382069 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Moon, Marathon County, Wisconsin, United States of America 44.7716333 -89.787902 appended 2 Helsingborg, Skåne, Götaland, 252 68, Sverige 56.0441984 12.7040684 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 United States of America 39.7837304 -100.4458825 appended 2 General Luna, Surigao Del Norte, Caraga, 8419, Philippines 9.80067315 126.118702106101 appended 2 Annapolis, Anne Arundel County, Maryland, United States of America 38.9786401 -76.492786 appended 2 Marseille, Bouches-du-Rhône, Provence-Alpes-Côte d'Azur, France métropolitaine, 13000, France 43.2961743 5.3699525 appended 2 Brazil, Clay County, Indiana, 47834, United States of America 39.523652 -87.1250154 appended 2 Tallahassee, Leon County, Florida, United States of America 30.4380832 -84.2809332 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Winchester, Winchester City, Virginia, United States of America 39.1852184 -78.1652404 appended 2 KL, Malaysia 3.1546872 101.7136362 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Lafayette, Lafayette Parish, Louisiana, United States of America 30.2240897 -92.0198427 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Estados Unidos, Becerril, Cesar, Colombia 9.624388 -73.2125095 appended 2 Rachel, Lincoln County, Nevada, 89001, United States of America 37.6413209 -115.748361 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Wales, UK 52.2928116 -3.73893 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Ctes., Argentina -28.5912315 -57.9394658 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 서울특별시, 대한민국 37.5666791 126.9782914 appended 2 Michigan, United States of America 43.6211955 -84.6824346 appended 2 Listening, 600, 5th Avenue, West Edge, International District/Chinatown, Seattle, King County, Washington, 98104, United States of America 47.6041834 -122.3292397 appended 2 اليمن 16.3471243 47.8915271 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 La Camila, Departamento San Martín, SDE, G4322, Argentina -28.1652832 -63.64468 appended 2 Braga, Cávado, Norte, 4700-435, Portugal 41.5510583 -8.4280045 appended 2 Chapel Hill, Orange County, North Carolina, United States of America 35.9131542 -79.05578 appended 2 Miami, Miami-Dade County, Florida, United States of America 25.7742658 -80.1936589 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Westfield, Hamilton County, Indiana, United States of America 40.0428151 -86.1274888 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Corpus Christi, Nueces County, Texas, United States of America 27.8002542 -97.3955744 appended 2 Waukesha, Waukesha County, Wisconsin, United States of America 43.0116784 -88.2314813 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Minha casa, 1480, Rua Tamoio, Niterói, Sede, Canoas, Microrregião de Porto Alegre, Região Metropolitana de Porto Alegre, Mesorregião Metropolitana de Porto Alegre, RS, Região Sul, 92120-001, Brasil -29.9476433 -51.1695867 appended 2 Glasgow, Glasgow City, Scotland, G, UK 55.856656 -4.2435817 appended 2 Deutschland, Europe 51.0834196 10.4234469 appended 2 Manchester, Greater Manchester, North West England, England, UK 53.4791301 -2.2441009 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Greenville, Greenville County, South Carolina, United States of America 34.851354 -82.3984882 appended 2 Tucumán, San Miguel de Tucumán, Departamento Capital, TU, T4000, Argentina -26.8303703 -65.2038133 appended 2 Wisconsin, United States of America 44.4308975 -89.6884637 appended 2 NYC, New York, United States of America 40.7306458 -73.9866136 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Ghana 8.0300284 -1.0800271 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 St. Petersburg, FL, 2nd Avenue North, Methodist Town, St. Petersburg, Pinellas County, Florida, 33701, United States of America 27.77330515 -82.6469934 appended 2 El Paso City, El Paso County, Texas, United States of America 31.8111305 -106.501349395577 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 2 پاکستان 30.3308401 71.247499 appended 2 Wilson, Wilson County, North Carolina, 27893, United States of America 35.7212689 -77.9155395 appended appended 2 England, UK 52.7954791 -0.540240286617432 appended 2 Perth, Padbury Walk, Northbridge, Perth, Western Australia, 6005, Australia -31.9513659 115.860389528787 appended 1 Arizona, United States of America 34.395342 -111.7632755 appended 2 European Union, Ananda Coomaraswami Mawatha, Cinnamon Gardens, Colombo, කොළඹ දිස්ත්රික්කය, Western Province, 0007, ශ්රී ලංකාව இலங்கை 6.9116138 79.8578631 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 Minneapolis, Hennepin County, Minnesota, United States of America 44.9772995 -93.2654692 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Texas, United States of America 31.8160381 -99.5120986 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Redmond, King County, Washington, United States of America 47.6694141 -122.1238767 appended 2 Stone Mountain, DeKalb County, Georgia, 30087, United States of America 33.8062166 -84.1457505 appended 2 Toronto, Ontario, Canada 43.653963 -79.387207 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 2 Dallas, Dallas County, Texas, United States of America 32.7762719 -96.7968559 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Happiness, Rotonda, Charlotte County, Florida, 33981, United States of America 26.925995 -82.25603 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 John B. Keane Road, Listowel, Listowel Urban, Listowel, County Kerry, Munster, V31TR74, Ireland 52.4498412 -9.4777916 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 2 California, United States of America 36.7014631 -118.7559974 appended appended 2 United States of America 39.7837304 -100.4458825 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Boston, Suffolk County, Massachusetts, United States of America 42.3604823 -71.0595678 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Washington, District of Columbia, United States of America 38.8949549 -77.0366456 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Englewood, Chicago, Cook County, Illinois, 60636, United States of America 41.7797559 -87.6458836 appended appended 2 Canada 61.0666922 -107.9917071 appended 2 Lowndes County, Georgia, United States of America 30.8195619 -83.2628255 appended 1 กรุงเทพมหานคร, ประเทศไทย 13.7538929 100.8160803 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Miami Drive, Tallahassee, Leon County, Florida, 32311, United States of America 30.429583 -84.217732 appended appended 2 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 NYC, New York, United States of America 40.7306458 -73.9866136 appended 2 Oregon, United States of America 43.9792797 -120.737257 appended 2 Drexel Hill, Valley Road, Upper Darby Township, Delaware County, Pennsylvania, 19026, United States of America 39.9483282 -75.306887787778 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 NYC, New York, United States of America 40.7306458 -73.9866136 appended 2 Hulu Kelang, Selangor, 53100, Malaysia 3.209928 101.7608508 appended appended 2 California, United States of America 36.7014631 -118.7559974 appended 2 BK, Kings County, NYC, New York, 11226, United States of America 40.6501038 -73.9495823 appended appended 2 Atlanta, Fulton County, Georgia, United States of America 33.7490987 -84.3901849 appended 1 Београд, Централна Србија, 11000, Србија 44.8178131 20.4568974 appended 2 England, Legoland Windsor, Rose Cottages, Oakley Green, Windsor and Maidenhead, South East, England, SL4 4AU, UK 51.46426255 -0.651714721140142 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Nederland 52.2379891 5.53460738161551 appended 2 Hamilton, Ontario, L8N 1A3, Canada 43.255205 -79.868202 appended appended 2 India 22.3511148 78.6677428 appended 2 North America 51.0000002 -109.0000002 appended 2 Uddingston, South Lanarkshire, Scotland, G71 7ES, UK 55.8170913 -4.0822926 appended appended 2 Ciudad de México, Cuauhtémoc, CDMX, 06060, México 19.4326009 -99.1333416 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Crieff, Perth and Kinross, Scotland, PH7 3HU, UK 56.372717 -3.8397453 appended 1 Helsinki, Helsingin seutukunta, Uusimaa, Etelä-Suomi, Manner-Suomi, Suomi 60.1674086 24.9425683 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 2 Norwich, Norfolk, East of England, England, UK 52.628606 1.29227 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Home of the Brave, King Street West, King West, Old Toronto, Toronto, Ontario, M5V 1M5, Canada 43.6442782 -79.4002211 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended appended 2 Queens County, NYC, New York, United States of America 40.6524927 -73.7914214158161 appended 2 Mansour, حي الأندلس, الكرخ, محافظة بغداد, 10013, العراق 33.321756 44.335385 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 2 Columbus, Franklin County, Ohio, United States of America 39.9622601 -83.0007065 appended 2 O Town, Railway Parade North, Syndal, Glen Waverley, City of Monash, Greater Melbourne, Victoria, 3150, Australia -37.8789504 145.1625316 appended 2 Miami Beach, Miami-Dade County, Florida, United States of America 25.7881436 -80.1272705 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 2 Motherwell, North Lanarkshire, Scotland, ML1, UK 55.7915214 -3.9823503 appended 2 Allahabad, Uttar Pradesh, India 25.2859603 81.896732069544 appended 2 原宿, 表参道, 渋谷1, 渋谷区, 東京都, 150-0001, 日本 35.6687049 139.7053357 appended 2 서울특별시, 대한민국 37.5666791 126.9782914 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Lusaka, Lusaka Province, Zambia -15.416697 28.281381 appended 2 NYC, New York, United States of America 40.7306458 -73.9866136 appended 2 United States of America 39.7837304 -100.4458825 appended 2 Bournemouth, South West England, England, UK 50.74467035 -1.85798090318094 appended 2 Nairobi, Kenya -1.2832533 36.8172449 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 กรุงเทพมหานคร, ประเทศไทย 13.7538929 100.8160803 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Africa 2.0000003 15.9999997 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Newcastle, Amajuba District Municipality, KwaZulu-Natal, 2940, South Africa -27.762778 29.923889 appended 2 Boston, Suffolk County, Massachusetts, United States of America 42.3604823 -71.0595678 appended 2 NYC, New York, United States of America 40.7306458 -73.9866136 appended 2 Toronto, Ontario, Canada 43.653963 -79.387207 appended 2 Казахстан 47.2286086 65.2093197 appended 2 LA, Los Angeles County, California, United States of America 34.054935 -118.244476 appended 2 Montebello, Papineau, Outaouais, Québec, Canada 45.6512171 -74.942673 appended 2 Turtle Island, Oxford County, Maine, United States of America 44.0357402 -70.4837919763434 appended 2 East Midlands, England, UK 52.79657515 -0.671822256833873 appended 2 Boston, Suffolk County, Massachusetts, United States of America 42.3604823 -71.0595678 appended 2 Beach City, Chambers County, Texas, United States of America 29.7419486 -94.8395296 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 England, UK 52.7954791 -0.540240286617432 appended 2 Team Mystic Mural, Bromley Road, Downham, London Borough of Lewisham, London, Greater London, England, BR1 4JT, UK 51.419243 0.0015531 appended 2 Sussex, St. Helena Lane, Streat, Lewes, East Sussex, South East, England, BN7 3DH, UK 50.94468065 -0.06192935288129 appended 2 Omaha, Douglas County, Nebraska, United States of America 41.2587317 -95.9378732 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Nairobi, Kenya -1.2832533 36.8172449 appended 2 Accra, Accra Metropolitan, Greater Accra Region, 0302, Ghana 5.5600141 -0.2057437 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Baby, Provins, Seine-et-Marne, Île-de-France, France métropolitaine, 77480, France 48.3955294 3.3427924 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 Warsaw, Richmond County, Virginia, United States of America 37.9587465 -76.7580211 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Annandale-on-Hudson, Town of Red Hook, Dutchess County, New York, 12504, United States of America 42.0128695 -73.9081901 appended 2 United States of America 39.7837304 -100.4458825 appended 2 Manchester, Greater Manchester, North West England, England, UK 53.4791301 -2.2441009 appended 2 Maine, United States of America 45.709097 -68.8590201 appended appended 2 Michigan, United States of America 43.6211955 -84.6824346 appended 2 Columbus, Franklin County, Ohio, United States of America 39.9622601 -83.0007065 appended 2 Texas, United States of America 31.8160381 -99.5120986 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Montréal, Montréal (06), Québec, Canada 45.4972159 -73.6103642 appended appended 2 Rolla, Phelps County, Missouri, United States of America 37.9513575 -91.771792 appended 2 Jammu, Jammu and Kashmir, 180004, India 32.7185614 74.8580917 appended 2 Juiz de Fora, Microrregião Juiz de Fora, Mesorregião Zona da Mata, MG, Região Sudeste, Brasil -21.7609533 -43.3501129 appended 2 Nowhere, Franklin County, Kansas, United States of America 38.7311123 -95.2414104 appended 2 Vulcan, Mureș, 547043, România 46.1495325 24.8544374569545 appended appended 1 Amsterdam, Centrum, Amsterdam, Noord-Holland, Nederland 52.3745403 4.89797550561798 appended 2 Leeds, Yorkshire and the Humber, England, UK 53.7974185 -1.5437941 appended 2 Berlin, 10117, Deutschland 52.5170365 13.3888599 appended 2 Barcelona, BCN, CAT, España 41.3828939 2.1774322 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Northern Frontier, San Diego, San Diego County, California, 92103-3607, United States of America 32.7349196 -117.1545974 appended 2 Carlow, County Carlow, Leinster, R93 V960, Ireland 52.8408344 -6.9261131 appended 2 Nashville-Davidson, Davidson County, Tennessee, United States of America 36.1622296 -86.7743531 appended 2 NYC, New York, United States of America 40.7306458 -73.9866136 appended 2 Siliguri, Darjiling, Darjeeling, West Bengal, India 26.7164127 88.4309916 appended 2 Vault, Châteaubriant-Ancenis, Loire-Atlantique, Pays de la Loire, France métropolitaine, 44390, France 47.465651 -1.4823004 appended 2 Baltimore, Maryland, 21203, United States of America 39.2908816 -76.610759 appended 2 U.S.A, Depósito de Evaporación Solar El Caracol, Ecatepec de Morelos, Estado de México, 55107, México 19.5584043 -99.0277414 appended appended 1 Quito, Pichincha, Ecuador -0.2130423 -78.501997 appended 2 Huddersfield, Yorkshire and the Humber, England, HD1 2AA, UK 53.6466645 -1.7822482 appended 2 Reims, Marne, Grand Est, France métropolitaine, 51100, France 49.2577886 4.031926 appended 2 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 Washington, District of Columbia, United States of America 38.8949549 -77.0366456 appended 2 San Antonio, Bexar County, Texas, United States of America 29.4246002 -98.4951405 appended 1 Amsterdam, Centrum, Amsterdam, Noord-Holland, Nederland 52.3745403 4.89797550561798 appended 2 Philippines 12.7503486 122.7312101 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 2 Boston, Suffolk County, Massachusetts, United States of America 42.3604823 -71.0595678 appended 2 Everything Everywhere, Grovesnor Square, Macclesfield, Cheshire East, North West England, England, SK11 6AX, UK 53.26022 -2.126926 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 France métropolitaine, France 46.603354 1.8883335 appended 2 Forter Castle, C26, Little Forter, Angus, Scotland, PH11 8QW, UK 56.7695284 -3.3333906 appended 2 Paris, Île-de-France, France métropolitaine, France 48.8566101 2.3514992 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Georgia, United States of America 32.3293809 -83.1137366 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 San Francisco, 9405, Boulevard Leduc, Quartier DIX30, Brossard, Longueuil (agglomeration), Montérégie, Québec, J4Y 0A5, Canada 45.4423543 -73.4373087 appended 2 Philadelphia, Philadelphia County, Pennsylvania, United States of America 39.9523993 -75.1635899 appended 2 Philadelphia, Philadelphia County, Pennsylvania, United States of America 39.9523993 -75.1635899 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Hagerstown, Washington County, Maryland, United States of America 39.6419219 -77.7202641 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Titusville, Crawford County, Pennsylvania, United States of America 41.624468 -79.669652 appended 2 Portland, Multnomah County, Oregon, United States of America 45.5202471 -122.6741949 appended 2 England, Legoland Windsor, Rose Cottages, Oakley Green, Windsor and Maidenhead, South East, England, SL4 4AU, UK 51.46426255 -0.651714721140142 appended 1 Arizona, United States of America 34.395342 -111.7632755 appended 2 Île-de-France, France métropolitaine, France 48.6443057 2.7537863 appended 2 BK, Kings County, NYC, New York, 11226, United States of America 40.6501038 -73.9495823 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Argentina -34.9964963 -64.9672817 appended 2 Cheshire, Whatcroft Lane, Davenham, Whatcroft, Cheshire West and Chester, North West England, England, CW9 7SQ, UK 53.2141028 -2.47177008607121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Milwaukee, Milwaukee County, Wisconsin, United States of America 43.0349931 -87.922497 appended 2 Kroonstad, Fezile Dabi District Municipality, Free State, South Africa -27.6532701 27.235515 appended 2 Universe, Whinhall, Mosside, North Lanarkshire, Scotland, ML6, UK 55.85881005 -4.00208685912683 appended appended 2 Lake Ridge, Prince William County, Virginia, United States of America 38.687894 -77.2977618 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Miami, Miami-Dade County, Florida, United States of America 25.7742658 -80.1936589 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 2 India 22.3511148 78.6677428 appended 2 ABQ, Bernalillo County, New Mexico, United States of America 35.0841034 -106.6509851 appended 1 Quito, Pichincha, Ecuador -0.2130423 -78.501997 appended 2 Grenada, Grenada County, Mississippi, 38901, United States of America 33.7690049 -89.8084192 appended 2 Louisiana, United States of America 30.8703881 -92.007126 appended 2 Cumberland, Allegany County, Maryland, 21502, United States of America 39.6528509 -78.7624714 appended 2 LA International, Etruria, Stoke-on-Trent, West Midlands, England, ST1 5UB, UK 53.029256 -2.19979110233224 appended 2 Sunbury, Delaware County, Ohio, United States of America 40.2425623 -82.8590673 appended 1 İstanbul, Fatih, İstanbul, Marmara Bölgesi, 34126, Türkiye 41.0096334 28.9651646 appended 2 CABA, Argentina -34.6075616 -58.437076 appended appended 2 Arvada, Jefferson County, Colorado, United States of America 39.8211225 -105.220742990446 appended 2 England, UK 52.7954791 -0.540240286617432 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Royal Leamington Spa, Warwickshire, West Midlands, England, CV32 4DN, UK 52.2921548 -1.5356986 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 America/New_York Timezone, Carriage House Circle, Trinity, Randolph County, North Carolina, 27370, United States of America 35.8552727 -80.0162562961353 appended 2 La Nava de Santiago, Badajoz, Extremadura, España 39.0618905 -6.5050901 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 Kolkata, Hāora, West Bengal, 700021, India 22.5677459 88.3476023 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Kenya 1.4419683 38.4313975 appended 2 Annecy, Haute-Savoie, Auvergne-Rhône-Alpes, France métropolitaine, 74000, France 45.88975045 6.135465100226 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 Atlanta, Fulton County, Georgia, United States of America 33.7490987 -84.3901849 appended 2 Sydney, NSW, Australia -33.8548157 151.2164539 appended appended 2 Worldwide, 2641, Northeast Alberta Street, King, Portland, Multnomah County, Oregon, 97217, United States of America 45.5591381 -122.638103 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Kanpur, Kanpur Nagar, Uttar Pradesh, 208012, India 26.4609135 80.3217588 appended 1 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 India 22.3511148 78.6677428 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 New Delhi, Delhi, India 28.6141793 77.2022662 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 Hassan, Hasana taluk, Hassan district, Karnataka, 573201, India 13.0070817 76.0992703 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Delhi, Central Delhi, Delhi, 110006, India 28.6517178 77.2219388 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended appended 2 Jalandhar, Jullundur, Jalandhar, Punjab, 144001, India 31.3323762 75.576889 appended 2 Aya Nagar, South Delhi, Delhi, India 28.47649105 77.1329131592514 appended 2 Surat, Bharūch, Surat, Gujarat, 395001, India 21.1864607 72.8081281 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 Bengaluru, Bangalore Urban, Karnataka, India 12.9791198 77.5912997 appended 1 New Delhi, Delhi, India 28.6141793 77.2022662 appended 2 Kanpur, Kanpur Nagar, Uttar Pradesh, 208012, India 26.4609135 80.3217588 appended 1 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 India 22.3511148 78.6677428 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 New Delhi, Delhi, India 28.6141793 77.2022662 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 Hassan, Hasana taluk, Hassan district, Karnataka, 573201, India 13.0070817 76.0992703 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Delhi, Central Delhi, Delhi, 110006, India 28.6517178 77.2219388 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended appended 2 Jalandhar, Jullundur, Jalandhar, Punjab, 144001, India 31.3323762 75.576889 appended 2 Aya Nagar, South Delhi, Delhi, India 28.47649105 77.1329131592514 appended 2 Surat, Bharūch, Surat, Gujarat, 395001, India 21.1864607 72.8081281 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 India 22.3511148 78.6677428 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 Bengaluru, Bangalore Urban, Karnataka, India 12.9791198 77.5912997 appended 2 India 22.3511148 78.6677428 appended 2 South Proud Street, Muncie, Delaware County, Indiana, 47305, United States of America 40.192971 -85.395372 appended 2 India 22.3511148 78.6677428 appended 2 Kanpur, Kanpur Nagar, Uttar Pradesh, 208012, India 26.4609135 80.3217588 appended 2 Việt Nam 13.2904027 108.4265113 appended 2 Allahabad, Uttar Pradesh, India 25.2859603 81.896732069544 appended 2 Gwalior, Madhya Pradesh, 474002, India 26.2 78.2 appended 2 India, Salta, Municipio de Salta, Capital, SA, 4400, Argentina -24.8339082 -65.3822399 appended 1 Kolkata, Hāora, West Bengal, 700021, India 22.5677459 88.3476023 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 India 22.3511148 78.6677428 appended 2 Mumbai, Greater Bombay, Mumbai Suburban, Maharashtra, India 19.1334321 72.8882172 appended 2 Bengaluru, Bangalore Urban, Karnataka, India 12.9791198 77.5912997 appended 2 India 22.3511148 78.6677428 appended 2 South Proud Street, Muncie, Delaware County, Indiana, 47305, United States of America 40.192971 -85.395372 appended 2 India 22.3511148 78.6677428 appended 2 Kanpur, Kanpur Nagar, Uttar Pradesh, 208012, India 26.4609135 80.3217588 appended 2 Việt Nam 13.2904027 108.4265113 appended 2 Nicasio, Marin County, California, 94946, United States of America 38.0615885 -122.6985975 appended 2 Essex County, New Jersey, United States of America 40.7913922 -74.2479444 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Grand Prairie, Dallas County, Texas, United States of America 32.657368 -97.0284662417504 appended 2 Dayton, Montgomery County, Ohio, United States of America 39.7589478 -84.1916069 appended appended appended 2 Missouri, United States of America 38.7604815 -92.5617875 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Modesto, Stanislaus County, California, United States of America 37.6390972 -120.9968782 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 2 Huntington, Suffolk County, New York, United States of America 40.868154 -73.425676 appended 2 Philadelphia, Philadelphia County, Pennsylvania, United States of America 39.9523993 -75.1635899 appended 2 Las Vegas, Clark County, Nevada, United States of America 36.1662859 -115.149225 appended 2 Pickerington, Fairfield County, Ohio, 43147, United States of America 39.8842304 -82.7535049 appended 2 Heaven, Villiers Street, St Clement Danes, Covent Garden, City of Westminster, London, Greater London, England, WC2N 6NG, UK 51.507865 -0.1245597 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Chicago, Cook County, Illinois, United States of America 41.8755546 -87.6244212 appended 2 Colorado, United States of America 38.7251776 -105.6077167 appended 2 There is a village here, Balkan welaýaty, Türkmenistan 38.1619307 56.2536543 appended 2 Baltimore, Maryland, 21203, United States of America 39.2908816 -76.610759 appended 2 Gainesville, Alachua County, Florida, United States of America 29.6519396 -82.3249961 appended 2 Florida, United States of America 27.7567667 -81.4639835 appended 2 LA, Los Angeles County, California, United States of America 34.054935 -118.244476 appended appended 2 Florida, United States of America 27.7567667 -81.4639835 appended 2 LA, Los Angeles County, California, United States of America 34.054935 -118.244476 appended appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 Bank of America Center, 230, South Clark Street, Loop, Chicago, Cook County, Illinois, 60611, United States of America 41.87848185 -87.6314994083818 appended 2 Schleswig-Holstein, Deutschland 54.1853998 9.8220089 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 Bank of America Center, 230, South Clark Street, Loop, Chicago, Cook County, Illinois, 60611, United States of America 41.87848185 -87.6314994083818 appended 2 Schleswig-Holstein, Deutschland 54.1853998 9.8220089 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Việt Nam 13.2904027 108.4265113 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Việt Nam 13.2904027 108.4265113 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Việt Nam 13.2904027 108.4265113 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Ontario, Canada 50.000678 -86.000977 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Ontario, Canada 50.000678 -86.000977 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Ontario, Canada 50.000678 -86.000977 appended 2 South Australia, Australia -30.5343665 135.6301212 appended 2 Miami, Miami-Dade County, Florida, United States of America 25.7742658 -80.1936589 appended 2 South Australia, Australia -30.5343665 135.6301212 appended 2 Miami, Miami-Dade County, Florida, United States of America 25.7742658 -80.1936589 appended 2 South Australia, Australia -30.5343665 135.6301212 appended 2 Miami, Miami-Dade County, Florida, United States of America 25.7742658 -80.1936589 appended appended 2 Texas Forever, Eldridge Parkway, Alief, Harris County, Texas, 77083, United States of America 29.6890054 -95.6227567 appended 2 تونس 33.8439408 9.400138 appended appended 2 Texas Forever, Eldridge Parkway, Alief, Harris County, Texas, 77083, United States of America 29.6890054 -95.6227567 appended 2 تونس 33.8439408 9.400138 appended appended 2 Texas Forever, Eldridge Parkway, Alief, Harris County, Texas, 77083, United States of America 29.6890054 -95.6227567 appended 2 تونس 33.8439408 9.400138 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Pisces, Groceville, Montgomery County, Texas, 77306, United States of America 30.3276618 -95.3139087 appended 2 Minnesota, United States of America 45.9896587 -94.6113288 appended 2 Pisces, Groceville, Montgomery County, Texas, 77306, United States of America 30.3276618 -95.3139087 appended 2 Minnesota, United States of America 45.9896587 -94.6113288 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Tardis, 20, გიორგი ახვლედიანის ქუჩა, ფიქრის გორა, ვერე, ძველი თბილისის რაიონი, თბილისი, 0108, საქართველო 41.7066548 44.7889604 appended appended 2 South Glens Falls, Moreau, Saratoga County, New York, 12803, United States of America 43.299447 -73.635178 appended 2 Tardis, 20, გიორგი ახვლედიანის ქუჩა, ფიქრის გორა, ვერე, ძველი თბილისის რაიონი, თბილისი, 0108, საქართველო 41.7066548 44.7889604 appended appended 2 South Glens Falls, Moreau, Saratoga County, New York, 12803, United States of America 43.299447 -73.635178 appended 2 Tardis, 20, გიორგი ახვლედიანის ქუჩა, ფიქრის გორა, ვერე, ძველი თბილისის რაიონი, თბილისი, 0108, საქართველო 41.7066548 44.7889604 appended appended 2 South Glens Falls, Moreau, Saratoga County, New York, 12803, United States of America 43.299447 -73.635178 appended 2 Amsterdam, Centrum, Amsterdam, Noord-Holland, Nederland 52.3745403 4.89797550561798 appended 2 Amsterdam, Centrum, Amsterdam, Noord-Holland, Nederland 52.3745403 4.89797550561798 appended 2 Amsterdam, Centrum, Amsterdam, Noord-Holland, Nederland 52.3745403 4.89797550561798 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Washington, District of Columbia, United States of America 38.8949549 -77.0366456 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Washington, District of Columbia, United States of America 38.8949549 -77.0366456 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Washington, District of Columbia, United States of America 38.8949549 -77.0366456 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Bengaluru, Bangalore Urban, Karnataka, India 12.9791198 77.5912997 appended 2 Rubicone, FC, EMR, 47043, Italia 44.0933443 12.3960576 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Bengaluru, Bangalore Urban, Karnataka, India 12.9791198 77.5912997 appended 2 Rubicone, FC, EMR, 47043, Italia 44.0933443 12.3960576 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Bengaluru, Bangalore Urban, Karnataka, India 12.9791198 77.5912997 appended 2 Rubicone, FC, EMR, 47043, Italia 44.0933443 12.3960576 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 BK, Kings County, NYC, New York, 11226, United States of America 40.6501038 -73.9495823 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 2 BK, Kings County, NYC, New York, 11226, United States of America 40.6501038 -73.9495823 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 2 BK, Kings County, NYC, New York, 11226, United States of America 40.6501038 -73.9495823 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 2 Virginia, United States of America 37.1232245 -78.4927721 appended 2 Oklahoma, United States of America 34.9550817 -97.2684063 appended 2 Virginia, United States of America 37.1232245 -78.4927721 appended 2 Oklahoma, United States of America 34.9550817 -97.2684063 appended 2 Virginia, United States of America 37.1232245 -78.4927721 appended 2 Oklahoma, United States of America 34.9550817 -97.2684063 appended 2 Seattle, King County, Washington, United States of America 47.6038321 -122.3300624 appended 2 BK, Kings County, NYC, New York, 11226, United States of America 40.6501038 -73.9495823 appended 2 Knaresborough, North Yorkshire, Yorkshire and the Humber, England, HG5 0BZ, UK 54.0099825 -1.462186 appended 2 Seattle, King County, Washington, United States of America 47.6038321 -122.3300624 appended 2 BK, Kings County, NYC, New York, 11226, United States of America 40.6501038 -73.9495823 appended 2 Knaresborough, North Yorkshire, Yorkshire and the Humber, England, HG5 0BZ, UK 54.0099825 -1.462186 appended 2 Seattle, King County, Washington, United States of America 47.6038321 -122.3300624 appended 2 BK, Kings County, NYC, New York, 11226, United States of America 40.6501038 -73.9495823 appended 2 Knaresborough, North Yorkshire, Yorkshire and the Humber, England, HG5 0BZ, UK 54.0099825 -1.462186 appended 2 L.A., Beetz, Kremmen, Landkreis Oberhavel, Brandenburg, 16766, Deutschland 52.8454307 13.0011564 appended 2 Johannesburg, City of Johannesburg Metropolitan Municipality, Gauteng, 2001, South Africa -26.205 28.049722 appended 2 L.A., Beetz, Kremmen, Landkreis Oberhavel, Brandenburg, 16766, Deutschland 52.8454307 13.0011564 appended 2 Johannesburg, City of Johannesburg Metropolitan Municipality, Gauteng, 2001, South Africa -26.205 28.049722 appended 2 L.A., Beetz, Kremmen, Landkreis Oberhavel, Brandenburg, 16766, Deutschland 52.8454307 13.0011564 appended 2 Johannesburg, City of Johannesburg Metropolitan Municipality, Gauteng, 2001, South Africa -26.205 28.049722 appended 2 England, UK 52.7954791 -0.540240286617432 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 England, UK 52.7954791 -0.540240286617432 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended appended 2 Nkandla, uThungulu District Municipality, KwaZulu-Natal, South Africa -28.62 31.090556 appended 2 Chandler, Maricopa County, Arizona, United States of America 33.3067132 -111.8408489 appended 2 Nkandla, uThungulu District Municipality, KwaZulu-Natal, South Africa -28.62 31.090556 appended 2 Chandler, Maricopa County, Arizona, United States of America 33.3067132 -111.8408489 appended 2 Nkandla, uThungulu District Municipality, KwaZulu-Natal, South Africa -28.62 31.090556 appended 2 Chandler, Maricopa County, Arizona, United States of America 33.3067132 -111.8408489 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 South Australia, Australia -30.5343665 135.6301212 appended 2 Santa Clara County, California, CA, United States of America 37.034583193882 -121.517372158299 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 South Australia, Australia -30.5343665 135.6301212 appended 2 Santa Clara County, California, CA, United States of America 37.034583193882 -121.517372158299 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 South Australia, Australia -30.5343665 135.6301212 appended 2 Santa Clara County, California, CA, United States of America 37.034583193882 -121.517372158299 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 Athens, Athens - Clarke County, Georgia, 30609, United States of America 33.9550905 -83.3881868 appended 1 Athens, Athens - Clarke County, Georgia, 30609, United States of America 33.9550905 -83.3881868 appended 1 Athens, Athens - Clarke County, Georgia, 30609, United States of America 33.9550905 -83.3881868 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Jakarta, Gambir, Jakarta Pusat, Daerah Khusus Ibukota Jakarta, 10110, Indonesia -6.1753942 106.827183 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Jakarta, Gambir, Jakarta Pusat, Daerah Khusus Ibukota Jakarta, 10110, Indonesia -6.1753942 106.827183 appended 1 Time, King Street West, University District, Kingston, Ontario, K7L2V3, Canada 44.2222023 -76.4986098 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Jakarta, Gambir, Jakarta Pusat, Daerah Khusus Ibukota Jakarta, 10110, Indonesia -6.1753942 106.827183 appended 2 Dallas, Dallas County, Texas, United States of America 32.7762719 -96.7968559 appended 2 Chennai, Chennai district, Tamil Nadu, India 13.0801721 80.2838331 appended 2 Dallas, Dallas County, Texas, United States of America 32.7762719 -96.7968559 appended 2 Chennai, Chennai district, Tamil Nadu, India 13.0801721 80.2838331 appended 2 Dallas, Dallas County, Texas, United States of America 32.7762719 -96.7968559 appended 2 Chennai, Chennai district, Tamil Nadu, India 13.0801721 80.2838331 appended 1 Athens, Athens - Clarke County, Georgia, 30609, United States of America 33.9550905 -83.3881868 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 Athens, Athens - Clarke County, Georgia, 30609, United States of America 33.9550905 -83.3881868 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 Athens, Athens - Clarke County, Georgia, 30609, United States of America 33.9550905 -83.3881868 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Szabolcs-Szatmár-Bereg megye, Észak-Alföld, Alföld és Észak, Magyarország 48.0297821 22.0040108 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Szabolcs-Szatmár-Bereg megye, Észak-Alföld, Alföld és Észak, Magyarország 48.0297821 22.0040108 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Szabolcs-Szatmár-Bereg megye, Észak-Alföld, Alföld és Észak, Magyarország 48.0297821 22.0040108 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 Київ, Шевченківський район, Київ, 01000-06999, Україна 50.4501071 30.5240501 appended 2 Boston, Suffolk County, Massachusetts, United States of America 42.3604823 -71.0595678 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 Київ, Шевченківський район, Київ, 01000-06999, Україна 50.4501071 30.5240501 appended 2 Boston, Suffolk County, Massachusetts, United States of America 42.3604823 -71.0595678 appended 1 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 Київ, Шевченківський район, Київ, 01000-06999, Україна 50.4501071 30.5240501 appended 2 Boston, Suffolk County, Massachusetts, United States of America 42.3604823 -71.0595678 appended 2 Florida, United States of America 27.7567667 -81.4639835 appended 2 Florida, United States of America 27.7567667 -81.4639835 appended 2 Florida, United States of America 27.7567667 -81.4639835 appended 2 Barcelona, BCN, CAT, España 41.3828939 2.1774322 appended 2 Mallorca, Sencelles, Pla de Mallorca, Illes Balears, 124 39.6134018 2.88043053264008 appended 2 Barcelona, BCN, CAT, España 41.3828939 2.1774322 appended 2 Mallorca, Sencelles, Pla de Mallorca, Illes Balears, 124 39.6134018 2.88043053264008 appended 2 Barcelona, BCN, CAT, España 41.3828939 2.1774322 appended 2 Mallorca, Sencelles, Pla de Mallorca, Illes Balears, 124 39.6134018 2.88043053264008 appended 2 Springfield, Sangamon County, Illinois, United States of America 39.7989763 -89.6443688 appended 2 Hartland, Waukesha County, Wisconsin, United States of America 43.105008 -88.3420398 appended 2 Sunderland, Tyne and Wear, North East England, England, UK 54.9063791 -1.375053 appended 2 Springfield, Sangamon County, Illinois, United States of America 39.7989763 -89.6443688 appended 2 Hartland, Waukesha County, Wisconsin, United States of America 43.105008 -88.3420398 appended 2 Sunderland, Tyne and Wear, North East England, England, UK 54.9063791 -1.375053 appended 2 Springfield, Sangamon County, Illinois, United States of America 39.7989763 -89.6443688 appended 2 Hartland, Waukesha County, Wisconsin, United States of America 43.105008 -88.3420398 appended 2 Sunderland, Tyne and Wear, North East England, England, UK 54.9063791 -1.375053 appended 2 Brasil -10.3333333 -53.2 appended 2 Brasil -10.3333333 -53.2 appended 2 Brasil -10.3333333 -53.2 appended 2 Florida Crescent, Humberlea, North York, Toronto, Ontario, M9M 1S3, Canada 43.7345567 -79.5414449 appended 2 Florida Crescent, Humberlea, North York, Toronto, Ontario, M9M 1S3, Canada 43.7345567 -79.5414449 appended 2 Florida Crescent, Humberlea, North York, Toronto, Ontario, M9M 1S3, Canada 43.7345567 -79.5414449 appended 1 New Delhi, Delhi, India 28.6141793 77.2022662 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 New Delhi, Delhi, India 28.6141793 77.2022662 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 New Delhi, Delhi, India 28.6141793 77.2022662 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Grigny, Évry, Essonne, Île-de-France, France métropolitaine, 91350, France 48.6591 2.38993 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Grigny, Évry, Essonne, Île-de-France, France métropolitaine, 91350, France 48.6591 2.38993 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Grigny, Évry, Essonne, Île-de-France, France métropolitaine, 91350, France 48.6591 2.38993 appended appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 San Jose Diridon, Laurel Grove Lane, Plant 51, Buena Vista, San José, Santa Clara County, California, 95110, United States of America 37.3297085 -121.9031599 appended 2 Lincolnshire, East Midlands, England, UK 53.166667 -0.25 appended 2 Durham, Durham County, North Carolina, United States of America 35.9966551 -78.9018115 appended 2 San Jose Diridon, Laurel Grove Lane, Plant 51, Buena Vista, San José, Santa Clara County, California, 95110, United States of America 37.3297085 -121.9031599 appended 2 Lincolnshire, East Midlands, England, UK 53.166667 -0.25 appended 2 Durham, Durham County, North Carolina, United States of America 35.9966551 -78.9018115 appended 2 San Jose Diridon, Laurel Grove Lane, Plant 51, Buena Vista, San José, Santa Clara County, California, 95110, United States of America 37.3297085 -121.9031599 appended 2 Lincolnshire, East Midlands, England, UK 53.166667 -0.25 appended 2 Durham, Durham County, North Carolina, United States of America 35.9966551 -78.9018115 appended 2 Western, Otter Tail County, Minnesota, 56522, United States of America 46.1519043 -96.1831165 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Atlanta, Fulton County, Georgia, United States of America 33.7490987 -84.3901849 appended 2 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 Western, Otter Tail County, Minnesota, 56522, United States of America 46.1519043 -96.1831165 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Atlanta, Fulton County, Georgia, United States of America 33.7490987 -84.3901849 appended 2 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 2 Western, Otter Tail County, Minnesota, 56522, United States of America 46.1519043 -96.1831165 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Atlanta, Fulton County, Georgia, United States of America 33.7490987 -84.3901849 appended 2 London, Greater London, England, SW1A 2DU, UK 51.5073219 -0.1276474 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Cantón Heredia, Provincia Heredia, Costa Rica 10.17778125 -84.0591841807008 appended 1 None, TO, PIE, Italia 44.933143 7.540121 appended 2 Cantón Heredia, Provincia Heredia, Costa Rica 10.17778125 -84.0591841807008
--------------------------------------------------------------------------- timeout Traceback (most recent call last) /usr/lib/python3.5/urllib/request.py in do_open(self, http_class, req, **http_conn_args) 1253 try: -> 1254 h.request(req.get_method(), req.selector, req.data, headers) 1255 except OSError as err: # timeout error /usr/lib/python3.5/http/client.py in request(self, method, url, body, headers) 1105 """Send a complete request to the server.""" -> 1106 self._send_request(method, url, body, headers) 1107 /usr/lib/python3.5/http/client.py in _send_request(self, method, url, body, headers) 1150 body = _encode(body, 'body') -> 1151 self.endheaders(body) 1152 /usr/lib/python3.5/http/client.py in endheaders(self, message_body) 1101 raise CannotSendHeader() -> 1102 self._send_output(message_body) 1103 /usr/lib/python3.5/http/client.py in _send_output(self, message_body) 933 --> 934 self.send(msg) 935 if message_body is not None: /usr/lib/python3.5/http/client.py in send(self, data) 876 if self.auto_open: --> 877 self.connect() 878 else: /usr/lib/python3.5/http/client.py in connect(self) 1259 self.sock = self._context.wrap_socket(self.sock, -> 1260 server_hostname=server_hostname) 1261 if not self._context.check_hostname and self._check_hostname: /usr/lib/python3.5/ssl.py in wrap_socket(self, sock, server_side, do_handshake_on_connect, suppress_ragged_eofs, server_hostname) 376 server_hostname=server_hostname, --> 377 _context=self) 378 /usr/lib/python3.5/ssl.py in __init__(self, sock, keyfile, certfile, server_side, cert_reqs, ssl_version, ca_certs, do_handshake_on_connect, family, type, proto, fileno, suppress_ragged_eofs, npn_protocols, ciphers, server_hostname, _context) 751 raise ValueError("do_handshake_on_connect should not be specified for non-blocking sockets") --> 752 self.do_handshake() 753 /usr/lib/python3.5/ssl.py in do_handshake(self, block) 987 self.settimeout(None) --> 988 self._sslobj.do_handshake() 989 finally: /usr/lib/python3.5/ssl.py in do_handshake(self) 632 """Start the SSL/TLS handshake.""" --> 633 self._sslobj.do_handshake() 634 if self.context.check_hostname: timeout: _ssl.c:629: The handshake operation timed out During handling of the above exception, another exception occurred: URLError Traceback (most recent call last) ~/.local/lib/python3.5/site-packages/geopy/geocoders/base.py in _call_geocoder(self, url, timeout, raw, requester, deserializer, **kwargs) 151 try: --> 152 page = requester(req, timeout=(timeout or self.timeout), **kwargs) 153 except Exception as error: # pylint: disable=W0703 /usr/lib/python3.5/urllib/request.py in urlopen(url, data, timeout, cafile, capath, cadefault, context) 162 opener = _opener --> 163 return opener.open(url, data, timeout) 164 /usr/lib/python3.5/urllib/request.py in open(self, fullurl, data, timeout) 465 --> 466 response = self._open(req, data) 467 /usr/lib/python3.5/urllib/request.py in _open(self, req, data) 483 result = self._call_chain(self.handle_open, protocol, protocol + --> 484 '_open', req) 485 if result: /usr/lib/python3.5/urllib/request.py in _call_chain(self, chain, kind, meth_name, *args) 443 func = getattr(handler, meth_name) --> 444 result = func(*args) 445 if result is not None: /usr/lib/python3.5/urllib/request.py in https_open(self, req) 1296 return self.do_open(http.client.HTTPSConnection, req, -> 1297 context=self._context, check_hostname=self._check_hostname) 1298 /usr/lib/python3.5/urllib/request.py in do_open(self, http_class, req, **http_conn_args) 1255 except OSError as err: # timeout error -> 1256 raise URLError(err) 1257 r = h.getresponse() URLError: <urlopen error _ssl.c:629: The handshake operation timed out> During handling of the above exception, another exception occurred: GeocoderTimedOut Traceback (most recent call last) <ipython-input-5-58d756bfb8e8> in <module>() 24 subjectivities.append(tweet['subjectivity']) 25 ---> 26 latlong = locate.geocode(tweet['user']['location'], timeout = 10) 27 if latlong is None: 28 latlong = locate.geocode(tweet['user']['time_zone'], timeout = 10) ~/.local/lib/python3.5/site-packages/geopy/geocoders/osm.py in geocode(self, query, exactly_one, timeout, limit, addressdetails, language, geometry) 228 229 return self._parse_json( --> 230 self._call_geocoder(url, timeout=timeout), exactly_one 231 ) 232 ~/.local/lib/python3.5/site-packages/geopy/geocoders/base.py in _call_geocoder(self, url, timeout, raw, requester, deserializer, **kwargs) 169 elif isinstance(error, URLError): 170 if "timed out" in message: --> 171 raise GeocoderTimedOut('Service timed out') 172 elif "unreachable" in message: 173 raise GeocoderUnavailable('Service not available') GeocoderTimedOut: Service timed out
In [6]:
import dateutil
df = pd.DataFrame({'time':times, 'polarity': polarities, 'subjectivity': subjectivities})
df = df.sort_values(by=['time'])
df['time'] = df['time'].apply(dateutil.parser.parse)
df.dtypes
Out[6]:
polarity float64 subjectivity float64 time datetime64[ns, UTC] dtype: object
In [7]:
plt.figure(figsize = (12, 5))
plt.title('Sentiment Comparision')
plt.plot(df['time'], df['polarity'])
plt.plot(df['time'], df['subjectivity'])
plt.xlabel('Time')
plt.ylabel('Sentiment Value')
Out[7]:
Text(0,0.5,'Sentiment Value')
In [8]:
lats = [lat[0] for lat in locations]
longi = [long[1] for long in locations]
print(lats, " + ", longi)
[52.2379891, 29.8207822747902, 28.1477885, 44.933143, 51.5073219, -8.8483112, 11.0869172, 42.291707, 44.933143, 39.7837304, 28.1083929, 9.6000359, 44.933143, 44.933143, 51.5073219, 46.3239455, 44.933143, 44.933143, 39.4124481, 44.2222023, 44.2222023, 39.5162234, 44.933143, 44.7716333, 56.0441984, 44.933143, 44.933143, 39.7837304, 9.80067315, 38.9786401, 43.2961743, 39.523652, 30.4380832, 44.933143, 39.1852184, 3.1546872, 44.933143, 30.2240897, 44.933143, 9.624388, 37.6413209, 44.933143, 52.2928116, 44.933143, -28.5912315, 44.933143, 37.5666791, 43.6211955, 47.6041834, 16.3471243, 44.933143, -28.1652832, 41.5510583, 35.9131542, 25.7742658, 44.933143, 40.0428151, 44.933143, 27.8002542, 43.0116784, 44.933143, 44.933143, -29.9476433, 55.856656, 51.0834196, 53.4791301, 44.933143, 44.933143, 44.933143, 34.851354, -26.8303703, 44.4308975, 40.7306458, 44.933143, 8.0300284, 44.933143, 44.933143, 27.77330515, 31.8111305, 44.933143, 30.3308401, 35.7212689, 52.7954791, -31.9513659, 34.395342, 6.9116138, 44.2222023, 51.5073219, 44.9772995, 44.933143, 31.8160381, 44.933143, 47.6694141, 33.8062166, 43.653963, 44.933143, 32.7762719, 44.933143, 26.925995, 44.933143, 52.4498412, 44.2222023, 36.7014631, 39.7837304, 44.933143, 44.933143, 44.933143, 42.3604823, 44.933143, 44.933143, 44.933143, 38.8949549, 44.933143, 41.7797559, 61.0666922, 30.8195619, 13.7538929, 44.933143, 44.933143, 30.429583, 51.5073219, 44.933143, 40.7306458, 43.9792797, 39.9483282, 44.933143, 44.933143, 44.933143, 40.7306458, 3.209928, 36.7014631, 40.6501038, 33.7490987, 44.8178131, 51.46426255, 44.933143, 52.2379891, 43.255205, 22.3511148, 51.0000002, 55.8170913, 19.4326009, 44.933143, 56.372717, 60.1674086, 44.933143, 52.628606, 44.933143, 44.933143, 43.6442782, 51.5073219, 40.6524927, 33.321756, 44.2222023, 39.9622601, -37.8789504, 25.7881436, 44.2222023, 55.7915214, 25.2859603, 35.6687049, 37.5666791, 44.933143, -15.416697, 40.7306458, 39.7837304, 50.74467035, -1.2832533, 44.933143, 13.7538929, 44.933143, 2.0000003, 44.933143, -27.762778, 42.3604823, 40.7306458, 43.653963, 47.2286086, 34.054935, 45.6512171, 44.0357402, 52.79657515, 42.3604823, 29.7419486, 44.933143, 52.7954791, 51.419243, 50.94468065, 41.2587317, 44.933143, -1.2832533, 5.5600141, 44.933143, 48.3955294, 44.933143, 44.933143, 44.933143, 51.5073219, 44.933143, 44.933143, 37.9587465, 44.933143, 42.0128695, 39.7837304, 53.4791301, 45.709097, 43.6211955, 39.9622601, 31.8160381, 44.2222023, 44.933143, 44.933143, 45.4972159, 37.9513575, 32.7185614, -21.7609533, 38.7311123, 46.1495325, 52.3745403, 53.7974185, 52.5170365, 41.3828939, 44.933143, 32.7349196, 52.8408344, 36.1622296, 40.7306458, 26.7164127, 47.465651, 39.2908816, 19.5584043, -0.2130423, 53.6466645, 49.2577886, 51.5073219, 38.8949549, 29.4246002, 52.3745403, 12.7503486, 44.2222023, 42.3604823, 53.26022, 44.933143, 46.603354, 56.7695284, 48.8566101, 44.933143, 32.3293809, 44.933143, 45.4423543, 39.9523993, 39.9523993, 44.933143, 39.6419219, 44.933143, 41.624468, 45.5202471, 51.46426255, 34.395342, 48.6443057, 40.6501038, 44.933143, -34.9964963, 53.2141028, 44.933143, 44.933143, 44.933143, 43.0349931, -27.6532701, 55.85881005, 38.687894, 44.933143, 25.7742658, 44.933143, 22.3511148, 35.0841034, -0.2130423, 33.7690049, 30.8703881, 39.6528509, 53.029256, 40.2425623, 41.0096334, -34.6075616, 39.8211225, 52.7954791, 44.2222023, 44.933143, 44.933143, 52.2921548, 44.933143, 35.8552727, 39.0618905, 44.933143, 44.933143, 22.5677459, 44.933143, 1.4419683, 45.88975045, 51.5073219, 33.7490987, -33.8548157, 45.5591381, 44.933143, 26.4609135, 19.1334321, 22.3511148, 44.933143, 28.6141793, 19.1334321, 13.0070817, 44.933143, 28.6517178, 19.1334321, 31.3323762, 28.47649105, 21.1864607, 19.1334321, 12.9791198, 28.6141793, 26.4609135, 19.1334321, 22.3511148, 44.933143, 28.6141793, 19.1334321, 13.0070817, 44.933143, 28.6517178, 19.1334321, 31.3323762, 28.47649105, 21.1864607, 19.1334321, 19.1334321, 22.3511148, 19.1334321, 12.9791198, 22.3511148, 40.192971, 22.3511148, 26.4609135, 13.2904027, 25.2859603, 26.2, -24.8339082, 22.5677459, 19.1334321, 19.1334321, 22.3511148, 19.1334321, 12.9791198, 22.3511148, 40.192971, 22.3511148, 26.4609135, 13.2904027, 38.0615885, 40.7913922, 44.933143, 32.657368, 39.7589478, 38.7604815, 44.933143, 37.6390972, 44.933143, 44.2222023, 40.868154, 39.9523993, 36.1662859, 39.8842304, 51.507865, 44.933143, 44.933143, 41.8755546, 38.7251776, 38.1619307, 39.2908816, 29.6519396, 27.7567667, 34.054935, 27.7567667, 34.054935, 51.5073219, 51.5073219, 41.87848185, 54.1853998, 51.5073219, 51.5073219, 41.87848185, 54.1853998, 44.933143, 44.933143, 13.2904027, 44.933143, 44.933143, 13.2904027, 44.933143, 44.933143, 13.2904027, 44.933143, 44.933143, 44.933143, 44.933143, 44.933143, 50.000678, 44.933143, 44.933143, 50.000678, 44.933143, 44.933143, 50.000678, -30.5343665, 25.7742658, -30.5343665, 25.7742658, -30.5343665, 25.7742658, 29.6890054, 33.8439408, 29.6890054, 33.8439408, 29.6890054, 33.8439408, 44.933143, 44.933143, 44.933143, 30.3276618, 45.9896587, 30.3276618, 45.9896587, 44.933143, 44.933143, 44.933143, 41.7066548, 43.299447, 41.7066548, 43.299447, 41.7066548, 43.299447, 52.3745403, 52.3745403, 52.3745403, 44.933143, 44.933143, 44.933143, 38.8949549, 44.933143, 38.8949549, 44.933143, 38.8949549, 44.933143, 12.9791198, 44.0933443, 44.933143, 12.9791198, 44.0933443, 44.933143, 12.9791198, 44.0933443, 44.933143, 44.933143, 44.933143, 44.933143, 40.6501038, 44.933143, 40.6501038, 44.933143, 40.6501038, 44.933143, 37.1232245, 34.9550817, 37.1232245, 34.9550817, 37.1232245, 34.9550817, 47.6038321, 40.6501038, 54.0099825, 47.6038321, 40.6501038, 54.0099825, 47.6038321, 40.6501038, 54.0099825, 52.8454307, -26.205, 52.8454307, -26.205, 52.8454307, -26.205, 52.7954791, 51.5073219, 52.7954791, 51.5073219, 44.933143, 44.933143, 44.933143, -28.62, 33.3067132, -28.62, 33.3067132, -28.62, 33.3067132, 44.2222023, 44.2222023, 44.2222023, 44.933143, 44.933143, 44.933143, 44.933143, 44.933143, 44.933143, -30.5343665, 37.034583193882, 44.933143, -30.5343665, 37.034583193882, 44.933143, -30.5343665, 37.034583193882, 44.933143, 33.9550905, 33.9550905, 33.9550905, 44.2222023, 44.933143, -6.1753942, 44.2222023, 44.933143, -6.1753942, 44.2222023, 44.933143, -6.1753942, 32.7762719, 13.0801721, 32.7762719, 13.0801721, 32.7762719, 13.0801721, 33.9550905, 44.933143, 33.9550905, 44.933143, 33.9550905, 44.933143, 48.0297821, 44.933143, 48.0297821, 44.933143, 48.0297821, 44.933143, 51.5073219, 50.4501071, 42.3604823, 51.5073219, 50.4501071, 42.3604823, 51.5073219, 50.4501071, 42.3604823, 27.7567667, 27.7567667, 27.7567667, 41.3828939, 39.6134018, 41.3828939, 39.6134018, 41.3828939, 39.6134018, 39.7989763, 43.105008, 54.9063791, 39.7989763, 43.105008, 54.9063791, 39.7989763, 43.105008, 54.9063791, -10.3333333, -10.3333333, -10.3333333, 43.7345567, 43.7345567, 43.7345567, 28.6141793, 44.933143, 28.6141793, 44.933143, 28.6141793, 44.933143, 48.6591, 44.933143, 44.933143, 48.6591, 44.933143, 44.933143, 48.6591, 44.933143, 44.933143, 37.3297085, 53.166667, 35.9966551, 37.3297085, 53.166667, 35.9966551, 37.3297085, 53.166667, 35.9966551, 46.1519043, 44.933143, 33.7490987, 51.5073219, 46.1519043, 44.933143, 33.7490987, 51.5073219, 46.1519043, 44.933143, 33.7490987, 51.5073219, 44.933143, 10.17778125, 44.933143, 10.17778125] + [5.53460738161551, -95.7366129150998, -82.7774086726313, 7.540121, -0.1276474, 13.2076618, -73.8806606343634, -85.5872286, 7.540121, -100.4458825, 84.0917139, 7.9999721, 7.540121, 7.540121, -0.1276474, -0.4645212, 7.540121, 7.540121, 16.8225645, -76.4986098, -76.4986098, -76.9382069, 7.540121, -89.787902, 12.7040684, 7.540121, 7.540121, -100.4458825, 126.118702106101, -76.492786, 5.3699525, -87.1250154, -84.2809332, 7.540121, -78.1652404, 101.7136362, 7.540121, -92.0198427, 7.540121, -73.2125095, -115.748361, 7.540121, -3.73893, 7.540121, -57.9394658, 7.540121, 126.9782914, -84.6824346, -122.3292397, 47.8915271, 7.540121, -63.64468, -8.4280045, -79.05578, -80.1936589, 7.540121, -86.1274888, 7.540121, -97.3955744, -88.2314813, 7.540121, 7.540121, -51.1695867, -4.2435817, 10.4234469, -2.2441009, 7.540121, 7.540121, 7.540121, -82.3984882, -65.2038133, -89.6884637, -73.9866136, 7.540121, -1.0800271, 7.540121, 7.540121, -82.6469934, -106.501349395577, 7.540121, 71.247499, -77.9155395, -0.540240286617432, 115.860389528787, -111.7632755, 79.8578631, -76.4986098, -0.1276474, -93.2654692, 7.540121, -99.5120986, 7.540121, -122.1238767, -84.1457505, -79.387207, 7.540121, -96.7968559, 7.540121, -82.25603, 7.540121, -9.4777916, -76.4986098, -118.7559974, -100.4458825, 7.540121, 7.540121, 7.540121, -71.0595678, 7.540121, 7.540121, 7.540121, -77.0366456, 7.540121, -87.6458836, -107.9917071, -83.2628255, 100.8160803, 7.540121, 7.540121, -84.217732, -0.1276474, 7.540121, -73.9866136, -120.737257, -75.306887787778, 7.540121, 7.540121, 7.540121, -73.9866136, 101.7608508, -118.7559974, -73.9495823, -84.3901849, 20.4568974, -0.651714721140142, 7.540121, 5.53460738161551, -79.868202, 78.6677428, -109.0000002, -4.0822926, -99.1333416, 7.540121, -3.8397453, 24.9425683, 7.540121, 1.29227, 7.540121, 7.540121, -79.4002211, -0.1276474, -73.7914214158161, 44.335385, -76.4986098, -83.0007065, 145.1625316, -80.1272705, -76.4986098, -3.9823503, 81.896732069544, 139.7053357, 126.9782914, 7.540121, 28.281381, -73.9866136, -100.4458825, -1.85798090318094, 36.8172449, 7.540121, 100.8160803, 7.540121, 15.9999997, 7.540121, 29.923889, -71.0595678, -73.9866136, -79.387207, 65.2093197, -118.244476, -74.942673, -70.4837919763434, -0.671822256833873, -71.0595678, -94.8395296, 7.540121, -0.540240286617432, 0.0015531, -0.06192935288129, -95.9378732, 7.540121, 36.8172449, -0.2057437, 7.540121, 3.3427924, 7.540121, 7.540121, 7.540121, -0.1276474, 7.540121, 7.540121, -76.7580211, 7.540121, -73.9081901, -100.4458825, -2.2441009, -68.8590201, -84.6824346, -83.0007065, -99.5120986, -76.4986098, 7.540121, 7.540121, -73.6103642, -91.771792, 74.8580917, -43.3501129, -95.2414104, 24.8544374569545, 4.89797550561798, -1.5437941, 13.3888599, 2.1774322, 7.540121, -117.1545974, -6.9261131, -86.7743531, -73.9866136, 88.4309916, -1.4823004, -76.610759, -99.0277414, -78.501997, -1.7822482, 4.031926, -0.1276474, -77.0366456, -98.4951405, 4.89797550561798, 122.7312101, -76.4986098, -71.0595678, -2.126926, 7.540121, 1.8883335, -3.3333906, 2.3514992, 7.540121, -83.1137366, 7.540121, -73.4373087, -75.1635899, -75.1635899, 7.540121, -77.7202641, 7.540121, -79.669652, -122.6741949, -0.651714721140142, -111.7632755, 2.7537863, -73.9495823, 7.540121, -64.9672817, -2.47177008607121, 7.540121, 7.540121, 7.540121, -87.922497, 27.235515, -4.00208685912683, -77.2977618, 7.540121, -80.1936589, 7.540121, 78.6677428, -106.6509851, -78.501997, -89.8084192, -92.007126, -78.7624714, -2.19979110233224, -82.8590673, 28.9651646, -58.437076, -105.220742990446, -0.540240286617432, -76.4986098, 7.540121, 7.540121, -1.5356986, 7.540121, -80.0162562961353, -6.5050901, 7.540121, 7.540121, 88.3476023, 7.540121, 38.4313975, 6.135465100226, -0.1276474, -84.3901849, 151.2164539, -122.638103, 7.540121, 80.3217588, 72.8882172, 78.6677428, 7.540121, 77.2022662, 72.8882172, 76.0992703, 7.540121, 77.2219388, 72.8882172, 75.576889, 77.1329131592514, 72.8081281, 72.8882172, 77.5912997, 77.2022662, 80.3217588, 72.8882172, 78.6677428, 7.540121, 77.2022662, 72.8882172, 76.0992703, 7.540121, 77.2219388, 72.8882172, 75.576889, 77.1329131592514, 72.8081281, 72.8882172, 72.8882172, 78.6677428, 72.8882172, 77.5912997, 78.6677428, -85.395372, 78.6677428, 80.3217588, 108.4265113, 81.896732069544, 78.2, -65.3822399, 88.3476023, 72.8882172, 72.8882172, 78.6677428, 72.8882172, 77.5912997, 78.6677428, -85.395372, 78.6677428, 80.3217588, 108.4265113, -122.6985975, -74.2479444, 7.540121, -97.0284662417504, -84.1916069, -92.5617875, 7.540121, -120.9968782, 7.540121, -76.4986098, -73.425676, -75.1635899, -115.149225, -82.7535049, -0.1245597, 7.540121, 7.540121, -87.6244212, -105.6077167, 56.2536543, -76.610759, -82.3249961, -81.4639835, -118.244476, -81.4639835, -118.244476, -0.1276474, -0.1276474, -87.6314994083818, 9.8220089, -0.1276474, -0.1276474, -87.6314994083818, 9.8220089, 7.540121, 7.540121, 108.4265113, 7.540121, 7.540121, 108.4265113, 7.540121, 7.540121, 108.4265113, 7.540121, 7.540121, 7.540121, 7.540121, 7.540121, -86.000977, 7.540121, 7.540121, -86.000977, 7.540121, 7.540121, -86.000977, 135.6301212, -80.1936589, 135.6301212, -80.1936589, 135.6301212, -80.1936589, -95.6227567, 9.400138, -95.6227567, 9.400138, -95.6227567, 9.400138, 7.540121, 7.540121, 7.540121, -95.3139087, -94.6113288, -95.3139087, -94.6113288, 7.540121, 7.540121, 7.540121, 44.7889604, -73.635178, 44.7889604, -73.635178, 44.7889604, -73.635178, 4.89797550561798, 4.89797550561798, 4.89797550561798, 7.540121, 7.540121, 7.540121, -77.0366456, 7.540121, -77.0366456, 7.540121, -77.0366456, 7.540121, 77.5912997, 12.3960576, 7.540121, 77.5912997, 12.3960576, 7.540121, 77.5912997, 12.3960576, 7.540121, 7.540121, 7.540121, 7.540121, -73.9495823, 7.540121, -73.9495823, 7.540121, -73.9495823, 7.540121, -78.4927721, -97.2684063, -78.4927721, -97.2684063, -78.4927721, -97.2684063, -122.3300624, -73.9495823, -1.462186, -122.3300624, -73.9495823, -1.462186, -122.3300624, -73.9495823, -1.462186, 13.0011564, 28.049722, 13.0011564, 28.049722, 13.0011564, 28.049722, -0.540240286617432, -0.1276474, -0.540240286617432, -0.1276474, 7.540121, 7.540121, 7.540121, 31.090556, -111.8408489, 31.090556, -111.8408489, 31.090556, -111.8408489, -76.4986098, -76.4986098, -76.4986098, 7.540121, 7.540121, 7.540121, 7.540121, 7.540121, 7.540121, 135.6301212, -121.517372158299, 7.540121, 135.6301212, -121.517372158299, 7.540121, 135.6301212, -121.517372158299, 7.540121, -83.3881868, -83.3881868, -83.3881868, -76.4986098, 7.540121, 106.827183, -76.4986098, 7.540121, 106.827183, -76.4986098, 7.540121, 106.827183, -96.7968559, 80.2838331, -96.7968559, 80.2838331, -96.7968559, 80.2838331, -83.3881868, 7.540121, -83.3881868, 7.540121, -83.3881868, 7.540121, 22.0040108, 7.540121, 22.0040108, 7.540121, 22.0040108, 7.540121, -0.1276474, 30.5240501, -71.0595678, -0.1276474, 30.5240501, -71.0595678, -0.1276474, 30.5240501, -71.0595678, -81.4639835, -81.4639835, -81.4639835, 2.1774322, 2.88043053264008, 2.1774322, 2.88043053264008, 2.1774322, 2.88043053264008, -89.6443688, -88.3420398, -1.375053, -89.6443688, -88.3420398, -1.375053, -89.6443688, -88.3420398, -1.375053, -53.2, -53.2, -53.2, -79.5414449, -79.5414449, -79.5414449, 77.2022662, 7.540121, 77.2022662, 7.540121, 77.2022662, 7.540121, 2.38993, 7.540121, 7.540121, 2.38993, 7.540121, 7.540121, 2.38993, 7.540121, 7.540121, -121.9031599, -0.25, -78.9018115, -121.9031599, -0.25, -78.9018115, -121.9031599, -0.25, -78.9018115, -96.1831165, 7.540121, -84.3901849, -0.1276474, -96.1831165, 7.540121, -84.3901849, -0.1276474, -96.1831165, 7.540121, -84.3901849, -0.1276474, 7.540121, -84.0591841807008, 7.540121, -84.0591841807008]
In [9]:
lats = list(filter(lambda a: a != 'p', lats))
In [10]:
import mplleaflet
mapdf = pd.DataFrame({'lat': lats, 'longi': longi, 'polarity':polarities[:len(lats)]})
plt.figure(figsize=(8, 8))
plt.scatter(longi, lats, c = polarities[:len(lats)])
mplleaflet.display()
Out[10]: