python - Indexing data by string -


I have a large CSV file that encodes the name and indicator of the array given below. Example:

  Time, dataset 1 [0], dataset 1 [1], dataset 1 [2], dataset 2 [0], dataset 2 [1], dataset 2 [2] N 0, 43, 35, think (obviously there is too much data in the array), 29, 21, 59, 39 \ n 1, 21, 59, 39, 43, 35, 29 \ n  

).

How can I easily parse / strip any ideas into an efficient data frame?

[edit]

Ideally I am after a structure like this:

  time dataset 1 dataset 2 0 [43.35 , 29] [21,59,39] 1 1 [21,59,39] [43,35,29]  

Where the index was stripped from the label and changed to the Nepariya index

code> < P> output as:

  & gt; & Gt; & Gt; Time Dataset 1 [0] Dataset 1 [1] Dataset 1 [2] Dataset 2 [0] Datasets 2 [1] \ 0 0 43 35 29 21 59 1 1 21 59 39 43 35 Datasets 2 [2] 0 39 1 2  

Comments