How to do a lookup for the best number that suits a condition between two arrays?
If you create gap as a row, and shim as a column, this is only a couple of lines. < will automatically expand the two vectors to...

5 meses ago | 0

Why is my table displaying "1 x 1 table" instead of the actual values
It may be that your matrix1 is not a numeric matrix, but rather is itself a table. You have not provide enough information for a...

5 meses ago | 0

How to tell two categorical arrays with different categories names are the same
You don't have categorical arrays, you have numeric arrays. If you had categorical arrays, you'd just look at their categories.

5 meses ago | 0

| accepted

Separate multi-word comma separated cell into rows
[Edited to be even modern by using split, not strsplit, join, not strjoin, and double, not str2double.] Here's a more modern ve...

5 meses ago | 1

Plot two x-axis in a graph with Time(calendar month/year) on axis and Hour on another x-axis
This made little sense to me until I realized that the times were elapsed times from the beginning of data collection i hours, a...

5 meses ago | 0

How do you convert DateTime Strings into Date and Time values (seconds or month,day,time) Trying to plot wind speed by time
Cam, what problem are you having. Your screenshot suggests you have a vector of datetimes. Use that in plot, or whatever chartin...

5 meses ago | 0

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

5 meses ago | 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...

5 meses ago | 0

| accepted

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

5 meses ago | 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...

5 meses ago | 0

| accepted

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

5 meses ago | 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 ...

5 meses ago | 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...

5 meses ago | 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...

5 meses ago | 0

| accepted

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

5 meses ago | 0

| accepted

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

5 meses ago | 0

| accepted

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

5 meses ago | 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...

5 meses ago | 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...

5 meses ago | 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...

5 meses ago | 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-...

5 meses ago | 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)...

5 meses ago | 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: ...

5 meses ago | 0

| accepted

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

5 meses ago | 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/...

5 meses ago | 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...

5 meses ago | 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...

5 meses ago | 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...

5 meses ago | 0