Is there any data tidying tool for python/pandas similar to R tidyr tool?
I'd start with the melt() function in pandas.  I wrote an article about it:
https://www.ibm.com/developerworks/community/blogs/jfp/entry/Tidy_Data_In_Python?lang=en