DPlot Forum Index DPlot
http://www.dplot.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Operate on X with _coarse_ time format data ?

 
Post new topic   Reply to topic    DPlot Forum Index -> Suggestions/Questions
View previous topic :: View next topic  
Author Message
bfennema



Joined: 23 Oct 2011
Posts: 7
Location: Bray, Ireland

PostPosted: Thu Oct 27, 2011 10:25 am    Post subject: Operate on X with _coarse_ time format data ? Reply with quote

The following is a query because I do not claim that this should work, given that the time stamp is too coarse.

I have a file with data that is sampled faster than a second but the time tag is like

19/10/2011 15:54:50 10
(repeat 8 ) 11,13 etc
19/10/2011 15:54:50 21
19/10/2011 15:54:51 21
(repeat Cool
19/10/2011 15:54:51

So in other words my time stamp is too coarse for the data (it should have been 50.1,50.2 etc)

Regular X,Y plots all look perfect and display the time in the x-axis
which is a bonus.

In order to subtract Y=Y(n+1) - Y(n) I run Operate on X and add X+1 on a copy of the curve.

This modifies the time stamp to:

31/12/1899 0:00:00

and collapses all my data into a single point (with X=0) -

I am not sure whether this is because I execute +1 on a time stamp or
because there are gaps in my time.

When I load the data via colum=0 for X (which gives the increment) everything works fine, but I lose the nice time label in the graphs.

By the way, I really like this Plotting tool - you can make eally nice graphs quickly - my days of struggling with Excel are over !!

B.
_________________
Best regards,

Boris Fennema
Back to top
View user's profile Send private message
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Thu Oct 27, 2011 1:29 pm    Post subject: Reply with quote

From my phone, so this may not be entirely correct but should be close. Use Operate on X with X=(15+54/60+(50+$N*0.1)/3600)/24. The $N will be replaced with the point index.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Thu Oct 27, 2011 2:53 pm    Post subject: Reply with quote

Aaarrgghh. Nevermind. $N is apparently only in my head and not supported.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
DPlotAdmin
Site Admin


Joined: 24 Jun 2003
Posts: 2310
Location: Vicksburg, Mississippi

PostPosted: Thu Oct 27, 2011 4:45 pm    Post subject: Reply with quote

Sorry for the runaround earlier. There's a decent reason that my imagined $N is not included in the text placeholders: in most of the functions that accept an equation, the placeholder represents a constant (minimum Y, for example) for all points within a curve. The point index obviously isn't constant for all points. But I have gone ahead and added j or J as the point index, useful only with Operate on X and Operate on Y. That will be available in the next release.

In the meantime you can still do what you want, though it isn't exactly straightforward. On your graph, create a new curve with Generate>Y=f(X) and Y=
(15+54/60+(49.9+X*0.1)/3600)/24
with X from 1 through however many points you have and incremented by 1. Now select Generate>Switch Independent Variable and in the curve list select the curve you just created.
_________________
Visualize Your Data
support@dplot.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
bfennema



Joined: 23 Oct 2011
Posts: 7
Location: Bray, Ireland

PostPosted: Fri Oct 28, 2011 9:32 am    Post subject: Reply with quote

Excellent - that is perfect.

I really like it that you have exposed internals such as X Y, indepedent variables etc.

It gives you a great flexibility to process the data sets - also it is fast.

A great product - I am sold !

B.
_________________
Best regards,

Boris Fennema
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Suggestions/Questions All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group