Answered
Time series data with missing dates to remap to calendar days vector?
If you have R2014b or later, use tables and datetimes. For the specific question you've asked, simplest to use ismember and inde...

9 years ago | 1

| accepted

Answered
error using textscan to read a csv file with number and text and date in one file
Fan, leave the commas out fo the format and use readtable: >> t = readtable('test1_V6.csv','Format','%{HH:mm:ss}D%f%C%f%f%f...

9 years ago | 0

| accepted

Answered
Can I merge two matrices of different length with respect to a date column contained in both?
Benedict, you might find that using tables and their various join methods makes what you're doing very straight-forward. The fol...

9 years ago | 0

Answered
comparing if specific date and time reside in other two cell arrays
siki, I think you want to look into using a table, and the various join functions that tables provide. In R2016b, you might even...

9 years ago | 0

Answered
Error using Matlab table command
It looks like you're running R2016b. It also looks like you have something wrong with your installation, or something on your pa...

9 years ago | 0

Answered
How to convert cell to double for creating variables from table?
Steve, the root cause of your problem is that second line in the file: readtable is seeing text in the first line of data, and c...

9 years ago | 0

Answered
How to choose some rows of a table by order?
It sounds like a grouped varfun is what you're looking for: >> item = randi([1 3],10,1); >> date = datetime(2016,12,rand...

9 years ago | 0

| accepted

Answered
How can I parse a timestamp in the format yyyy/doy/hh/mm/ss
You have R2014b, use datetime: >> str = '2016/183/13/20/15'; >> d = datetime(str,'InputFormat','yyyy/DDD/HH/mm/ss') d...

9 years ago | 0

Answered
Time series data formatting issues
Clay, the simplest thing to do is just fill in the NaTs after the fact: >> c c = '12/01/2016 10:00:00 PM' ...

9 years ago | 0

Answered
Datetime bug in R2016b when saving figure that has a legend
Kristin, I can't reproduce this in R2016b on either windows or mac. Is it possible you're using a pre-release version of R2016b?...

9 years ago | 0

Answered
How to import date time format from excel
Or with durations and a table: >> M = [0.198981481481482 1.257375 0.219814814814815 1.286917 ...

9 years ago | 0

Answered
Performance of table data type
As posts on this thread have indicated, while tables are often the right data structure for the job, their performance in scalar...

9 years ago | 0

Answered
I want to get the value of a variable from a table
Phillipp, I'm not exactly sure what you're aksing to do, but in general if you have a table named diagramoptions containing a va...

9 years ago | 0

| accepted

Answered
write table without nans to txt and csv
Danielle, if you can write to a spreadsheet, and then save the spreadsheet as csv, you'll get what you're looking for. Whether o...

9 years ago | 1

Answered
convert datestring to datenum problem.
In R2014b or later, you should consider using datetimes, not datenums: >> s = '2016-11-22T13:12:47.320Z' s = '201...

9 years ago | 0

Answered
Indexing rows from table that contain specific proportions of values across 2 variables
This isn't really a question about tables, it's a question about data sampling. It surely will not be possible in general, and i...

9 years ago | 0

Answered
how to find number of days in a month in a repeated dates vector ? all tips are helpful
If the question is, "how much data do I have in each month?". If you have access to R2016b, you could use a timetable and the sy...

9 years ago | 1

Answered
Is there an Alternative to timetable
Karoline, you could create a table that contains a variable that's either a datetime or a duration, and apply interp1 to the var...

9 years ago | 0

Answered
Convert time dates to seconds
You might find this easy to do using a table and datetimes/durations. Given a csv file that look like your example, >> t = ...

9 years ago | 1

Answered
How concatenate two tables in MATLAB?
Adriano, to horizontally concatenate anything in MATLAB, you would probably just use square brackets, right? Such as AB = [A B]....

9 years ago | 9

| accepted

Answered
How do I align date formats
Using datetimes, Walter's suggestion would look like >> dates = {'01/01/2016'; '1/01/2016'; '01/1/2016'; '1/1/2016'}; >>...

9 years ago | 0

Answered
How can I convert a datetime vector to cell??
Adriano, row names are really convenient when you want to use them for subscripting. But in this case, you need to consider that...

9 years ago | 0

Answered
How can I extract multiple rows from a text file or table that meet a certain condition to then be saved as a txt or an excel file.
Alejandro, it's not clear to me how you have imported those data or what you imported them into. In general, I think the only he...

9 years ago | 0

Answered
How can I assign a variable name to each column of a table composed by only one matrix?
Presumably you've discovered that array2table already does that... >> A = [1 2 3; 4 5 6] A = 1 2 3 ...

9 years ago | 1

Answered
How to set the number of x-axis ticks on a datetime plot?
Plotting with datetime automatically chooses what it thinks is an appropriate tick label format, based on the time span of the a...

9 years ago | 0

| accepted

Answered
Calculate the number of days between two datetimes?
between already calculated the difference between those two dates in days: >> d1 = datetime('yesterday'); d2 = datetime('to...

9 years ago | 4

Answered
Using panel data, how can I create a new table with weekly price data based on a table with daily price data, for every stock?
John, I'll assume you have the Financial Toolbox. I think what you're looking to do is to calculate mean price, by ticker and we...

9 years ago | 0

| accepted

Answered
Add table variable and assign constant string
This slight change to the original code also works: >> T.newVar(:,1) = newString % note the ",1" T = Section D...

9 years ago | 2

Answered
Averaging timeseries with different number of data points in each time interval
If you happen to have access to R2016b (the latest MATLAB release), you could try using timetables. Assuming you start with a fi...

9 years ago | 2

Answered
How to Merge 500 tables with occsaional different dates in their date column
Is outerjoin what you are looking for? >> t1 = table(datetime(2016,1,[1;2;3;5]),[1;2;3;4],[5;6;7;8]); >> t2 = table(date...

9 years ago | 0

| accepted