回答済み
how do you plot fft of each sensor for both test
Zeshan, you have all your data in a numeric array, t1. I strongly recommend that you convert that to a timetable. Then your plot...

5年以上前 | 1

回答済み
compare datetime with different lengths
SW, if all you want is a plot, there's nothing special you need to do, just plot them. t1 = datetime(2020,11,19) + caldays(0:2:...

5年以上前 | 0

回答済み
Condition for Specific Data collection
Unless you are using a fairly old version of MATLAB, I strognly recommend that you stay away from xlsread, and use readtable or ...

5年以上前 | 0

回答済み
importing data and plotting
In a more recent version of MATLAB, I would suggest to not use importdata. It's old and gives you a result that is hard to work ...

5年以上前 | 0

回答済み
How do I run my MATLAB program through multiple excel files in the folder?
There is. First step: use readmatrix or readtable, stay away from the much older xlsread. Ditto xlswrite. Then use something lik...

5年以上前 | 0

回答済み
How to import an excel file and split a column
The short answer is no. Your timestamps are stored in the spreadsheet as floating point numbers. But why do you need to split ti...

5年以上前 | 0

| 採用済み

回答済み
Consecutive count of values based on multiple conditions
Put your data in a table, and use rowfun with ID as the grouping variable. Write a function that does all the logic you need to ...

5年以上前 | 1

回答済み
Arrayfun with a timetable
timetable1 is not a timetable, and probably not even legal MATLAB code. I'm going to assume you mean that you have an actual tim...

5年以上前 | 0

| 採用済み

回答済み
How to use multiple arguments in matrix
Or >> t = datetime(2020,1,1,0:8759,0,0); >> scale = [repmat(.2,1,6) repmat(.5,1,8) repmat(.2,1,2) repmat(.5,1,7) .2]; >> scal...

5年以上前 | 0

回答済み
Fill missing NaN by 1 in a table value
Not sure what the question is, but based on your title, "fillmissing".

5年以上前 | 0

回答済み
How to read a netcdf file and convert it to time table
Hamed, it's not currently possible to create a timetable that is 3-D (lat-by-lon-by-time). One thing you can do is make a 45*875...

5年以上前 | 0

回答済み
Plotting Multiple Data Streams with Timestamp
CW, if I am undersatand correctly, you are looking for the same kind of chart that stackedplot makes, for multi-rate data. The o...

5年以上前 | 0

| 採用済み

回答済み
How can i plot multiple plots with respect to date in matlab for forecasting problem ?
No reason why something like this plot(datetime(2020,11,18:30),rand(3,13)) should not work.

5年以上前 | 0

回答済み
if it is greater than 75 percent missing data
I think this would be much simpler if you created a timetable by combining the first 6 vars in the table. Actually, I have no id...

5年以上前 | 0

| 採用済み

回答済み
Why do I get identical outputs from a randomized script?
You don't want to use seeds to get independent parallel random number streams. Switch to using one of the generators that is des...

5年以上前 | 0

回答済み
Store different data types efficiently
Moritz, if "I stored these variables for all documents in a large struct array" is literally true, then that's your problem. I m...

5年以上前 | 0

回答済み
Plotting a line graph
The simple answer for one country is just (ignoring the fact that most people would want time along the horizontal axis) plot(s...

5年以上前 | 0

回答済み
Getting UTC time from Posix time - leap seconds
Bruce, you are getting tripped up by the difference between clockface time, and the elapsed time since 1970. Here's the deal: A...

5年以上前 | 0

回答済み
Plot severity colour on bubble map by datetime
I would think you'd want to convert the datetimes into something numeric or categorical, based on their years or months or whate...

5年以上前 | 0

回答済み
table2timetable adding time vector with start- and end date
I'm not exactly sure what question you are asking. You can make a timetasble whose row times are durations (elapsed times), but ...

5年以上前 | 0

回答済み
How to plot forecasted data with corresponding dates
This code snippet Data=readtable('2019_SysLoad.xlsx'); testdates=Data((5834:end),1); %converting dates to array A = table2arr...

5年以上前 | 0

回答済み
Subset data within time range
Your database appears to be a spreadsheet. Don't use xlsread. Use readtimetable or readtable, depending on what version you h...

5年以上前 | 0

回答済み
Convert Time in timeseries object from posix to datetime
Georg, three suggestions: 1) Numeric precision may be better if you separate the conversion of whole and fractional seconds lik...

5年以上前 | 0

回答済み
How can we convert a datetime into a string that represents a Unix timestamp in nanoseconds?
There's an easier way already built into datetime: >> dt = datetime(["16-Jun-2020 00:00:00.000000001" "16-Jun-2020 00:00:00.000...

5年以上前 | 1

回答済み
How to find the min, max and mean values of 34 timetables stored in a 1 x 34 cell and add them as extra columns to the respective timetables?
As others have said, it seems to make little sense to create new variables in each timetable, each of which are a column vector ...

6年弱前 | 0

回答済み
How to find streaks in a categorical vector?
diff is a numeric function. categorical is not numeric. Ordinal categoricals have a mathematical ordering, but they don't have a...

6年弱前 | 0

| 採用済み

回答済み
how to vector with the same length of matrix
I'm going to suggest that you stay away from xlsread, and use readtable instead. Putting that together with Am eer's answer, you...

6年弱前 | 0

回答済み
Adding Polyfit to a table
"do they have to be part of the table anyway?" polyfit doesn't accept tables, so yes and no. You will likely find the managemen...

6年弱前 | 0

回答済み
Time Series modeling/Predicting for GARCH
You were on the right track, it's just that you file contains two-digit year timestamps, and you need to specify that. Pragmatic...

6年弱前 | 0

回答済み
How can i select daily data with a 15 min partition?
These two things "only get the data for the day at 00:00. I want you to take all the data from those selected days" seem contr...

6年弱前 | 1

| 採用済み