Community Profile

photo

Leon


Last seen: 21 days ago

NOAA

147 total contributions since 2011

Contact

Leon's Badges

  • First Review
  • Thankful Level 4
  • First Answer

View details...

Contributions in
View by

Question


How to preserve subscript or superscript formatting in a text string?
I'm reading out some text strings (units) from some Excel files: filename = 'AAA.xlsx'; opt = detectImportOptions(filename); ...

21 days ago | 0 answers | 0

0

answers

Question


How to read units on a 2nd row out of an Excel file?
Attached is an example Excel file. I'm using this command to read the info out of the file: T1 = readtable('test.xlsx', 'Pres...

21 days ago | 2 answers | 0

2

answers

Question


How to force y-axis values not to use scientific notation in axes?
My y-axis ranges from 0.001 to 0.003, it always shows up as 1-3 x 10^-3. How do I force it show up as 0.001 to 0.003?

28 days ago | 1 answer | 0

1

answer

Question


How to subset a table and pass the variable names?
I'm trying to subset a large table to only get the rows that I'm interested in. Below is my code: My table is named T % uniq...

2 months ago | 1 answer | 0

1

answer

Question


How to find the unique elements in multiple strings?
I have strings like the below. It can be 1 or can be more than 20. Here is an example with just 2 strings> A = "CTDTMP, CTDSA...

2 months ago | 1 answer | 0

1

answer

Question


How to link subgroup data points together in a plot?
I have matrix A like the below. The first column is the group number. % GroupNo, X, Y 1, x1, y1 1, x2, y2 1, x3, y3 2, x4, ...

3 months ago | 1 answer | 0

1

answer

Question


Time info is not read correctly by readtable
I'm using the below command to read my Excel files (see attached for an example): A = readtable('test.xlsx'); I notice one int...

3 months ago | 1 answer | 0

1

answer

Question


How to check and convert a column of strings to numbers
I have some column data like this: A = "3" "3" "31" "31" "57" "58" or this A = ...

3 months ago | 1 answer | 0

1

answer

Question


How to extract a column numerical data as strings?
I have some data stored in xlsx format. There is always a column data called "Station IDs". Sometimes it is numerical and someti...

3 months ago | 1 answer | 0

1

answer

Question


How to decipher date formats?
My date columns stored in Excel can have various formats like the below: '9/1/19' '31-Dec-2020' I'm reading them into Matlab ...

4 months ago | 2 answers | 0

2

answers

Question


Readtable error help?
Here is my code and attached is my test.xlsx. clear all close all clc A = readtable('test.xlsx', 'FY20', 'PreserveVaria...

4 months ago | 1 answer | 0

1

answer

Question


How to identify duplicate rows in a matrix?
I have a matrix like the below. It could have millions of rows. A = [Year, Month, Day, Time, Lon, Lat, A, B, C; 20...

4 months ago | 1 answer | 0

1

answer

Question


How to replace all elements in a Table?
For example, if I want to replace all -9999 with -999, I can do this in a matrix: A(A==-9999) = -999; My question is how to do...

4 months ago | 1 answer | 0

1

answer

Question


How to pass a table generated from a function back to app-designer?
I have a function like this to generate a data table: function Function1(app, PATH, FILE); File_mat = fulfile(PATH, FILE...

4 months ago | 1 answer | 0

1

answer

Question


How to find the position of the first non-zero element of my matrix?
For example, if I have a column data like the below: A = [0; 1; 0; 0; 0]; The answer would be 2. For the below example: B = ...

4 months ago | 1 answer | 0

1

answer

Question


How to check if a column of a table exist?
The below command works if I know the exact names of the Table column variable names. any(strcmp('EXPOCODE', T1.Properties.Va...

4 months ago | 2 answers | 0

2

answers

Question


How to save a column of strings into a NetCDF file?
If I have a one-column data with a dimension of 200x1 (e.g., Longitude as in the below example), I know how to store them into a...

4 months ago | 1 answer | 0

1

answer

Question


How to assign a column of text string to another variable?
For example, A = repmat('test', 5,1); If I want to assign A to B, why the below doesn't work? What is the right way to do it? ...

4 months ago | 1 answer | 0

1

answer

Question


How to read numerics as strings with readtable?
I have a table in spreadsheet (xlsx). One of the column is composed of either a numerical number, or several of them, like the b...

4 months ago | 1 answer | 0

1

answer

Question


How to make this text string column program faster?
Accessions here are text strings with a length between 3 and 8. Here is my current program to process them: % Accession: ACCN ...

4 months ago | 1 answer | 0

1

answer

Question


How to position the default interactivity bar?
I'm referring to the toolbar with things like Zoom in, Zoom out, Home, etc. Right now, its default position is to cover my xtick...

5 months ago | 1 answer | 0

1

answer

Question


How to set marker groups in one plot?
I have matrix A like the below. The first column is the group number. % GroupNo, X, Y 1, x1, y1 1, x2, y2 1, x3, y3 2, x4, ...

5 months ago | 1 answer | 0

1

answer

Question


how to fix this upper directory link?
File_W = fullfile(app.Path, '..', 'MyFolder', [fileName, '_myFormat_.xlsx']); writetable(T1, File_W); The above is my code to ...

5 months ago | 1 answer | 0

1

answer

Question


How to preserve embedded equations and color coding within Excel when using readtable and writetable?
Below is how I normally read info out of an Excel file T = readtable ('example.xlsx','PreserveVariableNames',true); What if I ...

5 months ago | 0 answers | 0

0

answers

Question


Is it possible to set the position of a uialert within app designer?
Below is my code to generate an alert pop up window. message = sprintf('No file is generated.'); uialert(app...

5 months ago | 1 answer | 0

1

answer

Question


How to read Excel files with unknown number of header rows?
Below is my code to read an Excel file using readtable: T1 = readtable ('test.xlsx','PreserveVariableNames',true); Headers = T...

5 months ago | 1 answer | 0

1

answer

Question


How to position two figures on one app-designer gridlayout position?
I need to overlay two figures on one app-designer gridlayout position. The two figures need to be one on top of the other, with ...

5 months ago | 1 answer | 0

1

answer

Question


How to use savefig in app-designer?
Here is how I plot my map in app-designer: load map_use; %M N [m n] = size(M); for i=...

5 months ago | 1 answer | 0

1

answer

Question


How not to delete one element of a figure when using cla?
I have a map with coastlines and sampling stations that are added from other scripts using the command plot. When I move on to t...

5 months ago | 2 answers | 0

2

answers

Answered
How to properly position multiple plots within app-designer
For future reference, I finally got this figured it out. All I need to do is to set the "PlotBoxAspectRatioMode" property to "au...

5 months ago | 0

Load more