回答済み
Readtable function has some kind of limitation on the number of rows and columns?
You have not provided any sample of what's in your spreadsheet, so pretty hard to say what's wrong. Best guess is you have a lot...

8年以上前 | 0

回答済み
How can I take a data set with data at variable times and put it on 1 minute intervals for date and time, and generate a regression between the time stamps of my data.
You got a lot of code there, and I'm not really sure what all you are doing, especially "take into account data points that migh...

8年以上前 | 0

回答済み
How do I plot time-stamped data from file?
Reading the data in is relatively easy in recent MATLAB, although there's a couple of tricks. I'm using R2017b, earlier versions...

8年以上前 | 0

| 採用済み

回答済み
Plot distance with time
I'm gonna make a different guess: those numbers are seconds since midnight. So: >> t = readtable('Trial1.xls'); Warning:...

8年以上前 | 0

回答済み
convert seconds to time
Unless you are using an older version of MATLAB, use durations: >> seconds(28225.6) ans = duration 28225.6 s...

8年以上前 | 4

回答済み
Using datenum with a structure field
As Walter pointed out, there were two things going on, both having to do with the fact that s.Field for a non-scalar st...

8年以上前 | 1

回答済み
Reading dates/times into MATLAB and saving as a numeric vector
Unless you are using a pretty old version of MATLAB, I recommend you don't use datenum and datestr. Try datetime. For example: ...

8年以上前 | 2

| 採用済み

回答済み
Using for loop for plotting from a timetable?
I imagine that plot(TT2.Date,TT2{:,1:2}) would also work. And if there's only two variables in your timetable, that's eq...

8年以上前 | 0

回答済み
Pivot table with different operations for columns
Look at using a timetable, and look at using varfun with year/month as your grouping variable(s).

8年以上前 | 0

| 採用済み

回答済み
change date format in table
The warning is coming from readtable, and it's worth paying attention to what it says, and addressing the issue, because that is...

8年以上前 | 0

回答済み
Got error in joining two tables: Left and right key variables 'Date' and 'Date' include cells containing non-string values.
The error seems clear: you are trying to use a variable that is not supported as a key. You say that you have a datenum variable...

8年以上前 | 1

回答済み
How to import csv file into matlab ?
readtable, possibly using importoptions, is the thing to use in recent versions of MATLAB.

8年以上前 | 1

回答済み
Add missing time data
Your data run from 1-Jan-2016 to 31-Dec-2016. There are >> minutes(diff(datetime(2016,[1 12],[1 31]))) ans = 5...

8年以上前 | 1

回答済み
Inconsistent date formats across time functions
"This difference does make converting between string and numerical formats prone to programming errors." Robert, you may mean...

8年以上前 | 0

回答済み
confusing datestr and datetime month and minutes formating
The formats for datetime are not just more consistent, they are an <http://www.unicode.org/reports/tr35/tr35-dates.html#Date_Fie...

8年以上前 | 0

回答済み
Using Dates (if possible) as structure fields.
It's quite possible that you could use a timetable, in which each row is labelled with a datetime. Hard to say without more info...

8年以上前 | 0

回答済み
How to define sequence of dates between to dates on monthly time step?
Hydro, I think all you need is to add a step size of one calendar month (in your code you are stepping by one day): StartDa...

8年以上前 | 2

| 採用済み

回答済み
How do I convert table data to double to manipulate them?
The answer might be as simple as something like T.Z = T.x .* T.y. Without more information, hard to tell.

8年以上前 | 0

回答済み
How to get rid of unwanted comment in the data imported using 'readtable'
That's not a table, it's a cell array of ... char row vectors? Hard to know without more info. If it is, then just use strrep an...

8年以上前 | 0

回答済み
Find and trim text in a table
As KL's answer indicated, this isn't really a question about tables, you just need to figure out how to do it for a string colum...

8年以上前 | 0

回答済み
Finding unique values in a table without losing the rest of the data
It's pretty hard to tell what you mean by, "without losing the rest of the information of the table", but an alternative to Amy'...

8年以上前 | 0

回答済み
How can i read from CAN and save the messages in a timetable?
Jose, I think typically you would want to vertically concatenate all the timetables you get. You might either do something like ...

8年以上前 | 0

| 採用済み

回答済み
Fail to create a new variable in the Timetable
Angelina, if you are using timetables, you will likely be happier using datetimes, rather than going back and forth between thos...

8年以上前 | 0

| 採用済み

回答済み
How to convert from decimal time to hh:mm:ss
Unless you are using an older version of MATLAB, you are likely better off using readtable (instead of xlsread) and datetime (in...

8年以上前 | 0

回答済み
Need help with datenum function
If you have R2015b, you will likely be happioer using datetimes rather than datenums: dates = datetime(data.date(2:end),'Fo...

8年以上前 | 0

回答済み
How to count the duplicate id's within a group of a table?
If the table is already sorted by date and ID (use sortrows), then it's straight-forward: >> t t = 9×3 table ...

8年以上前 | 0

回答済み
I want to concate two tables vertically.the table has no variable name.how can I do that?
The problem here is that the requirement of two rows that are numbers and one row that is text is exactly the opposite orientati...

8年以上前 | 0

回答済み
Using corresponding values in a table in an equations
If your table is named "t", then t.value3 = (t.value1./100).*t.population creates a new variable in t named "value3".

8年以上前 | 0

回答済み
Optimise function with datetime operations
Assuming "date" is a datetime array, a couple things as a starting point: 1) The creation of the FFR and RED arrays looks lik...

8年以上前 | 0

| 採用済み

回答済み
How can I create a table to work with, from this .txt?
This is a _TAB delimited file_. In recent version of MATLAB, that is automatically detected, as is the type (datetime) of the fi...

8年以上前 | 0