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={