So I came up with renaming almost all columns in the very beginning manually to have them with names without surpraises, and it all (dropping, combining, etc.) went well after : )

Here is my "perfect" df