답변 있음
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]; >>...

거의 9년 전 | 0

답변 있음
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...

거의 9년 전 | 0

답변 있음
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...

거의 9년 전 | 0

답변 있음
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; ......

거의 9년 전 | 0

| 수락됨

답변 있음
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...

거의 9년 전 | 2

답변 있음
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...

거의 9년 전 | 0

| 수락됨

답변 있음
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...

거의 9년 전 | 0

답변 있음
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 ...

거의 9년 전 | 1

답변 있음
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 ...

거의 9년 전 | 0

답변 있음
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...

거의 9년 전 | 1

답변 있음
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...

거의 9년 전 | 3

답변 있음
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-...

거의 9년 전 | 1

| 수락됨

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

거의 9년 전 | 1

| 수락됨

답변 있음
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...

거의 9년 전 | 1

답변 있음
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...

거의 9년 전 | 2

답변 있음
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...

거의 9년 전 | 1

답변 있음
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...

거의 9년 전 | 0

답변 있음
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,...

거의 9년 전 | 0

답변 있음
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...

거의 9년 전 | 1

답변 있음
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. >>...

거의 9년 전 | 0

| 수락됨

답변 있음
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...

대략 9년 전 | 1

| 수락됨

답변 있음
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 ...

대략 9년 전 | 0

답변 있음
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...

대략 9년 전 | 1

| 수락됨

답변 있음
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...

대략 9년 전 | 1

답변 있음
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 ...

대략 9년 전 | 1

| 수락됨

답변 있음
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...

대략 9년 전 | 0

답변 있음
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...

대략 9년 전 | 0

답변 있음
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...

대략 9년 전 | 0

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

대략 9년 전 | 2

답변 있음
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...

대략 9년 전 | 0