已回答
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...

6 years 前 | 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:...

6 years 前 | 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 ...

6 years 前 | 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 ...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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 ...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 0

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

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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.

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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 ...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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...

6 years 前 | 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 years 前 | 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 years 前 | 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 years 前 | 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 years 前 | 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 years 前 | 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 years 前 | 1

| 已接受