Tag: python

The Rise of Powerlifting in the United States: A Data-Driven Look at Trends and Patterns

Posted on

If are looking to hire an analytics professional, please send me a message at [email protected]. I am looking for new opportunities and available to start ASAP. sPowerlifting in the United States has seen explosive growth in recent years, both in popularity and participation. National federations like USA Powerlifting have reported a sharp increase in membership, with … Continue reading The Rise of Powerlifting in the United States: A Data-Driven Look at Trends and Patterns

Turning Data Into Awesome With sqldf and pandasql

Posted on 1 Comment on Turning Data Into Awesome With sqldf and pandasql

Both R and Python possess libraries for using SQL statements to interact with data frames. While both languages have native facilities for manipulating data, the sqldf and pandasql provide a simple and elegant interface for conducting tasks using an intuitive framework that’s widely used by analysts.             R and sqldf sqldf(“SELECT COUNT(*) FROM … Continue reading Turning Data Into Awesome With sqldf and pandasql

Extract Google Trends Data with Python

Posted on 1 Comment on Extract Google Trends Data with Python

Anyone who has regularly worked with Google Trends data has had to deal with the slightly tedious task of grabbing keyword level data and reformatting the spreadsheet provided by Google. After looking for a seamless way to pull the data, I came upon the PyTrends library on GitHub, and sought to put together some quick … Continue reading Extract Google Trends Data with Python

A Few Days of Python: Automating Tasks Involving Excel Files

Posted on 1 Comment on A Few Days of Python: Automating Tasks Involving Excel Files

There are plenty of instances where analysts are regularly forwarded xls spreadsheets and tasked with summarizing the data. In many cases, these scenarios can be automated through fairly simple Python scripts. In the following code, I take an Excel spreadsheet with two sheets, summarize each sheet using a pivot table, and add those results to … Continue reading A Few Days of Python: Automating Tasks Involving Excel Files

Homework during the hiring process…no thanks!

Posted on 16 Comments on Homework during the hiring process…no thanks!

Not too long ago, I was on the job market looking for work as an applied statistician or data scientist within the the online marketing industry. One thing I’ve come to expect with almost every company is some sort of homework assignment or challenge where a spreadsheet would be presented along with some guidelines on … Continue reading Homework during the hiring process…no thanks!