#CrossCompute
name = ''
target_folder = '/tmp'
#source_table_path = 'Fvt_Lat_Long.csv'

source_table_path = 'Fvt_Lat_Long.csv'

import pandas as pd
url = 'https://www.nycgovparks.org/bigapps/DPR_Eateries_001.json'
fvt = pd.read_json(url, convert_dates=['state_date', 'end_date'])

selected_fvt = fvt[fvt['name'].str.contains(name, case=False)]

length = len(selected_fvt)
if(length == 0):
    print("There are no matching Food Vendors with this name.")
elif(length == 1):
    print("There is %s" %length + " matching Food Vendor with this name.")
elif(length>1):
    print("There are %s" %length + " matching Food Vendors with this name")

print("Vendors_with_matching_name = %s" %length)

from datetime import datetime
now = datetime.now()
filtered_fvt = selected_fvt[now > selected_fvt['end_date']]
exp_len = len(filtered_fvt)
print("There are %s" %exp_len + " expired Food Vendor Permits.")

allVendors = len(selected_fvt)
valid = allVendors-exp_len
valid_fvt = selected_fvt[now < selected_fvt['end_date']]
print("There are %s" %valid + " valid Food Vendor Permits.")

print("Vendors_with_valid_licenses = %s" %valid)

target_path = target_folder + '/table1.csv'
valid_fvt.to_csv(target_path, index=False)
print('Valid_Vendor_table_path = %s' % target_path)

print("Vendors_with_expired_license = %s" % exp_len)

target_path = target_folder + '/table.csv'
filtered_fvt.to_csv(target_path, index=False)
print('Expired_Vendor_table_path = %s' % target_path)

from os.path import join
from shutil import copy
target_path = join(target_folder, 'Fvt_Lat_Long.csv')
copy(source_table_path, target_path)
print('example_satellite_geotable_path = ' + target_path)