Add files via upload

coderapperr · web-flow · commit 60266e6749f1 · 2019-09-10T18:49:19.000+05:30
diff --git a/weather_report_code.txt b/weather_report_code.txt
@@ -0,0 +1,33 @@
+import pandas as pd
+
+dataset = pd.read_csv('country-capitals.csv')
+
+capitalLatitude = list(dataset['CapitalLatitude'])
+capitaLongitude = list(dataset['CapitalLongitude'])
+countryName = list(dataset['CountryName'])
+capitalName = list(dataset['CapitalName'])
+
+import requests
+
+source = requests.get('https://api.darksky.net/forecast/d4387196621d5db9b64386336cd76060/9.55,44.05')
+
+source.status_code
+
+data = source.json()
+
+import csv
+
+csv_file = open('weather_report.csv','w')
+
+csv_writer = csv.writer(csv_file)
+
+headers = ['Country','Capital','Capital_Latitude','Capital_Longitude','Timezone'] + list(data['currently'].keys())
+
+csv_writer.writerow(headers)
+
+for i in range(len(countryName)):
+        source = requests.get('https://api.darksky.net/forecast/d4387196621d5db9b64386336cd76060/'+capitalLatitude[i]+','+str(capitaLongitude[i]))
+        data = source.json()
+        csv_writer.writerow([countryName[i],capitalName[i],capitalLatitude[i],capitaLongitude[i],data['timezone']]+list(data['currently'].values()))
+        
+csv_file.close()        
