Is there any way we could get the meaning of num_orders_week, spend_this_week, and qty_this_week?
I've tried spend_this_week = sum(individual qty_this_week * selling_price) for the week for a customer_id but the data's story is inconsistent with this assumption.
same issue with spend_this_week = sum(individual qty_this_week * selling_price * num_orders_week) for the week for a customer_id
If you do this, how do you intend to get the same set of information for the test set?
I hope that an understanding of what these mean can help me to find a way to autoregressively construct those details for weeks into the future (test set)
Hi @isaacOluwafemiOg, I have addressed this issue by uploading a full variable description file to the Data page.
That's lovely, @Ajoel.
Thank you for bringing solution to my problem.
Hi could anyone help me?
I'm considering the description 'spend_this_week' column as provided in the variable_description.pdf. But still I'm unable to calculate how it from the other columns( individual qty_this_week, selling_price, num_orders_week). Could anyone let me know what the relation between these? Thanks in advance
In spite of the variable_description.pdf, I couldn't figure how the 'spend_this_week' values were derived either so I've left that variable alone for the time being.
Oh okay, thanks for sharing :)