• > This has a great SQL-ish API. Python is similar but starts to be a little clunky since it requires you to think about indices:

    groupby has an as_index parameter for this very purpose

    > Deducting the discount

    You focus on doing the subtraction during the group by. Is there any good reason for this? You could either do it as a step before, or after summing up both columns. Putting too many things into one command is not good practice yet you benchmark the language based on how easy it is to do said bad practice

  • Although not quite the same without a pipe operator, https://pola.rs was an improvement for me when missing the R dataframe syntax.
    • OP makes that concession in the first section of the post. (I may or may not have made a similar comment before deleting in kneejerk shame)
  • > You need to read the previous line to understand what

    that ended rather abruptly?