I’m working with a dataset for a project. Unfortunately, I don’t have access to detailed information about the variables (apart from the descriptions I’ll provide below).
After cleaning the data a bit (it was a real mess), I’m left with this dataset, which I’ll link here (along with a screenshot).
One of the variables is called “margin,” defined as “cumulative customer margin.” This makes me think the variable should be in absolute value. Then, I have two other variables: “price” and “number of transactions.”
When filtering for number of transactions = 1, I’d expect the values of price to always be higher than margin (assuming margin = price – cost). However, I’ve found many anomalous values. I’m attaching a few examples in the screenshot.
Any insights would be greatly appreciated!
Here is the translation of the table:

I’m working with a dataset for a project. Unfortunately, I don’t have access to detailed information about the variables (apart from the descriptions I’ll provide below).
After cleaning the data a bit (it was a real mess), I’m left with this dataset, which I’ll link here (along with a screenshot).
One of the variables is called “margin,” defined as “cumulative customer margin.” This makes me think the variable should be in absolute value. Then, I have two other variables: “price” and “number of transactions.”
When filtering for number of transactions = 1, I’d expect the values of price to always be higher than margin (assuming margin = price – cost). However, I’ve found many anomalous values. I’m attaching a few examples in the screenshot.
Any insights would be greatly appreciated!
Here is the translation of the table: