Looks like when making use of gazilions numbers, a single and thus minimal data structure that suffices to get the job done is a matrix is a spreadsheet is an sql table. ;-)

I too am trying pandas daily after matlab (and q/kdb) and getting more annoyed by the day, of how inept it is. :-O Then again, it could be me - a craftsman & its tools, etc.