Skip to main content
Anonymous
April 4, 2010
Question

Reading in real world datasets for analysis

I've been trying to find a way to do this in MathCAD (and I have version 14).

What I want to do is read in some real-world data into MathCAD so I can perform some analysis on it. Unfortunately MathCAD's abilities in this area are very limited.

I've attached a file showing the type of dataset I'm trying to analyze. The file shows a data set organized as a block of 31x12 daily measurements repeated n times.

Obviously for months that have less than 31 days then it puts a missing value in (in this case -999).

How in MathCAD would I program to read that data into a time series (a single column vector) so that I can plot the data?

12 replies

AlvaroDíaz12-Amethyst
12-Amethyst
April 4, 2010
On 4/4/2010 7:53:49 PM, AReader wrote:

>How in MathCAD would I program
>to read that data into a time
>series (a single column
>vector) so that I can plot the
>data?

See the attached. Can you tell us what values are?

Regards. Alvaro.
Translate
Anonymous
April 5, 2010
On 4/4/2010 11:51:37 PM, adiaz wrote:
>On 4/4/2010 7:53:49 PM, AReader wrote:
>
>>How in MathCAD would I program
>>to read that data into a time
>>series (a single column
>>vector) so that I can plot the
>>data?
>
>See the attached. Can you tell us what
>values are?
>
>Regards. Alvaro.

Alvaro

Close but the data is read downwards in each column (31 values) and then across one column

The table would have a header of:

Year, Day of Month, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec

So for the year 1772, the first 35 days would produce 32,20,27,27,15,22,25,0,0,45,62,52,25,17,30,20,-18,-13,-18,-10,-6,15,12,5,12,15,0,15,-33,-10,-8,-15,7,15,-25 ...

So in blocks of 31 x 12, each year is read down a column and then across one. Dates that don't exist (eg February 29,30,31) get filled with -999

Does this make sense now?
Translate
AlvaroDíaz12-Amethyst
12-Amethyst
April 5, 2010
On 4/5/2010 1:00:47 AM, AReader wrote:

>Does this make sense now?

Yes, I don't check in what order data ends (or I do that, but because I use dd/mm/yy sometimes I misread and get confusing with bad ordered data).

Regards. Alvaro.
Translate
ptc-13682881-Visitor
1-Visitor
April 4, 2010
On 4/4/2010 7:53:49 PM, AReader wrote:
...
>What I want to do is read in
>some real-world data into
>MathCAD ... Unfortunately
>MathCAD's abilities in this
>area are very limited.
...
_______________________

jmG


Translate
TomGutman1-Visitor
1-Visitor
April 4, 2010
You need to read the data as the full matrix (as it is in the file), and then use a program to loop through the data to create a single time series. That program would just ignore the missing data.
__________________
� � � � Tom Gutman
Translate
ptc-13682881-Visitor
1-Visitor
April 5, 2010
Here is an example of waterfall plot.

jmG
Translate
Terms & ConditionsAccessibility statement