×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Having issue with consolidating date and time vectors in large array to datetime in one vector

thread575-428507

Having issue with consolidating date and time vectors in large array to datetime in one vector

Having issue with consolidating date and time vectors in large array to datetime in one vector

(OP)
I could only find a limited amount of video instruction on this, new to Matlab.
I have some data files with date and time in separate column vectors, but want to plot the time stamped data, so that date and time are together (as x axis on plot).

RE: Having issue with consolidating date and time vectors in large array to datetime in one vector

Date is typically (in Excel) a whole number where 1 represents 1/1/1900, and time is the floating point fraction of a day

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: Having issue with consolidating date and time vectors in large array to datetime in one vector

(OP)
What you are telling me is that to concatenate the two columns requires (1) that the date reference needs to be consistent to the same date between logger file (consistent with Microsoft)and the MatLab software definition of date relative to a starting date (different than Microsoft date). Then I must convert the time into a real fraction and add this to the integer date, as one final output vector.
That sounds about right, as I did run into some odd looking date times after trying straightforward addition without conversion to Matlab date.

RE: Having issue with consolidating date and time vectors in large array to datetime in one vector

That's pretty much it. Matlab does have functions for manipulating dates and times: https://www.mathworks.com/help/finance/handling-an...

However, if it were me; I'd upload into Excel and do the concatenation there.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: Having issue with consolidating date and time vectors in large array to datetime in one vector

(OP)
I was using Excel previously when the files only had about 35,000 rows. Since we will be running for about 1 week to 2 weeks at a time, the LOGGERXX.csv might have as many as 1,209,600 rows as some of the data is updated once per second, some has a variable update time about 5 seconds to 60 seconds, depending on a dial setting, and some updates once per minute. Plotting part of all these separate blocks of data into one consolidated graphic might get interesting. We have not had the ability to get everything running on one Arduino Mega. Trying to work more than about 35,000 rows in Excel gets really tedious, and I think it cannot handle past 1,000,000 rows anyway.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login

Resources

Research Report - How Engineers are Using Remote Access
Remote access enables engineers to work from anywhere provided they have an internet connection. We surveyed our audience of engineers, designers and product managers to learn how they use remote access within their organizations. We wanted to know which industries have adopted remote access, which software they are using, and what features matter most. Download Now
eBook - Managing the Context of Product Complexity Using the Digital Twin
Keeping track of changes to complex products is difficult—think Aerospace & Defense equipment, new generations of commercial aircraft, and software-based automobiles. A new way to managing the digital context of the physical product is required and the answer is the Digital Twin. This ebook explores the opportunity available for Operations and Maintenance for the Digital Twin. Download Now
White Paper - Trends in Industrial Filtration
Substantial progress has been made in filtration technologies in recent years. New filter media materials, designs and processes have led to filters that are more efficient, reliable, compact and longer lasting. This white paper will discuss the various trends that are impacting operational responsibilities of MROs today and the resources that are available for staying up-to-date on the latest filtration solutions. Download Now
Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close