回答済み

Subscripting into a table using one subscript (as in t(i)) is not supported. Specify a row subscript and a variable subscript, as in t(rows,vars). To select variables, use t(:

As the error message suggests, all you need is a colon as the second subscript. data = readtable('numfile.xlsx') ... dataTrai...

Subscripting into a table using one subscript (as in t(i)) is not supported. Specify a row subscript and a variable subscript, as in t(rows,vars). To select variables, use t(:

As the error message suggests, all you need is a colon as the second subscript. data = readtable('numfile.xlsx') ... dataTrai...

約1年 前 | 0

回答済み

Get and interpolate missed daily data

Tis is a one-liner with timetables and retime: >> tt = readtimetable("missed data.xlsx") Warning: Column headers from the file...

Get and interpolate missed daily data

Tis is a one-liner with timetables and retime: >> tt = readtimetable("missed data.xlsx") Warning: Column headers from the file...

約1年 前 | 0

| 採用済み

回答済み

How to convert an excel file (.csv) to a .wav format/any other audio format file?

This should give a hint that xlsread is not the right way to go. In this case, you want to use readmatrix: a = readmatrix("w...

How to convert an excel file (.csv) to a .wav format/any other audio format file?

This should give a hint that xlsread is not the right way to go. In this case, you want to use readmatrix: a = readmatrix("w...

約1年 前 | 0

回答済み

Import values from excel to use it as content

You can index into a vector of your numic values with a categorical: >> opts = detectImportOptions("Book1.2.xlsx") >> opts.Var...

Import values from excel to use it as content

You can index into a vector of your numic values with a categorical: >> opts = detectImportOptions("Book1.2.xlsx") >> opts.Var...

約1年 前 | 0

| 採用済み

回答済み

Inserting Date Time into code

You need to read 20141018_1.txt into a timetable so you have the timestamps for each for of rainfall data. Every other line in t...

Inserting Date Time into code

You need to read 20141018_1.txt into a timetable so you have the timestamps for each for of rainfall data. Every other line in t...

約1年 前 | 0

回答済み

Combining many variables into one table

In recent MATLAB version, there's Simulink.Simulation.Dataset called extractTimetable. Not sure if that's what you have, but it ...

Combining many variables into one table

In recent MATLAB version, there's Simulink.Simulation.Dataset called extractTimetable. Not sure if that's what you have, but it ...

約1年 前 | 0

回答済み

Use loop to Summarize the Data using MATLAB

Not sure what you are trying to do. Maybe you are trying to get all the Energy data into one array? It's not clerar from your qu...

Use loop to Summarize the Data using MATLAB

Not sure what you are trying to do. Maybe you are trying to get all the Energy data into one array? It's not clerar from your qu...

約1年 前 | 0

回答済み

Use timetable as x axis in heatmap

Amir, according to your screenshots, you do NOT have a timetable. You have a table containg one datetime variable, and a separat...

Use timetable as x axis in heatmap

Amir, according to your screenshots, you do NOT have a timetable. You have a table containg one datetime variable, and a separat...

約1年 前 | 0

| 採用済み

回答済み

How do I combine rows of a 2D cell array with 1D cell arrays of varying lengths?

Mixed data are what tables (or timetables) are for: >> SID = ["sid001";"sid002";"sid003";"sid004";"sid005"]; >> Status = categ...

How do I combine rows of a 2D cell array with 1D cell arrays of varying lengths?

Mixed data are what tables (or timetables) are for: >> SID = ["sid001";"sid002";"sid003";"sid004";"sid005"]; >> Status = categ...

約1年 前 | 0

| 採用済み

回答済み

Compare columns of different tables and extract value

This sounds like you need a join. Also, probably a timetable: >> data = readtimetable('Thess_20062100.csv'); >> data.Daily_Tap...

Compare columns of different tables and extract value

This sounds like you need a join. Also, probably a timetable: >> data = readtimetable('Thess_20062100.csv'); >> data.Daily_Tap...

約1年 前 | 0

| 採用済み

回答済み

Storing values in a matrix

This will be MUCH easier using a timetable. It's a one-liner: >> tt = timetable(rand(100,1),'RowTimes',datetime(2022,3,9,1:100,...

Storing values in a matrix

This will be MUCH easier using a timetable. It's a one-liner: >> tt = timetable(rand(100,1),'RowTimes',datetime(2022,3,9,1:100,...

約1年 前 | 1

回答済み

How to place values in a matrix with values from another matrix?

This is a one-liner with join. You have time, so use a timetable: >> year = datetime([2018;2019;2020;2021;2022],1,1); x = [13;1...

How to place values in a matrix with values from another matrix?

This is a one-liner with join. You have time, so use a timetable: >> year = datetime([2018;2019;2020;2021;2022],1,1); x = [13;1...

約1年 前 | 0

回答済み

How to search a specific row and a column from a csv file that are associated with the date that was selected?

It's a LOT easier using a timetable: >> x = (1:20)'; >> y = rand(size(x)); >> date = datetime(2022,1,repelem(1:4,5)'); >> tt...

How to search a specific row and a column from a csv file that are associated with the date that was selected?

It's a LOT easier using a timetable: >> x = (1:20)'; >> y = rand(size(x)); >> date = datetime(2022,1,repelem(1:4,5)'); >> tt...

約1年 前 | 1

回答済み

Extracting information from multiple tables within a cell to plot

Here's a version that uses grouped rowfun and varfun to do the heavy lifting: load matlab.mat table_heightsPR = cellfun(@heigh...

Extracting information from multiple tables within a cell to plot

Here's a version that uses grouped rowfun and varfun to do the heavy lifting: load matlab.mat table_heightsPR = cellfun(@heigh...

約1年 前 | 0

回答済み

How to acess data if its in cell form?

This looks susp[iciously like another post: https://www.mathworks.com/matlabcentral/answers/1664149-i-have-a-list-of-data-and-i-...

How to acess data if its in cell form?

This looks susp[iciously like another post: https://www.mathworks.com/matlabcentral/answers/1664149-i-have-a-list-of-data-and-i-...

約1年 前 | 0

回答済み

Create table from array in a loop

In addition to what Stephen has said, this code (which as Stephen points out was unncessary) V835 = rawTable((rawTable.x > 830)...

Create table from array in a loop

In addition to what Stephen has said, this code (which as Stephen points out was unncessary) V835 = rawTable((rawTable.x > 830)...

約1年 前 | 0

回答済み

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

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

約1年 前 | 0

| 採用済み

回答済み

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

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

約1年 前 | 0

回答済み

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

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

約1年 前 | 0

回答済み

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

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

約1年 前 | 0

回答済み

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

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

約1年 前 | 0

回答済み

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

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

約1年 前 | 0

回答済み

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

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

約1年 前 | 0

回答済み

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

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

約1年 前 | 0

回答済み

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

約1年 前 | 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...

約1年 前 | 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...

約1年 前 | 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 = ...

約1年 前 | 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...

約1年 前 | 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...

約1年 前 | 0