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

circa 5 anni fa | 1

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

| accettato

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

circa 5 anni fa | 1

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

circa 5 anni fa | 0

| accettato

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

| accettato

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

| accettato

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

circa 5 anni fa | 0

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

oltre 5 anni fa | 1

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

oltre 5 anni fa | 0

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

oltre 5 anni fa | 0

| accettato

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

oltre 5 anni fa | 0

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

oltre 5 anni fa | 0

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

oltre 5 anni fa | 0

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

oltre 5 anni fa | 1

| accettato

Carica altro