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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

| aceptada

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

alrededor de 4 años hace | 0

| aceptada

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

alrededor de 4 años hace | 0

Respondida
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);...

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 1

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

| aceptada

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

| aceptada

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

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

alrededor de 4 años hace | 0

Respondida
Count unique values in a double
In addition to what Walter said, if you want the unique values of one variable in a table, likely this is what you should use: ...

alrededor de 4 años hace | 0

Respondida
Switching TimeZone property in datetime function doesn't change output.
Marius, here's what's happening: The first few inputs of your code tell datetime that the instant of time you are talking about...

alrededor de 4 años hace | 1

| aceptada

Respondida
How to sum structures
Assuming that you are starting with something like this >> A.X = table(rand(3,1),rand(3,1),'VariableNames',{'X1' 'X2'}); >> A....

más de 4 años hace | 0

Respondida
How to add two sets of imported data?
Ashley, there's a long example in the doc that talks about "how to perform calculations by using the numeric and categorical da...

más de 4 años hace | 1

Respondida
Finding the difference in timeseries values
David, you are correct that diff(TableName.Variables) removes the times and the variable names, in fact, it returns a numeric ma...

más de 4 años hace | 0

Respondida
Can I use the movmean function for a time series?
CivilEngBath, I recommend that you take a look at using timetables, not timeseries. smoothdata on timetables does what you want....

más de 4 años hace | 0

Respondida
Plot data to a certain date with array
Give this a try: >> tt = timetable((1:365)','RowTimes',datetime(2021,1,1:365)) tt = 365×1 timetable Time Var...

más de 4 años hace | 0

Respondida
Replacing missing data in timetable with values from another dataset
IIUC, I think the simplest thing to do would be to remove the rows with missng data, vertically concatenate with the other data,...

más de 4 años hace | 1

| aceptada

Respondida
How to convert timeseries class mat file to excel
In MATLAB R2021b, you can use timeseries2timetable, and then write the timetable to excel. This timeseries has nothing complica...

más de 4 años hace | 1

Cargar más