I recently purchased a Mac as my personal machine. While working on my “Intermediate” Excel posts, I found myself needing to create and manipulate some sample data. Without Microsoft Excel and not wanting to shell out even more money for software, I turned to the next best of option: Google Sheets. Let’s face it, no … Continue reading Accessing Google Drive with R
“Intermediate” Excel With Python
In my last post, I shared some examples of "Intermediate” Excel functions in R, focusing on pivot tables and Vlookup. This week, I’m going to look at the same skills but in Python. While R and Python have some similarities, they certainly have their differences as well. I’ll try to point out the subtle differences … Continue reading “Intermediate” Excel With Python
“Intermediate” Excel with R
Before finding my home at Fetch, I looked over tons of Job Descriptions. With everything becoming “data driven” these days, every role requires some familiarity with data and Microsoft Excel. I remember many of them requiring “Intermediate” skills, more specifically, pivot tables and Vlookup. While Excel is a solid starting point for organizing and manipulating … Continue reading “Intermediate” Excel with R
Pesky Date Formats
If you’ve worked with Excel and/or with data for a while, you’ve probably dealt with pesky date formats. Dates come in a variety of makes and models including “d/m/y”, “mm/dd/yy”, “yyyy-mm-dd” and on and on. There’s nothing worse than opening Excel, applying filters, then dropping the filter menu down to find that Excel is reading … Continue reading Pesky Date Formats
As you set out to learn a new skill, it’s often to difficult to pinpoint where you need to begin. Many times we do not know what we don’t know. Having read many articles discussing the skills needed for successful Data Analysts, I know tools like SQL, R, and Python are heavily used in the … Continue reading Twitter
Scheduling R Scripts on Windows
When I first started hearing and learning about R, it was presented to me as more of a “statistical language.” Admittedly, my statistical knowledge is still growing and I questioned whether learning R would be useful for me. However, as I dove in, I quickly learned that R is a powerful tool for many tasks … Continue reading Scheduling R Scripts on Windows
IN and Subqueries
I’d like to share my current favorite SQL "combo," if you will. The database I use on a daily basis is designed such that there are several main tables that hold IDs and metrics followed by several tables that act as libraries and hold the values that are paired with each ID. Here is a … Continue reading IN and Subqueries
