[SciPy-user] NumPy Newcomer Questions: Reading Data Stream & Building Array
rshepard at appl-ecosys.com
Mon Sep 11 11:48:03 CDT 2006
On Mon, 11 Sep 2006, Andrew Straw wrote:
> Actually, with the sophisticated dtypes (datatypes) now in numpy, you can
> now store strings and floats in the same array. However, you solution
> sounds sensible and simpler than creating such an array, so you may prefer
> to carry on.
Thank you, Andrew.
Thinking more about the process, I decided that writing the parsed and
processed stream into a sqlite3 table is the better approach. This gives us
permanent storage of the digital images of each scanned paper form so they
can be compared if a data audit is required.
Also, it is easier -- for me, at least -- to write the SQL select
statements to calculate column averages grouped by the two string values. It
is these average values that are to be inserted into a 2D array.
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc.(TM) | Accelerator
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
More information about the SciPy-user