Community Profile

photo

Jeremy Hughes

MathWorks

Last seen: Today Active since 2015

Software Developer, Musician and Science Fiction Writer.

Statistics

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

View badges

Content Feed

View by

Answered
why "writetable" replaces points with commas ???
@Walter Roberson, @Peter PerkinsYou're both right. Walter is more right. An XLSX file is a zip file containing XML data which ...

6 days ago | 0

Answered
Importing 4D Excel data sets
You might try readcell. It will at least give you all the data. You will have to restructure it to get the format you'd like.

8 days ago | 0

Answered
Program architecture for handling large .csv files
First, it would help to see an example file, and some sample code that demonstrates the problem. Here's the best I can say wit...

8 days ago | 0

Answered
how to use setvartype on a table that is already existing
This will do what you're literally asking for. T = array2table(strings(200,0)) % 200 variables, 0 rows, all string type But I ...

11 days ago | 0

| accepted

Answered
Problem with readtable MATLAB R2020a+
My best guess is that there's something installed on the path that conflicts with a function//variable that readtable is using i...

19 days ago | 0

| accepted

Answered
Error csvread() numeric field -> *i
It it weren't for the "*" character this would work. Something like "1-2i" will be read as complex numbers. If you have contro...

1 month ago | 0

Answered
For loop to replace n/a with NaN in a table
What does this do? data= readtable("Wetland_Water_Quality_data_1.csv","TreatAsMissing","n/a");

1 month ago | 0

Answered
CSV file reading and applying loop to plot graphs
Without an example file, it's impossible to say why the code doesn't work as expected. I'm just working backwards from the error...

2 months ago | 0

| accepted

Answered
CSV file reading and applying loop to plot graphs
You should look at what nhdr is when you see the error. It's likely an empty value which makes nhdr+2 empty, and [nhdr+2 inf] ju...

2 months ago | 0

Answered
ReadTable Producing ExtraVar Headers
Main issue is that the sample code is a bad practice. Once created by detectImportOptions, the options don't get updated based o...

2 months ago | 0

| accepted

Answered
Mixed character Tab delimited csv file read in
Ahhh, that's because the data is in quotes. readmatrix assumes quoted data is meant to be preserved, so the only way to get tha...

3 months ago | 1

Answered
Mixed character Tab delimited csv file read in
Just a note: CSV means comma-separated-values, but if this is TAB separated, it's not really CSV. If the data in the sections a...

3 months ago | 0

Answered
xlsread isn't storing all the cell values from a column
The issue is in the call to readcell which isn't using the correct syntax. See readcell documentation for details. It looks lik...

3 months ago | 0

Answered
Quick question regarding CSV file reading.
I'd do this: opts = detectImportOptions('cycle1.csv','Delimiter',',','VariableNamingRule','preserve'); opts.SelectedVariableNa...

3 months ago | 0

Answered
read csv file with dates and numerical in R2016b
Try this: opts = detectImportOptions(filename) T = readtable(filename,opts);

3 months ago | 0

Answered
xlswrite substitute that writes to specific columns
This syntax is equivalent to writematrix(A,filename,'Range',xlRange)

4 months ago | 1

| accepted

Answered
How to import several csv files (Nan,numeric,text) for operate with them after
I suggest readtable.

4 months ago | 1

| accepted

Answered
Find and replace (overwriting) to the middle of an existing binary file
fopen(filename,'a') % append mode https://www.mathworks.com/help/matlab/ref/fopen.html#btrnibn-1-permission Then use fseek to ...

4 months ago | 0

| accepted

Answered
export a cell array to excel spreadsheet
Try writecell.

4 months ago | 0

| accepted

Answered
Import parts of large comma decimal txt file
You can try this after R2020a readtable(filename,'DecimalSeparator',',') or earlier opts = detectImportOptions(filename,'Deci...

5 months ago | 1

| accepted

Answered
count number of rows in csv outside of matlab
Turns out this is not as easy of a question as you might think, especially if your CSV contains data that might be double-quoted...

5 months ago | 0

| accepted

Answered
Merge datetime cells to create specific datetime format
If your data looks like: 2021,02,22,02,30,... then you might be better off calling readmatrix, and converting the columns A =...

5 months ago | 0

Answered
how to save data into same excel sheet after each iteration
You can try writetable/writecell/writematrix with the 'WriteMode','append' parameter. e.g. writetable(myTable,'file.xlsx','Wr...

6 months ago | 0

Answered
Unable to open file as a workbook excel 97
I tried opening one of your files in a hex editor, and it's not an excel file. It's a text file. What clued me in was a warning...

6 months ago | 0

Answered
readtable command for csv file
Try this, opts = detectImportOptions(filename) T = readtable(filename,opts) I think the import options based default reading...

6 months ago | 0

Answered
How to apply a function on all images in ImageDatastore ?
I think this is what you want. imds = imageDatastore(files,...) tds = transform(imds,@(img)classify(net,img)); YPred = readal...

6 months ago | 0

| accepted

Answered
table calculation for CSV file
I tried readtable('CSVCWtable3') but MATLAB said Unable to find or open 'CSVCWtable3'. Check the path and filename or file permi...

6 months ago | 0

Answered
How can I import multiple .CSV files in MATLAB and SISTEMATICALLY process the data of each file?
You could also look at tabularTextDatastore with transform, and writeall functions. This is the basic way that's done, but you m...

6 months ago | 0

Answered
How to skip file in imageDatastore.ReadFcn?
The only way to do this is to remove the files from the Files list on the ImageDatastore, or make a copy of this dataset which c...

6 months ago | 1

| accepted

Answered
how to fix "unrecognized table variable name" error?
'ReadVariableNames',false This tells readtable not to read variable names from the file. So all the variable names will be "Va...

7 months ago | 0

Load more