Leon
Last seen: 4 days ago
NOAA
158 total contributions since 2011Leon's Badges
Publish your first comment or rating
Awarded to Leon on 09 Feb 2020
Accept 50 answers given by other contributors
Awarded to Leon on 04 Jun 2019
Provide your first answer ever to someone else's question
Awarded to Leon on 11 Apr 2018
Question
How to first form a variable and then assign values to it?
My variable can be anything like the below: if case1 Var = Temperature elseif case2 Var = Pressure elseif case3 V...
1 month ago | 1 answer | 0
1
answerQuestion
How to position radio buttons into grid layouts in App Designer?
Is it possible to position each of the radio buttons in a radio button group into a grid layout? Many thanks.
1 month ago | 1 answer | 1
1
answerQuestion
How to form a structure array variable?
I have a structure array like the below Test{1}.a = [1; 2; 3]; Test{1}.b = [7; 3; 22]; Test{1}.c = [4; 9; 22]; ... If I hav...
1 month ago | 2 answers | 0
2
answersQuestion
Is there such a table units identification approach?
Imagine I have a table T1. We know its units will be Units = T1.Properties.VariableUnits; Similarly, its header will be Heade...
1 month ago | 2 answers | 0
2
answersQuestion
How to replace -999 values with NaN in a Matlab table?
I have a Matlab table T1, with columns like the below: T1.year T1.month T1.day T1.var1 T1.var2 ... Some of its columns a...
2 months ago | 2 answers | 0
2
answersQuestion
How to bold a phrase in a textbox?
Below is my code. How do I bold the phrase "Flag: "? C = [C, newline, ['Flag: ', num2str(B(i)) ] ]; app.text1.Value = C;...
2 months ago | 1 answer | 0
1
answerQuestion
How to check if a column data is equal to any of a group of values?
I have a column data A like the below: A = [1; 3; 2; 7; 11; 6]; B can be a group of numbers with unknow counts. For example B ...
2 months ago | 4 answers | 0
4
answersQuestion
string join does not work for char arrays?
I have a column list of numbers like the below M = [2; 3; 5; 7; 16]; What I want is to create a string array like this "2, 3,...
3 months ago | 4 answers | 0
4
answersQuestion
How to find unique group of numbers?
I have a cell array like the below, storing some groups of numbers: C{1} = [1; 3; 4]; C{2} = [3; 9; 135; 278]; C{3} = [6; 89;...
3 months ago | 1 answer | 0
1
answerQuestion
How to write special characters into an Excel cell?
I'm trying to write the units of my table into the 2nd row of my Excel file. Below is the code: writecell(T.Properties.Variable...
3 months ago | 1 answer | 0
1
answerQuestion
Adding a unit row to a table
Below is how I normall create my table in Excel: TT = table(Year, Month, Day, Longitude, Latitude, Oxygen, Chlorophyll_A); wri...
3 months ago | 1 answer | 0
1
answerQuestion
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); ...
6 months ago | 0 answers | 0
0
answersQuestion
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...
6 months ago | 2 answers | 0
2
answersQuestion
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?
6 months ago | 1 answer | 0
1
answerQuestion
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...
7 months ago | 1 answer | 0
1
answerQuestion
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...
7 months ago | 1 answer | 0
1
answerQuestion
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, ...
8 months ago | 1 answer | 0
1
answerQuestion
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...
8 months ago | 1 answer | 0
1
answerQuestion
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 = ...
8 months ago | 1 answer | 0
1
answerQuestion
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...
8 months ago | 1 answer | 0
1
answerQuestion
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 ...
8 months ago | 2 answers | 0
2
answersQuestion
Readtable error help?
Here is my code and attached is my test.xlsx. clear all close all clc A = readtable('test.xlsx', 'FY20', 'PreserveVaria...
8 months ago | 2 answers | 0
2
answersQuestion
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...
9 months ago | 1 answer | 0
1
answerQuestion
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...
9 months ago | 1 answer | 0
1
answerQuestion
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...
9 months ago | 1 answer | 0
1
answerQuestion
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 = ...
9 months ago | 1 answer | 0
1
answerQuestion
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...
9 months ago | 2 answers | 0
2
answersQuestion
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...
9 months ago | 1 answer | 0
1
answerQuestion
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? ...
9 months ago | 1 answer | 0
1
answerQuestion
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...
9 months ago | 1 answer | 0
1
answer
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
Select web siteYou can also select a web site from the following list:
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)