Pandas is a great lib to process BIg Data.
1) pandas.pivot_table(data,values=None,columns=None,aggfunc=func)
func can be any function in python
2) pandas.merge(left,right,hpw='inner')
combine left with right based on the inner columns.
3) pandas.read_table(filepath_or_buffer,sep='\t',names=None)
I think《powerful Python data analysis toolkit》 is useful. And It's enough for us to use pandas.