Answered
How to add datetime from seconds?
That's not the error that I get, but it's possible that you are using an older version with different error handling. In any ca...

6 meses ago | 1

| accepted

Answered
Split timetable using retime
You are using datetimes, which is a linear time line. It sounds like you want "time of day", which is a circular time line. I ca...

6 meses ago | 0

Answered
How to import text to timetable with ntsf timestamp
In recent versions (since R2018a? or thereabouts): >> help datetime [snip] D = datetime(X,'ConvertFrom',TYPE) converts the nu...

6 meses ago | 0

| accepted

Answered
How to identify entries for a time frame?
The data in your example are VERY sparse, and it's hard to know if that's typical or not. One very simple way to do what you wa...

6 meses ago | 0

Answered
How can I extract data from a table and put it into a new one?
With no example, it's hard to understand what you have and what you want to end up with, but your description sounds very much l...

6 meses ago | 0

Answered
extract data for a specified date and time period
Abhishek, you have not made clear what problem you are actually running into. One of the problems is that every 400 rows or so, ...

6 meses ago | 2

Answered
extract column name of table with Nan column
Using {:,:} to convert the entire table to a homogeneous array is perhaps one way to do this, but scales badly very quickly as t...

6 meses ago | 0

Answered
export cell2table to excel
cell2table is a unction that converts a cell array to 1 table. writetable is a function that writes a table to a file. This Su...

6 meses ago | 0

Answered
Undefined operator '-' for input arguments of type 'table'.
Tables are containers, and can contain (almost) any data type. So they do not support all the methods that their contents suppor...

6 meses ago | 0

Answered
deleting all rows from a table that contain a string
Eth, I think the more important question is how you got yourself into this corner to begin with. You say you have a table, But i...

6 meses ago | 0

Answered
missing data, time series
All you need to do is call retime and tell it what you want the new time v ecgtor to be. Sometimes it's as simple as 'hourly', o...

6 meses ago | 0

| accepted

Answered
How to get difference between two time values ?
Don't use etime. Use datetimes. Haritha, without more info it's hard to tell, but it looks like your "data" is a cellarray of ch...

6 meses ago | 0

Answered
Get time/date online
I've taken the liberty of updating Vincent's soln's with soemthing more current (and in the second case, more straight-forward a...

6 meses ago | 0

Answered
Categorical2Num in a table
If you are computing the average of a numeric variable using a cate3gorical variable to group your data, then you should not nee...

6 meses ago | 0

Answered
How to extracy table rows by date?
Looking at your code, you seem to be creating a timetable with no data, just row times. That doesn't seem useful. But then "arra...

6 meses ago | 0

Answered
Using for loop to create monthly data sets from a timetable with annual data
+1 to what dpb said, but if you really want to do this timerange(datetime(1985,i,1),datetime(1985,i+1,1)) should do it. To...

6 meses ago | 0

Answered
How to find same values in table and show them in a new table?
Your first question is just an inner join, I think. Perhaps an outer join, you have not explained sufficiently. You'll have to s...

6 meses ago | 0

Answered
Extract rows from a matrix using time ranges
dulio, I strongly recommend that you use datetims and timetables. You will likely be happier in the long run: >> X = [734139 ...

6 meses ago | 0

Answered
Convert Date to DATENUM format
"which I would like to convert to datenum format." Louise, you really don't want to do that. Any of it. Unless you are using a ...

6 meses ago | 0

| accepted

Answered
Using a custom interpolation function in RETIME for timetable
Create a new timetable with your desired ime vector, using FillWithMissing. Then overwrite the variable(s) in that new timetable...

6 meses ago | 0

Answered
How to select a time from one array which is close to the time in another array ?
N loops needed for this. Use durations amd 'nearest' interpolation. Actually, this problem is probably ill-posed, because if the...

7 meses ago | 0

Answered
Extract rows in one array based on time values in a another array +20 seconds
I'm not 100% following, but I would think a timetable would be your friend here. The following selects rows of a timetable that ...

7 meses ago | 0

Answered
missing data, time series
Johannes, If I understand your question corre3ctly, you may want to consider using datetimes and a timetable. Not sure what form...

7 meses ago | 0

Answered
manipulate structure field data to create a table
Tailor-made for the too-often-overlooked unstack: >> type = categorical(["type1";"type1";"type2";"type2"]); >> list = ["a";"p"...

7 meses ago | 1

| accepted

Answered
separate table data in to sub tables
ALDO, unless you have a good reason for wanting to do this, I'm gonna suggest that you consider NOT doing it. There are a bunch ...

7 meses ago | 0

Answered
Working with table.
>> t = table(datetime(2019,5,1:3)',[1;2;3],[4;5;6]) t = 3×3 table Var1 Var2 Var3 ___________ ____ ...

7 meses ago | 0

Answered
Creating Table From Excel Data
It almost looks like you have table namednamed "greenhousegasinventorydatadata", and one of the variables in that table is calle...

7 meses ago | 0

Answered
standardizeMissing not working on all table columns
standardizeMissing isn't designed to dig into arbitrary cell arrays. If "valid" values in that cell array are always two-element...

7 meses ago | 1

| accepted

Answered
how to concatenate tables stored in a structure
If you really ever only have five fields/tables in your scalar struct, just do this: T=cat(1,S.T1,S.T2,S.T3,S.T4,S.T5) But pre...

7 meses ago | 0

Answered
Extract last character in table variable as new table variable
As Walter showed, this is more of a "string" question than a "table" question. In MATLAB versions since (IIRC) R2016b-ish, try t...

7 meses ago | 1

Load more