Problem 43667. Use a timetable to analyze a train timetable (Part 4)

Created by Heather Gorr

Solve Later

{"relationships":[{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/document","targetMode":"","relationshipId":"rId1","target":"/matlab/document.xml"},{"relationshipType":"http://schemas.mathworks.com/matlab/code/2013/relationships/output","targetMode":"","relationshipId":"rId2","target":"/matlab/output.xml"}],"parts":[{"partUri":"/matlab/document.xml","relationship":[],"contentType":"application/vnd.mathworks.matlab.code.document+xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<w:document xmlns:w=\"http://schemas.openxmlformats.org/wordprocessingml/2006/main\"><w:body><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>You are analyzing a train timetable (you have some time to kill since you just missed your train!) What is the average daily trip duration?</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:rPr><w:b/></w:rPr><w:t>Example:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[DepTime = datetime(2016,11,1,[6 8 9],[22 51 05],0)';\nArrTime = datetime(2016,11,1,[9 10 12],[17 32 09],0)';\nDestination = categorical({'BOS';'NYC';'BOS'});\ntt = timetable(DepTime,Destination,ArrTime)\ntt = \n DepTime Destination ArrTime \n____________________ ___________ ____________________\n01-Nov-2016 06:22:00 BOS 01-Nov-2016 09:17:00\n01-Nov-2016 08:51:00 NYC 01-Nov-2016 10:32:00\n01-Nov-2016 09:05:00 BOS 01-Nov-2016 12:09:00]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>The result should be a duration variable:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"code\"/></w:pPr><w:r><w:t><![CDATA[Dur = [duration(3,9,05);duration(2,55,15);duration(3,0,24)]\nDur = \n3×1 duration array\n 03:09:05\n 02:55:15\n 03:00:24]]></w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:rPr><w:b/></w:rPr><w:t>Feature Tip:</w:t></w:r><w:r><w:t> </w:t></w:r><w:hyperlink w:docLocation=\"https://www.mathworks.com/help/matlab/release-notes.html?rntext=&amp;startrelease=R2016b&amp;endrelease=R2016b&amp;groupby=release&amp;sortby=descending\"><w:r><w:t>R2016b</w:t></w:r></w:hyperlink><w:r><w:t> introduces timetables with related functions which may be helpful. To learn more see</w:t></w:r><w:r><w:t> </w:t></w:r><w:hyperlink w:docLocation=\"http://www.mathworks.com/help/matlab/timetables.html\"><w:r><w:t>MATLAB Timetables</w:t></w:r></w:hyperlink><w:r><w:t>.</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:rPr><w:b/></w:rPr><w:t>Related Problems:</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:hyperlink w:docLocation=\"http://www.mathworks.com/matlabcentral/cody/problems/43664-use-a-timetable-to-analyze-a-train-timetable-part-1\"><w:r><w:t>Use a timetable to analyze a train timetable (Part 1)</w:t></w:r></w:hyperlink></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:hyperlink w:docLocation=\"http://www.mathworks.com/matlabcentral/cody/problems/43665-use-a-timetable-to-analyze-a-train-timetable-part-2\"><w:r><w:t>Use a timetable to analyze a train timetable (Part 2)</w:t></w:r></w:hyperlink></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:hyperlink w:docLocation=\"http://www.mathworks.com/matlabcentral/cody/problems/43666-use-a-timetable-to-analyze-a-train-timetable-part-3\"><w:r><w:t>Use a timetable to analyze a train timetable (Part 3)</w:t></w:r></w:hyperlink></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:r><w:t>Use a timetable to analyze a train timetable (Part 4)</w:t></w:r></w:p><w:p><w:pPr><w:pStyle w:val=\"text\"/></w:pPr><w:hyperlink w:docLocation=\"http://www.mathworks.com/matlabcentral/cody/problems/43668-use-a-timetable-to-analyze-a-train-timetable-part-5\"><w:r><w:t>Use a timetable to analyze a train timetable (Part 5)</w:t></w:r></w:hyperlink></w:p></w:body></w:document>"},{"partUri":"/matlab/output.xml","contentType":"text/xml","content":"<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\" ?><embeddedOutputs><metaData><evaluationState>manual</evaluationState><layoutState>code</layoutState><outputStatus>ready</outputStatus></metaData><outputArray type=\"array\"/><regionArray type=\"array\"/></embeddedOutputs>"}]}

You are analyzing a train timetable (you have some time to kill since you just missed your train!) What is the average daily trip duration?Example:<pre class="language-matlab">DepTime = datetime(2016,11,1,[6 8 9],[22 51 05],0)';
ArrTime = datetime(2016,11,1,[9 10 12],[17 32 09],0)';
Destination = categorical({'BOS';'NYC';'BOS'});
tt = timetable(DepTime,Destination,ArrTime)
tt = 
 DepTime Destination ArrTime 
____________________ ___________ ____________________
01-Nov-2016 06:22:00 BOS 01-Nov-2016 09:17:00
01-Nov-2016 08:51:00 NYC 01-Nov-2016 10:32:00
01-Nov-2016 09:05:00 BOS 01-Nov-2016 12:09:00
</pre>The result should be a duration variable:<pre class="language-matlab">Dur = [duration(3,9,05);duration(2,55,15);duration(3,0,24)]
Dur = 
3×1 duration array
 03:09:05
 02:55:15
 03:00:24
</pre>Feature Tip: <a href = "https://www.mathworks.com/help/matlab/release-notes.html?rntext=&startrelease=R2016b&endrelease=R2016b&groupby=release&sortby=descending">R2016b</a> introduces timetables with related functions which may be helpful. To learn more see <a href = "http://www.mathworks.com/help/matlab/timetables.html">MATLAB Timetables</a>.Related Problems:<a href = "http://www.mathworks.com/matlabcentral/cody/problems/43664-use-a-timetable-to-analyze-a-train-timetable-part-1">Use a timetable to analyze a train timetable (Part 1)</a><a href = "http://www.mathworks.com/matlabcentral/cody/problems/43665-use-a-timetable-to-analyze-a-train-timetable-part-2">Use a timetable to analyze a train timetable (Part 2)</a><a href = "http://www.mathworks.com/matlabcentral/cody/problems/43666-use-a-timetable-to-analyze-a-train-timetable-part-3">Use a timetable to analyze a train timetable (Part 3)</a>Use a timetable to analyze a train timetable (Part 4)<a href = "http://www.mathworks.com/matlabcentral/cody/problems/43668-use-a-timetable-to-analyze-a-train-timetable-part-5">Use a timetable to analyze a train timetable (Part 5)</a>

You are analyzing a train timetable (you have some time to kill since you just missed your train!) What is the average daily trip duration?

*Example:*

DepTime = datetime(2016,11,1,[6 8 9],[22 51 05],0)';
ArrTime = datetime(2016,11,1,[9 10 12],[17 32 09],0)';
Destination = categorical({'BOS';'NYC';'BOS'});
tt = timetable(DepTime,Destination,ArrTime)
tt = 
       DepTime          Destination          ArrTime       
____________________    ___________    ____________________
01-Nov-2016 06:22:00    BOS            01-Nov-2016 09:17:00
01-Nov-2016 08:51:00    NYC            01-Nov-2016 10:32:00
01-Nov-2016 09:05:00    BOS            01-Nov-2016 12:09:00

The result should be a duration variable:

Dur = [duration(3,9,05);duration(2,55,15);duration(3,0,24)]
Dur = 
  3×1 duration array
   03:09:05
   02:55:15
   03:00:24

*Feature Tip:* <https://www.mathworks.com/help/matlab/release-notes.html?rntext=&startrelease=R2016b&endrelease=R2016b&groupby=release&sortby=descending R2016b> introduces timetables with related functions which may be helpful. To learn more see <http://www.mathworks.com/help/matlab/timetables.html MATLAB Timetables>.

*Related Problems:*

<http://www.mathworks.com/matlabcentral/cody/problems/43664-use-a-timetable-to-analyze-a-train-timetable-part-1 Use a timetable to analyze a train timetable (Part 1)>

<http://www.mathworks.com/matlabcentral/cody/problems/43665-use-a-timetable-to-analyze-a-train-timetable-part-2 Use a timetable to analyze a train timetable (Part 2)>

<http://www.mathworks.com/matlabcentral/cody/problems/43666-use-a-timetable-to-analyze-a-train-timetable-part-3 Use a timetable to analyze a train timetable (Part 3)>

Use a timetable to analyze a train timetable (Part 4)

<http://www.mathworks.com/matlabcentral/cody/problems/43668-use-a-timetable-to-analyze-a-train-timetable-part-5 Use a timetable to analyze a train timetable (Part 5)>

Solve

Solution Stats

87 Solutions
44 Solvers

Last Solution submitted on Jun 08, 2021

Last 200 Solutions

Problem Comments

3 Comments

3 Comments

Peng Liu on 22 Nov 2016

Could you be more specific on the underlying relationship between the input (timetable) and output (mean duration)? That is, among which group are you calculating the mean duration? From your example, there are only 2 groups of destinations, i.e., BOS and NYC, but why there are 3 values in the output? What's the mapping behind? Also, your problems including Part 1, 4, 5 are all based on single test, which allows hard-coded solution to lead.

Nikolaos Nikolaou on 28 Oct 2019

Peng do share the grouping method cause it eludes me :)

Rafael S.T. Vieira on 30 Aug 2020

There seems to be an error with the test suite: the first mean time should be 03:09:50 and not 03:09:05. And the test code should probably be abs(ttDur - Dur) <= duration([0 0 1]) (not 0.01).

Solution Comments

Solution 1252405

1 Comment

1 Comment

Rafael S.T. Vieira on 30 Aug 2020

This is not a solution. It returns just a single value instead of 3 and somehow works.

Solution 1058925

2 Comments

2 Comments

Peng Liu on 22 Nov 2016

Eventually figured out the grouping method in this problem, which is not so obvious...

Rafael S.T. Vieira on 30 Aug 2020

This is a proper solution and with small size.

Problem Recent Solvers44

Problem Tags

feature r2016b timetable

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!