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

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

5 years ago | 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

6 years ago | 0

| accepted

Answered
How to convert time to a number?
>> d = duration('17:15','Format','mm:ss') d = duration 17:15 >> d.Format = 'm' d = duration 17.25 min

6 years ago | 0

Answered
Is there a list of datastore SelectedFormats?
Somewhat buried in the tabularTextDatastore doc: "You can use the same conversion specifiers that the textscan function accepts"...

6 years ago | 0

| accepted

Answered
Problems with empty cell in a large matrix
You have a fixed-width file, and readtable needs to be told how it's organized, using fixedWidthImportOptions: >> opts = fixedW...

6 years ago | 1

| accepted

Answered
How to subset a table with character elements
Blue, I'm a little late to the party, but at least for those data, what you really ought to do is use a categorical for t.type. ...

6 years ago | 0

Answered
Tables and files in matlab
Does this not do what you want? >> t = readtable('Um7V.txt','Delimiter',';','ReadVariableNames',false); >> head(t) ans = 8...

6 years ago | 1

Answered
How do I plot a datetime vs data within a cell array?
You almost certyainly do not want to store your data like that. For one thing, cell arrays are designed for complete generality,...

6 years ago | 1

| accepted

Answered
Pairwise difference of datetime vectors (i.e. pdist for time data)
pdist is probably much more than you actually need, assuming that by "distance" you mean a simple subtraction. pdist is designed...

6 years ago | 1

| accepted