Answered
Getting UTC time from Posix time - leap seconds
Bruce, you are getting tripped up by the difference between clockface time, and the elapsed time since 1970. Here's the deal: A...

3 months ago | 0

Answered
Plot severity colour on bubble map by datetime
I would think you'd want to convert the datetimes into something numeric or categorical, based on their years or months or whate...

3 months ago | 0

Answered
table2timetable adding time vector with start- and end date
I'm not exactly sure what question you are asking. You can make a timetasble whose row times are durations (elapsed times), but ...

3 months ago | 0

Answered
How to plot forecasted data with corresponding dates
This code snippet Data=readtable('2019_SysLoad.xlsx'); testdates=Data((5834:end),1); %converting dates to array A = table2arr...

3 months ago | 0

Answered
Subset data within time range
Your database appears to be a spreadsheet. Don't use xlsread. Use readtimetable or readtable, depending on what version you h...

3 months ago | 0

Answered
Convert Time in timeseries object from posix to datetime
Georg, three suggestions: 1) Numeric precision may be better if you separate the conversion of whole and fractional seconds lik...

3 months ago | 0

Answered
How can we convert a datetime into a string that represents a Unix timestamp in nanoseconds?
There's an easier way already built into datetime: >> dt = datetime(["16-Jun-2020 00:00:00.000000001" "16-Jun-2020 00:00:00.000...

8 months ago | 1

Answered
How to find the min, max and mean values of 34 timetables stored in a 1 x 34 cell and add them as extra columns to the respective timetables?
As others have said, it seems to make little sense to create new variables in each timetable, each of which are a column vector ...

10 months ago | 0

Answered
How to find streaks in a categorical vector?
diff is a numeric function. categorical is not numeric. Ordinal categoricals have a mathematical ordering, but they don't have a...

10 months ago | 0

| accepted

Answered
how to vector with the same length of matrix
I'm going to suggest that you stay away from xlsread, and use readtable instead. Putting that together with Am eer's answer, you...

10 months ago | 0

Answered
Adding Polyfit to a table
"do they have to be part of the table anyway?" polyfit doesn't accept tables, so yes and no. You will likely find the managemen...

10 months ago | 0

Answered
Time Series modeling/Predicting for GARCH
You were on the right track, it's just that you file contains two-digit year timestamps, and you need to specify that. Pragmatic...

10 months ago | 0

Answered
How can i select daily data with a 15 min partition?
These two things "only get the data for the day at 00:00. I want you to take all the data from those selected days" seem contr...

10 months ago | 1

| accepted

Answered
How to read from Excel columns into Signal analyzer app?
You must be leaving something out. If T.st is numeric, then T.st = seconds(T.st) creates a duration, and TT = table2timetable(T...

10 months ago | 0

| accepted

Answered
Separating timeseries into winter and summer months and removing night data
This is straight-forward using logical subscripting. No loops needed: >> t = datetime(2020,1,1) + hours(0:2:365*24)'; >> tt = ...

10 months ago | 0

| accepted

Answered
Calculate with same amount on every date and adjust when date changes (for-loop)
This is almost certainly simple to do with a timetable, no looping needed. Probably either retime or rowfun, plus cumsum. But ho...

10 months ago | 0

Answered
How can I convert datetime vector to datenum (class-double)
You almost certainly DO NOT want to convert datetimes to datenums. In recent versions of MATLAB, there are not many good reasons...

10 months ago | 0

Answered
Merge or join two data sets
You have an irregular intraday table (sentiments) and a daily timetable (returns). It sounds like you want to turn the sentiment...

10 months ago | 0

| accepted

Answered
Import dates from csv files and plot them
Sarlota, I recommend that you use datetime, and not use datenum or datestr at all. Especially do not do this DateString = dates...

10 months ago | 0

Answered
How to check for gaps between datetimes in list of files in a folder?
Louise, if you really want one array that contains both time and text, timetable is the right thign to use (though I would argue...

10 months ago | 1

Answered
I have a timetable with 10 columns that are all binary and I want to add them together so I get a sum of those binary numbers for each row. Is there an easy way to do this?
There are several ways to do this, here's one particularly simple one. Assuming you are starting with something like this ... >...

10 months ago | 0

| accepted

Answered
Repeating a day of the year sequence from a specified date input
Right off the bat, 365 is a bug. I can't tell if you want to start at, say, 1-Oct-2020, and increment the day until you get to 3...

10 months ago | 1

Answered
Correlation Coefficient through time
"%(If you have any input in how to make these ^^^ calculations simpler I would also really appreciate any help)" Does this coun...

11 months ago | 0

Answered
How can I set time for x-axis plot in standard year, month,
I have no idea what that mat file is intended to contain. It's one double vector. In any case, don't use datetick. Just use dat...

11 months ago | 0

Answered
Calculate longterm daily average
grpstats is one good way to do this if you have Stats&MachineLearning. But you can do it with varfun or groupsummary as well, u...

11 months ago | 2

Answered
Retime puts all NaN
As Mohammad says, you must have times that are not exactly at the 5 minute marks. That's the danger of a short display format. ...

11 months ago | 1

Answered
Separate inhale and exhale duration
You don't need any loops. Your picture doesn't seem to match your description, but if each sret of four values corresponds to i...

11 months ago | 0

Answered
Removing a Date (Leap Year) from being Averaged
Not 100% sure what you are trying to end up with, but my guess is the average number of each type of complaint for each day of t...

11 months ago | 1

| accepted

Answered
Hi All,Remove empty [] entries row in Timetable, rmmissing is not removing rows which have empty entries, Please help, thank you very much
Amarkant, this ought to be a very simple operation, something involving rmmissing or maybe something like t = t(~ismissing(t.Va...

11 months ago | 0

Answered
Splitting groups into seperate tables
MLE, it's not clear what you have done, and what you want to do. splitapply on a table is for cases when you want to apply a fu...

1 year ago | 0

Load more