[Numpy-discussion] read line mixed with string and number?

Chao YUE chaoyuejoy at gmail.com
Thu May 10 12:21:33 EDT 2012


Dear all,

I have files which contain lines like this:

30516F5  Sep    1985  1-Day Rain    Trace   0.2    3.2   Trace   0.0
0.0    0.0    0.0    0.2    0.0   Trace  29.2    0.0    0.0    0.0
0.0    1.8
30516F5  Sep    1985  1-Day Snow    Trace   0.0    0.0    0.0   14.8
10.1   Trace   0.0    0.0    0.0    0.0    0.0    0.0    0.0    0.0
Trace  Trace   0.0
30516F5  Sep    1985  1-Day Pcpn.   Trace   0.2    3.2   Trace  18.9
9.8   Trace   0.0    0.2    0.0   Trace  29.2    0.0    0.0    0.0
Trace   1.8    0.0
30516F5  May    1986  Max. Temp.     Misg   Misg   Misg   Misg   Misg
Misg   9.0    8.0    8.0    0.0    6.0    1.0    1.0   -3.0    3.
30516F5  May    1986  Min. Temp.     Misg   Misg   Misg   Misg   Misg
Misg   Misg  -1.0   -2.0   -6.0   -5.0   -5.0   -3.0   -7.0   -6.0   -5.0
-3.0


different columns were separated by blank spaces. with the first column as
sitename, second as month name, then year, then variable name and data.

I want to read them line by line into a list, and then connect all the
numerical data within one year into a list, and then combining different
year data into one masked ndarray,
in this process, I check the flags (Trace, Misg, etc.) and replace them as
unique values (or missing values). and then begin to analyse the data. each
file contains only one site,
it can be big or small depending on the number of years.

I don't know what's the good way to do this job. what I am thinking is to
read one file line by line, and then divide this line by blank space, and
replace special flag. but during this process,
I need to do type conversion.

any suggestion would be appreciated.

Chao

-- 
***********************************************************************************
Chao YUE
Laboratoire des Sciences du Climat et de l'Environnement (LSCE-IPSL)
UMR 1572 CEA-CNRS-UVSQ
Batiment 712 - Pe 119
91191 GIF Sur YVETTE Cedex
Tel: (33) 01 69 08 29 02; Fax:01.69.08.77.16
************************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/numpy-discussion/attachments/20120510/c87524ce/attachment.html>


More information about the NumPy-Discussion mailing list