Simon - MATLAB Central
photo

Simon


Last seen: en dag ago Active since 2022

Followers: 0   Following: 0

Statistics

All
MATLAB AnswersCodyFrom 07/22 to 01/25Use left and right arrows to move selectionFrom 07/22Use left and right arrows to move left selectionTo 01/25Use left and right arrows to move right selectionUse TAB to select grip buttons or left and right arrows to change selection100%

RANK
12 947
of 296 430

REPUTATION
3

CONTRIBUTIONS
33 Questions
11 Answers

ANSWER ACCEPTANCE
78.79%

VOTES RECEIVED
3

  • Thankful Level 4
  • Solver
  • First Answer

View badges

Feeds

View by

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

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

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

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

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

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

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

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

mer än ett år 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...

mer än ett år 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', ',...

mer än ett år 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...

mer än ett år 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...

mer än ett år 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...

mer än ett år 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...

mer än ett år 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...

mer än ett år 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...

mer än ett år ago | 1 answer | 1

1

answer

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

mer än ett år 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 ...

mer än ett år 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...

mer än ett år 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...

mer än ett år 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 ...

mer än ett år 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...

mer än ett år 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...

mer än ett år ago | 1 answer | 0

1

answer

Question


Is there a less bug-prone way to include quote in selector string variable when defining opt.TableSelector?
My situation is to readtable( ) several tables, each of which has a specific title, from an html file. I have come up with a co...

mer än ett år ago | 1 answer | 0

1

answer

Answered
Storing a .mat file in mysql database
In my own experience I have tried three different approaches to store tables in MySQL. I also use Workbench (UI for MySQL comman...

mer än ett år ago | 0

Question


How to access data of regexp output (without temporary variable)?
I know how to convert the output from regexp( ) to a table by intermediating through a temporary variable as this solution: str...

mer än ett år ago | 4 answers | 0

4

answers

Question


use unstack to reshape table with dummy variable (edited: alternative crosstab method)
After I sort table according to a group variable, I like to put the group value as the 'header' column and put its members in th...

nästan 2 år ago | 2 answers | 0

2

answers

Question


Edit: sqlwrite( ) fails when integer variable's value range is set too small.
Edit: previous wrong undestanding: "sqlwrite( ) fails to save a tall table to MySQL (native connection mode), when the number o...

nästan 2 år ago | 1 answer | 0

1

answer

Answered
Unable to connect to MySQL (native data source configuration) on iMac
After I upgrade Matlab to 2023a, this problem is gone. I now can connect to MySQL server with "native" mode. Thanks to Mathwork...

nästan 2 år ago | 0

| accepted

Question


Why is parfor-loop is much slower than for-loop in this case?
I just started to explore the pros and cons of parfor-loop. In the simpy testing codes below, parfor-loop is much slower than fo...

nästan 2 år ago | 1 answer | 0

1

answer

Load more

Go to top of page