Answered
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 years ago | 0

| accepted

Answered
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 years ago | 1

Answered
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 years ago | 4

Answered
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 years ago | 0

Answered
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 years ago | 2

Answered
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 years ago | 1

| accepted

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 1

| accepted

Answered
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 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

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

10 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 1

Answered
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 years ago | 1

| accepted

Answered
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 years ago | 0

Answered
(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 years ago | 0

Answered
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 years ago | 1

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 0

Answered
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 years ago | 1

Answered
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 years ago | 1

| accepted

Answered
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 years ago | 0

| accepted

Answered
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 years ago | 0

Answered
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 years ago | 0