回答済み

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

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

5ヶ月 前 | 1

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

| 採用済み

回答済み

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

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

5ヶ月 前 | 0

| 採用済み

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 1

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

| 採用済み

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

| 採用済み

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

5ヶ月 前 | 0

回答済み

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

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

6ヶ月 前 | 1

| 採用済み

回答済み

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

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

8ヶ月 前 | 0

回答済み

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

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

8ヶ月 前 | 1

回答済み

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

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

8ヶ月 前 | 0

回答済み

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

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

8ヶ月 前 | 0

回答済み

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

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

8ヶ月 前 | 0

回答済み

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

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

8ヶ月 前 | 0

| 採用済み