답변 있음
How to delete rows that contain NaN in a table
If you have access to R2016b, you can use <https://www.mathworks.com/help/matlab/ref/rmmissing.html rmmissing> .

대략 9년 전 | 4

답변 있음
How to append different tables of different class types (a table of class type datetime and a table of classs type double)
I think you mean that B is 5x5, not 5x1. You probably want to be careful using the word "table", since table is a data type i...

대략 9년 전 | 0

답변 있음
i want save the table in file on my computer , i wrote the following but display error ? what should i do ?
Also, if you mean "table" as in the data type whose class is table, don't use xlswrite, use writetable.

대략 9년 전 | 0

답변 있음
Lilliefors test critical values
As the documentation says, "The Lilliefors test cannot be used when the null hypothesis is not a location-scale family of distri...

대략 9년 전 | 0

| 수락됨

답변 있음
Why are strings stored in an extra cell within a table
As the other replies have sort of hinted at but not said explicitly, this actually has little to do with tables, although using ...

대략 9년 전 | 1

답변 있음
how to circular shift table columns
For what you're doing, I recommend that you take advantage of a table's row names. It makes growing the rows happen automaticall...

대략 9년 전 | 1

답변 있음
how to fill a time series from burst sampled data?
Dom, since it appears you have R2016b, here's what I came up with using a timetable: >> % t0 = datetime(2016,9,11,8,29,11,'...

대략 9년 전 | 1

| 수락됨

답변 있음
Can I get a datetime output in a different Time Zone from the input Time Zone in one function call?
I think this also does what you want: >> d = datetime('2016-Jan-20 12:00:00 UTC','InputFormat','yyyy-MMM-dd HH:mm:ss z','Ti...

대략 9년 전 | 1

답변 있음
How to create “Date” containers in Matlab, ignoring months and years?
In addition to Guillaume's answer, there's also this: >> d = datetime('now') d = datetime 23-Jan-2017 14:09:...

대략 9년 전 | 0

답변 있음
read only time from date
If you're using MATLAB R2014b or later, use datetime and timeofday: >> t = datetime({'2017-01-19 11-35-12.34' '2017-01-19 1...

대략 9년 전 | 0

답변 있음
Combine date vector into single column
Unless you're using a version of MATLAB older than R2014b, you should be using datetimes: >> datetime(4.264400001156250e+04...

대략 9년 전 | 0

답변 있음
I have an excel file ... which consists of 1st column is dates and time and other n rows and n columns data.... in this file, I have daily 1-hour data, I want day night data separate for the reference I have attached output file. Please find input an
I recommend using readtable, using the %D format to create datetimes. Then it's easy to select rows of the table by day and nigh...

대략 9년 전 | 0

| 수락됨

답변 있음
How can I remove the date of a datetime matrix ?
It seems like the answer to this question is, "don't plot with datenums." Since R2014a, plotting with datetimes will already lea...

대략 9년 전 | 0

답변 있음
how to calculate average, mean and last price of date strings
I'm gonna assume that the thing displayed in the original post is _not_ what you're starting with, that in fact you have somethi...

대략 9년 전 | 0

답변 있음
How to omit repeated X values in a table and assign a new computed Y value?
Or use a table and a grouped varfun: >> x = [1,1; 1,5; 1,3; 1,4; 2,100; 2,109; 2,105; 3,51; 4,23; 5,213; 5,215; 5, 210; 5,2...

대략 9년 전 | 0

답변 있음
replacing NaN with dot in a table
As Guillaume already said, this is almost certainly a bad idea, and you should really ask yourself why you want to do it. You ca...

대략 9년 전 | 1

답변 있음
How do we eliminated (empty or zeros) Columns or Rows from tables in Matlab
Also beginning in R2016b, use rmmissing: >> t = array2table(randn(5)); >> t{3,:} = NaN; >> t.Var3(:) = NaN t = ...

대략 9년 전 | 2

답변 있음
Reading CSV file with time stamped data and Plotting data with Time in the X-axis
I'm not familiar with PLC files, but in anything like a recent MATLAB, you should be able to use readtable and datetime. Somethi...

대략 9년 전 | 0

답변 있음
Plotting monthly precipitation and time
In R2014b or later, use datetimes, not datenums: >> x = {'7/15/05' '8/9/05' '9/15/05' '10/16/05' '11/17/05' '12/28/05' '3/8...

대략 9년 전 | 0

| 수락됨

답변 있음
Plotting a graph of a date !!
In recent versions of MATLAB (since R2014b), do this: >> t = datetime(1991,10,1) + calmonths(0:11) t = 1×12 dateti...

대략 9년 전 | 1

답변 있음
setting up Dates on x-axis
It's hard to tell what you are doing, but it looks like you're trying to make a tick mark for every value. That seems like a bad...

대략 9년 전 | 0

답변 있음
How can one perform a function on a particular section of a table? And again a further section inside that section.
It sounds like maybe you want to use varfun with one or more grouping variables, but I can't tell for sure.

대략 9년 전 | 0

답변 있음
How to overwrite 'NaN' strings in a table using the for-loop
You almost certainly _don't_ want to the specific thing you've stated, i.e. "replace the strings 'NaN' with NaN". You'd end up s...

대략 9년 전 | 1

답변 있음
Datetime bug in R2016b when saving figure that has a legend
This seems to be a sporadic issue, and I've made a note to have it looked into. You should see a bug report posted sometime soon...

대략 9년 전 | 3

답변 있음
How to group Time based on hours and assign Time groups to their Dates ?
Not sure exactly what you are asking for, because you don't say what's in your table, and readtable's behavior for a spreadsheet...

대략 9년 전 | 0

답변 있음
How can I determine where there are date gaps in an array of date strings? And fill in the gaps...
One solution to this question, as I understand it, would be to make the plot using dates, not indices. Using datetime, a very si...

대략 9년 전 | 0

답변 있음
How do I reshape 3 vectors (date, depth, and variables) into a matrix separated by day?
I'm not sure I've understood exactly what you need to do, but this seems related: Create a table containing data like yours: ...

대략 9년 전 | 0

답변 있음
What is good way to import and scrub several Change of Variable (Mismatched Time-series) data sets, so they can be compared.
Corbyn, if you have access to the latest release, R2016b, you can use timetables: >> t1 = table2timetable(readtable('Datase...

대략 9년 전 | 1

| 수락됨

답변 있음
Tables with Datetime and Groups: Find most recent datetime within each group and write in new column for each row of each group
If you're using varfun to create a table, your function is allowed to return multiple rows. So just repmat the max time within e...

대략 9년 전 | 2

답변 있음
Working with time-series data in climate analysis
If you have access to R2016b, this is easy with a timetable: >> tt = timetable(datetime(2016,12,19,12,[1;3;5],0),[10;20;25]...

9년 초과 전 | 0

| 수락됨