Community Profile

photo

Leon


Last seen: 8 dagar 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...

3 månader 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...

3 månader 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...

3 månader 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...

3 månader 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...

4 månader 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.

4 månader 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...

4 månader 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...

4 månader 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...

5 månader 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;...

5 månader 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 ...

5 månader 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,...

6 månader 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;...

6 månader 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...

7 månader 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...

7 månader 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); ...

9 månader 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...

9 månader 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?

9 månader 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...

10 månader 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...

10 månader 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, ...

11 månader 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...

11 månader 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 = ...

11 månader 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...

11 månader 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 ...

12 månader 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...

12 månader 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...

12 månader 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...

12 månader 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...

12 månader 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 = ...

12 månader ago | 1 answer | 0

1

answer

Load more