답변 있음
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년 초과 전 | 1

| 수락됨

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

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

9년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 9

| 수락됨

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 0

답변 있음
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년 초과 전 | 1

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 4

답변 있음
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년 초과 전 | 0

| 수락됨

답변 있음
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년 초과 전 | 2

답변 있음
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년 초과 전 | 2

답변 있음
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년 초과 전 | 0

| 수락됨

더 보기