photo

Simon


Last seen: 9 días hace |  Con actividad desde 2022

Followers: 0   Following: 0

Estadística

All
  • Thankful Level 4
  • Solver
  • First Answer

Ver insignias

Feeds

Ver por

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

29 días hace | 1

Pregunta


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

29 días hace | 2 respuestas | 0

2

respuestas

Pregunta


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

6 meses hace | 1 respuesta | 0

1

respuesta

Pregunta


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

6 meses hace | 1 respuesta | 0

1

respuesta

Pregunta


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

9 meses hace | 0 respuestas | 0

0

respuestas

Pregunta


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

9 meses hace | 1 respuesta | 0

1

respuesta

Pregunta


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

alrededor de 1 año hace | 1 respuesta | 0

1

respuesta

Pregunta


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

más de 1 año hace | 0 respuestas | 0

0

respuestas

Pregunta


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

más de 1 año hace | 2 respuestas | 0

2

respuestas

Pregunta


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

más de 1 año hace | 1 respuesta | 0

1

respuesta

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

más de 1 año hace | 0

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

más de 1 año hace | 0

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

más de 1 año hace | 0

Pregunta


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

más de 1 año hace | 2 respuestas | 0

2

respuestas

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

más de 1 año hace | 0

Pregunta


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

más de 1 año hace | 1 respuesta | 1

1

respuesta

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

más de 1 año hace | 0

| aceptada

Pregunta


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

más de 1 año hace | 1 respuesta | 0

1

respuesta

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

más de 1 año hace | 0

Pregunta


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

más de 1 año hace | 0 respuestas | 0

0

respuestas

Pregunta


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

más de 1 año hace | 3 respuestas | 0

3

respuestas

Pregunta


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

más de 1 año hace | 1 respuesta | 0

1

respuesta

Pregunta


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

más de 1 año hace | 1 respuesta | 0

1

respuesta

Pregunta


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

casi 2 años hace | 1 respuesta | 0

1

respuesta

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

casi 2 años hace | 0

Pregunta


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

casi 2 años hace | 4 respuestas | 0

4

respuestas

Pregunta


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

casi 2 años hace | 2 respuestas | 0

2

respuestas

Pregunta


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

casi 2 años hace | 1 respuesta | 0

1

respuesta

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

casi 2 años hace | 0

| aceptada

Pregunta


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

casi 2 años hace | 1 respuesta | 0

1

respuesta

Cargar más