Respondida
How to build a time record from several matrices?
If you're using R2014b or newer, use durations: >> A = [1;2;3;4]; B = [5;6;7;8]; C = [9;10;11;12]; D = [13;14;15;16]; >>...

más de 9 años hace | 0

Respondida
Plotting precip and time data
If you are using a fairly recent version of MATLAB, use readtable, not xlsread. To make your life easier, you'll want to move th...

más de 9 años hace | 0

Respondida
Using Financial Timeseries with a large number of columns
Pojo, if you are using R2016b or later, you might look into using a timetable. Not sure what specifically you need to do with yo...

más de 9 años hace | 0

Respondida
Rehsaping Data Table to new format
I think you are looking for unstack: >> t = cell2table( ... {'1/1/2017', 'A', 1; ... '1/2/2017', 'A', 2; ......

más de 9 años hace | 0

| aceptada

Respondida
How do replace NaN values and delete full zero's columns from matlab table?
It seems like you're going against the grain here. There are tools to identify and remove missing values, but they mostly work w...

más de 9 años hace | 2

Respondida
How to tranfer the data types of the selected columns of the table from cell string to numeric
What you're seeing is because parenthesis and brace assignments are _into_, while dot assignments _replace_. To see why, conside...

más de 9 años hace | 0

| aceptada

Respondida
How can I select data from certain dates in a table?
If you have access to R2016b, this sounds exactly like what synchronize is for. You want to synchronize the second set of data t...

más de 9 años hace | 0

Respondida
How do I plot time series for multiple machines.
Using timetasbles in 16b, >> Temp = 60+ 20*randn(30,1); >> Turbine = categorical(repelem({'A';'B';'C'},10)); >> Date ...

más de 9 años hace | 1

Respondida
How to insert sequential dates in the x axis of a plot
If you're using a recent version of MATLAB, create your dates as datetimes, not datenums, and just call plot. You get the dates ...

más de 9 años hace | 0

Respondida
How to delete rows in a table
It's hard to tell what you actually have. You say both "table" and "dataset". The latter is a class in the Statistics Toolbox, t...

más de 9 años hace | 1

Respondida
How to convert cell array into double in table
This whole thread begs the question of how the table got like that to begin with, which is worth you figuring out, probably. But...

más de 9 años hace | 3

Respondida
Loop between dates using the value for that date
Probably a loop is not what you want. It's possible that you want to do something like this: i = isbetween(datime.Time,'31-...

más de 9 años hace | 1

| aceptada

Respondida
Determine UTC Offset for a given Time Zone?
All you need to do is: >> datetime(1490742843,'ConvertFrom','posixtime','TimeZone','Europe/Paris') ans = datetime ...

más de 9 años hace | 1

| aceptada

Respondida
find doesn't work with tables
find isn't going to work on a table, but it will work on the _contents_ of a table. So Guillaume, is right that if you're lookin...

más de 9 años hace | 1

Respondida
Adding a new variable called 'Count', which Indexes or counts the occurrence of each stock_code based on their dates
If you are using R2016b or later, you are almost certainly better off using a timetable, since those already have methods for la...

más de 9 años hace | 2

Respondida
Specific timestamp to date format using datetime
Assuming you have strings, not numbers, you've kind of answered the question yourself, except for m vs. M: >> datetime('201...

más de 9 años hace | 1

Respondida
How to convert UTC timehour into IST time hour?
Presumably you mean "Indian Standard Time", but there are three other places in the world that observe what _they_ call IST. And...

más de 9 años hace | 0

Respondida
Is there any way of plotting discrete data with dates??
Prior to R2016b, stem would not have worked with plotting datetimes. In R2016b and later, it does, e.g. stem(datetime(2017,...

más de 9 años hace | 0

Respondida
Join 2 tables with different values in the key variable
The three join functions don't do inequality joins. In any case, I think what you want is a many-to-one correspondence. In a rec...

más de 9 años hace | 1

Respondida
Convert Time series to minutes
Maybe what Steve suggested. Or maybe just change the display format of the time vector? Hard to tell what you're asking. >>...

más de 9 años hace | 0

| aceptada

Respondida
How to assign UTC time?
It's a clash of conventions. Isn't it always? Some conventions define east as positive, some as negative. For the timezones func...

más de 9 años hace | 1

| aceptada

Respondida
Convert Time (UT to LT)...
It sounds like you have "hour numbers". Use datetimes. Support for time zones is built in, and simple line plots will just work ...

más de 9 años hace | 0

Respondida
Filter only specific month from date serial number
Unless you're using a version prior to R2014b, use datetimes: >> dn = 736696 + 90*rand(10,1) dn = 736755.01...

más de 9 años hace | 1

| aceptada

Respondida
How can I read an Excel spreadsheet into a Matlab table and not have the storage requirement for the table increase by a factor of 10 over the Excel file size?
It's likely that you're reading in text data. Consider using categorical variables and datetimes in the table. readtable has had...

más de 9 años hace | 1

Respondida
Merging/Superimposing two tables without using loops
This isn't exactly a join, but it's close. It's not entirely clear to me what you want to do, for example, Mark is missing from ...

más de 9 años hace | 1

| aceptada

Respondida
I have an array of times and corresponding values. I determine the time corresponding to the max value. Max value occurs twice, so when I fprintf the output, the time shows as 99:1112 AAMM. I need it to show as 9:11 AM and 9:12 AM. How do I do that?
It's not exactly clear what you're asking for. It may be the second output from max, or equivalently, the second and third input...

más de 9 años hace | 0

Respondida
Convert NMEA string time to HH:MM:SS.FFFF
Assuming you want "times" and not "dates/times", you can create durations. Are these strings or numbers (you said "cell")? St...

más de 9 años hace | 0

Respondida
Select data with same dates
Hard to say exactly what you need to do, but if you have R2016b or later, take a look at retime and in particular the synchroniz...

más de 9 años hace | 0

Respondida
Merging Table with Duplicate Dates
varfun with grouping variables does this in one line: >> c = { 1 736561 'USA' 2752 251 ... 15 73668...

más de 9 años hace | 2

Respondida
Resample/Match random interval data to interval timeseries
If you have access to R2016b, use a timetable: >> Time = {'01-10-2016 00:00:00'; '01-10-2016 00:00:03'; '01-10-2016 00:00:0...

más de 9 años hace | 0