Leon
Last seen: alrededor de 1 mes ago
NOAA
162 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 write this line of code to create a Matlab table?
I have unknown number of column variables in cell array: Var{1} = [ 1; 2; 3; 4; 7]; Var{2} = [33; 10; 46; 7; 2]; ... If I kn...
alrededor de 2 meses ago | 1 answer | 0
1
answerQuestion
Anyone has issues with the Mathworks Community forum system?
I mean the system I'm using to ask this question. A lot of the time it would freeze for no reason and become uneditable. I wou...
alrededor de 2 meses ago | 0 answers | 0
0
answersQuestion
Is it possible to have a column data with some numerical values and some strings?
I have some really large data with millions of rows. I would have a column with 95% of them being numerical and 5% being strings...
alrededor de 2 meses ago | 1 answer | 0
1
answerQuestion
How to read out the strings from this Excel file?
Attached is the Excel file. Here is the code I use to read values out of the Excel file: T1 = readtable ('test.xlsx'); Unfo...
alrededor de 2 meses ago | 1 answer | 0
1
answerQuestion
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...
3 meses 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.
3 meses 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...
3 meses 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...
3 meses 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...
4 meses 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;...
4 meses 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 ...
4 meses 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,...
5 meses 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;...
5 meses 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...
5 meses 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...
5 meses 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); ...
7 meses 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...
8 meses 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?
8 meses 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...
9 meses 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...
9 meses 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, ...
10 meses 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...
10 meses 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 = ...
10 meses 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...
10 meses 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 ...
10 meses 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...
10 meses 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...
11 meses 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...
11 meses 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...
11 meses 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 = ...
11 meses 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)