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

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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 ...

alrededor de 1 año 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 ...

alrededor de 1 año 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...

alrededor de 1 año ago | 1

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

alrededor de 1 año 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 ...

alrededor de 1 año 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...

alrededor de 1 año 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"...

alrededor de 1 año 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 ...

alrededor de 1 año 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 ___________ ____ ...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año 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...

alrededor de 1 año ago | 1

Answered
horizontal concatenate a datetime structure to a table array
The simplest way to add one variable to a table is just to assign it: >> t = table(rand(3,1),rand(3,1)) t = 5×2 table ...

alrededor de 1 año ago | 0

Answered
Display struct array as a table
SG, two things: 1) Display for the table data type is intended to show the contents of the data container. It sounds almost lik...

alrededor de 1 año ago | 0

Answered
Doing averages in blocks for downsampling time series data
A regular timetable and resample? >> tt = timetable(rand(12,1),'SampleRate',200) tt = 12×1 timetable Time Va...

alrededor de 1 año ago | 1

| accepted

Answered
how to get hours of recorded data to 10 minutes time averaged data by moving averaging
It's not clear to me exactly what you want to do, but the following computes 10-minute binned means of timestamped data. >> tt ...

alrededor de 1 año ago | 0

| accepted

Answered
How to best store and work with timeseries datasets in Matlab?
MSani, you probably want to take a look at datastores, and tall (or not tall) timetables.

alrededor de 1 año ago | 1

Answered
Adding seconds to get new date
Andrew, it's not clear to me why you are converting datetimes to datevecs and then using etime. Not sure I've followed what you ...

alrededor de 1 año ago | 1

Answered
Need help transforming data from a table
Zac, if I understand correctly what you want to do, it's way simpler than all that. I assume you know that your data file is ki...

alrededor de 1 año ago | 0

| accepted

Load more