Find the min max and average of one column of data in python
<p>I have a set of data that looks like this</p>

<blockquote>
  <p>201206040210 -3461.00000000 -8134.00000000 -4514.00000000
  -4394.00000000 0 201206040211 -3580.00000000 -7967.00000000 -4614.00000000 -7876.00000000 0 201206040212 -3031.00000000 -9989.00000000 -9989.00000000 -3419.00000000 0 201206040213 -1199.00000000 -6961.00000000 -3798.00000000 -5822.00000000 0 201206040214 -2940.00000000 -5524.00000000 -5492.00000000
  -3394.00000000 0</p>
</blockquote>

<p>I want to take the second to last column and find the min, max, and average. 
Im a little confused on how to use split when the columns are delimited by a space and -. 
i Figure once i do that i can use min() and max function. I have written a shell script to do the same here</p>

<pre><code>#!/bin/ksh
awk '{print substr($5,2);}' data' &gt; /data1
sort -n data1 &gt; data2
tail -1 data2
head -1 data2
awk '{sum+=$1} END {print "average = ",sum/NR}' data2
</code></pre>

<p>Im just not sure how to do this in python. Thanks</p>

<p>EDIT: Decided to use numpy to do this.</p>
