回答済み
Trouble with date conversion
Worth saying that if the file was a spreadsheet and contained things like 20230101 as numeric values, there's a conversion for t...

1年以上前 | 1

回答済み
How to get columns as 'struct' in timetable
Ludo, I'm not 100% sure I follow your question, but lemme take a shot. As Stephen shows, a variable in a table can be a struct ...

1年以上前 | 1

回答済み
How to get columns as 'struct' in timetable
For the record, you are correct that timetable is the recommended way to work with timestamped data, but there are no plans to a...

1年以上前 | 1

回答済み
Plotting double vs datetime (DD-MM-YY), only the year is used from the datetime
Paul, in addition to what Walter said, those mat files each contain a bunch of 23041xN variables. Likely you would benefit from ...

1年以上前 | 0

| 採用済み

回答済み
How to update leap seconds
James, there's no way for customers to update MATLAB with new leap seconds. The IERS data is built into a binary file. The last...

1年以上前 | 0

| 採用済み

回答済み
How to find differences between 2 large tables that have a mix of string and numbers?
I thnk looping over every row in the tables will not be very performant. I would think this will do better: matches = false(siz...

1年以上前 | 0

回答済み
Importing data from Delsys Trigno software .csv
If you really have a csv, if it really has variable names spread over two lines, user NumHeaderLines to tell readtable to skip e...

1年以上前 | 0

回答済み
How to use groupsummary to group by hour-of-year
Is this really "hour of year", a value that runs from 0 to 8784? In the same way that day of year is just dt = datetime(2023,7,...

1年以上前 | 0

回答済み
mean of all these variables over latitude x longitude x time that is (5 x 5 x 2)
It's very likely that you should be using a timetable. You have "eight variables loaded with data (latitude,longitude,time,mont...

1年以上前 | 0

回答済み
How to calculate the date 0.25 years after the date of January 15, 2020
This is a long thread. I hope the following will clarify a couple things. The years function is not really intended for precise...

1年以上前 | 0

回答済み
seasonal mean for each year based on the sample code
As in your other post, I can't follow youre code, but my strong recommendation is to read in your data using readtimetable, and ...

1年以上前 | 0

回答済み
Duplicating categorical array to floating point value for perfcurve function
The short answer is that you can call double on a categorical array to get the category numbers as a numeric array. But that may...

1年以上前 | 0

回答済み
years in fourth dimension is not printing properly
I can't follow youre code, but my strong recommendation is to read in your data using readtimetable, and then use groupsummary o...

1年以上前 | 0

回答済み
How to rename identical variables under one common name?
This just SCREAMS for using categorical. Screams. This might seem like more work, but untimately you will be happier. TextData ...

1年以上前 | 0

回答済み
How do you access table data to be used with basic operators?
There are suggestions in this thread pointing in different directions. To answer the question as stated in the post's title, thi...

1年以上前 | 0

回答済み
How to reference a cell from a table within a table
Aron, it sounds like you have tables in a cell array in a table. Dirk is assuming you have "nested tables", which is different b...

1年以上前 | 1

回答済み
constructing a table from a particular data set
You almost certainly do not want to do all the calculation "by hand" as Sharad's answer shows. Import into a timetable, then us...

1年以上前 | 0

回答済み
Simulink Desktop Real-Time & MATLAB App Designer UI (App update lag)
This [SOUNDER_DATA;newSounder] can take some time, it's an expensive operation. If possible, better to save all those one-row ...

2年弱前 | 0

| 採用済み

回答済み
Extracting corresponding timestamp in two tables of different sizes.
The times are changed in the new table, so all the suggestions to match times are AFAICT not gonna work. I think you're on the r...

2年弱前 | 0

| 採用済み

回答済み
I need data points from Labchart file according to stimulus time points in a other channel , how can i get it?
Avinash, I'm not really sure what you are trying to do, but this should get you started: >> t = readtable("90.txt",HeaderLines=...

2年弱前 | 1

回答済み
Question on datestr to datetime conversion
It's hard to tell what this code is doing, but while replacing this datestr(now) with this char(datetime) is a literal old t...

2年弱前 | 0

回答済み
How to remove rows in table?
You don't need loops to do this. Hard to verify that this does what you are asking for with no mat file. pathsToDelete = {'E:\A...

2年弱前 | 0

回答済み
Select values based on datetime
The very first thing you should do is put your data and timestamps in a timetable. Once you do that, use retime to create a dai...

2年弱前 | 0

| 採用済み

回答済み
How can I calculate the overlapping time on a timetable?
This might get you started: >> load('T3.mat') >> T3.Next1 = [(T3.LOS(1:end-1) > T3.AOS(2:end)); false]; >> T3.Next2 = [(T3.LO...

2年弱前 | 0

回答済み
Grouping times by end to start time
This is a lot like hierarchical clustering, if you happen to have the Statistics Toolbox. https://www.mathworks.com/help/stats/...

2年弱前 | 0

回答済み
How to fill zeros and NaNs with the average of the previous nonzero consecutive values (part 2)
Just for fun: a varfun soln. Would look similar using grouptransform. Step one is to define groups of elements by finding runs ...

2年弱前 | 0

回答済み
Weighted Average for a certain depth
At one point you say "weighted soil moisture average to a given depth" and at another you say "soil moisture depth average". You...

2年弱前 | 0

回答済み
How can I list individual year from the datetime table?
I'm gonna go Dave one better: >> load DateList.mat >> t = table(Per); >> t.Year = year(t.Per); >> t2 = varfun(@(x){x},t,Inpu...

2年弱前 | 1

回答済み
How to plot a derivative against variable?
For extra credit, create a timetable from displacement, add velocity and accel, then use stackedplot to plot all three together....

2年弱前 | 0

回答済み
use unstack to reshape table with dummy variable (edited: alternative crosstab method)
I'm having trouble understanding the desireed output, but others have created what is essentially a crosstabulation of counts, s...

2年弱前 | 1