import pandas
import datetime
import pytz
import numpy as np

project_key = 'ahZzfmVwaWNvbGxlY3RzZXJ2ZXItaHJkchQLEgdQcm9qZWN0GICAgMi21YQLDA'
csv_url = 'http://epicollectserver.appspot.com/listEntriesCSV.csv?projectKey=' + project_key
data = pandas.read_csv(csv_url, parse_dates=['dateCreated'], index_col=['dateCreated'])
excluded_columns = ['key', 'latitude', 'longitude', 'altitude', 'deviceId', 'entryId', 'lastEdited', 'timeUploaded', 'projectName',
                    'photo', 'Unnamed: 15']
data = data.drop(excluded_columns, axis=1)
data.index = data.index.tz_localize('UTC')
data.index = data.index.tz_convert('Pacific/Guam')
data.index = data.index.date
data = data.sort()
data.to_csv('crb_yigo_barrel_traps.csv')
data
@article {crb_yigo_barrel_epicollect,
	title = {Harvesting data from the EpiCollect crb_yigo_barrel_epicollect Project},
	year = {2015},
	type = {CRB Technical Report},
	url = {http://nbviewer.ipython.org/url/guaminsects.net/anr/sites/default/files/crb_yigo_barrel_epicollect.ipynb},
	author = {Aubrey Moore}
}