Re: Re: Plotting date-time series in 3D how to handle date-time to plot
- To: mathgroup at smc.vnet.net
- Subject: [mg106691] Re: [mg106660] Re: Plotting date-time series in 3D how to handle date-time to plot
- From: Canopus56 <canopus56 at yahoo.com>
- Date: Thu, 21 Jan 2010 04:52:56 -0500 (EST)
- References: <hj40n2$sed$1@smc.vnet.net> <201001201149.GAA09262@smc.vnet.net>
> It seems that you are doing work in Excel anyway to get the date into a > Mathematica date list format. Why not keep the date in Excel internal > serialized date format. Thanks, Hans. Eliminating the additional work step of having to port things through Excel is one of the things I was after getting rid of. My objective was to have an efficient Mathematica on-click notebook that I could just click on and then recieve and updated chart of the raw data. - Kurt ----- Original Message ---- From: Hans Michel <hmichel at cox.net> To: mathgroup at smc.vnet.net Sent: Wed, January 20, 2010 4:49:49 AM Subject: [mg106691] [mg106660] Re: Plotting date-time series in 3D how to handle date-time to plot Kurt: It seems that you are doing work in Excel anyway to get the date into a Mathematica date list format. Why not keep the date in Excel internal serialized date format. See http://www.cpearson.com/excel/datetime.htm If you wish to convert that number to Mathematica date while in Mathematica then you can see http://forums.wolfram.com/mathgroup/archive/2004/May/msg00523.html ToDate[(38132 + 2)*(60*60*24)] ToDate[(excel serialdate here + 2)*(60*60*24)] If the work is already done to go from excel date to mathematica date list, then you can look into the following functions: FromDate function or AbsoluteTime function in mathematica If you wish to transform the date list to Julian day then see http://emr.cs.iit.edu/home/reingold/calendar-book/third-edition/ The Calendrica Package from edition have some serialized date formats like RD or JD or MJD. After serializing the dates, you will have numbers that ListPlot3D can deal with. Hans "Canopus56" <canopus56 at yahoo.com> wrote in message news:hj40n2$sed$1 at smc.vnet.net... >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 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}} > >
- References:
- Re: Plotting date-time series in 3D how to handle date-time to plot
- From: "Hans Michel" <hmichel@cox.net>
- Re: Plotting date-time series in 3D how to handle date-time to plot