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...

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...

17 Tage 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 ...

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 ...

2 Monate 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...

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...

2 Monate 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...

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...

2 Monate 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...

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...

2 Monate 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...

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...

2 Monate 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...

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...

2 Monate 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...

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...

2 Monate 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 = ...

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 = ...

2 Monate 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...

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...

2 Monate 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...

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...

2 Monate 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...

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...

3 Monate ago | 0

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...

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...

3 Monate 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...

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...

3 Monate 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 ... >...

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 ... >...

3 Monate 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...

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...

3 Monate 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...

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...

3 Monate 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...

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...

3 Monate 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...

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...

3 Monate 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. ...

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. ...

3 Monate 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...

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...

3 Monate 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...

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...

3 Monate 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...

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...

3 Monate 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...

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...

8 Monate ago | 0

Answered

How to account for the day suffix when using datetime to recognise dates in matlab?

Pedro, you could put a literal th in the format, 'eeee dd ''th''MMMM yyyy hh:mm:ss a' and read most of them, and go back and ...

How to account for the day suffix when using datetime to recognise dates in matlab?

Pedro, you could put a literal th in the format, 'eeee dd ''th''MMMM yyyy hh:mm:ss a' and read most of them, and go back and ...

8 Monate ago | 1

| accepted

Answered

How to plot datetime in garfh?

Gili, you say datetime and table, so I'm going to assume you are using those datatypes. contour does not currently support datet...

How to plot datetime in garfh?

Gili, you say datetime and table, so I'm going to assume you are using those datatypes. contour does not currently support datet...

9 Monate ago | 0

Answered

Datetime from csv: format change from 2017b to 2018 and higher

readtable now reads timestamps as datetimes by default. I think you have two options: 1) If you are already getting datetimes i...

Datetime from csv: format change from 2017b to 2018 and higher

readtable now reads timestamps as datetimes by default. I think you have two options: 1) If you are already getting datetimes i...

9 Monate ago | 0

Answered

Reassign Categorical Variable Value

If you wanted to all the sundays into mondays, it would be easy: combinecats. But you want to turn them into either mondays or f...

Reassign Categorical Variable Value

If you wanted to all the sundays into mondays, it would be easy: combinecats. But you want to turn them into either mondays or f...

9 Monate ago | 0

Answered

Convert empty table to zero

The answer might be >> t = table.empty(0,3) t = 0×3 empty table >> t{1,:} = 0 t = 1×3 table Var1 Var2 Var3 ...

Convert empty table to zero

The answer might be >> t = table.empty(0,3) t = 0×3 empty table >> t{1,:} = 0 t = 1×3 table Var1 Var2 Var3 ...

9 Monate ago | 0

Answered

How to create a datetime vector from text input and sum only certain values?

First, use readtable, not xlsread. If you have a very recent version, use readtimetable. I'm not clear on exactly what's in your...

How to create a datetime vector from text input and sum only certain values?

First, use readtable, not xlsread. If you have a very recent version, use readtimetable. I'm not clear on exactly what's in your...

9 Monate ago | 0

| accepted