Beantwortet
How to convert to datenumber from two cell values
In any case, if you are using a recent Version of MATLAB (R2014b or later), consider moving to datetimes, not datenums: >> ...

mehr als 8 Jahre vor | 0

| akzeptiert

Beantwortet
How to sum a specified portion of a column in a data table?
SS's answer works, but if you are doing this on only ONE variable, this is much simpler: C = sum(B.VarName(31:57); where...

mehr als 8 Jahre vor | 3

Beantwortet
Time Format: import unique format to be able to plot
I'm gonna guess that you've stripped away most of the context in the interests of asking a specific question. Usually that's goo...

mehr als 8 Jahre vor | 1

Beantwortet
import and plot dated time series
As Akira says, use readtable and plot. In recent versions, readtable will create a datetime variable automatically, in earlier v...

mehr als 8 Jahre vor | 1

Beantwortet
what is the best way to plot dates?
It would be good to post data that people can simply cut and paste. You have 11 pairs of repeated dates, and what appears to ...

mehr als 8 Jahre vor | 1

Beantwortet
Analyse table value for calculations
Like Eric, I will observe that your example seems wrong, and it's not at all clear what you are starting with and what you want ...

mehr als 8 Jahre vor | 0

Beantwortet
Logical result false when comparing 2 identical times
The extension of the file you've posted does not match your code. The file you've posted appears to be a .xlsx file. Add :ss....

mehr als 8 Jahre vor | 1

| akzeptiert

Beantwortet
How to Compare datetimes with milisecs?
This has nothing to do with milliseconds, at least not if what you posted is what you are actually doing. I don't know what y...

mehr als 8 Jahre vor | 0

Beantwortet
Logical indexing: Find row in table by text in column
Two other things worth considering: 1) if {'hi', 'bye'; 'don', 'tcry'} are always unique, consider making them row names. The...

mehr als 8 Jahre vor | 0

Beantwortet
How to display the value of an enumeration in a table, as opposed to a 1x1 array of the enumeration class?
Simon, I forget exactly what release (I'm guessing R2016a or b), but sometime after tables were originally released in R2014b, t...

mehr als 8 Jahre vor | 0

Beantwortet
Reading in data and plotting the sunrise/sunset time of different dates against the time.
As Jan points out, the real question here was the plotting. Since this was originally answered six years ago, in versions of MAT...

mehr als 8 Jahre vor | 0

Beantwortet
Merge a timedate table with a normal table
You are trying to concatenate a 5x2 datetime array with a 5x2 table. You do not have a timetable and a table. As dpb says, I ima...

mehr als 8 Jahre vor | 0

Beantwortet
Compare two tables with two column combinations
tables have all the same "set membership" functions as numeric arrays: >> t1 = table({'a';'b';'c';'c';'a';'b'},{'d';'e';'d'...

mehr als 8 Jahre vor | 1

| akzeptiert

Beantwortet
Changing class of the variables in the table - I can't get it to work without a loop
Pawel, the only way to change the type of a variable in a table is to overwrite it. Assigning with t(:,vars) = ... or t{:,vars} ...

mehr als 8 Jahre vor | 1

| akzeptiert

Beantwortet
Date format changes at midnight
In recent versions of MATLAB, don't use xlsread or datenum. Use readtable, which will create a datetime in the table, without th...

mehr als 8 Jahre vor | 2

| akzeptiert

Beantwortet
How to extract row intervals from a table to create a new one.
Walter interpreted "all the columns from b and d rows" as "FROM b TO d". I'm going to interpret it as "b AND d". If the first...

mehr als 8 Jahre vor | 0

Beantwortet
Extract a range of data acording to the date range from a table
There's only four seasons, best to not overthink this. spring = t(ismember(month(t.Time),1:3),:); etc. But Guillaume's a...

mehr als 8 Jahre vor | 0

| akzeptiert

Beantwortet
How to call/create column variables from changeable table?
I think what you are looking for is either data1 = data(:,{'S' 'Al' 'Si' 'Ca' 'Fe'}) or data1 = data{:,{'S' 'Al' 'S...

mehr als 8 Jahre vor | 1

| akzeptiert

Beantwortet
Insert of discontinuous dates/time (yyyymmddhhmm) to the first column and filling of NAN to the second column which missing unknown field
In recent versions of MATLAB: >> t = readtable('Tide.txt','ReadVariableNames',false); >> t.Properties.VariableNames = {'...

mehr als 8 Jahre vor | 0

| akzeptiert

Beantwortet
Extract data from table starting at a certain position
It sounds like maybe you have a table (the MATLAB data type) with multiple rows for each patient, and you want to split the data...

mehr als 8 Jahre vor | 0

Beantwortet
converting num to date on the xaxis in Matlab R2016a
I think the problekm here is that plot typically puts ticks to show "nice" values in the range of your data, while you are looki...

mehr als 8 Jahre vor | 0

Beantwortet
Aggregate time table for working hours
Behi, your code is telling retime to create all those rows. I think you have three options: # Just delete the rows of SyncedD...

mehr als 8 Jahre vor | 1

Beantwortet
Excel dates into separate variables
Unless you're using a fairly old version of MATLAB, I recommend using readtable and datetimes. It might go something like this: ...

mehr als 8 Jahre vor | 0

| akzeptiert

Beantwortet
How do I parse and erase from a string while importing CSV with tableread?
Fixing the names in the importOptions setting is one choice, but an alternative might have been to patch up the names after read...

mehr als 8 Jahre vor | 0

Beantwortet
Import date data from excel
Unless you are using an older version of MATLAB, you are likely much better of using readtable to read your data into a table, c...

mehr als 8 Jahre vor | 0

| akzeptiert

Beantwortet
Hi all, I want to write a code that assign new column to the table. For example, I have a column like:
Part of this question has nothing to do with tables, the other part does: 1) Not sure how 50 comes from Forest,B, but let's a...

mehr als 8 Jahre vor | 0

Beantwortet
How do I convert a cell array of character strings into datetime array efficiently?
There is a more elegant way, and stop calling me Shirley. The thing you're passing into datenum, c{6:end,1}, is a list of val...

mehr als 8 Jahre vor | 0

| akzeptiert

Beantwortet
How can I create a single header for two columns for a table?
One possibility is ConfidenceInterval = [LowerBound,UpperBound]; T = table(AlpaParameter,ConfidenceInterval,'RowNames',I...

mehr als 8 Jahre vor | 0

Beantwortet
Convert timetable with some mixed text representing numbers to all numeric for retime function
Matt, you have not said where that timetable came from. I think you want to fix this at the cause. Typically, you'll get text wh...

mehr als 8 Jahre vor | 0

Beantwortet
How do I reformat a mixed format data file to work with readtable()?
In recent versions of MATLAB, you can use detectimportoptions to get more control over what gets read from where. But you may en...

mehr als 8 Jahre vor | 0

| akzeptiert