DOC: Updated to mention axis='index' and axis='columns
Updated docs throughout DataFrame methods to mention
that axis can be set to 'index' or 'column' instead of 0 or 1
which improves readability significantly.

Fixes #9658 
