回答済み
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...

7年弱前 | 0

回答済み
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...

7年弱前 | 0

回答済み
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...

7年弱前 | 0

回答済み
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 ...

7年弱前 | 0

回答済み
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 ...

7年弱前 | 0

| 採用済み

回答済み
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...

7年弱前 | 1

回答済み
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年弱前 | 0

回答済み
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年弱前 | 0

回答済み
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年弱前 | 0

回答済み
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年弱前 | 1

| 採用済み

回答済み
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年弱前 | 0

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

7年弱前 | 0

回答済み
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年弱前 | 0

回答済み
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年弱前 | 1

| 採用済み

回答済み
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年弱前 | 1

回答済み
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年弱前 | 2

回答済み
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 ...

7年弱前 | 0

回答済み
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...

7年弱前 | 0

回答済み
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...

7年弱前 | 1

| 採用済み

回答済み
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 ...

7年弱前 | 0

| 採用済み

回答済み
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.

7年弱前 | 1

回答済み
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 ...

7年弱前 | 1

回答済み
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...

7年弱前 | 0

| 採用済み

回答済み
split timetable containing data from various dates
You may have a good reason for wanting to split up the data, but often it is not necessary, tools like findgroups/splitapply, va...

7年弱前 | 0

回答済み
Row & Column Operations in table
If the table is entirely numeric, t{:,:} = t{:,:} + 1 would also work, and may be more readable. But varfun will be more efficie...

7年弱前 | 1

回答済み
Trouble using retime to obtain 1 year of hourly average values from 15 years of hourly average values
Here's a sol'n that is along the lines of what Steve and Cris suggest, but uses varfun to create a table. I think groupsummary o...

7年弱前 | 1

| 採用済み

回答済み
Import CSV file using readtable gives wrong date time format.
Steven, I'm guessing that you are in the UK, and your system is set to US. Just a guess. You only give one line of your file, so...

7年弱前 | 0

| 採用済み

回答済み
Find values in a table with multiple data types and set them to NA or NaN
I think standardizeMissing is the way to go here. It's "straight-forward" to do it explicitly >> t = table(["a";"b";"c"],[1;999...

7年弱前 | 2

| 採用済み

回答済み
Write cell array with multiple elements in the cell to Excel File
A cell array is not realluy a good choice for storing your data. Use a table, and use writetable to write out that "ragged" arra...

7年弱前 | 0

回答済み
Data manipulation problem?
Definitely move away from dlmread. fopen+textscan are very powerful, but just make more work in this case. Use readtable. You ...

7年弱前 | 0