BUG/TST: transform and filter on non-unique index, closes #4620