답변 있음
How to Sort following table data in excel containing multiple column ?
This sounds like a join, but for some reason you have everything in one table. I'm guessing you can use ismember on the two lea...

7년 초과 전 | 0

답변 있음
How can I remove entire rows from a table based on NaN values in a specific column (cell data type) in a table?
rmmissing. It's a one-liner.

7년 초과 전 | 1

답변 있음
What does Undefined operator '*' for input arguments of type 'table' mean
Tables are containers. Even if you have all numbers in a table, it's still a container around the numbers. The reason is that ta...

7년 초과 전 | 0

답변 있음
how to lag timetable to the nearest day
"Lag" means different things to different people. You might mean, "round the row times to the nearest whole day." Just apply ...

7년 초과 전 | 0

답변 있음
Performance comparison among Struct Array, Cell Array and Table
Kat, there's no way you are gonna get a useful answer without providing more information. The best representation of your data i...

7년 초과 전 | 0

답변 있음
Merge table with different rows
"Merge" is kind of vague. It may be that you just need to add a semicolon to vertically concatenate: Com = [file1; file2]

7년 초과 전 | 0

답변 있음
Dummy Variable ased on categorical vars in table
Don't use a loop. It's completely unnecessary. And make BS and Bank categorical variables. Then all you need is Data.DV = (...

7년 초과 전 | 0

답변 있음
How to use textscan to import time value (hh:mm:ss)
This is a row-oriented file, I'll let you figure out how to best get that into MATLAB. But if the question is how to turn those ...

7년 초과 전 | 1

답변 있음
How to convert a string data time to a number
Don't use datenums. Convert your text to datetime: >> datetime('10/08/2018 6:30:32 PM','InputFormat','MM/dd/yyyy hh:mm:ss a...

7년 초과 전 | 0

답변 있음
How do I import a dataset that uses date, time of day, and event duration separately? How do I specify InputFormat to account for the separate contexts? Why isn't my logical data importing correctly?
When I read this in a recent version of MATLAB with no import options, I get day as a datetime, time as text, and duration as nu...

7년 초과 전 | 0

| 수락됨

답변 있음
How to convert date/time from excel in 2 separate columns to a single date/time variable in matlab
The right answer depends on how they are stored in the spreadsheet and what version of MATLAB you are using. In recent versio...

7년 초과 전 | 1

답변 있음
Create a Table of Data
I'm guessing you want to create a table with three variables named wet_something, wet_somethingelse, ..., each of which is itsel...

7년 초과 전 | 0

답변 있음
Aggregation on Matlab Table
I doubt that what you showed is actually what you want. I imagine what you want is a table (the datatype) with a categorical ...

7년 초과 전 | 0

답변 있음
Processing array where the elements are sometimes min/sec and sometimes hour/min/sec
cyclist, if you know that the text is a mixture of those two formats, can't you convert using one format, and then go back and c...

7년 초과 전 | 1

답변 있음
I'm trying to organize data so it can easily be averaged by date
"return all the data from the second day of January" Imagine having this timetable: >> tt = array2timetable(rand(100,2),...

7년 초과 전 | 0

답변 있음
Using user defined Function with a Table of variables , through a For Loop
If "table" means the table data type, then rowfun is designed for exactly this. Of course, it doesn't really stay within the lin...

7년 초과 전 | 0

답변 있음
Assigning time series in a structure
Temirlan, I would think you'd want to read the spreadsheet using readtable, then convert that table to a timetable with one vari...

7년 초과 전 | 0

답변 있음
Hello! i have been given a task to find monthly log return time series and then aggregate each to an annual log return series. but every code i use, follows with an error. how do i convert the data to annual the easiest possible way?
If the question is, "how do i convert the data to annual the easiest possible way?", the answer is to import using readtable (Ch...

7년 초과 전 | 0

답변 있음
access sequence of file with date increment
There are other ways to do this, but here's one straight-forward way: >> dates = [datetime(2011,11,1):caldays(1):datetime(2...

7년 초과 전 | 0

답변 있음
How to use datenum with a date represented as a scaler?
If possible, use datetime rather than datenum/datestr/datevec. As Walter showed, you can convert directly from numeric to dateti...

7년 초과 전 | 0

답변 있음
How to sort rows of a cell array by date/time when the other columns are different data types?
Samantha, this sounds like you could be using a timetable, rather than a cell array. You will likely find things easier to work ...

7년 초과 전 | 1

답변 있음
Array multiplication for large dates set
I'm guessing that by "multiplication", you don't mean numeric multiplication, but rather you mean, "my data are M x N". >> ...

7년 초과 전 | 0

답변 있음
convert excel datetime to time in matlab
If possible, use readtable, not xlsread. It handles many of the vagueries of Excel timestamps, and in recent versionw will autom...

7년 초과 전 | 0

답변 있음
Cell array of dates in string format to date array
Lauren, is there a reason you want to avoid using tables? You really will be much happier using readtable, especially in recent ...

7년 초과 전 | 0

답변 있음
How to convert date and time present in same cell to a matrix having all values in elongated form like Y, M, D, H, Mi, S?
I'm gonna suggest that you likely _don't_ need to do this. Unless you are using a pretty old version of MATLAB, use datetime ins...

7년 초과 전 | 0

답변 있음
Need Help Appending data to a table in every iteration from a for loop .I want to add new data to New_Table every loop but not overwrite the existing data.
I can't follow the original code at all, but in general, it's not a great idea, performance-wise, to groew a table in a loop. Th...

7년 초과 전 | 5

답변 있음
So, I've got a csv file with both text and numbers in the table
readtable is the first thing to try to read a CSV. You have commas as the decimal separator, so you'll need to use detectimporto...

7년 초과 전 | 0

답변 있음
Subtractions between consecutive rows in a table
Deyire, unless you're using a pretty old version of MATLAB, use datetime and duration instead of datestr/datenum/datevec. Also y...

7년 초과 전 | 1

| 수락됨

답변 있음
How to use for loop on group of rows in table?
Stephanie, you may have a reason dfor wanting to split up your data, but it's very often not necessary. It looks like maybe what...

7년 초과 전 | 0

| 수락됨

답변 있음
Preserving dates when importing a XLSX file in matlab.
I would think that in recent versions of MATLAB, all you need to do is add 'HeaderLines',1 to the original readtable call. What'...

7년 초과 전 | 0