# Variables = ', '.join(list(vars_metadata['var_short_name']))
Variables = 'More than 50 variables: details can be found in tblVariables'
reference_list = (dataset_metadata.iloc[0]['dataset_references']).split(",")
DB_list = [DB] * len(vars_metadata)
Dataset_Name_list = [Dataset_Name] * len(vars_metadata)
short_name_list = list(vars_metadata['var_short_name'])
long_name_list = list(vars_metadata['var_long_name'])
unit_list = list(ip.NaNtoNone(vars_metadata['var_unit']))
spatial_res_list = list('1') * len(vars_metadata) # Irregular
temporal_res_list = list('1') * len(vars_metadata) # Irregular
keyword_list = list(vars_metadata['var_keywords'])
comment_list = list(ip.NaNtoNone(vars_metadata['var_comment']))
Temporal_Coverage_Begin_list = [cF.findMinMaxDate(Dataset_Name)['minDate']
] * len(vars_metadata)
Temporal_Coverage_End_list = [cF.findMinMaxDate(Dataset_Name)['maxDate']
] * len(vars_metadata)
Lat_Coverage_Begin_list = [cF.findSpatialBounds(Dataset_Name)['minLat']
] * len(vars_metadata)
Lat_Coverage_End_list = [cF.findSpatialBounds(Dataset_Name)['maxLat']
] * len(vars_metadata)
Lon_Coverage_Begin_list = [cF.findSpatialBounds(Dataset_Name)['minLon']
] * len(vars_metadata)
Lon_Coverage_End_list = [cF.findSpatialBounds(Dataset_Name)['maxLon']
] * len(vars_metadata)
Grid_Mapping_list = ['CRS'] * len(vars_metadata)
Make_ID_list = ['1'] * len(vars_metadata) #Observation
Sensor_ID_list = ['2'] * len(vars_metadata) # In-Situ
Process_ID_list = ['2'] * len(vars_metadata) # Reprocessed
short_name_list = list(vars_metadata['var_short_name'])
long_name_list = list(vars_metadata['var_long_name'])
unit_list = list(ip.NaNtoNone(vars_metadata['var_unit']))
spatial_res_list = list('2') * len(vars_metadata)# 1/2 x 1/2
temporal_res_list = list('9') * len(vars_metadata) # Three days
keyword_list = list(vars_metadata['var_short_name'] + ', ' + vars_metadata['var_keywords'])
comment_list = list(ip.NaNtoNone(vars_metadata['var_comment']))
# Temporal_Coverage_Begin_list = '1994-01-03' * len(vars_metadata)
# Temporal_Coverage_End_list = '2015-12-30' * len(vars_metadata)
Lat_Coverage_Begin_list = ['-90'] * len(vars_metadata)
Lat_Coverage_End_list = ['90'] * len(vars_metadata)
Lon_Coverage_Begin_list = ['-180'] * len(vars_metadata)
Lon_Coverage_End_list = ['180'] * len(vars_metadata)
Temporal_Coverage_Begin_list = [cF.findMinMaxDate(Table_Name)['minDate']] * len(vars_metadata)
Temporal_Coverage_End_list = [cF.findMinMaxDate(Table_Name)['maxDate']] * len(vars_metadata)
# Lat_Coverage_Begin_list = [cF.findSpatialBounds(Table_Name)['minLat']] * len(vars_metadata)
# Lat_Coverage_End_list = [cF.findSpatialBounds(Table_Name)['maxLat']] * len(vars_metadata)
# Lon_Coverage_Begin_list = [cF.findSpatialBounds(Table_Name)['minLon']] * len(vars_metadata)
# Lon_Coverage_End_list = [cF.findSpatialBounds(Table_Name)['maxLon']] * len(vars_metadata)
Grid_Mapping_list = ['CRS'] * len(vars_metadata)
Make_ID_list = ['2'] * len(vars_metadata)#Model
Sensor_ID_list = ['3'] * len(vars_metadata) # Blend
Process_ID_list = ['2'] * len(vars_metadata) # Reprocessed
Study_Domain_ID_list = ['4'] * len(vars_metadata)
# print(DB_list, Dataset_Name_list, short_name_list, long_name_list, unit_list,temporal_res_list, spatial_res_list, Temporal_Coverage_Begin_list, Temporal_Coverage_End_list, Lat_Coverage_Begin_list, Lat_Coverage_End_list, Lon_Coverage_Begin_list, Lon_Coverage_End_list, Grid_Mapping_list,Make_ID_list, Sensor_ID_list, Process_ID_list, Study_Domain_ID_list, keyword_list, comment_list)
# print(len(DB_list),len(Dataset_Name_list),len(short_name_list),len(long_name_list),len(unit_list),len(temporal_res_list),len(spatial_res_list),len(Temporal_Coverage_Begin_list),len(Temporal_Coverage_End_list),len(Lat_Coverage_Begin_list),len(Lat_Coverage_End_list),len(Lon_Coverage_Begin_list),len(Lon_Coverage_End_list),len(Grid_Mapping_list),len(Make_ID_list),len(Sensor_ID_list),len(Process_ID_list),len(Study_Domain_ID_list),len(keyword_list),len(comment_list))
# print('DB: ', DB, '\n', '\n', 'Dataset_Name: ', Dataset_Name, '\n', '\n', 'Dataset_Long_Name: ',Dataset_Long_Name, '\n', '\n', 'Variables: ',Variables, '\n', '\n', 'Data_Source: ', Data_Source, '\n', '\n', 'Distributor: ', Distributor, '\n', '\n', 'Description: ', Description, '\n', '\n', 'Climatology: ',Climatology)
