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

mehr als 9 Jahre vor | 1

| akzeptiert

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

mehr als 9 Jahre vor | 0

| akzeptiert

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

| akzeptiert

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

| akzeptiert

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

mehr als 9 Jahre vor | 1

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 1

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 1

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

mehr als 9 Jahre vor | 9

| akzeptiert

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 0

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

mehr als 9 Jahre vor | 1

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

mehr als 9 Jahre vor | 0

| akzeptiert

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

mehr als 9 Jahre vor | 4

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

mehr als 9 Jahre vor | 0

| akzeptiert

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

mehr als 9 Jahre vor | 2

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

mehr als 9 Jahre vor | 2

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

mehr als 9 Jahre vor | 0

| akzeptiert