This package is used to retrieve and transform historical weather data from www.worldweatheronline.com into pandas dataframe and csv.

You can get API key for free (free trial 500 requests/key/day for 60 days, as of 30-May-2019).

example API explorer: https://www.worldweatheronline.com/developer/premium-api-explorer.aspx

Input: api_key, location_list, start_date, end_date, frequency

Output: location_name.csv

Output column names: date_time, maxtempC, mintempC, totalSnow_cm, sunHour, uvIndex, uvIndex, moon_illumination, moonrise, moonset, sunrise, sunset, DewPointC, FeelsLikeC, HeatIndexC, WindChillC, WindGustKmph, cloudcover, humidity, precipMM, pressure, tempC, visibility, winddirDegree, windspeedKmph

pip install wwo-hist

from wwo_hist import retrieve_hist_data

import os
os.chdir(".\YOUR_PATH")

frequency=3
start_date = '11-DEC-2018'
end_date = '11-MAR-2019'
api_key = 'YOUR_API_KEY'
location_list = ['singapore','california']

hist_weather_data = retrieve_hist_data(api_key,
                                location_list,
                                start_date,
                                end_date,
                                frequency,
                                location_label = False,
                                export_csv = True,
                                store_df = True)

api_key: string

(Premium/ free trial) API key from https://www.worldweatheronline.com/developer/api/

location_list: list of string

US Zipcode, UK Postcode, Canada Postalcode, IP address, Latitude/Longitude (decimal degree) or city name

start_date: string

Preferred date format: 'dd-mmm-yyyy'

end_date: string

Preferred date format: 'dd-mmm-yyyy'

frequency: integer

1, 3, 6, 12, 24

1 hourly, 3 hourly, 6 hourly, 12 hourly (day/night) or 24 hourly (day average)

location_label: bool, default = False

If True, all column names will have city name as prefix.

export_csv: bool, default = True

If False, no csv file will be exported to current directory.

store_df: bool, default = False

If True, retrieved dataframe(s) will be stored as list in the work space.