Answered
How to compare 2 columns line by line between two matrix of different size?
ismember will work, but ithis is a join operation. It's a one-liner: >> matrix1 = readtable('datasetPDP.csv'); >> matrix2 = re...

ungefär 2 år ago | 0

| accepted

Answered
averaging columns in a table based on two other columns
This should be straight-forward using either groupsummary, or varfun with displacement_pixel as the input/data variable and x_pi...

ungefär 2 år ago | 0

Answered
How do I make an array from select points in a large table (based on dates)?
Alex, you already have a timetable, which is the right thing to use. To help get you started: >> i = isbetween(timeofday(UMR202...

ungefär 2 år ago | 0

| accepted

Answered
How to reformat this table's information so that a column of data becomes the header's for matching data?
I guess this is a useful format? Voss shows one way, here's another: >> Items = "Item" + (1:8)'; >> Family = "Family" + [1;2;4...

ungefär 2 år ago | 1

Answered
Import and export excel data having combined number and text in a single cell.
If each cell of your spreadsheet literally contains things like "4-sample1-sample2-(23.56,-13.54)", then you may want to figure ...

ungefär 2 år ago | 0

Answered
Stacked plots: display two variables on the same x-axis
Farbod, IIUC, you cannot do that with stackedplot. Each subplot can have only one y axis. The whole point of stackedplot is to a...

ungefär 2 år ago | 0

Answered
retrieve data specific date
In addition to what KSSV shows, since you say "retrieve data", I recommend that you use a timetable, and things like timerange,o...

ungefär 2 år ago | 0

Answered
Outerjoin does not merge the keys
As Kevin implies, your are using all four variables in smalltable as keys. That makes no sense. On top of that, there are NO com...

ungefär 2 år ago | 0

Answered
Combination of two signals with different sample rates
Use a timetable, and call synchronize. synchronize uses interp1, but it may be that you particularly want to use the SP-oriented...

ungefär 2 år ago | 0

Answered
Problem in determining standard error and plotting 3 error bars
Zhou, independently from how to make the figure, this code Data = table2array(WORK01S1); % convert it into array Temp = ...

ungefär 2 år ago | 1

Answered
Select best time in an array
You are making your life more difficult using fopen etc. Use writetable and readtable: >> laptimes = readtable("laptimes.txt","...

ungefär 2 år ago | 1

| accepted

Answered
tic/toc versus time.perf_counter_ns()
The doc doesn't say you can't use tic/toc to time very short things, and clearly that is not true: >> tic, x = 1; toc Elapsed ...

ungefär 2 år ago | 0

Answered
How to extract time series averaged over a region?
Keegan, there's a bunch of ways to do this, here's one that uses a timetable: >> lat = ncread("chl2020.nc","latitude"); >> lon...

ungefär 2 år ago | 0

| accepted

Answered
How can I merge successive row values (sum of the values) of the column Y according to a condition in column X?
You want to do grouped sums, where the groups are defined by consecutive zeros in X. Once you have the groups defined as a new v...

ungefär 2 år ago | 0

Answered
Stackedplot: Incorrect x-axis values & multi-variable usage
Jackson, you have a table, and while stackedplot knows to plot against time with a timetable, it can't know what to plot against...

mer än 2 år ago | 0

| accepted

Answered
How to do interpolation only if data interval is > than 3h?
StarStrider's suggestion of datetime and retime is the way to go. Also, like SS, I am mostly guessing at what you are asking for...

mer än 2 år ago | 0

| accepted

Answered
readtable decide which coloumns are read as string and which as number. xlsx file
Magnus, detectImportOptions and subsequent modifications on what it returns are what you are looking for. You can set any or all...

mer än 2 år ago | 0

Answered
How do I load only part of a table saved to a .mat file?
You might look into using datastores, which would, in effect, allow you to load pieces.

mer än 2 år ago | 0

Answered
Read variable in .mat workspace
Rachael, the times are not part of the data, they are "metadata". But as your screenshot shows, the row times of the Acceleratio...

mer än 2 år ago | 0

Answered
Table of tables. Subtables have variable height
Joanna, I suspect that you are 95% of the way there, but it's hard to tell. You say, "each column of subtables has the same widt...

mer än 2 år ago | 0

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

mer än 2 år ago | 0

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

mer än 2 år ago | 0

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

mer än 2 år ago | 0

| accepted

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

mer än 2 år ago | 1

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

mer än 2 år ago | 0

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

mer än 2 år ago | 0

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

mer än 2 år ago | 0

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

mer än 2 år ago | 0

| accepted

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

mer än 2 år ago | 0

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

mer än 2 år ago | 0

| accepted

Load more