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

más de 10 años hace | 0

| aceptada

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

más de 10 años hace | 1

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

más de 10 años hace | 4

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

más de 10 años hace | 0

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

más de 10 años hace | 2

Respondida
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,...

más de 10 años hace | 1

| aceptada

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

más de 10 años hace | 0

| aceptada

Respondida
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 = ...

más de 10 años hace | 0

| aceptada

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

más de 10 años hace | 1

| aceptada

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

más de 10 años hace | 1

Respondida
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 '...

más de 10 años hace | 0

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

más de 10 años hace | 0

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

más de 10 años hace | 0

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

más de 10 años hace | 0

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

más de 10 años hace | 0

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

más de 10 años hace | 1

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

más de 10 años hace | 0

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

más de 10 años hace | 1

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

más de 10 años hace | 1

| aceptada

Respondida
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,...

más de 10 años hace | 0

Respondida
(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.

más de 10 años hace | 0

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

más de 10 años hace | 1

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

más de 10 años hace | 0

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

más de 10 años hace | 0

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

más de 10 años hace | 0

Respondida
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,:...

más de 10 años hace | 1

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

casi 11 años hace | 1

| aceptada

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

casi 11 años hace | 0

| aceptada

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

casi 11 años hace | 0

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

casi 11 años hace | 0