Jeremy Hughes
MathWorks
Software Developer, Musician and Science Fiction Writer.
Statistics
Your submissions were downloaded 10 or more times in a month
Awarded to Jeremy Hughes on 01 Nov 2019
Your submission is selected as "Pick of The Week"
Awarded to Jeremy Hughes on 09 Oct 2019
Publish your first review
Awarded to Jeremy Hughes on 09 Oct 2019
Your submissions received 10 five star ratings
Awarded to Jeremy Hughes on 09 Oct 2019
Publish your first submission
Awarded to Jeremy Hughes on 09 Oct 2019
20 of your answers have been accepted
Awarded to Jeremy Hughes on 16 Dec 2018
Contribute at least one answer each month for 6 consecutive months
Awarded to Jeremy Hughes on 02 Jan 2018
Answer 1 question that was unanswered for more than 30 days
Awarded to Jeremy Hughes on 20 Jul 2017
Provide your first answer ever to someone else's question
Awarded to Jeremy Hughes on 20 Jul 2017
Content Feed
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...
19日 前 | 0
| 採用済み
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","...
25日 前 | 0
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...
約1ヶ月 前 | 0
| 採用済み
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...
約2ヶ月 前 | 0
| 採用済み
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...
約2ヶ月 前 | 1
| 採用済み
{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...
約2ヶ月 前 | 0
| 採用済み
readmatrix command not working
This looks like an installation issue to me. Something is missing/broken causing initialization error in the internal code. Doe...
2ヶ月 前 | 0
Reading .txt with multiple delimiters
Readtable accepts multiple delimiters. Try this: T = readtable(filename,"Delimiter",[" ","|"])
2ヶ月 前 | 0
readtable not reading logical values as expected
The default results of detectImportOptions seeing "1" & "0" will be numeric, and the default logical reading expects "true","t" ...
2ヶ月 前 | 1
| 採用済み
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 ...
3ヶ月 前 | 0
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.
3ヶ月 前 | 0
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...
3ヶ月 前 | 0
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ヶ月 前 | 0
| 採用済み
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...
3ヶ月 前 | 0
| 採用済み
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...
3ヶ月 前 | 0
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");
4ヶ月 前 | 0
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...
4ヶ月 前 | 0
| 採用済み
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...
4ヶ月 前 | 0
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...
5ヶ月 前 | 0
| 採用済み
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...
5ヶ月 前 | 1
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...
5ヶ月 前 | 0
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...
5ヶ月 前 | 0
Quick question regarding CSV file reading.
I'd do this: opts = detectImportOptions('cycle1.csv','Delimiter',',','VariableNamingRule','preserve'); opts.SelectedVariableNa...
5ヶ月 前 | 0
read csv file with dates and numerical in R2016b
Try this: opts = detectImportOptions(filename) T = readtable(filename,opts);
6ヶ月 前 | 0
xlswrite substitute that writes to specific columns
This syntax is equivalent to writematrix(A,filename,'Range',xlRange)
6ヶ月 前 | 1
| 採用済み
How to import several csv files (Nan,numeric,text) for operate with them after
I suggest readtable.
6ヶ月 前 | 1
| 採用済み
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 ...
7ヶ月 前 | 0
| 採用済み
Import parts of large comma decimal txt file
You can try this after R2020a readtable(filename,'DecimalSeparator',',') or earlier opts = detectImportOptions(filename,'Deci...
8ヶ月 前 | 1
| 採用済み
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...
8ヶ月 前 | 0
| 採用済み
