Community Profile

photo

Brian


Last seen: 6 months ago

Thrivent Financial for Lutherans

52 total contributions since 2011

Contact

Brian's Badges

  • Thankful Level 3

View details...

Contributions in
View by

Question


Matlab Clustering technique with textual data
Hi, I am trying to figure out the best way to cluster numeric information (stock returns) using a series of textual information....

3 years ago | 1 answer | 0

1

answer

Question


How do I efficiently make a large SQL query into Matlab?
I have a SQL table that contains data that I need for analysis which is about 60 million records and 5 fields. What is the best ...

5 years ago | 1 answer | 0

1

answer

Question


Why does Matlab add digits to a code generated vector?
I have a simple command that is creating a vector. Test = (51.7:.1:130)' I then iterate through this vector and use the valu...

5 years ago | 1 answer | 0

1

answer

Question


Table to Matrix from SQL Query
Hi, I have a large SQL query that is importing data into my workspace. I intend to create a data matrix and accompanying label v...

5 years ago | 0 answers | 0

0

answers

Question


Parallel Computing with hyper-threading
I run some of my programs via the parallel computing toolbox using a reasonably powerful machine (20 Cores) to accomplish long r...

5 years ago | 0 answers | 0

0

answers

Question


Spreadsheet LinkEX and datetime fields
Hi, I use the Spreadsheet Link EX to transfer data from Matlab to excel quite frequently. Since the datetime data type was intro...

5 years ago | 0 answers | 0

0

answers

Question


GRPSTATS and datetime columns
Hi, I use grpstats to calculate statistics by different variables often. The new datetime format is very useful and I have conve...

5 years ago | 1 answer | 0

1

answer

Question


grpstats flexibility for additional functions
Hi, I am just wondering if the grpstats function can be used with things other than the standard formulas listed on the help pag...

5 years ago | 1 answer | 0

1

answer

Question


Plot single vector from 3D array
I have a 5x5x150 3d array where I am saving a time series of correlations between variables. At the end of my code I'm attemptin...

5 years ago | 1 answer | 1

1

answer

Question


Slow or Laggy Matlab Workspace
Matlab has become unusually unresponsive when I allow it to sit for some time (a few hours to a few days). The type of slowness ...

5 years ago | 3 answers | 2

3

answers

Question


Join or Merge Data
Hi, I have two large cells that I need to effectively "JOIN" together via two fields (one text and one numeric). Say one cell ha...

6 years ago | 1 answer | 0

1

answer

Question


Help Optimize slow Datestr() function performance
I have imported a large text file with textual dates in the format m/d/yyyy. The end result that I need is a numeric date (for e...

6 years ago | 1 answer | 0

1

answer

Question


Fastest way to import single column?
I am attempting to import just a single column (a textual date field) from a large file with many columns and many rows. When I ...

6 years ago | 2 answers | 0

2

answers

Question


Export Data via fprintf printing something else besides NaN
Hi, I have a simple export loop that is writing the contents of a matrix to a text file for another system to read. The issue is...

6 years ago | 1 answer | 0

1

answer

Question


Fastest Way to write data to a text file - fprintf
I am writing a lot of date to a text file one line at a time (1.7 million rows, 4 columns) that is comprised of different data t...

7 years ago | 2 answers | 1

2

answers

Question


Matlab Slow Import using Import preview
I am using the Import function in Matlab to preview the file before import. The file I am importing is rather large (500 MB or s...

7 years ago | 1 answer | 0

1

answer

Question


Database toolbox query not returning all records
I have a fairly simply SQL query that I am running using the database toolbox connecting to a DB2 datasource. For some reason my...

8 years ago | 0 answers | 0

0

answers

Question


How Can I Speed Up My Code
I've got a job that is running a bunch of iterations on a large dataset and taking more time than I'd like. While I'd like to wr...

8 years ago | 2 answers | 0

2

answers

Question


Use eval statement to create Matrices with variables
I am having trouble with some seemingly basic eval syntax. I have a few variables in loops that I'd like to use to create the na...

8 years ago | 2 answers | 0

2

answers

Question


Create location Index from cell arrays
I have a small piece of code that loops through an array and creates an Index location of that value in another cell array. Acco...

8 years ago | 1 answer | 0

1

answer

Question


Importing Matrix from text or csv files
I have a large matrix that I'd like to import, preferably in one command into a few different Matlab variables. I have been atte...

8 years ago | 1 answer | 0

1

answer

Question


Enable Parfor or Vectorization
I'm looking for a faster way to calculate these loops. I've read some about vectorization on Loren's page but I'm not sure that ...

8 years ago | 0 answers | 0

0

answers

Question


Fast Export Method
I have always used the export command to export a dataset to a comma delimited text file. When the files get a little larger (50...

8 years ago | 1 answer | 0

1

answer

Question


Parfor Step
I am attempting to run a ParFor statement with a step function and Matlab is giving me an error "The range of a parfor statement...

8 years ago | 1 answer | 0

1

answer

Question


Matrix to Table format
I have a very large file that received in a matrix format. Because I'm going to write the data to a SQL database table I need to...

8 years ago | 1 answer | 0

1

answer

Question


Parfor Loops
I have the parallel computing toolbox but I have trouble writing loops in a manner that the toolbox likes. Can someone make a su...

8 years ago | 2 answers | 0

2

answers

Question


Scheduling a Matlab Script
I am attempting to schedule a Matlab job each day using the windows scheduler. I am having trouble getting it to run my m file. ...

8 years ago | 1 answer | 1

1

answer

Question


Matlab Database Toolbox
What is an easy way to create table joints using the querybuilder that is available for the database toolbox? I'm just looking f...

8 years ago | 2 answers | 0

2

answers

Question


Matlab Database Toolbox join
I am wrting a SQL query to pull a list of securities from a table that I am connecting to via ODBC connection. What I'd like to ...

8 years ago | 1 answer | 2

1

answer

Question


Import from .txt or .csv
I am importing some large .csv files where I have textual column headers and row headers. I am using the readtext() function fro...

8 years ago | 1 answer | 0

1

answer

Load more