Jeremy Hughes

Last seen: 14 days ago | Active since 2015

Followers: 0 Following: 0

Statistics

All

Feeds

Answered
Filtering multiple .csv files based on data from a table
It looks like you're loading all the data into memory, then looping to do the filtering. And to the best of my ability to tell, ...

3 months ago | 0

| accepted

Answered
Merging multiple data files to a singel big file/ usage for Ai applications
I can only answer part of this question. If you try to post as separate questions, you may get better answers. The file appears...

6 months ago | 0

Answered
Changing the shell for system commands to mingw-w64
On Windows, the only way to do this is to launch the desired shell with the command as an argument. I couldn't (quickly) find t...

7 months ago | 0

Answered
Matlab doesn't release memory after imported table is cleared
I'd caution against using the memory function to diagnose anything. This diagnostic code block may not have the same dynamics as...

11 months ago | 0

Answered
How to introduce a body (json text) in webread function?
You can use WEBWRITE for POST requests: https://www.mathworks.com/help/matlab/ref/webwrite.html opts = weboptions("ContentType"...

11 months ago | 0

Answered
ignore NaN value in the matris
There are a few ways to do this. Let's make an example vector with NaNs x = rand(1,10); x(1:4:end) = NaN Now, for SUM, you pr...

11 months ago | 0

Answered
How can I split comma-separated characters inside a cell of a cell array?
C={'NORMAL,HI,LOW,MEDIUM,OUTOFR'} split(C,",")

11 months ago | 0

Answered
How to extract base workspace data/variables in excel
If you want to edit a variable with a GUI interface, try open Example: x = rand(4); open x This will open the variable in ...

11 months ago | 0

Answered
unexpected writetable and readtable behavior
I think part of this is that the table looks like this: T1 = cell2table({[1 2 3], 2}) Where most tables look like: T2 = table...

1 year ago | 0

Answered
writestruct does not reproduce the input of readstruct
Unfortunately, there's no way to get that to happen 100% of the time, and readstruct/writestruct are not meant to do that. In fa...

2 years ago | 0

| accepted

Answered
xlsread error in 2018b
xlsread uses an active Excel process on windows and has different behavior entirely on other platforms (or if excel isn't instal...

2 years ago | 0

Answered
Repeat writing to Excel workbook on OneDrive causes "You may not have write permissions or the file may be open by another application" error.
One Drive is syncing files to the cloud when they are updated--it locks those files when that happens so you can't write to it f...

2 years ago | 1

| accepted

Answered
I want to export data to txt file in Loop
If you want to write the data to one file, this should work for i=1:N data = readtable(files(i).name); % Assuming you...

2 years ago | 0

Answered
Problems reading datetimes with readtable
There is a slight issue with the file format in question. The second case looks to readtable like three columns if you choose sp...

2 years ago | 0

| accepted

Answered
Nonstandard input date format into readstruct function?
I believe this is a bug. I've created a bug report internally. Thanks.

2 years ago | 0

| accepted

Answered
Importing Excel Database Into MATLAB
This issue is in the call to readtabkle test = readtable('./dataset2.xlsx','Sheet','Sheet1','Range','A2:CA26','TreatAsEmpty',{'...

2 years ago | 0

Answered
formatstring error when using tabularTextDatastore
Turns out this was a bug in R2020a and is been fixed in R2020b. See: https://www.mathworks.com/support/bugreports/2263913 You c...

2 years ago | 0

Answered
MATLAB system command bug - returns partial stdout
Very late to the story here, but there was a bug in the linux kernal that affected the system command in this way. https://www.m...

2 years ago | 0

Answered
Readtable is not reading my delimiter and datetime columns correctly
Passing in the delimiter is the right thing to do. The detectImportOptions function (which is being called by readtable) tries t...

2 years ago | 0

Answered
Is it possible to decide which line is variable names in readtable?
You can try: readtable(filename,"NumHeaderLines",2) or opts = detectImportOptions(filename) opts.VariableNamesRange = "A3"...

2 years ago | 0

Answered
filedatastore; read M mat files of size (1xL) into single tall array that is of size (1, L*M)
In general, you'll have better luck identifying where the problem lies by looking at each piece of the code separately. fcn = @...

2 years ago | 1

| accepted

Answered
Help with code, writematrix not working. Please help fix
The error reffers to mpower.m being a script and not a function. mpower is a builtin function, and mpower.m contains only help t...

2 years ago | 0

Answered
Export arrays to excel
If each variable is 1x5000 then your original code is creating a 1x35000 block of data when you put it in the table. This is val...

2 years ago | 0

| accepted

Answered
fwrite and MATLAB for a raid0 disk - Only one lane?
I was playing around with this and found that this is much faster (by a factor of 3 on my machine): fwrite(fid,data(:),"double"...

2 years ago | 0

Answered
Reading .txt file in MATLAB with issue in formatting
The issue is that \" is not how CSV files (and thus readtable) escape doube-quotes. To escape quotes, the file should have "". ...

2 years ago | 0

Answered
Export data to specified excel rows using writematrix
I believe it should be possible to do this using (almost) the syntax you tried, and there are some suggestions in the comments, ...

3 years ago | 0

| accepted

Answered
How can I identify the maximum value in a column and then grab specific cells in the same row as that value?
Sounds like, in MATLAB table nomenclature, you want to find the row of the table that contains the maximum value of a particular...

3 years ago | 0

| accepted

Answered
"Unable to find or open 'Filename.txt'" error in MATLAB 2022a for files from a shared network drive.
Try first >> cd Z:\Groups\Smith_G\Ryan Poland\MultiPAS-IV\Data\NO2 Calibration\20210930 If that works, then you can either ad...

3 years ago | 0

| accepted

Answered
File Extensions Name-Value pair error
The issue is that .csv isn't a supported spreadsheet format. Many people associate csv with spreadsheet, and that's likely due t...

3 years ago | 0

| accepted

Answered
Create a datastore from a table
I had no issue with arrayDatastore taking a table. Could you share some sample code with the errors or problems you're seeing? ...

3 years ago | 0

Jeremy Hughes

Statistics

File Exchange

File Exchange

File Exchange

File Exchange

File Exchange

File Exchange

MATLAB Answers

MATLAB Answers

MATLAB Answers

MATLAB Answers

Feeds