BUG/ENH: Allow drop to accept axis name

Still need to add tests for DataFrame and Series, but should work. Very
simple fix to boot :).

Finally closes #5044