Data Preprocessing: SQL vs. Python

Raw data could be messy and inconsistent. Before any meaningful insights can be generated, the first thing we need to do is to clean and explore the data, which leads us to the important question: what tool should we use to facilitate this crucial step? Generally speaking, there are two Continue reading Data Preprocessing: SQL vs. Python

Bridging the Gap: How Learning a Foreign Language Can Enhance Your Programming Skills

computer code

Like many students at the Institute, I completed the PCEP (Entry Level Python Programmer) certification, which solidified my grasp of Python programming fundamentals. However, my programming journey is far from over. While strengthening my coding skills, I have noticed many similarities between learning a programming language and a foreign language. Continue reading Bridging the Gap: How Learning a Foreign Language Can Enhance Your Programming Skills

Reframing Learning Programming

cartoon people. First person says Do you have any practice coding? Second person responds: No, but I'm skilled at looking over someone's shoulder and reminding them that they forgot a semicolon.

In a 2022 survey of 1,000 United States students conducted by KX, 58% consider coding vital to future success. The desire to learn coding has exploded in popularity over the years, but learning a new programming language can feel daunting. You could be a student applying to the IAA, nervous Continue reading Reframing Learning Programming

Learning SAS With Baseball Data, Where Process > Results

Last Monday marked the beginning of the “bootcamp” portion of the MSA program. Aside from two communications classes and preparing for a group presentation, the first week of bootcamp mainly consisted of learning and applying statistical concepts and the SAS programming language. As a member of the orange summer cohort, Continue reading Learning SAS With Baseball Data, Where Process > Results