for i, width in enumerate(col_widths):
if width > 40:
width = 40
elif width < 10:
width = 10
worksheet.set_column(i, i, width)
writer.save()
#determine SKU or node search
search_level = 'cat.CATEGORY_ID'
data_type = fd.search_type()
print('working...')
if data_type == 'grainger_query':
search_level, data_process = fd.blue_search_level()
search_data = fd.data_in(data_type, settings.directory_name)
attribute_df = attribute_process(data_type, search_data)
if attribute_df.empty==False:
data_out(settings.directory_name, attribute_df, search_level)
else:
print('EMPTY DATAFRAME')
elif data_type == 'gamut_query':
search_level = 'tax_att."categoryId"'
search_data = fd.data_in(data_type, settings.directory_name)
attribute_df = attribute_process(data_type, search_data)
#determine SKU or node search
search_level = 'cat.CATEGORY_ID'
gamut_df = pd.DataFrame()
grainger_df = pd.DataFrame()
grainger_skus = pd.DataFrame()
attribute_df = pd.DataFrame()
grainger_att_vals = pd.DataFrame()
grainger_sample_vals = pd.DataFrame()
gamut_att_vals = pd.DataFrame
data_type = fd.search_type()
if data_type == 'grainger_query':
search_level = fd.blue_search_level()
search_data = fd.data_in(data_type, settings.directory_name)
start_time = time.time()
print('working...')
if data_type == 'grainger_query':
if search_level == 'cat.CATEGORY_ID':
for k in search_data:
grainger_df = q.gcom.grainger_q(grainger_attr_query, search_level,
k)
if grainger_df.empty == False:
grainger_att_vals, grainger_sample_vals = q.grainger_values(
grainger_df)
grainger_sample_vals = grainger_sample_vals.rename(columns={