Jeremy Hughes

Last seen: 2日前 | 2015 以来アクティブ

Statistics

All

Content Feed

回答済み
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日前 | 0

回答済み
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 = @...

約1ヶ月前 | 1

| 採用済み

回答済み
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ヶ月前 | 0

回答済み
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...

3ヶ月前 | 0

| 採用済み

回答済み
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"...

3ヶ月前 | 0

回答済み
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 "". ...

4ヶ月前 | 0

回答済み
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, ...

4ヶ月前 | 0

| 採用済み

回答済み
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...

5ヶ月前 | 0

| 採用済み

回答済み
"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...

5ヶ月前 | 0

| 採用済み

回答済み
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...

7ヶ月前 | 0

| 採用済み

回答済み
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? ...

7ヶ月前 | 0

回答済み
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...

7ヶ月前 | 1

| 採用済み

回答済み
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...

7ヶ月前 | 0

回答済み
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...

8ヶ月前 | 0

| 採用済み

回答済み
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...

9ヶ月前 | 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","...

9ヶ月前 | 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...

10ヶ月前 | 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...

10ヶ月前 | 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...

10ヶ月前 | 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...

10ヶ月前 | 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...

10ヶ月前 | 0

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

11ヶ月前 | 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" ...

11ヶ月前 | 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 ...

11ヶ月前 | 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.

11ヶ月前 | 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...

11ヶ月前 | 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 ...

11ヶ月前 | 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...

11ヶ月前 | 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...

12ヶ月前 | 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");

約1年前 | 0

もっと読み込む

Jeremy Hughes

Statistics

File Exchange

File Exchange

File Exchange

File Exchange

File Exchange

MATLAB Answers

MATLAB Answers

MATLAB Answers

MATLAB Answers

Content Feed