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}}