filter a timetable by day
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Angelavtc
am 31 Mär. 2020
Kommentiert: Star Strider
am 31 Mär. 2020
Hi!
How can I create timetable that only groups the information from the following timetable by day?
timeStamps = datetime([2017 3 4; 2017 3 5; 2017 3 4; 2017 3 5; 2017 3 4; 2017 3 5; 2017 3 4; 2017 3 5]);
hour = [8 8 8 8 9 9 9 9]';
Volume = [5 10 15 20 25 30 35 40]';
Price= [40 35 30 25 20 15 10 5]';
T= table(timeStamps, hour, Volume, Price)
TT= table2timetable(T)
This is just an example, my real timetable is composed of several days, perhaps with a for loop?
0 Kommentare
Akzeptierte Antwort
Star Strider
am 31 Mär. 2020
I am not certain what you intend by ‘groups’.
TTRT = retime(TT, 'daily','mean')
producing:
TTRT =
2×3 timetable
timeStamps hour Volume Price
___________ ____ ______ _____
04-Mar-2017 8.5 20 25
05-Mar-2017 8.5 25 20
6 Kommentare
Star Strider
am 31 Mär. 2020
As always, my pleasure!
My code creates them automatically. Use the addressing I used to see and use each one.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu 2-D and 3-D Plots finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!