Pandas datastructure
Not sure if I understood your question correctly, but to dodata analysis, you would need to have a proper DF.

You have something like:

time A B C
1    3 4 6 
time B C D
2    9 4 6


You need one table header, so remove any other header text in the rows > 1.

Also (of course) the content of each row must match the column it belongs to.

So the DF above would change to:

time A B C D
1    3 4 6 0
2    9 4 0 6


Note the "zero" entries in time=1 -&gt; D=0 and time=2 -&gt; C=0. Here the "zero" is chosen to fill the gaps (zero activity in this case). 

This type of data representation is what you usually use for any kind of modelling.