Better explanation of `append` and `overwrite` in `to_parquet`

[hendrikmakait]

As mentioned in #1051 (comment), I have trouble understanding what the two options do and how they are not the inverse of one another. I suspect users face the same problem.