Data aggregation (sum, mean, min, max) scripts in Java, PHP, Python, R, SAS, SQL, XSLT, and VBA (MS Access/MS Excel)
Using U.S. Big Business 2014 yearly data (Wiki, Yahoo, Bloomberg sources) for seven industries (Banks, Financial Services, Food, Media, Oil & Gas, and Pharmaceuticals), scripts aggregate values across various metrics (revenues, assets, equity, net income, stock price, and employees).
REQUIREMENTS:
- Java - core utilities and io packages (version 1.8+)
- PHP - none (version 5+ core is only needed)
- Python - pandas package
- R - none (version 3+ base is only needed)
- SAS - none (version 9.0+ base is only needed)
- XSLT - xslt processor/script and attached xml file
- SQL - ANSI-compliant relational database of imported table data
- VBA - MS Office (Access/Excel) 2007+ installed