Risposto
Cell Array to table
Alberto, you are mixing metaphors. You have a cell array containing values you want to put in a table, and (apparently) a table...

oltre 7 anni fa | 1

| accettato

Risposto
How to delete empty cells in a cell array?
Another alternative, which may not be what you are looking for: >> c = {11 12 13; 21 [] 23; 31 [] []} c = 3×3 cell array ...

oltre 7 anni fa | 0

Risposto
Conversion from unix time string to uint64
I'm gonna run with Jan's guess, which, in the absence of any description, seems plausible: >> datetime(1520944184833390730/1e9,...

oltre 7 anni fa | 1

Risposto
How to filter dataset into specific time range and scan for missing values?
Timetables and retime were born to do this: >> X = [89 2 03 0030 1.6955 5.08; ... 89 2 03 0330 1.8172 4.39; ... ...

oltre 7 anni fa | 2

| accettato

Risposto
How to convert UTC timestamp to unix time in MATLAB with the respect of leap seconds
A couple things, apologies if you already know all this: 1) POSIX time does not have leap seconds. As Jan says, unix systems va...

oltre 7 anni fa | 3

| accettato

Risposto
Join two tables MATLAB
Isn't outerjoin what you are looking for? It will give you one table with rows that match, rows that are only in the left, and r...

oltre 7 anni fa | 0

| accettato

Risposto
can't fill missings on table
Apparently at least one of the table variables that you are applying fillmissing to isn't numeric. You will have to figure out w...

oltre 7 anni fa | 0

| accettato

Risposto
Match cell array of strings to table row names
Another possibility would be to (simple) join T1 to CA1, and then sum Weight.

oltre 7 anni fa | 0

Risposto
How can I group column of data with the same time stamp and get the row mean of each group?
retime on a timetable is the simplest way to compute means per time bin: >> tt = timetable(rand(10,1),'RowTimes',duration((sort...

oltre 7 anni fa | 0

Risposto
How to plot Date time series in MATLAB?
In something as recent as R2018b, stay away from datenum and datetick if possible. (Also, hardly ever does one need table2cell, ...

oltre 7 anni fa | 0

Risposto
Problem when importing a TXT file into MATLAB with "readtable". Text and numbers are between single quotes...
The real problem is that there's something funny in your file that you are not telling us about. Part of it may be using comma a...

oltre 7 anni fa | 0

Risposto
innerjoin two tables based on the first word in the key columns
The literal answer to your question is to create a new key variable pair from the first word of those two variables. Probably y...

oltre 7 anni fa | 0

Risposto
Change table variable dimension
You have created an Kx2 table, one of whose variables is KxMxNxL, the other is KxMxN. I don't know if that's what you intended, ...

oltre 7 anni fa | 0

Risposto
How to find out the average of data gathered from a For Loop for a specific column in a table?
The problem is that you are passing a table into mean. The table is a container, and what you need to do is to pass the variable...

oltre 7 anni fa | 0

| accettato

Risposto
Categories automatically being labelled and sorted into matrix?
It's pretty hard to understand exactly what you are trying to do from the information you have provided. One problem with what y...

oltre 7 anni fa | 0

Risposto
Insert new rows of NaN for missing timestamps in time series.
retime "adjusts" your data to a new set of row times. In general, "adjust" means things like interpolate, or aggregate, or take ...

oltre 7 anni fa | 0

| accettato

Risposto
Convert Unix Time in Date Time Format with Milliseconds
What you have is 1ns ticks since 1970. That's sort of Posix time, but at a different resolution. If that's really what you have,...

oltre 7 anni fa | 12

| accettato

Risposto
Convert Julian Date to Calendar days
Michael, I can't speak for the correctness of that code, but you or that code may be confusing some things. There's the prolept...

oltre 7 anni fa | 3

Risposto
fints toweekly vs timetable retime
retime won't know about holidays, and 'weekly' assumes you mean the start of the week (just as 'monthly' assumes start of month)...

oltre 7 anni fa | 0

| accettato

Risposto
Problem when using retime
Sofie, if I understand correctly, you want to find, within each day, the maximum temperature, and the date/time at which that ma...

oltre 7 anni fa | 0

Risposto
Insert new rows of NaN for missing timestamps in time series.
I recommend you use a timetable. Read your data in using readtable, then use table2timetable. The retime function makes what you...

oltre 7 anni fa | 1

Risposto
Import time and date text file
If that is LITERALLY what your text file looks like, then all you need to do is to give readtable an appropriate date format, so...

oltre 7 anni fa | 1

Risposto
transform duration into some visible in the table
You have a cell array, each cell of which contains a scalar duration. That explains the Variable Editor display you are seeing. ...

oltre 7 anni fa | 1

Risposto
Comparing date time vectors.
There is, it's not hard, but this seems like such a strange thing to want to do that I feel like you must mean something else. ...

oltre 7 anni fa | 0

| accettato

Risposto
How do I make an array of elapsed times?
Unless you are using a pretty old version of MATLAB (< R2014b), use datetimes: >> t1 = datetime('April 18, 1995 12:00:00','Inpu...

oltre 7 anni fa | 0

Risposto
intersect two datetime vectors
As others have said, you don't have any matches between those two datetime vectors. The seem to be off by anything from about .5...

oltre 7 anni fa | 0

Risposto
Find date time value that corresponds to maximum daily value
I'm not sure retime will do all of what's asked for: it only works on one variable at a time. Getting the max tide for each day ...

oltre 7 anni fa | 1

Risposto
Missing 2000 years on date from csv file.
If all you have is a missing "20", the quick and dirty solution is to add calyears(2000) to each datetime in your table. But the...

oltre 7 anni fa | 0

Risposto
Reading the exact time and date as in excel sheet !
chamant, you will be much better off using readtable, and durations, if you have anythign like a recent version of MATLAB.

oltre 7 anni fa | 0

Risposto
How to find the total value by category in a table
The problem with Chris' solution is that by going through findgroups in that way, you lose all the categoricalness of your group...

oltre 7 anni fa | 1

Carica altro