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

oltre 8 anni fa | 0

| accettato

Risposto
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,...

oltre 8 anni fa | 0

| accettato

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

oltre 8 anni fa | 0

| accettato

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

oltre 8 anni fa | 1

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 1

| accettato

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 1

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

oltre 8 anni fa | 0

Risposto
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')

oltre 8 anni fa | 0

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 2

| accettato

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 2

| accettato

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 1

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

oltre 8 anni fa | 0

| accettato

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

oltre 8 anni fa | 1

| accettato

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 1

| accettato

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

oltre 8 anni fa | 1

| accettato

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 1

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

oltre 8 anni fa | 0

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

oltre 8 anni fa | 0

| accettato

Carica altro