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

mehr als 10 Jahre vor | 0

| akzeptiert

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

mehr als 10 Jahre vor | 1

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

mehr als 10 Jahre vor | 4

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

mehr als 10 Jahre vor | 0

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

mehr als 10 Jahre vor | 2

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

mehr als 10 Jahre vor | 1

| akzeptiert

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

mehr als 10 Jahre vor | 0

| akzeptiert

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

mehr als 10 Jahre vor | 0

| akzeptiert

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

mehr als 10 Jahre vor | 1

| akzeptiert

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

mehr als 10 Jahre vor | 1

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

mehr als 10 Jahre vor | 0

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

mehr als 10 Jahre vor | 0

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

mehr als 10 Jahre vor | 0

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

mehr als 10 Jahre vor | 0

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

mehr als 10 Jahre vor | 0

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

mehr als 10 Jahre vor | 1

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

fast 11 Jahre vor | 0

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

fast 11 Jahre vor | 1

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

fast 11 Jahre vor | 1

| akzeptiert

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

fast 11 Jahre vor | 0

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

fast 11 Jahre vor | 0

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

fast 11 Jahre vor | 1

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

fast 11 Jahre vor | 0

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

fast 11 Jahre vor | 0

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

fast 11 Jahre vor | 0

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

fast 11 Jahre vor | 1

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

fast 11 Jahre vor | 1

| akzeptiert

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

fast 11 Jahre vor | 0

| akzeptiert

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

fast 11 Jahre vor | 0

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

fast 11 Jahre vor | 0