Answered
How can I use the excel import functionality in Matlab to import a table but to have the individual pices of data in the table rows to not be imported as 1x1 tables as well?
I imagine what's happening is this: you are importing a spreadsheet using readtable, and you get a table. >> t = readtable('myf...

8 years ago | 0

| accepted

Answered
How can I create a table with no specific number of rows and input various data types row by row?
I'm only guessing at what you mean by "no specific number of rows". "objresult.CountRows" looks like it know how many there are,...

8 years ago | 0

| accepted

Answered
How do I take the power of elements in a table?
Based on the error you cite, it seems that one or more of those variables are themselves tables. Nothing wrong with that, you'll...

8 years ago | 0

| accepted

Answered
Time between two dates
>> d = datetime(2018,3,14,16,[30 40],54) d = 1×2 datetime array 14-Mar-2018 16:30:54 14-Mar-2018 16:40:54 ...

8 years ago | 1

Answered
How to replace values in one table with those of another table (different size) under multiple conditions?
I'm not 100% sure what result you want, but it seems that you will want to # find the rows in table1 with missing values. thi...

8 years ago | 0

Answered
How to use retime with duration in timetable?
I am not sure what question you are asking. I think that you have a timetable whose row times are datetimes, i.e. absolute times...

8 years ago | 0

Answered
Apply function (str2double) to each element in a timetable
varfun does this with no problem: >> t = table(["123";"456"],{'789'; '012'},[345;678]) t = 2×3 table Var1 ...

8 years ago | 0

Answered
Plotting Box Representation of Different Group of Categorical Data
If you have access to the Statistics & Machine Learning Toolbox, the box plot function does that and more.

8 years ago | 0

Answered
How to convert from categorical to double ?
Presumably when you created your categorical arrays, you used the vector [0.5 0.75 1 1.25 1.5] to define the unique raw values. ...

8 years ago | 1

| accepted

Answered
Plot two categorical columns from a table
The question you are asking seems like you need to think in terms of contingency tables. The Statistics Toolbox has some tools t...

8 years ago | 0

Answered
how to plot datetime against number
rohail, you don't need to convert anything if your data are already datetimes, which seems to be what you are indicating. Ideall...

8 years ago | 0

Answered
separate date and time from a .txt file with no spaces
datetime actually is fleximble enough to read those timestamps: >> datetime('201812312341CMTI2','InputFormat','uuuuDDDHHmm'...

8 years ago | 0

Answered
Problem with table, error 'Unrecognized row name '...' '
There's something you're not telling us (probably what Walter suggests): >> Fluidi={'Dowcal 20';'Dowtherm Q';'Therminol XP'...

8 years ago | 1

Answered
Converting a timetable to a matrix
AA, I guess Walter has answered your question, but I can't think of a reason why you would want to convert your table containing...

8 years ago | 0

Answered
Table with date and x need to plot graph
In R2016b or later, timetables make the "compute daily sum" step super easy: tt2 = retime(tt,'daily','sum')

8 years ago | 0

Answered
How can i create a descriptive statistics table for columns
Another possibility: >> t = array2table(rand(10,5)) t = 10×5 table Var1 Var2 Var3 Var4...

8 years ago | 0

Answered
Replacing values in a table
Are these actual integer types, and not just doubles with integer values in them? Because you can't put NaNs into int16 and int3...

8 years ago | 2

| accepted

Answered
Converting time to usable format
Is this what you are looking for? >> datetime('319:17:19:21.28','InputFormat','DDD:HH:mm:ss.SS','Format','dd-MMM-yyyy HH:mm...

8 years ago | 0

Answered
How can I turn a date in the format: '2018-03-25T05:15:00.000Z' in a datetime vector?
The short answer is >> datetime('2018-03-25T05:15:00.000Z','InputFormat','uuuu-MM-dd''T''HH:mm:ss.SSS''Z''') ans = ...

8 years ago | 2

| accepted

Answered
I have a text file contain the date and time like this 20180405125901 (2018-April-05 12:59:01), can matlab load the file and convert it to datetime like this 05-Apr-2018 12:59:01
If this is a CSV or similar, it's also possible to use readtable and read them in directly as datetimes. Specify the datetime fo...

8 years ago | 0

Answered
Best way to lookup values in table...
You don't need a loop to do this. Try this: HourlyProfile.Data = t{HourlyProfile.Hr+1, HourlyProfile.Mo} or even Ho...

8 years ago | 1

Answered
Create a table with timedate and values
It's pretty much impossible to say for sure what you're doing wrong without knowing what's _in_ those mat files, but based on th...

8 years ago | 0

| accepted

Answered
Creating a table with missing endpoints
Those look suspiciously like datenums, circa 2005. I'm gonna take a wild guess that 108 is 01:08. I might be completely wrong. I...

8 years ago | 1

| accepted

Answered
Convert clock time to decimal
It sounds very likely that you have some sort of table in Excel that has columns of numbers and also a column of times. If that ...

8 years ago | 0

Answered
Unable to plot column of data that is not numerical ("Input arguments must be numeric, datetime or duration.")
It looks like that variable is categorical, but has been read in as text. You probably want to convert to a categorical variable...

8 years ago | 1

| accepted

Answered
Pulling columns from a table to create new table
If you want to make a new table, just use subscripting, no reason to use table2array. NumericValueTable(:,[1 2 4 7]) wil...

8 years ago | 1

| accepted

Answered
How can I modify table by horizontal row wise from three different tables?
Your question is not really clear to me, but likely you want some combination of setdiff and join. A simple example would help.

8 years ago | 0

Answered
How do I separate date and time of a raw date?
Don't do _any_ of that. You've read the timestamps in as datetimes. Don't fight that. Assuming you have a table T: T.Sta...

8 years ago | 1

Answered
I am trying to get a value from an excel sheet, when a specific date and time are entered on matlab. The table consists of a date, time and radiation columns. How do i approach this problem,
You are probably better off using readtable to read all three columns in the sheet as a table. As of R2018a, you can read both t...

8 years ago | 0

Answered
How to select cells in a table with values in a given range?
Hard to say what you are really asking, but in MATLAB ... t = readtable(example.xls') t2 = t(ismember(t.condition,1:2:17...

8 years ago | 0

| accepted