Community Profile

photo

Jeremy Hughes

Last seen: en dag ago Active since 2015

Statistics

All
  • GitHub Submissions Level 1
  • Personal Best Downloads Level 1
  • Editor's Pick
  • First Review
  • 5-Star Galaxy Level 4
  • First Submission
  • Knowledgeable Level 4
  • 6 Month Streak
  • Revival Level 1
  • First Answer

View badges

Content Feed

View by

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

en dag ago | 0

Submitted


MATLAB For-Each
Tools for simplifying for-loops. Customizable loop iteration.

28 dagar ago | 4 downloads |

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

ungefär en månad 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.

ungefär 2 månader 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',{'...

ungefär 2 månader 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...

ungefär 2 månader 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...

4 månader 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...

7 månader 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"...

7 månader 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 = @...

9 månader 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...

9 månader 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...

10 månader 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"...

10 månader 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 "". ...

11 månader 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, ...

12 månader 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...

12 månader 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...

ungefär ett år 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...

ungefär ett år 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? ...

ungefär ett år ago | 0

Answered
How to use textscan with empty char fields
The format specifier %c always reads one character, no matter what that character is. What you likely want it %s, which reads al...

ungefär ett år ago | 1

| accepted

Answered
Convert serial number date in date string - Excel file
First, I would suggest using readcell if you want to get datetimes. This will give you the right thing by default. Otherwise, c...

ungefär ett år ago | 0

Answered
readmatrix not working in 2021b
I agree with the previous answer, but readmatrix is probably not what's being shadowed. It's probably something readmatrix relie...

mer än ett år ago | 0

| accepted

Answered
how to read mixed date and data
I made some corrections in the comments above, but this is how I would do this more robustly using partial detection with detect...

mer än ett år ago | 0

| accepted

Answered
use of readtable to read unstructured data
Based on the file attached, I suggest treating this as a fixed width file. opts = detectImportOptions("sample.txt","FileType","...

mer än ett år ago | 0

Answered
How to delete multiple rows from a table using a for loop (with a condition)?
I wouldn't use a for loop. MATLAB excells at array operations. A = randn(12,5); % Make some data with positive and negative v...

mer än ett år ago | 0

| accepted

Answered
Why are there a few bytes added every time I call writetable?
writetable write "into" a sheet by default. And there's some meta-data being added, but I'm not sure if it's MATLAB, or the exce...

mer än ett år ago | 0

| accepted

Answered
Unable to detect datetime or duration data in file for row times
Hi Sangani, This is a consequence of how Excel stores "time" data. It represents it as a "number" internally, with a custom for...

mer än ett år ago | 1

| accepted

Answered
{0*0 char} error while Importing .dat file
Instead of readtable and table2array, you could instead use readmatrix (as of R2019a) directly. The reason some of the columns...

mer än ett år ago | 0

| accepted

Answered
readmatrix command not working
This looks like an installation issue to me. Something is missing/broken causing initialization error in the internal code. Doe...

mer än ett år ago | 0

Answered
Reading .txt with multiple delimiters
Readtable accepts multiple delimiters. Try this: T = readtable(filename,"Delimiter",[" ","|"])

mer än ett år ago | 0

Load more