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

• To: mathgroup at smc.vnet.net
• Subject: [mg106639] Re: Plotting date-time series in 3D how to handle date-time to plot
• From: dh <dh at metrohm.com>
• Date: Wed, 20 Jan 2010 06:45:50 -0500 (EST)
• References: <hj40n2\$sed\$1@smc.vnet.net>

```
Hi,

you should explain better what you want.

In a time series, the independent variable is normally the time. But

beside the time you give 2 data values. Is this supposed to be 2

different time series or a vector valued function?

Assuming the former, we need DateListPlot not ListPlot3D. We extract the

data in the correct form using "Part" or for short: [[..]]:

DateListPlot[{lstTriple[[All, {1, 3}]], lstTriple[[All, {1, 2}]]}]

Daniel

Canopus56 wrote:

> 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: Initialization problem in a DynamicModule
• Next by Date: Re: First function debug help
• Previous by thread: Plotting date-time series in 3D how to handle date-time to plot
• Next by thread: Re: Plotting date-time series in 3D how to handle date-time to plot