Hello everyone, I have a
dataframe in Python that seems to be in the wrong format and I want it to be in a different format for my task. For example, I am showing a part of the
location product sales_Jan_2023 sales_Feb_2023 sales_March_2023 USA Apple 1000 1200 900 USA Samsung 800 1000 1200 Canada Apple 700 500 900 Canada Samsung 1100 900 1200
I don’t want to analyze each month separately, instead, I want to analyze them together, and I want these columns to somehow be converted into rows so that each row corresponds to a sale of the product and in this way, I can analyze all sales simultaneously. If anyone knows how to do this, please provide some methods using example codes.