# 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)