/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)

Primary LanguageJava

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