DATA_TRANSPOSE

Scripts to transpose data from long to wide formats in Java, PHP, Python, R, SAS, SQL, XSLT, and VBA (MS Access and MS Excel).

Using Google Doodles from 2010-2015 data, scripts read in attached yearly CSV files, aggregates data by distinct Year, Date, and Month, then transposes data into month columns.

REQUIREMENTS:

1. Java - core utilities and io packages (version 1.8+)
2. PHP - none (version 5+ core is only needed)
3. Python - pandas package
4. R - none (version 3+ base is only needed)
5. SAS - none (version 9.0+ base is only needed)
6. XSLT - xslt processor/script and attached xml file
7. SQL - ANSI-compliant relational database of imported table data
8. VBA - MS Office (Access/Excel) 2007+ installed