Databases
StackOverflow2013
Postsdbo
POSplitting up a data file in Python, round 2
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSplitting up a data file in Python, round 2
    text
    copied!<p>So I have recently found a solution to this question <a href="https://stackoverflow.com/questions/9459623/splitting-data-file-columns-into-separate-arrays-in-python">here</a> in which I wanted to take two columns of a data file and put them into two arrays I now have this code which does the job nicely.</p> <pre><code>Xvals=[]; Yvals=[] i = open('BGBiasRE_IM3_wCSrescaled.txt','r') lines = [line.split() for line in i if line[:4] not in ('time', 'Step')] Xvals, Yvals = zip(*lines) V = [0, 0.004, 0, 0.0004] pylab.plot(Xvals, Yvals, marker='o') pylab.axis(V) pylab.xlabel('Time (ms)') pylab.ylabel('Current (A)') pylab.title('Title') pylab.show() </code></pre> <p>But I now realise I screwed up the question. I have a data file laid out as below,</p> <pre><code> time I(R_stkb) Step Information: Temp=0 (Run: 1/11) 0.000000000000000e+000 0.000000e+000 9.999999960041972e-012 8.924141e-012 1.999999992008394e-011 9.623148e-012 Step Information: Temp=10 (Run: 2/11) 0.000000000000000e+000 0.000000e+000 9.999999960041972e-012 4.924141e-012 1.999999992008394e-011 8.623148e-012 </code></pre> <p>(Note: No empty lines between each data line, and a Tab between the two data values)</p> <p>The above code appends all the step information into one array, so I get two big long arrays when I want two different arrays for the different steps so I can plot their respective arrays separately later on. I also have to get the Step name, in this case Temp=10 and attach it/name the array to reflect each chunk of step info. Eg. I would like to end up with arrays like such</p> <pre><code>Temp0_Xvals = [ 0.000000000000000e+000, 9.999999960041972e-012, 1.999999992008394e-011] Temp0_Yvals = [ 0.000000e+000, 8.924141e-012, 9.623148e-012] Temp10_Xvals = [...] Temp10_Yvals = [...] etc etc </code></pre> <p>Obviously this makes the problem much more complicated and I have no idea where to start.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload