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

más de 5 años hace | 1

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

| aceptada

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

más de 5 años hace | 1

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

más de 5 años hace | 0

| aceptada

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

| aceptada

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

más de 5 años hace | 0

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

más de 5 años hace | 0

| aceptada

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

más de 5 años hace | 0

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

casi 6 años hace | 1

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

alrededor de 6 años hace | 0

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

alrededor de 6 años hace | 0

| aceptada

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

alrededor de 6 años hace | 0

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

alrededor de 6 años hace | 0

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

alrededor de 6 años hace | 0

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

alrededor de 6 años hace | 1

| aceptada