Simon

Last seen: 3 months ago | Active since 2022

Followers: 0 Following: 0

Statistics

All

Feeds

Answered
sqlread specific columns/variables from a MySQL table
The answer to my own questiion is fetch. sqlread always reads in the whole table. sqlquery = 'select wanted_column from myTabl...

3 months ago | 1

Question

sqlread specific columns/variables from a MySQL table
I want to import to Matlab one or a couple specific columns from a table that is stored in MySQL database. sqlread(conn, tablena...

3 months ago | 2 answers | 0

2

answers

Question

Functional programming and idea-oriented Git branching strategy
I analyze a set of financial statement data. The end output of this project should be a short list of stocks for investment, not...

8 months ago | 1 answer | 0

1

answer

Question

function chaining when one function has multiple outputs
Similar question has been asked before, but I would ask the question in a more specific manner. If the function in the input en...

8 months ago | 1 answer | 0

1

answer

Question

my license for database toolbox isn’t linked to mobile Matlab
I have bought the license of Database Toolbox and it wotks fine in Mac. When I try to connect with an sqlite .db file in the iPa...

12 months ago | 0 answers | 0

0

answers

Question

sqlite ignore project path?
I have a sqlite database, say "filename.db", in a local folder (MacOS). The folder is then added to my project path. However, sq...

12 months ago | 1 answer | 0

1

answer

Question

How to select non-string variables convertvars( ) argument?
I want to convert non-string variables to string using convertvars. I can do convertvars(T, @isnumeric, 'string') and convertvar...

1 year ago | 1 answer | 0

1

answer

Question

What is the best folder organization for a large data analysis project with multilayered subprojects?
My project involves several subprojects. They should be completed in a sequential manner. And each subproject involves different...

1 year ago | 0 answers | 0

0

answers

Question

Is there a parallel version of splitapply()?
Group-based computation is naturally sutiable for parallel computation. I wonder why Matlab has not yet a built-in parfor-splita...

1 year ago | 2 answers | 0

2

answers

Question

readtable(html file) producing extra empty columns
Original question: In another thread, similar question was asked for readtable(csv file). The answer was to set {'delimiter', ',...

1 year ago | 1 answer | 0

1

answer

Answered
What should go in a next-generation MATLAB X?
Insert 'parfor' option into splitapply( ), grouptransform( ) or create separate parallel versions of those two functions. Righ...

1 year ago | 0

Answered
What should go in a next-generation MATLAB X?
@Andrew Janke Do you cast your table variables to categorical? In my case, if a task is to process strings, it will be many-time...

1 year ago | 0

Answered
What should go in a next-generation MATLAB X?
My wish list, not about code improvement but about official tutorials. a tutorial of using splitapply to take advantage of para...

1 year ago | 0

Question

Why doesn't parfeval(@splitapply) improve splitapply's performance?
I want to readtable many html-files to extract tables. I wrote a function extract_sheet to do just that. I had used parfor to pe...

1 year ago | 2 answers | 0

2

answers

Answered
What should go in a next-generation MATLAB X?
Better folder path utility. Python's pathlib is powerful and very intuitive to use. Matlab's dir is cumbersome. To be the proble...

1 year ago | 0

Question

(par)for k=1:N end; select for or parfor loop without code replication
I like to use for-loop or parfor-loop with function input flag. One way to do that is using if-else with code replication. I won...

1 year ago | 1 answer | 1

1

answer

Solved

Getting the indices from a vector
This is a basic MATLAB operation. It is for instructional purposes. --- You may already know how to <http://www.mathworks....

1 year ago

Solved

Find max
Find the maximum value of a given vector or matrix.

1 year ago

Solved

Inner product of two vectors
Find the inner product of two vectors.

1 year ago

Solved

Find Air Temperature from Cricket Stridulation Rate
Stridulation is the process that creates a cricket's “chirp” by rubbing their wings or legs. According to the Old Farmer's Alma...

1 year ago

Solved

Get the length of a given vector
Given a vector x, the output y should equal the length of x.

1 year ago

Solved

Select every other element of a vector
Write a function which returns every other element of the vector passed in. That is, it returns the all odd-numbered elements, s...

1 year ago

Solved

Find the sum of all the numbers of the input vector
Find the sum of all the numbers of the input vector x. Examples: Input x = [1 2 3 5] Output y is 11 Input x ...

1 year ago

Answered
(revised) What is the right way to apply parallel.pool.Constant on functional handle?
I think I found the solution: feval(). It's in the help page of broadcast variable and parfor. function res = iter_test(f, T) ...

2 years ago | 0

| accepted

Question

(revised) What is the right way to apply parallel.pool.Constant on functional handle?
(original question) I use parfor-loop to process through rows of table/array. In each iteration, a function handle is called to ...

2 years ago | 1 answer | 0

1

answer

Answered
(problem solved, question revised) How to select table rows with varargin and not using logical condition as input argument.
@Steven Lord I think I finally figure out how to do it based on your algorithm. Great thanks for your generous help. I think the...

2 years ago | 0

Question

How to write one universal function to evaluate many equations?
I am working on verifying whether if equations are valid over a large data set. The challenge is that the number of equations to...

2 years ago | 0 answers | 0

0

answers

Question

(problem solved, question revised) How to select table rows with varargin and not using logical condition as input argument.
(original question)"I have tables. Selecting rows where values meet logical conditions from them is a frequent task. It becomes ...

2 years ago | 3 answers | 0

3

answers

Question

a philosophical question regarding function (how many tasks should be wrapped inside a function?)
My data have two types of tables. They share common columns, and the second type has extra columns. I couldn't decide whether i...

2 years ago | 1 answer | 0

1

answer

Question

What toolboxes should I get to do speech formant analysis in real time?
I want to record speech sound with a mucrophone, and have its formants analyzed and displayed in real time. Hopefully the spectr...

2 years ago | 1 answer | 0

1

answer