Ever since I realized I could export a WhatsApp group chat, I thought it would be cool to do a little analysis on the messages. Some of my best friends and I have been in a group chat since late 2014, October 20th, to be exact. Since then, a day hasn’t gone by where someone … Continue reading The group chat is LIT! Parsing WhatsApp with Python, R , & Tableau
Moving Files with Python
YouTube is one of my favorite resources on the Internet. While there are plenty of good blogs and articles related to data analysis and programming, there’s nothing like a good how-to video. A few weeks ago, YouTube suggested Corey Schafer’s channel to me. Corey has a bunch of great python and linux/mac videos and I’ve … Continue reading Moving Files with Python
Accessing Google Drive with R
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
