ParfaitG
With skillsets encompassing: general-purpose languages (Python, R); special-purpose (XSLT, SQL); statistical packages (SAS, Stata); relational databases
Chicago, IL
Pinned Repositories
DATA_GRAPH
Bar graph plotting with industry productivity data in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel)
DATA_MIGRATION
Binary, CSV, JSON, SQL, and XML data migration scripts in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel).
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)
DATABASE_CONNECTIONS
Java, PHP, Python, R, SAS, and VBA Scripts to connect to file level (SQLite, MS Access) and server level (MySQL, SQL Server) databases using various modules and ODBC drivers
GUI_Program
GUI report menu for data selection across multiple filters in Java, PHP, Python, R, SAS, and VBA (MS Access/Excel)
MEEKNESS
Multiple RDBMS and application project featuring meek fictional characters in literature, films, television, songs
RANDOM_DATA
Scripts to generate random data across various data types (int, character, numeric, boolean, date) and langauges (Java, PHP, Python, R, SQL, SAS, VBA)
TEXT_PARSE
Text parsing scripts using Regex in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel)
WEB_SCRAPING
HTML table download scripts in PHP, Python, R, SAS, MS Access/MS Excel
WORKSHOPS
Projects, demos, talks, and other materials
ParfaitG's Repositories
ParfaitG/DATA_MIGRATION
Binary, CSV, JSON, SQL, and XML data migration scripts in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel).
ParfaitG/WORKSHOPS
Projects, demos, talks, and other materials
ParfaitG/DATABASE_CONNECTIONS
Java, PHP, Python, R, SAS, and VBA Scripts to connect to file level (SQLite, MS Access) and server level (MySQL, SQL Server) databases using various modules and ODBC drivers
ParfaitG/GUI_Program
GUI report menu for data selection across multiple filters in Java, PHP, Python, R, SAS, and VBA (MS Access/Excel)
ParfaitG/TEXT_PARSE
Text parsing scripts using Regex in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel)
ParfaitG/WEB_SCRAPING
HTML table download scripts in PHP, Python, R, SAS, MS Access/MS Excel
ParfaitG/DATA_GRAPH
Bar graph plotting with industry productivity data in Java, PHP, Python, R, SAS, and VBA (MS Access and MS Excel)
ParfaitG/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)
ParfaitG/MSACCESS_TOOLKIT
Microsoft Access tool kit with modules for PDF forms, Outlook emails, Excel Pivot workbooks, XML transformation, and Custom Ribbon tab.
ParfaitG/RANDOM_DATA
Scripts to generate random data across various data types (int, character, numeric, boolean, date) and langauges (Java, PHP, Python, R, SQL, SAS, VBA)
ParfaitG/XSLT_TRANSFORM
XSLT scripts in Bash, C#, Java, Perl, PHP, Powershell, Python, R, SAS, and VBA
ParfaitG/DATA_AGGREGATION
Data aggregation (sum, mean, min, max) scripts in Java, PHP, Python, R, SAS, SQL, XSLT, and VBA (MS Access/MS Excel)
ParfaitG/DATA_STRUCTURES
Scripts overviewing data structures in Java, PHP, Python, R, SAS, and VBA
ParfaitG/DATA_VIDEOS
Materials used in YouTube channel data analytics videos
ParfaitG/FILE_SYSTEM_HANDLE
Scripts to copy, move, delete select or bulk files with command line arguments in Java, PHP, Python, R, and VBA
ParfaitG/GUI_Table
GUI menu to output tables across multiple filters in Java, PHP, Python, R, SAS, and VBA (MS Access/Excel)
ParfaitG/MEEKNESS
Multiple RDBMS and application project featuring meek fictional characters in literature, films, television, songs
ParfaitG/PDF_OUTPUT
Scripts for CSV data processing to PDF reports in Java, PHP, Python, R, SAS, and VBA.
ParfaitG/2021-n01-Rebooting-LightningTalks-OpenMic
Please join us in rebooting the Chicago R User Group with an evening of lightning talks and an open mic, live and in person!
ParfaitG/311_SERVICE_REQUESTS
Data Analysis reports and maps of City of Chicago's 311 Service Requests, 2011 - 2016 written in SAS.
ParfaitG/AndBiodiversity
Informational website written in RMarkdown on the biodiversity loss crisis
ParfaitG/COM_Interface
Microsoft Office COM Interface implementation and automation in R, Python, and PowerShell
ParfaitG/DIVVY_TRIPS_ANALYSIS
Tabular and graphical analysis of Chicago's Divvy Bike Sharing Program (2013-2016) by Stations using Python
ParfaitG/LIBRARY_ANALYSIS
Graphical and table data analysis of Chicago and SWAN Public Libraries using R
ParfaitG/pandas
Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more
ParfaitG/ParfaitG.github.io
Personal website for ParfaitG showcasing data analytics projects