Respondida
Specify format when using readtable() to read spreadsheet .xlsx?
Cell arrays are the standard way to store strings in MATLAB. You may or may not be asking about character matrices, but you real...

casi 10 años hace | 0

| aceptada

Respondida
Datetime from Unix time miliseconds
It's not entirely clear to me what you're starting out with. "unix time" isiusually measure in seconds since 1970, you may have ...

casi 10 años hace | 3

Respondida
Delete rows if the column has weekend date
'date' and 'time' aren't really types in MATLAB, so it's not clear what you have. I'm guessing you have a cell array, the first ...

casi 10 años hace | 0

Respondida
How can i generate month and year strings for Datetime vectors?
To create _numbers_ use the Year and Month properties of a datetime >> d = datetime+calmonths([1;2;3]) d = 03-Sep...

casi 10 años hace | 0

Respondida
how to put dates in x-axis in subplots?
James, if you're using R2014b or later, you should try using datetime, not datenum. There's plotting functionality built around ...

casi 10 años hace | 0

Respondida
Search in two columns (Tables)
I'm not 100% sure I've understood the operation you want to do, but it sounds like you want to find the rows in table 2 whose ex...

casi 10 años hace | 0

Respondida
How to Manipulate Values in the Table
You could do it with rowfun, here's another way. First make your data friendlier: >> t = table([1;2;3;4;5],[1;1;0;0;1],cate...

casi 10 años hace | 0

| aceptada

Respondida
Add header to my new extracted data from a table?
mahrukh, there are much simpler ways to do this, especially your use of subscripting. For example: data = readtable('my_fil...

casi 10 años hace | 0

| aceptada

Respondida
Setting mixed table data as empty
Callum, it's possible that passing things like isnumeric into varfun as the 'InputVariables' parameter would help, although I'm ...

casi 10 años hace | 0

Respondida
append table to a exist csv file
Marco, it's quite possible (you don't provide enough info to know for sure) that the reason why your table is so big is because ...

casi 10 años hace | 0

| aceptada

Respondida
Align Two Data Sets by Date and Location Where Both Data Sets Are Missing Data Points at Random Dates and Locations?
Dylan, if I understand your description correctly, this is a pretty classic example of an outer join: First cook up some fake...

más de 10 años hace | 1

| aceptada

Respondida
Creating table of fints from tall table of various financial data
Josh, I think you mean varfun (no 'c'), right? The function you pass into varfun should take exactly one input - varfun works on...

más de 10 años hace | 0

Respondida
Bug? Datetime creation produces both NaT and 1-Jan-1970 values.
Erik, that does appear to be a bug. You are making an indexed assignment to only some elements of a datetime array that does not...

más de 10 años hace | 1

| aceptada

Respondida
Struct 2 table conversion error
The error message says it all: to convert a scalar struct to a table, the fields all have to be the same number of rows. However...

más de 10 años hace | 0

Respondida
How to convert datetime
You're going to need to say what those two numbers, which differ by *15 orders of magnitude*, are supposed to represent. The fir...

más de 10 años hace | 0

Respondida
How do I apply calculations on a table of cells? Why are my double numbers recognized as cells?
Others may already (almost) said this, but the problem is that you are taking a cell array of strings and working on it one cell...

más de 10 años hace | 0

Respondida
Importing HH:MM:SS from excel
datestr is the (old) command to create strings that represent dates and times. So that's why you have a char array. If you impor...

más de 10 años hace | 4

| aceptada

Respondida
How to change time stamp to readable date and time without giving reference time ?
When I do this >> datetime('08-Feb-2016 10:28:52','Format','dd-MMM-yyyy HH:mm:ss.SSSSSSSSS') - seconds(1.454956105656222e+9...

más de 10 años hace | 0

Respondida
How to split a column in a table into two columns by a space
If the variable in your table is literally a datetime, and not a cellstr containing datestrs, then you'll want to split them uin...

más de 10 años hace | 0

Respondida
Significant figures in table
For numeric variables, tables respect the long/short precision of the current command window setting, but do so using either for...

más de 10 años hace | 0

Respondida
How to convert a series of number representing dates into into plottable values?
Assuming you're using R2014b or later: If you read them from the file as strings, you can turn those strings into datetimes a...

más de 10 años hace | 0

Respondida
How can I create a table from variables (DATA, ColumnNames)
Joe, you may be happy with where you ended up, but I'm not sure it's the best way. You said: _"The data (DATA.m / double) ...

más de 10 años hace | 0

| aceptada

Respondida
Datetime with variable format
Winston, I recommend that you NOT mix datenum and datetime. If you're in R2014b or later, don't use datenums. Among other things...

más de 10 años hace | 2

Respondida
access data from a table
Jenny, "datetime" is a datatype in MATLAB since R2014b. It appears that you are not using that, and that what you're calling "Da...

más de 10 años hace | 0

Respondida
How to find cell match in matlab table and exctract data from table
Gert, no offense intended, but it's your data format that I would describe as "awful". Using StarStrider's code, Here's the firs...

más de 10 años hace | 0

Respondida
How to pre-allocate table rows
Danial, I interpret your question as "I have a table with one row. I'd need the same table, but lengthened to 10 rows so that...

más de 10 años hace | 7

| aceptada

Respondida
CSV Date time error
Dan, your description is a little light on details. Assuming you have data like a bigger version of this ... timestamps = ....

más de 10 años hace | 0

Respondida
Loss of precision with netcdf time when using datenum
Mashtine, I'm not super familiar with netCDF, but "365 day format" and this >> dt = between(datetime(2005,11,26),datetime(2...

más de 10 años hace | 0

Respondida
Different R squared from fitlm and corrcoeff?
Diana, you're comparing two different things, though they are related. See, e.g. <https://en.wikipedia.org/wiki/Coefficient_of_d...

más de 10 años hace | 0

| aceptada

Respondida
What is the best way to concatenate arrays of different types (matrices and cells of strings or numbers) into a table to be saved in txt file (for Matlab R2011a)?
Under simple conditions, writetable just does what you want: >> N = 3; >> a = [zeros(N,1) ones(N,1)]; >> b = [repmat(...

más de 10 años hace | 0

| aceptada