Presented code offers an extended example of combining Matlab and MySQL, in which we look at the single-week, all-files FEX download data made available in FEX submission 'A week on FEX', asking:
(a) what is the intraweek/intraday pattern of FEX download activity? (Admittedly, we have a single observation to rely on).
(b) which category's files were downloaded most over the week? (It's the last time you beat 'Statistics and probability', 'Wireless communications').
(c) which contributor's submissions were in greatest demand? (I knew it without crunching the numbers, Doug).
(d) which contributor poses the most determined challenge to The Hull Supremacy? :) (You inspired me, Nawaz).
(See attached images for details).
We use Yannick Maret's mym Matlab/MySQL interface to communicate with the database; mym download link is provided in FEX submission 'Access a MySQL database', linked to below.
Cite As
Dimitri Shvorob (2024). Analyze FEX download data (https://www.mathworks.com/matlabcentral/fileexchange/17718-analyze-fex-download-data), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Acknowledgements
Inspired by: Hodrick-Prescott Filter, Retrieve online content with Matlab
Inspired: A week on File Exchange, Access a MySQL database
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 | BSD |