Question

Subset using time range following specific time
I have two tables (see attached screenshot.) Both tables have a list of datetimes. I want to select the value from counts_subset...

3 years ago | 1 answer | 0

1

answer

Question

readtable working differently for different files
I have a bunch of spreadsheets which all have the same format. However, when I read them in, they appear differently... folder=...

3 years ago | 1 answer | 0

1

answer

Question

How to fit a log curve to a scatterplot?
Could anyone advise me on how to a fit a curve to this plot? The y-axis is decibels and so logarithmic. I have tried the hel...

3 years ago | 1 answer | 0

1

answer

Question

Is it possible to retrieve data from a website?
I have a list of vessel MMSI numbers. I would like to take each, enter it into the search bar on this page 'https://www.vesselfi...

3 years ago | 1 answer | 0

1

answer

Question

Saving matrix that contains cell arrays
Can anyone tell me the best way to save a large file that looks like this? I will be sharing it with colleagues to use in Matlab...

3 years ago | 1 answer | 0

1

answer

Question

How to avoid Warning when assigning values to a table
Hello, I have the attached table. I create an empty table and then add each variable separately from the name of files in a fol...

3 years ago | 1 answer | 0

1

answer

Question

Matlab is mixing MONTH and DAY up
Hello, I have a datetime array where the format is dd/MM/yyyy, but when I used ymd(), Matlab tells me that day is month and mont...

3 years ago | 1 answer | 0

1

answer

Question

Function to use withtol but only forward in time?
I have a timetable where the rows are datetimes. I then have a second timetable and I want to match the values in the second tim...

3 years ago | 1 answer | 0

1

answer

Question

Prevent plot() filling missing data between points
I have the plot belo where x=datenum and y=SPL. You can see, particularly in the second plot down, that there are periods where ...

4 years ago | 1 answer | 0

1

answer

Question

Synchronize timetables with tolerance of 5 minutes
I have two tables with common information and I would like to synchronize them, creating an additional column for data from one ...

4 years ago | 0 answers | 0

0

answers

Question

Aligning axes of two plots, one categorical axis, one datetime axis
I have the following figure. As you can see, the x axes of the bottom two plots are perfectly aligned. These axes are datetime ...

4 years ago | 1 answer | 0

1

answer

Question

How to use boxchart()?
I am trying to use a boxchart for the first time as opposed to a boxplot, as it looks to have better functionality for what I wa...

4 years ago | 1 answer | 1

1

answer

Question

Read in specific range of large .csv
I have very large .csv files that I am trying to work with, e.g. 7000 * 72000. In each file the first column is a time vector. ...

4 years ago | 1 answer | 0

1

answer

Question

Generalized linear models in Matlab
After learning to use Matlab this year to process and visualise large databases of acoustic data, I am now looking to do some st...

4 years ago | 0 answers | 0

0

answers

Question

Align time axes of two plots?
I have two figures where the x-axis is time, and they overlap in time. One is a spectrogram of a sound file and the other shows ...

4 years ago | 0 answers | 0

0

answers

Question

How do select values in one table which match those in another...
I have two tables which look like the following. Where the MMSI number in column one of IMO_file matches Var4 in AISfile, I want...

4 years ago | 1 answer | 0

1

answer

Question

Streamline for loops and indexing of large files
I am wondering if anyone has any advice on how I could streamline a script I am working on. The purpose of a script is to subse...

4 years ago | 1 answer | 0

1

answer

Question

Read one column only of a large file, line by line?
I have a large table e.g. 7836x72001. I am interested in extracting the first column from the table which is a vector of datenum...

4 years ago | 2 answers | 0

2

answers

Question

Fast subsetting or indexing of data
I am working with large datasets which I am subsetting into various categories and saving as smaller files. What I am doing righ...

4 years ago | 1 answer | 0

1

answer

Question

Find last row of csv contents using fopen, fgetl?? Or, another way?
Hello, I have a large csv ~350,000 rows, which contains a lot of information I don't need. The purpose of my script is to extrac...

4 years ago | 1 answer | 0

1

answer

Question

Error: Warning: The end of file was reached before the requested samples were read completely. Total number of samples read is 15138816.
I am getting an error which says that the file I am reading is too short to read the requested number of samples. However, I kno...

4 years ago | 0 answers | 0

0

answers

Question

Subset timetable based on variable value using cell format
I have a timetable which looks like this: I would like to subset the timetable based on the values of the variables DayName,T...

4 years ago | 1 answer | 0

1

answer

Question

How to subset common datetimes from multiple timetables
I have five timetables which contain data for five locations across a common time period. I have presented these in a histogram ...

4 years ago | 0 answers | 0

0

answers

Question

How to count number of days within datetime array
I have a timetable which spans a year. The intervals between the datetimes varies from one minute to ten minutes. I am intereste...

4 years ago | 2 answers | 0

2

answers

Question

Randomly select one file, every 10 files, and randomise where you take that file from
I have a database of thousands of .wav files which I am looking to subset. For every 10 files, I would like to select one file, ...

4 years ago | 2 answers | 0

2

answers

Answered
Reading a large csv and converting to timetable
tt.Var1=datetime(tt.Var1, 'ConvertFrom','datenum');

4 years ago | 2

| accepted

Question

Reading a large csv and converting to timetable
I have a large .csv (7179x72001) where the first column is filled with datenums and the remaining columns are numerical values. ...

4 years ago | 1 answer | 0

1

answer

Question

Why can't I convert from datenum to datetime?
I am trying to convert a vector of datenums to datetime but for some reason having issues. The spreadsheet I am working with is ...

4 years ago | 2 answers | 0

2

answers

Question

Read several large csv and store as separate variables
I have 26 large .csv files that each take a while to load in to Matlab. I would like to be able to read them all in, using one f...

5 years ago | 1 answer | 0

1

answer

Question

Make informative x-axis labels for long term spectrogram plot
I have a spectrogram which spans one month worth of 2 minute recordings. Instead of labelling each two minute recording on the x...

5 years ago | 0 answers | 0

0

answers