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

7 years ago | 1

| accepted

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

7 years ago | 0

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

7 years ago | 1

Answered
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; ... ...

7 years ago | 2

| accepted

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

7 years ago | 3

| accepted

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

7 years ago | 0

| accepted

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

7 years ago | 0

| accepted

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

7 years ago | 0

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

7 years ago | 0

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

7 years ago | 0

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

7 years ago | 0

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

7 years ago | 0

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

7 years ago | 0

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

7 years ago | 0

| accepted

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

7 years ago | 0

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

7 years ago | 0

| accepted

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

7 years ago | 12

| accepted

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

7 years ago | 3

Answered
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)...

7 years ago | 0

| accepted

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

7 years ago | 0

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

7 years ago | 1

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

7 years ago | 1

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

7 years ago | 1

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

7 years ago | 0

| accepted

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

7 years ago | 0

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

7 years ago | 0

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

7 years ago | 1

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

7 years ago | 0

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

7 years ago | 0

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

7 years ago | 1