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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

| akzeptiert

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 4

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

mehr als 8 Jahre vor | 1

Beantwortet
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: ...

mehr als 8 Jahre vor | 2

| akzeptiert

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

| akzeptiert

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 1

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

mehr als 8 Jahre vor | 1

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

mehr als 8 Jahre vor | 1

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 2

| akzeptiert

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

Beantwortet
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'...

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

| akzeptiert

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

mehr als 8 Jahre vor | 0

| akzeptiert

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

Beantwortet
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".

mehr als 8 Jahre vor | 0

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

mehr als 8 Jahre vor | 0

| akzeptiert

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

mehr als 8 Jahre vor | 0