Answered
Help plotting a multivar table
There are many good reasons to put data into a table, but plot3 does not yet accept a table as input. This will make the plot: ...

3 months ago | 0

| accepted

Answered
turn table to contour
I'm not sure contour is the function you want to make the plot you showed. contourf, maybe? But maybe image instead. In any cas...

3 months ago | 0

Answered
Unable to find or open table data
Only in (I think) the most recent version of MATLAB will scatter(Tab,'Qgpm','hpft'); work. https://www.mathworks.com/help/...

3 months ago | 0

Answered
Creating time index in timetable
Autumn, "indexVal = 1x2088" is the problem. Tables are more general than data frames in Python, in that a variable in a table ma...

3 months ago | 0

Answered
Trouble with datetime formatting
Autumn, in addition to what others have said: 1) There's a preference (under Command Window) to set the default datetime locale...

3 months ago | 0

Answered
How do I insert errobar to a timeseries line, specifying the time length of the errorbars
Not clar what you mean by, "with the errorbars in each graph by year, season and month, respectively", but this may get you star...

3 months ago | 0

Answered
Converting dates in time series
Here's my solution: >> tt = timetable(rand(6,1),rand(6,1),'RowTimes',datetime(2007,2,27:32,12,0,0)) tt = 6×2 timetable ...

3 months ago | 0

Answered
Error when creating an empty Table
Reza, if that's really what you get in the command window, and you have not left anythng out, then you either have something els...

3 months ago | 0

Answered
Interpolate strings from an x y interval to a corresponding x y interval.
If you had timetables, ths would be a one-liner using synchronize. from and blocksFrom look suspiciously like time vectors. Time...

3 months ago | 1

Answered
i have a list of data and i have to select first 5th column of each row ..then simultaneously 6th column and 7th column
You almost certainly do not need cell arrays. You certainly don't need numeric matrices because most of your data is not numeric...

3 months ago | 0

Answered
I can't manage to stack plot 2 columns with the right graph size
Inigo, I don't know what you data look like or how you have them stored, but I strongly recommend that you look at using a timet...

3 months ago | 0

Answered
Locate indices of datetime from one table in another?
1) It looks like you must have use "day" as an input to groupsummary, which returns a categorical as the group values: >> tt = ...

3 months ago | 0

| accepted

Answered
Built in look-up style interpolation of timetables for non-numeric data?
You absolutely can use interp1 on a numeric vector over a datetime grid with unsorted, repeated query points: >> interp1(t,y,tP...

3 months ago | 0

| accepted

Answered
Adding a column of the same character name for all the rows in a table
It's even simpler than that: >> r1 = array2table(rand(5,1),'VariableNames',"Random1"); >> r1.Time(:) = "hours" r1 = 5×2 tabl...

3 months ago | 0

Answered
Table calculations, annual return
Almost certainly the best way to do this is to use a timetable, and a grouped varfun (or grouptransform). >> AAPL = rand(36,1);...

3 months ago | 0

Answered
Combine rows and average contents in table
In addition to dpb's solution that uses rowfun, here's a similar sol'n that uses varfun. The difference is that varfun works on ...

3 months ago | 0

Answered
How to join data elements with the same date in a table
This is a one-liner with unstack: >> date = datetime(2022,1,[1 1 1 2 2 2 3 3 3])'; >> station = categorical(["A" "B" "C" "A" "...

3 months ago | 0

Answered
Input timetables must contain unique row times when synchronizing using 'linear'
The problem is that one of these files has duplicate rows: >> t1 = readtable('ctm.xlsx'); >> t1.Time = days(t1.Time); t1.Time....

3 months ago | 0

Answered
How to convert one column of a table into numeric data type corresponding to the other column of the same table?
This is perhaps slightly more clear: >> genre = {'ab','a','a','o','abo'}'; >> runtime = [11,12,13,14,45]'; >> T = table(genre...

3 months ago | 1

Answered
Elegant way to view and compare data based on feature/parameter selection?
Martin, you may have moved on already, but maybe this is still helpful. First, I think using categorical will make life easier....

3 months ago | 0

Answered
How do I find a daily minimum value using retime when I have categorial data in the table?
SS's answer seems to have worked, and I'm late to the party, but I always like to provide an alternative to using datenum, and r...

3 months ago | 0

Answered
How to breakdown a timetable into intervals to performance calculations
Oliver, you may have moved on already, but maybe this will still help. Normally retime would be the thing to use for something ...

3 months ago | 0

Answered
Decimail Years date to JulianDate
Maybe I'm missing something. The file contains year and fractional year. Isn't this just >> T1 = readtable('https://www.mathwor...

3 months ago | 0

Answered
Make arrays into a table
TOK, you have 6 series, each with length 10. The normal way to orient that would be 10 rows, 6 columns. Nonetheless, >> a1 = ra...

3 months ago | 0

Answered
Define an event if there are > 5 signals detected in a minute
I'm going to assume that "I would like to define an 'event' if 5 or more signals are detected within a minute." and "check if th...

3 months ago | 0

| accepted

Answered
running for loop gives error " Row index exceeds table dimentions "
Not sure what purpose the first vector serves, but if it always defines non-overlapping groups, then there's no need for a loop:...

3 months ago | 0

Answered
Sort table based on number of occurrences
This has been unanswered for some time. Maybe this is still helpful. The main problem here is cell arrays of (repeated) text an...

3 months ago | 0

Answered
Timeit on pause(2) returns weird ouput
The issue is pause, not timeit: "STATE = pause(...) returns the state of pause previous to processing the input arguments." >>...

3 months ago | 0

Answered
postgresql database with time series results with NaT
You need to provide a format in whatever you are using to import: >> datetime("2022-02-28 16:16:34+00","Format","uuuu-MM-dd HH:...

3 months ago | 0

Answered
Write txt to table with collumn name
Sarah, you question is a little vague. It sounds like you have a series of folders, let's say they are named folder1, folder2, ....

3 months ago | 0

Load more