Can't seem to get the best r^2 from optimization loop

[mlauber71]

The data in the excel file looks quite strange and not like a standard table and I have not inspected it fully. Since it seems to be the same data set my remarks in this thread might also be relevant for you:

dataset piggly wiggly

@camvinga_19 First: it would go a long way if you could provide the data set so we might inspect ourself. But of course, this might not be possible. A few remarks: it is not really clear what your data does contain. Are these sales from one period or do you have an additional time variable one-hot encoding might not address your problem with the categorical data sufficiently if you have the product as a categorical variable and you have nearly as many products as you have lines/prices this mi…