Agreed the documentation could be a lot better. I wonder about a visual approach to using DataFrames and Series with all the different methods to demonstrated more clearly what's being done.
You mean excel?
I really liked this visual explanation of pivot and reshape: