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

alrededor de 13 horas 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...

alrededor de 16 horas 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 ...

3 días 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...

12 días 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...

25 días 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");

alrededor de 1 mes 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...

alrededor de 2 meses 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...

alrededor de 2 meses 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 meses 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...

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

2 meses 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 meses ago | 0

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

3 meses ago | 0

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

3 meses ago | 0

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

4 meses ago | 1

| accepted

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

4 meses 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 meses ago | 0

| accepted

Answered
export a cell array to excel spreadsheet
Try writecell.

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

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

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

6 meses ago | 0

Answered
problem with the function "fread"
The error indicates that fopen returned an invalid file ID. Try this: [fid,msg] = fopen(filename) if fid < 0 error(msg) ...

6 meses ago | 0

Load more