Answered
plotting a column of a timetable
Matthias, it seems like you've solved your immediate issue. But still, you really ought to figure out how those numeric data bec...

7 years ago | 0

Answered
How to get average/max/min table of many tables
Most likely, the simplest solution is to vertcat all of your tables, adding an ID variable (a "grouping variable") to indicate w...

7 years ago | 0

Answered
Is it possible to split a table into multiple tables based in ID (a number code) in colum A?
Kristian, as Walter demonstrates, it is easy to do. But you may find that splitting it up is less convenient than keeping it tog...

7 years ago | 2

Answered
Replace values in table from a second table
This sounds like in general you'd want a join operation. Hard to say without details. >> t1 = table([1;2;3;4],["a"; "b"; "c"; "...

7 years ago | 0

Answered
I want to call the fifth column from a table
Same way you'd do it with a struct: "dynamic field indexing", or "dynamic variable indexing" in this case. response = inputTabl...

7 years ago | 0

Answered
converting cell to categorical in table
It sounds like what you have is a cell array like {1 'two' 3 'four'}. It would help to see a short example to confirm that. You...

7 years ago | 0

Answered
How to replace space with zero in a table?
Sia, you may find that using the datetime datatype for Date, and the duration data type for Time, makes your life easier. Storin...

7 years ago | 1

Answered
Make a table from a structure
Milton, I think you are looking for struct2table.

7 years ago | 1

Answered
how to merge interpolated data into an existing timetable?
Really this is best done with fillmissing. It's just two lines: >> X = [1;2;-3;-4;5;6]; >> tt = timetable(X,'RowTimes',datetim...

7 years ago | 1

| accepted

Answered
How to convert text to time and merge two seperate date and time columns in readtable
Steph, in R2018b, you can read the file: >> type tmp1.csv 2014-12-14,"17:00:00",1,2 2014-12-14,"17:05:00",3,4 2014-12-14,"17...

7 years ago | 0

Answered
Combine 2 different columns with year and quarter in numeric to a single date column for time - series purpose
Jenny, unless you are using a pretty old version of MATLAB, or have a specific reason, you don't want to use datenums. As Akira ...

7 years ago | 0

Answered
Summarizing timetable data when categorical variables are present
Cameron, the answer is not really. retime is all about time. I thik what you want is something like varfun using time and some ...

7 years ago | 0

Answered
How to access a string array and use the contents as titles within array2table
It's not really clear what you are doing and what went wrong. If your matrix of data has 6 columns, then array2table will accept...

7 years ago | 0

Answered
How to parse date/time text using different locale?
Does the suggestion in the error message not solve this problem? It appears that you are trying to read timestamps with english ...

7 years ago | 1

Answered
Fill holes in time series with the correct time
If you can put your data into a timetable, retime makes this a one-liner. Something like tt = retime(tt,'minutely','FillWithCon...

7 years ago | 0

Answered
How to remove table data based on comparison between different columns in another table in MATLAB?
From your description it sounds like you want to remove rows from A whose timestamp falls in any of the time intervals defined b...

7 years ago | 0

Answered
Average data in an array based on corresponding time values
Star Strider's solution is old school. Nothing wrong with that, it gets the job done, but many people find accumarray hard to fa...

7 years ago | 1

Answered
How to convert from matlab time to reall time and date
Rebecca, your description is not clear enough to understand what you are trying to do, but unless you are using a fairly old ver...

7 years ago | 0

Answered
How to combine table vertically
Wendy, I'm not sure you are getting the correct advice. You have said you want to vertically concatenate. outerjoin does not do ...

7 years ago | 2

Answered
How to best extract figures from a table to pass to other functions?
Dave, it's not clear to me what you are asking, but here are a few observations: 1) Many of those square brackets can go away. ...

7 years ago | 0

Answered
Is there a function that can make new categorical array by sorting numeric data from a table?
I guess your x coordinate is just numeric values. It seems like putting your raw data into a timetable would be the way to go. T...

7 years ago | 1

| accepted

Answered
How to compare two table?
See the documentation for ismember. You want 'rows'.

7 years ago | 1

Answered
Compare information from table to string
You are correct that == doesn't work the way you have written it. You have to keep in mind that a table is a container, and so r...

7 years ago | 0

| accepted

Answered
Plot specific values from two different tables
One good way to do this would be to create two timewtables, and then synchronize them. Depending on what you want your plot to l...

7 years ago | 0

| accepted

Answered
Find previous time conditions were met, save it as new marix
Joel, it's hard to tell, but it seems very likely that you'd benefit from putting your data in a timetable. "30 per year" sounds...

7 years ago | 0

| accepted

Answered
How can I convert a character vector that includes date time and random text to datetime format?
None of this will work unles the format is stable, and if it is, a simpler version would be >> t = '2018-05-19_07.11.16_test6.c...

7 years ago | 0

Answered
I have a 29*3 table. Column 1 is for height (cm), Column 2 is for mass (kg), Column 3 is for body fat (kg). How can I divide body fat by mass to find out bf as a % of total body mass?
With respect, I have to sort of say Yike! to those two suggestions. One of the benefits of tables is to have meaningful names fo...

7 years ago | 1

Answered
i'm getting the following error when trying to create a table with multiple variables from if statements, any thoughts?
Orthogonal to the advice that others have given: If the table you are creating will eventually have more than one row (I assume...

7 years ago | 0

Answered
How do I select a y value by a certain x datetime
This is the kind of thing you can do with a timetaqble, but without more information, it's hard to say for sure. timetables do s...

7 years ago | 0

Answered
Combining multiple tables with same variable
If there's really only 5, just rename the variables and horzcat, and I guess also leave out the date var from all but one. I gue...

7 years ago | 0

Load more