How to plot a date file? Some questions, some solutions.
- To: mathgroup at smc.vnet.net
- Subject: [mg4848] How to plot a date file? Some questions, some solutions.
- From: lbliao at alumnae.caltech.edu (lbliao)
- Date: Thu, 26 Sep 1996 22:42:12 -0400
- Organization: California Institute of Technology, Alumni Association
- Sender: owner-wri-mathgroup at wolfram.com
The following is a file that I want to plot
as either R versus FQ or DG versus FQ.
Note it has three columns of numbers preceeded
by two letter identifiers R_, DG, FQ, where
R_ is a two letter identifier. _ denotes
white space.
R 999.1E-3,DG 000.0E+0,FQ 1.000E+3
R 999.1E-3,DG 000.0E+0,FQ 1.023E+3
R 999.1E-3,DG 000.0E+0,FQ 1.047E+3
R 999.1E-3,DG 000.0E+0,FQ 1.072E+3
R 999.1E-3,DG 000.0E+0,FQ 1.096E+3
R 999.1E-3,DG 000.0E+0,FQ 1.122E+3
R 999.1E-3,DG 000.0E+0,FQ 1.148E+3
R 999.1E-3,DG 000.0E+0,FQ 1.175E+3
R 999.1E-3,DG 000.0E+0,FQ 1.202E+3
R 999.1E-3,DG 000.0E+0,FQ 1.230E+3
R 998.9E-3,DG 000.0E+0,FQ 7.244E+3
R 998.9E-3,DG 000.0E+0,FQ 7.413E+3
R 999.0E-3,DG 000.0E+0,FQ 7.585E+3
R 998.9E-3,DG 000.0E+0,FQ 7.762E+3
R 998.9E-3,DG 000.0E+0,FQ 7.943E+3
R 998.9E-3,DG 000.0E+0,FQ 8.128E+3
R 999.0E-3,DG 000.0E+0,FQ 8.317E+3
R 999.0E-3,DG 000.0E+0,FQ 8.511E+3
R 999.0E-3,DG 000.0E+0,FQ 8.709E+3
R 999.0E-3,DG 000.0E+0,FQ 8.912E+3
R 999.0E-3,DG 000.0E+0,FQ 9.120E+3
R 999.0E-3,DG 000.0E+0,FQ 9.332E+3
R 998.8E-3,DG-000.0E+0,FQ 9.999E+3
R 998.8E-3,DG-000.0E+0,FQ 10.00E+3
The format is consistent. There is no space between a two letter
identifier and the number.
R followed by a space, then an optional sign, ie - for minus or
space for plus. The number part is 4 digit and one decimal sign.
The Exponent is one digit with a mandatory sign, then a comma separator,
and next two letter identifier DG, followed by no space and
so on.
The first problem is to separate the list into three columns
and ignoring
R
,DG
,FQ
This is done by the following ReadList command.
a=ReadList["c:\\file", Word,
WordSeparators -> {"R", ",DG", ",FQ"},
RecordLists->True]
For RecordList -> True, see page 182,
For WordSeparators -> {}, see p 496,
This has one PROBLEM. Although all the three number fields are separated,
they are not numbers any more, but words.
The second problem is to get any two columns from the three columns so that
they can be plotted using
PlotList
command. I do not see how to directly get two columns other than transposing
getting the rows, and then transposing back again, ie
Transpose[Transpose[a][[{1,3}]]]
Can some kind soul help? Pls reply via email also.
Thanks a lot!
lbliao
==== [MESSAGE SEPARATOR] ====