ameriflux/03.read_ascii.ncl
author Forrest Hoffman <forrest@climatemodeling.org>
Mon, 26 Jan 2009 22:08:20 -0500
changeset 0 0c6405ab2ff4
permissions -rw-r--r--
Initial commit of C-LAMP Diagnostics from Jeff Lee
forrest@0
     1
;----------------------------------------------------------------------
forrest@0
     2
; add Month to output
forrest@0
     3
; add lat, lon to output
forrest@0
     4
; add year to output
forrest@0
     5
;
forrest@0
     6
; This example reads an ASCII file that is formatted a specific way, and
forrest@0
     7
; writes out the results to a netCDF file.
forrest@0
     8
;
forrest@0
     9
; The first line in the ASCII file must be a header, with each field
forrest@0
    10
; separated by a single character delimiter (like a ","). The rest of
forrest@0
    11
; the file must be such that each row contains all fields, each
forrest@0
    12
; separated by the designated delimiter.
forrest@0
    13
;
forrest@0
    14
; The fields can be integer, float, double, character, or string.
forrest@0
    15
; String fields cannot be written to a netCDF file. They have to
forrest@0
    16
; be read in as character arrays and written out that way.
forrest@0
    17
;----------------------------------------------------------------------
forrest@0
    18
forrest@0
    19
;----------------------------------------------------------------------
forrest@0
    20
; This function returns the index locations of the given delimiter
forrest@0
    21
; in a row or several rows of strings.
forrest@0
    22
;----------------------------------------------------------------------
forrest@0
    23
function delim_indices(strings,nfields,delimiter)
forrest@0
    24
local cstrings, cdelim
forrest@0
    25
begin
forrest@0
    26
  nrows = dimsizes(strings)
forrest@0
    27
;
forrest@0
    28
; Handle special case if we only have one string. Make sure it
forrest@0
    29
; is put into a 2D array.
forrest@0
    30
;
forrest@0
    31
  if(nrows.eq.1) then
forrest@0
    32
    cstrings = new((/1,strlen(strings)+1/),character)
forrest@0
    33
  end if
forrest@0
    34
forrest@0
    35
  cstrings = stringtochar(strings)        ; Convert to characters.
forrest@0
    36
  cdelim   = stringtochar(delimiter)      ; Convert delimiter to character.
forrest@0
    37
;
forrest@0
    38
; Som error checking here. Make sure delimiter is one character.
forrest@0
    39
;
forrest@0
    40
  nc   = dimsizes(cdelim)
forrest@0
    41
  rank = dimsizes(nc)
forrest@0
    42
  if(rank.ne.1.or.(rank.eq.1.and.nc.ne.2)) then
forrest@0
    43
    print("delim_indices: fatal: the delimiter you've selected")
forrest@0
    44
    print("must be a single character. Can't continue.")
forrest@0
    45
    exit
forrest@0
    46
  end if
forrest@0
    47
forrest@0
    48
;
forrest@0
    49
; Create array to hold indices of delimiter locations, and then loop
forrest@0
    50
; through each row and find all the delimiters. Make sure each row has
forrest@0
    51
; the correct number of delimiters.
forrest@0
    52
;
forrest@0
    53
  ndelims  = nfields-1
forrest@0
    54
  cindices = new((/nrows,ndelims/),integer)
forrest@0
    55
  do i = 0, nrows-1
forrest@0
    56
    ii = ind(cstrings(i,:).eq.cdelim(0))
forrest@0
    57
;
forrest@0
    58
; Make sure there were delimiters on this row. If not, we just quit.
forrest@0
    59
; This could probably be modified to do this more gracefully.
forrest@0
    60
;
forrest@0
    61
    if(any(ismissing(ii))) then
forrest@0
    62
      print("delim_indices: fatal: I didn't find any delimiters")
forrest@0
    63
      print("('" + delimiter + "') on row " + i + ". Can't continue.")
forrest@0
    64
      exit
forrest@0
    65
    end if
forrest@0
    66
    if(dimsizes(ii).ne.ndelims) then
forrest@0
    67
      print("delim_indices: fatal: I expected to find " + ndelims)
forrest@0
    68
      print("delimiters on row " + i + ". Instead, I found " + dimsizes(ii) + ".")
forrest@0
    69
      print("Can't continue.")
forrest@0
    70
      exit
forrest@0
    71
    end if
forrest@0
    72
forrest@0
    73
    cindices(i,:) = ii
forrest@0
    74
forrest@0
    75
    delete(ii)            ; For next time through loop
forrest@0
    76
  end do
forrest@0
    77
forrest@0
    78
  return(cindices)
forrest@0
    79
end
forrest@0
    80
forrest@0
    81
;----------------------------------------------------------------------
forrest@0
    82
; This function reads in a particular field from a string array,
forrest@0
    83
; given the field number to read (fields start at #1 and go to #nfield),
forrest@0
    84
; and the indices of the delimiters.
forrest@0
    85
;
forrest@0
    86
; It returns either an integer, float, double, character, or a string,
forrest@0
    87
; depending on the input flag "return_type".
forrest@0
    88
;----------------------------------------------------------------------
forrest@0
    89
function read_field(strings,ifield,indices,return_type)
forrest@0
    90
local nstring, cstrings, nf, tmp_str
forrest@0
    91
begin
forrest@0
    92
  nrows = dimsizes(strings)
forrest@0
    93
;
forrest@0
    94
; Handle special case if we only have one string. Make sure it
forrest@0
    95
; is put into a 2D array.
forrest@0
    96
;
forrest@0
    97
  if(nrows.eq.1) then
forrest@0
    98
    cstrings = new((/1,strlen(strings)+1/),character)
forrest@0
    99
  end if
forrest@0
   100
forrest@0
   101
  cstrings = stringtochar(strings)
forrest@0
   102
  nf       = dimsizes(indices(0,:))+1     ; indices is nrows x (nfields-1)
forrest@0
   103
forrest@0
   104
;
forrest@0
   105
; Error checking. Make sure user has entered a valid field.
forrest@0
   106
;
forrest@0
   107
  if(ifield.le.0.or.ifield.gt.nf) then
forrest@0
   108
    print("read_field: fatal: you've selected a field that is")
forrest@0
   109
    print("out-of-range of the number of fields that you have (" + nf + ").")
forrest@0
   110
    exit
forrest@0
   111
  end if
forrest@0
   112
forrest@0
   113
;
forrest@0
   114
; Set up array to return. For string, int, float, or double arrays,
forrest@0
   115
; we don't have to do anything special. For character arrays,
forrest@0
   116
; however, we do.
forrest@0
   117
;
forrest@0
   118
  if(return_type.ne."character") then
forrest@0
   119
    return_array = new(nrows,return_type)
forrest@0
   120
  else
forrest@0
   121
;
forrest@0
   122
; We don't know what the biggest character array is at this point, so
forrest@0
   123
; make it bigger than necessary, and then resize later as necessary.
forrest@0
   124
;
forrest@0
   125
    tmp_return_array = new((/nrows,dimsizes(cstrings(0,:))/),"character")
forrest@0
   126
forrest@0
   127
    max_len = 0     ; Use to keep track of max lengths of strings.
forrest@0
   128
  end if
forrest@0
   129
forrest@0
   130
  do i = 0,nrows-1
forrest@0
   131
;
forrest@0
   132
; Special case of first field in row.
forrest@0
   133
;
forrest@0
   134
    if(ifield.eq.1) then
forrest@0
   135
      ibeg = 0
forrest@0
   136
      iend = indices(i,ifield-1)-1
forrest@0
   137
    else
forrest@0
   138
;
forrest@0
   139
; Special case of first field in row.
forrest@0
   140
;
forrest@0
   141
      if(ifield.eq.nf) then
forrest@0
   142
        ibeg = indices(i,ifield-2)+1
forrest@0
   143
        iend = dimsizes(cstrings(i,:))-1
forrest@0
   144
;
forrest@0
   145
; Any field between first and last field.
forrest@0
   146
;
forrest@0
   147
      else
forrest@0
   148
        ibeg = indices(i,ifield-2)+1
forrest@0
   149
        iend = indices(i,ifield-1)-1
forrest@0
   150
      end if  
forrest@0
   151
    end if
forrest@0
   152
;
forrest@0
   153
; Here's the code that pulls off the correct string, and converts it
forrest@0
   154
; to float if desired.
forrest@0
   155
;
forrest@0
   156
    if(return_type.eq."integer") then
forrest@0
   157
      return_array(i) = stringtointeger(chartostring(cstrings(i,ibeg:iend)))
forrest@0
   158
    end if
forrest@0
   159
    if(return_type.eq."float") then
forrest@0
   160
      return_array(i) = stringtofloat(chartostring(cstrings(i,ibeg:iend)))
forrest@0
   161
    end if
forrest@0
   162
    if(return_type.eq."double") then
forrest@0
   163
      return_array(i) = stringtodouble(chartostring(cstrings(i,ibeg:iend)))
forrest@0
   164
    end if
forrest@0
   165
    if(return_type.eq."string") then
forrest@0
   166
      return_array(i) = chartostring(cstrings(i,ibeg:iend))
forrest@0
   167
    end if
forrest@0
   168
    if(return_type.eq."character") then
forrest@0
   169
      if( (iend-ibeg+1) .gt. max_len) then
forrest@0
   170
        max_len = iend-ibeg+1
forrest@0
   171
      end if
forrest@0
   172
      tmp_return_array(i,0:iend-ibeg) = cstrings(i,ibeg:iend)
forrest@0
   173
    end if
forrest@0
   174
  end do
forrest@0
   175
forrest@0
   176
  if(return_type.eq."character") then
forrest@0
   177
    return_array = new((/nrows,max_len/),"character")
forrest@0
   178
    return_array = tmp_return_array(:,0:max_len-1)
forrest@0
   179
  end if
forrest@0
   180
forrest@0
   181
  return(return_array)
forrest@0
   182
end
forrest@0
   183
forrest@0
   184
forrest@0
   185
;----------------------------------------------------------------------
forrest@0
   186
; This function reads in string fields only to get the maximum string
forrest@0
   187
; length.
forrest@0
   188
;----------------------------------------------------------------------
forrest@0
   189
function get_maxlen(strings,ifield,indices)
forrest@0
   190
local nstring, cstrings, nf, tmp_str
forrest@0
   191
begin
forrest@0
   192
  nrows = dimsizes(strings)
forrest@0
   193
;
forrest@0
   194
; Handle special case if we only have one string. Make sure it
forrest@0
   195
; is put into a 2D array.
forrest@0
   196
;
forrest@0
   197
  if(nrows.eq.1) then
forrest@0
   198
    cstrings = new((/1,strlen(strings)+1/),character)
forrest@0
   199
  end if
forrest@0
   200
forrest@0
   201
  cstrings = stringtochar(strings)
forrest@0
   202
  nf       = dimsizes(indices(0,:))+1     ; indices is nrows x (nfields-1)
forrest@0
   203
forrest@0
   204
;
forrest@0
   205
; Error checking. Make sure user has entered a valid field.
forrest@0
   206
;
forrest@0
   207
  if(ifield.le.0.or.ifield.gt.nf) then
forrest@0
   208
    print("read_field: fatal: you've selected a field that is")
forrest@0
   209
    print("out-of-range of the number of fields that you have (" + nf + ").")
forrest@0
   210
    exit
forrest@0
   211
  end if
forrest@0
   212
;
forrest@0
   213
; We don't know what the biggest character array is at this point, so
forrest@0
   214
; make it bigger than necessary, and then resize later as necessary.
forrest@0
   215
;
forrest@0
   216
  tmp_return_array = new((/nrows,dimsizes(cstrings(0,:))/),"character")
forrest@0
   217
forrest@0
   218
  max_len = 0     ; Use to keep track of max lengths of strings.
forrest@0
   219
forrest@0
   220
  do i = 0,nrows-1
forrest@0
   221
;
forrest@0
   222
; Special case of first field in row.
forrest@0
   223
;
forrest@0
   224
    if(ifield.eq.1) then
forrest@0
   225
      ibeg = 0
forrest@0
   226
      iend = indices(i,ifield-1)-1
forrest@0
   227
    else
forrest@0
   228
;
forrest@0
   229
; Special case of first field in row.
forrest@0
   230
;
forrest@0
   231
      if(ifield.eq.nf) then
forrest@0
   232
        ibeg = indices(i,ifield-2)+1
forrest@0
   233
        iend = dimsizes(cstrings(i,:))-1
forrest@0
   234
;
forrest@0
   235
; Any field between first and last field.
forrest@0
   236
;
forrest@0
   237
      else
forrest@0
   238
        ibeg = indices(i,ifield-2)+1
forrest@0
   239
        iend = indices(i,ifield-1)-1
forrest@0
   240
      end if  
forrest@0
   241
    end if
forrest@0
   242
    if( (iend-ibeg+1) .gt. max_len) then
forrest@0
   243
      max_len = iend-ibeg+1
forrest@0
   244
    end if
forrest@0
   245
  end do
forrest@0
   246
forrest@0
   247
  return(max_len)
forrest@0
   248
end
forrest@0
   249
forrest@0
   250
;----------------------------------------------------------------------
forrest@0
   251
; Main code.
forrest@0
   252
;----------------------------------------------------------------------
forrest@0
   253
begin
forrest@0
   254
forrest@0
   255
; Set up defaults here.  We are hard-coding the field types here.
forrest@0
   256
; You can set up this script to try to determine the field types 
forrest@0
   257
; automatically, but this is a bit tedious. Maybe later.
forrest@0
   258
forrest@0
   259
  station = "USHa1"
forrest@0
   260
  lat     = 42.5378
forrest@0
   261
  lon     = -72.1715 + 360.
forrest@0
   262
  year    = 1991
forrest@0
   263
  nfields   = 30                        ; # of fields
forrest@0
   264
  delimiter = ","                       ; field delimiter
forrest@0
   265
 
forrest@0
   266
  filename  = station+year+"_L4_m.txt"  ; ASCII" file to read.
forrest@0
   267
  cdf_file  = station+year+"_L4_m.nc"   ; netCDF file to write. 
forrest@0
   268
forrest@0
   269
; In this case, fields #2-#2 are integers,
forrest@0
   270
; and the rest of the fields are floats.
forrest@0
   271
forrest@0
   272
  var_types      = new(nfields,string)
forrest@0
   273
  var_strlens    = new(nfields,integer)   ; var to hold strlens, just in case.
forrest@0
   274
forrest@0
   275
  var_types      = "float"       ; Most are floats.
forrest@0
   276
  var_types(0:1) = "integer"
forrest@0
   277
forrest@0
   278
  if(isfilepresent(cdf_file))
forrest@0
   279
    print("Warning: '" + cdf_file + "' exists. Will remove it.")
forrest@0
   280
    system("/bin/rm " + cdf_file)
forrest@0
   281
  end if
forrest@0
   282
forrest@0
   283
; Read in data as strings. This will create a string array that has the
forrest@0
   284
; same number of strings as there are rows in the file. We will then need
forrest@0
   285
; to parse each string later.
forrest@0
   286
forrest@0
   287
  read_data = asciiread(filename,-1,"string")
forrest@0
   288
  header    = read_data(0)        ; Header. Use for variable names.
forrest@0
   289
  data      = read_data(1:)       ; Get rid of first line which is a header.
forrest@0
   290
  nrows     = dimsizes(data)      ; Number of rows.
forrest@0
   291
forrest@0
   292
; Read in locations of delimiters in each string row.
forrest@0
   293
forrest@0
   294
  hindices = delim_indices(header,nfields,delimiter)   ; header row
forrest@0
   295
  dindices = delim_indices(data,nfields,delimiter)     ; rest of file
forrest@0
   296
forrest@0
   297
; print (hindices)
forrest@0
   298
; print (dindices)
forrest@0
   299
forrest@0
   300
; Read in the field names which will become variable names on
forrest@0
   301
; the netCDF file.
forrest@0
   302
forrest@0
   303
  var_names = new(nfields,string)
forrest@0
   304
forrest@0
   305
  do i=0,nfields-1
forrest@0
   306
    var_names(i) = read_field(header,i+1,hindices,"string")
forrest@0
   307
  end do
forrest@0
   308
forrest@0
   309
; Write out this netCDF file efficiently so it will be faster.
forrest@0
   310
; Try to predefine everything before you write to it.
forrest@0
   311
forrest@0
   312
  f = addfile(cdf_file,"c")
forrest@0
   313
  setfileoption(f,"DefineMode",True)       ; Enter predefine phase.
forrest@0
   314
forrest@0
   315
; Write global attributes to file. It's okay to do this before 
forrest@0
   316
; predefining the file's variables. We are still in "define" mode.
forrest@0
   317
forrest@0
   318
  fAtt               = True
forrest@0
   319
  fAtt@description   = "Data read in from " + filename + " ASCII file."
forrest@0
   320
  fAtt@creation_date = systemfunc ("date")        
forrest@0
   321
  fileattdef( f, fAtt )        
forrest@0
   322
forrest@0
   323
; Write dimension names to file. If there are no character variables,
forrest@0
   324
; then there's only one dimension name ("nvalues").
forrest@0
   325
forrest@0
   326
  nyear  = -1
forrest@0
   327
  nmonth = 12
forrest@0
   328
 
forrest@0
   329
  dim_names = (/ "year",  "month" /)
forrest@0
   330
  dim_sizes = (/ nyear ,  nmonth  /)
forrest@0
   331
  dimUnlim  = (/ True  ,  False   /)
forrest@0
   332
forrest@0
   333
  filedimdef( f, dim_names, dim_sizes, dimUnlim )
forrest@0
   334
  filedimdef( f, "lat", 1, False )
forrest@0
   335
  filedimdef( f, "lon", 1, False )
forrest@0
   336
forrest@0
   337
; Define each variable on the file.
forrest@0
   338
forrest@0
   339
  filevardef( f, "year", "integer", "year" )
forrest@0
   340
  filevardef( f, "lat" , "float"  , "lat" )
forrest@0
   341
  filevardef( f, "lon" , "float"  , "lon" )
forrest@0
   342
forrest@0
   343
; Don't deal with variable Month (i=0).
forrest@0
   344
forrest@0
   345
  do i=0,nfields-1
forrest@0
   346
     filevardef(f, var_names(i), var_types(i), dim_names)
forrest@0
   347
  end do
forrest@0
   348
forrest@0
   349
; Loop through each field, read the values for that field, print 
forrest@0
   350
; information about the variable, and then write it to the netCDF
forrest@0
   351
; file.
forrest@0
   352
forrest@0
   353
  do i=0,nfields-1
forrest@0
   354
    ifield = i+1           ; Fields start at #1, not #0.
forrest@0
   355
forrest@0
   356
; Note: you can't write strings to a netCDF file, so these have
forrest@0
   357
; to be written out as character arrays.
forrest@0
   358
forrest@0
   359
    tmp_data = new((/1,nmonth/),var_types(i))
forrest@0
   360
forrest@0
   361
    tmp_data(0,:) = read_field(data,ifield,dindices,var_types(i))
forrest@0
   362
forrest@0
   363
;   tmp_data(0,:) = out_data(:)
forrest@0
   364
forrest@0
   365
; Print some info about the variable.
forrest@0
   366
forrest@0
   367
    print("")
forrest@0
   368
    print("Writing variable '" + var_names(i) + "' (field #" + ifield + ").")
forrest@0
   369
    print("Type is " + var_types(i) + ".")
forrest@0
   370
    print("min/max = " + min(tmp_data) + "/" + max(tmp_data))
forrest@0
   371
forrest@0
   372
    if(any(ismissing(tmp_data))) then
forrest@0
   373
      print("This variable does contain missing values.")
forrest@0
   374
    else
forrest@0
   375
      print("This variable doesn't contain missing values.")
forrest@0
   376
    end if
forrest@0
   377
forrest@0
   378
    f->$var_names(i)$ = tmp_data       ; Write to netCDF file.
forrest@0
   379
forrest@0
   380
    delete(tmp_data)                   ; Delete for next round.
forrest@0
   381
;   delete(out_data) 
forrest@0
   382
  end do
forrest@0
   383
forrest@0
   384
  f->year = year
forrest@0
   385
  f->lat  = lat
forrest@0
   386
  f->lon  = lon 
forrest@0
   387
end