Community Profile

photo

Leon


Last seen: alrededor de 1 mes ago

NOAA

162 total contributions since 2011

Contact

Leon's Badges

  • First Review
  • Thankful Level 4
  • First Answer

View details...

Contributions in
View by

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

answer

Question


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

answers

Question


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

answer

Question


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

answer

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...

3 meses ago | 1 answer | 0

1

answer

Question


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

answer

Question


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

answers

Question


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

answers

Question


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

answers

Question


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

answer

Question


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

answers

Question


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

answers

Question


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

answer

Question


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

answer

Question


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

answer

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); ...

7 meses 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...

8 meses 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?

8 meses 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...

9 meses 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...

9 meses 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, ...

10 meses 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...

10 meses 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 = ...

10 meses 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...

10 meses 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 ...

10 meses 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...

10 meses ago | 2 answers | 0

2

answers

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...

11 meses 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...

11 meses 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...

11 meses 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 = ...

11 meses ago | 1 answer | 0

1

answer

Load more