Re: Plotting date-time series in 3D how to handle date-time to plot
- To: mathgroup at smc.vnet.net
- Subject: [mg106653] Re: Plotting date-time series in 3D how to handle date-time to plot
- From: Canopus56 <canopus56 at yahoo.com>
- Date: Wed, 20 Jan 2010 06:48:29 -0500 (EST)
- References: <hj40n2$sed$1@smc.vnet.net> <4B559536.1090102@metrohm.com>
> 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? Thanks David. I am after a 3D plot that looks like the following with the Day-Date on the x axis and the Hour-Date on the y-axis. The desired output looks like this: http://www.slas.us/gallery2/main.php?g2_itemId=2817 Instead of converting the dates to a numeric Julianday, I would like to use dates along the x-axis. If have not run it, but the 2D plot you suggested is not the desired plot. The 2D plot would be for all-hours-on-all days against all-counts. Thanks again for your ongoing help. - Kurt ----- Original Message ---- From: dh <dh at metrohm.com> To: Canopus56 <canopus56 at yahoo.com> Sent: Tue, January 19, 2010 4:19:18 AM Subject: [mg106653] Re: Plotting date-time series in 3D how to handle date-time to plot 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.