답변 있음
Data with start and end date only converted to consecutive data for each hour between start and end date
Tim, there are bunch of ways to do this. Here's two versions using tables, datetime, cell array "curly brace expansion", and row...

대략 10년 전 | 0

| 수락됨

답변 있음
Matching 2 date column in Matlab
Samantha, your question isn't all that clear. The first thing is I recommend you use a table, not a cell array. With that, and u...

대략 10년 전 | 1

답변 있음
How to import date/time data into matlab with microsecond precision
I see things like '06/18/13 16:55:01.581688' in your file. From your screenshot, it looks like you're using a version of MATLAB ...

대략 10년 전 | 4

답변 있음
outerjoin using Row Names as key?
Row names have to be unique, so I think you're wanting to do something that might be described as more of a merge than a full-bl...

대략 10년 전 | 0

답변 있음
how to pivot the table
A much shorter example would make your question easier to understand. I don't think this has anything to do with "pivoting" i...

대략 10년 전 | 2

답변 있음
Does innerjoin work between 2 tables where one of them has 0 rows?
Christopher, you are correct, this is a bug. Prior to R2015b, it worked correctly. There's not yet a bug report posted for this,...

10년 초과 전 | 1

| 수락됨

답변 있음
datetime data type and time series object
Christopher, it's nice to hear that you've used datetime and think it's worthwhile. Integrating datetime into more places in MAT...

10년 초과 전 | 0

| 수락됨

답변 있음
problem with converting dates to numbers
The version of 01AA002_Daily_Flow_ts.csv that you've attached has column headings and freeform text at the bottom, so tr = ...

10년 초과 전 | 0

| 수락됨

답변 있음
Elapsed Time for specific month
Better in the future to attach a properly-formatted file. Here's a solution, using a table, datetimes, and splitapply. The re...

10년 초과 전 | 1

| 수락됨

답변 있음
Vector of dates going back one rolling year
If you're using a recent version of MATLAB, try using datetime: >> dateshift(datetime('today'),'end','month',-11:0) ans ...

10년 초과 전 | 1

답변 있음
how to combine a date and corresponding time column imported from a .CSV file.
Srini, it sounds like you've imported the file OK, you just need to combine the two pieces. Probably you used a format like '...

10년 초과 전 | 0

답변 있음
How do I get matlab to recognize a date in a .txt file?
You may fnid that using readtable, and a format such as '%{yyyy-MM-dd}D%f', and perhaps specifying an appropriate delimiter, wor...

10년 초과 전 | 0

답변 있음
Finding the value of a variable for specific dates
Stephen's answer went above and beyond, and accounts for a tolerance on the dates. If that is not important, just use ismember t...

10년 초과 전 | 0

답변 있음
Formatting multiple, incongruent variables in a single table
Benjamin, your description is light on details, but if "data table" means MATLAB's table data type, it's possible that you could...

10년 초과 전 | 0

답변 있음
How to Replace certain elements of table column with corresponding values of another array of different size?
It sounds like maybe you want to use join, or ismember.

10년 초과 전 | 0

답변 있음
how to make a table from matrix data?
Abraham, I think what you're looking for is the array2table function.

10년 초과 전 | 1

답변 있음
load txt files with columns of numbers and text
The first hit for a google search for "matlab load text file" leads to, as Stephen says, readtable and importtool. This is what ...

10년 초과 전 | 0

답변 있음
Manipulating datetime and datevector values: Adding millions of seconds
Unless you specifically want date vectors, you are probably better off working entirely with datetimes. Since date vectors store...

10년 초과 전 | 1

답변 있음
Datevec to Datetime conversion results in 1 millisecond error?
Screen shots are probably not the most convenient way for others to diagnose this problem. You haven't lost a millisecond, yo...

10년 초과 전 | 1

| 수락됨

답변 있음
How to work with several groups of data?
One possibility would be to store the tables (or matrices) as fields of a scalar struct, with field names like 10Flap. Actually,...

10년 초과 전 | 0

답변 있음
(How) Can I access multiple columns of a table using colon between their (string) lables (variable names)?
Arman, there may be a more compact way to write it using ismember, but that is more or less the right way to do what you want.

10년 초과 전 | 0

답변 있음
Assigning row names using "RowNames" property assignment does not work for me
OK, I read your question and code in a hurry, and read "variable names" when you actually said "row names". Sorry about that. He...

10년 초과 전 | 1

답변 있음
How to count data based on the categories
Another possibility, using rowfun and a table. This code: Master = ... [1 100680 1 2 1 1 36731 1 1 9 ...

10년 초과 전 | 0

답변 있음
Assigning row names using "RowNames" property assignment does not work for me
Stephen, you're going to need to explain what goes wrong, because that code should work, and seems to work for me.

10년 초과 전 | 0

답변 있음
Importing date and time from an excel file to matlab
If you have R2014b or later, see my response to <http://www.mathworks.com/matlabcentral/answers/249462-how-to-import-date-and-ti...

10년 초과 전 | 0

답변 있음
How to import Date and time in two different cells?
Using readtable in R2015a, the dates come in as strings, the times as numbers: >> t = readtable('test.xlsx'); >> t(1:5,:...

10년 초과 전 | 1

답변 있음
finding the value in a table
You said "table". Your screenshot looks a whole lot like a spreadsheet. It would help to be more clear. Assuming you mean tha...

10년 초과 전 | 1

| 수락됨

답변 있음
How to make a 2-layer Subtotal from a table
Edson, I think this does the trick: >> question = readtable('question.xlsx') question = First Second A...

10년 초과 전 | 0

| 수락됨

답변 있음
How to calculate monthly average for 1st, 2nd. ... 24th hour of the day?
In R2014b or later, assuming you have this in a CSV text file: Date,Temp 01/01/2011 01:03:00,6.925 01/01/2011 01:04:0...

10년 초과 전 | 0

답변 있음
Problem with function "datenum"
What version/platform of MATLAB is this? This sounds like a <http://www.mathworks.com/support/bugreports/622845?s_tid=srchtitle ...

10년 초과 전 | 0