Mathematica 9 is now available
Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2010

[Date Index] [Thread Index] [Author Index]

Search the Archive

Plotting date-time series in 3D how to handle date-time to plot

  • To: mathgroup at smc.vnet.net
  • Subject: [mg106626] Plotting date-time series in 3D how to handle date-time to plot
  • From: Canopus56 <canopus56 at yahoo.com>
  • Date: Tue, 19 Jan 2010 05:13:11 -0500 (EST)

I have a year's worth of time series data that I would like to plot in 3d using ListPlot3D. ListPlot3D does not accept the system formatted dates like the 2D utility DateListPlot.

Q1. What is the best way to plot this type of time series in 3D where the date-times may cross January 1 and two or more years? 

A week's worth of data is appended. 

I have previously been doing this by converting raw csv data file's date-time to a Julian Day in Excel and then importing to Mathematica.  I would like to simplify things by doing the entire import and plot routine in Mathematica directly on the raw data csv file.

Thanks for your help. - Kurt 

lstTriple = {{{2009, 12, 15, 0, 0, 0.}, 0, -0.7252}, {{2009, 12, 15, 1, 0, 0.}, 
 1, -10.926}, {{2009, 12, 15, 2, 0, 0.}, 
 2, -21.7816}, {{2009, 12, 15, 3, 0, 0.}, 
 3, -33.0166}, {{2009, 12, 15, 4, 0, 0.}, 
 4, -44.3585}, {{2009, 12, 15, 5, 0, 0.}, 
 5, -55.4223}, {{2009, 12, 15, 6, 0, 0.}, 
 6, -65.3759}, {{2009, 12, 15, 7, 0, 0.}, 
 7, -71.8831}, {{2009, 12, 15, 8, 0, 0.}, 
 8, -70.8447}, {{2009, 12, 15, 9, 0, 0.}, 
 9, -63.1364}, {{2009, 12, 15, 10, 0, 0.}, 
 10, -52.7841}, {{2009, 12, 15, 11, 0, 0.}, 
 11, -41.6044}, {{2009, 12, 15, 12, 0, 0.}, 
 12, -30.2628}, {{2009, 12, 15, 13, 0, 0.}, 
 13, -19.0995}, {{2009, 12, 15, 14, 0, 0.}, 
 14, -8.3809}, {{2009, 12, 15, 15, 0, 0.}, 15, 
 1.6071}, {{2009, 12, 15, 16, 0, 0.}, 16, 
 10.5065}, {{2009, 12, 15, 17, 0, 0.}, 17, 
 17.8571}, {{2009, 12, 15, 18, 0, 0.}, 18, 
 23.1082}, {{2009, 12, 15, 19, 0, 0.}, 19, 
 25.72}, {{2009, 12, 15, 20, 0, 0.}, 20, 
 25.3619}, {{2009, 12, 15, 21, 0, 0.}, 21, 
 22.082}, {{2009, 12, 15, 22, 0, 0.}, 22, 
 16.2805}, {{2009, 12, 15, 23, 0, 0.}, 23, 
 8.5148}, {{2009, 12, 16, 0, 0, 0.}, 
 0, -0.6809}, {{2009, 12, 16, 1, 0, 0.}, 
 1, -10.8716}, {{2009, 12, 16, 2, 0, 0.}, 
 2, -21.7206}, {{2009, 12, 16, 3, 0, 0.}, 
 3, -32.9522}, {{2009, 12, 16, 4, 0, 0.}, 
 4, -44.2945}, {{2009, 12, 16, 5, 0, 0.}, 
 5, -55.3652}, {{2009, 12, 16, 6, 0, 0.}, 
 6, -65.3402}, {{2009, 12, 16, 7, 0, 0.}, 
 7, -71.9011}, {{2009, 12, 16, 8, 0, 0.}, 
 8, -70.9291}, {{2009, 12, 16, 9, 0, 0.}, 
 9, -63.2465}, {{2009, 12, 16, 10, 0, 0.}, 
 10, -52.9002}, {{2009, 12, 16, 11, 0, 0.}, 
 11, -41.7218}, {{2009, 12, 16, 12, 0, 0.}, 
 12, -30.38}, {{2009, 12, 16, 13, 0, 0.}, 
 13, -19.2154}, {{2009, 12, 16, 14, 0, 0.}, 
 14, -8.4942}, {{2009, 12, 16, 15, 0, 0.}, 15, 
 1.4982}, {{2009, 12, 16, 16, 0, 0.}, 16, 
 10.4049}, {{2009, 12, 16, 17, 0, 0.}, 17, 
 17.7668}, {{2009, 12, 16, 18, 0, 0.}, 18, 
 23.0345}, {{2009, 12, 16, 19, 0, 0.}, 19, 
 25.6681}, {{2009, 12, 16, 20, 0, 0.}, 20, 
 25.335}, {{2009, 12, 16, 21, 0, 0.}, 21, 
 22.0799}, {{2009, 12, 16, 22, 0, 0.}, 22, 
 16.3002}, {{2009, 12, 16, 23, 0, 0.}, 23, 
 8.552}, {{2009, 12, 17, 0, 0, 0.}, 
 0, -0.6305}, {{2009, 12, 17, 1, 0, 0.}, 
 1, -10.8118}, {{2009, 12, 17, 2, 0, 0.}, 
 2, -21.6544}, {{2009, 12, 17, 3, 0, 0.}, 
 3, -32.8826}, {{2009, 12, 17, 4, 0, 0.}, 
 4, -44.2253}, {{2009, 12, 17, 5, 0, 0.}, 
 5, -55.3024}, {{2009, 12, 17, 6, 0, 0.}, 
 6, -65.2976}, {{2009, 12, 17, 7, 0, 0.}, 
 7, -71.9107}, {{2009, 12, 17, 8, 0, 0.}, 
 8, -71.0062}, {{2009, 12, 17, 9, 0, 0.}, 
 9, -63.3515}, {{2009, 12, 17, 10, 0, 0.}, 
 10, -53.0123}, {{2009, 12, 17, 11, 0, 0.}, 
 11, -41.8355}, {{2009, 12, 17, 12, 0, 0.}, 
 12, -30.4934}, {{2009, 12, 17, 13, 0, 0.}, 
 13, -19.3273}, {{2009, 12, 17, 14, 0, 0.}, 
 14, -8.6031}, {{2009, 12, 17, 15, 0, 0.}, 15, 
 1.3943}, {{2009, 12, 17, 16, 0, 0.}, 16, 
 10.309}, {{2009, 12, 17, 17, 0, 0.}, 17, 
 17.683}, {{2009, 12, 17, 18, 0, 0.}, 18, 
 22.9678}, {{2009, 12, 17, 19, 0, 0.}, 19, 
 25.6237}, {{2009, 12, 17, 20, 0, 0.}, 20, 
 25.3157}, {{2009, 12, 17, 21, 0, 0.}, 21, 
 22.0853}, {{2009, 12, 17, 22, 0, 0.}, 22, 
 16.3269}, {{2009, 12, 17, 23, 0, 0.}, 23, 
 8.5956}, {{2009, 12, 18, 0, 0, 0.}, 
 0, -0.5742}, {{2009, 12, 18, 1, 0, 0.}, 
 1, -10.7464}, {{2009, 12, 18, 2, 0, 0.}, 
 2, -21.5829}, {{2009, 12, 18, 3, 0, 0.}, 
 3, -32.8081}, {{2009, 12, 18, 4, 0, 0.}, 
 4, -44.151}, {{2009, 12, 18, 5, 0, 0.}, 
 5, -55.234}, {{2009, 12, 18, 6, 0, 0.}, 
 6, -65.2482}, {{2009, 12, 18, 7, 0, 0.}, 
 7, -71.9119}, {{2009, 12, 18, 8, 0, 0.}, 
 8, -71.0759}, {{2009, 12, 18, 9, 0, 0.}, 
 9, -63.4512}, {{2009, 12, 18, 10, 0, 0.}, 
 10, -53.1202}, {{2009, 12, 18, 11, 0, 0.}, 
 11, -41.9454}, {{2009, 12, 18, 12, 0, 0.}, 
 12, -30.6029}, {{2009, 12, 18, 13, 0, 0.}, 
 13, -19.435}, {{2009, 12, 18, 14, 0, 0.}, 
 14, -8.7074}, {{2009, 12, 18, 15, 0, 0.}, 15, 
 1.2956}, {{2009, 12, 18, 16, 0, 0.}, 16, 
 10.2189}, {{2009, 12, 18, 17, 0, 0.}, 17, 
 17.6057}, {{2009, 12, 18, 18, 0, 0.}, 18, 
 22.9083}, {{2009, 12, 18, 19, 0, 0.}, 19, 
 25.5868}, {{2009, 12, 18, 20, 0, 0.}, 20, 
 25.304}, {{2009, 12, 18, 21, 0, 0.}, 21, 
 22.098}, {{2009, 12, 18, 22, 0, 0.}, 22, 
 16.3605}, {{2009, 12, 18, 23, 0, 0.}, 23, 
 8.6455}, {{2009, 12, 19, 0, 0, 0.}, 
 0, -0.5121}, {{2009, 12, 19, 1, 0, 0.}, 
 1, -10.6756}, {{2009, 12, 19, 2, 0, 0.}, 
 2, -21.5065}, {{2009, 12, 19, 3, 0, 0.}, 
 3, -32.7286}, {{2009, 12, 19, 4, 0, 0.}, 
 4, -44.0717}, {{2009, 12, 19, 5, 0, 0.}, 
 5, -55.1602}, {{2009, 12, 19, 6, 0, 0.}, 
 6, -65.1923}, {{2009, 12, 19, 7, 0, 0.}, 
 7, -71.9049}, {{2009, 12, 19, 8, 0, 0.}, 
 8, -71.1382}, {{2009, 12, 19, 9, 0, 0.}, 
 9, -63.5455}, {{2009, 12, 19, 10, 0, 0.}, 
 10, -53.2237}, {{2009, 12, 19, 11, 0, 0.}, 
 11, -42.0512}, {{2009, 12, 19, 12, 0, 0.}, 
 12, -30.7084}, {{2009, 12, 19, 13, 0, 0.}, 
 13, -19.5384}, {{2009, 12, 19, 14, 0, 0.}, 
 14, -8.807}, {{2009, 12, 19, 15, 0, 0.}, 15, 
 1.2021}, {{2009, 12, 19, 16, 0, 0.}, 16, 
 10.1347}, {{2009, 12, 19, 17, 0, 0.}, 17, 
 17.5349}, {{2009, 12, 19, 18, 0, 0.}, 18, 
 22.856}, {{2009, 12, 19, 19, 0, 0.}, 19, 
 25.5574}, {{2009, 12, 19, 20, 0, 0.}, 20, 
 25.3}, {{2009, 12, 19, 21, 0, 0.}, 21, 
 22.1181}, {{2009, 12, 19, 22, 0, 0.}, 22, 
 16.401}, {{2009, 12, 19, 23, 0, 0.}, 23, 
 8.7018}, {{2009, 12, 20, 0, 0, 0.}, 
 0, -0.4442}, {{2009, 12, 20, 1, 0, 0.}, 
 1, -10.5995}, {{2009, 12, 20, 2, 0, 0.}, 
 2, -21.425}, {{2009, 12, 20, 3, 0, 0.}, 
 3, -32.6443}, {{2009, 12, 20, 4, 0, 0.}, 
 4, -43.9875}, {{2009, 12, 20, 5, 0, 0.}, 
 5, -55.0811}, {{2009, 12, 20, 6, 0, 0.}, 
 6, -65.1298}, {{2009, 12, 20, 7, 0, 0.}, 
 7, -71.8895}, {{2009, 12, 20, 8, 0, 0.}, 
 8, -71.1929}, {{2009, 12, 20, 9, 0, 0.}, 
 9, -63.6343}, {{2009, 12, 20, 10, 0, 0.}, 
 10, -53.3227}, {{2009, 12, 20, 11, 0, 0.}, 
 11, -42.1529}, {{2009, 12, 20, 12, 0, 0.}, 
 12, -30.8097}, {{2009, 12, 20, 13, 0, 0.}, 
 13, -19.6374}, {{2009, 12, 20, 14, 0, 0.}, 
 14, -8.9018}, {{2009, 12, 20, 15, 0, 0.}, 15, 
 1.114}, {{2009, 12, 20, 16, 0, 0.}, 16, 
 10.0564}, {{2009, 12, 20, 17, 0, 0.}, 17, 
 17.4708}, {{2009, 12, 20, 18, 0, 0.}, 18, 
 22.8108}, {{2009, 12, 20, 19, 0, 0.}, 19, 
 25.5357}, {{2009, 12, 20, 20, 0, 0.}, 20, 
 25.3035}, {{2009, 12, 20, 21, 0, 0.}, 21, 
 22.1455}, {{2009, 12, 20, 22, 0, 0.}, 22, 
 16.4482}, {{2009, 12, 20, 23, 0, 0.}, 23, 
 8.7644}, {{2009, 12, 21, 0, 0, 0.}, 
 0, -0.3706}, {{2009, 12, 21, 1, 0, 0.}, 
 1, -10.5182}, {{2009, 12, 21, 2, 0, 0.}, 
 2, -21.3387}, {{2009, 12, 21, 3, 0, 0.}, 
 3, -32.5553}, {{2009, 12, 21, 4, 0, 0.}, 
 4, -43.8986}, {{2009, 12, 21, 5, 0, 0.}, 
 5, -54.9968}, {{2009, 12, 21, 6, 0, 0.}, 
 6, -65.061}, {{2009, 12, 21, 7, 0, 0.}, 
 7, -71.866}, {{2009, 12, 21, 8, 0, 0.}, 
 8, -71.2399}, {{2009, 12, 21, 9, 0, 0.}, 
 9, -63.7174}, {{2009, 12, 21, 10, 0, 0.}, 
 10, -53.4171}, {{2009, 12, 21, 11, 0, 0.}, 
 11, -42.2503}, {{2009, 12, 21, 12, 0, 0.}, 
 12, -30.9068}, {{2009, 12, 21, 13, 0, 0.}, 
 13, -19.732}, {{2009, 12, 21, 14, 0, 0.}, 
 14, -8.9916}, {{2009, 12, 21, 15, 0, 0.}, 15, 
 1.0313}, {{2009, 12, 21, 16, 0, 0.}, 16, 
 9.9842}, {{2009, 12, 21, 17, 0, 0.}, 17, 
 17.4133}, {{2009, 12, 21, 18, 0, 0.}, 18, 
 22.773}, {{2009, 12, 21, 19, 0, 0.}, 19, 
 25.5215}, {{2009, 12, 21, 20, 0, 0.}, 20, 
 25.3146}, {{2009, 12, 21, 21, 0, 0.}, 21, 
 22.1802}, {{2009, 12, 21, 22, 0, 0.}, 22, 
16.5023}, {{2009, 12, 21, 23, 0, 0.}, 23, 8.8331}}

      


  • Prev by Date: Re: trouble with a Binet in a generalized Pell recursion
  • Next by Date: Newbie to Mathematica - how do you read in an array of subscripted variables?
  • Previous by thread: Re: Re: Re: More /.{I->-1} craziness. Schools are conservative. So are
  • Next by thread: Re: Plotting date-time series in 3D how to handle date-time to plot