What this is for: Extracting bulk data from the NPI registry and downloading as CSV Requirements: Knowledge of JSON, Pandas dataframes Concepts covered: Making an API request, flattening JSON, combining dataframes Download: Download the Jupyter notebook If you work with health care provider data, you are no doubt familiar with NPI (National Provider Identifier) data. […]
What this is for: Querying Facebook’s ad library for political or issue ads and downloading results to .CSV Requirements: Verified Facebook ID, Facebook developer account, Basic understanding of APIs and Pandas dataframes In 2019, Facebook launched its Ad Library to improve transparency in advertising, allowing anyone to easily search ads that pages are running. While […]
One of my favorite parts of summer is Meadow Tea, a chilled tea brewed with fresh apple mint (mentha suaveolens). This is a fairly common drink in Pennsylvania Dutch areas, particularly among Mennonite and Amish communities. It’s definitely an acquired taste – most people either love it or hate it. I love it, so I’m […]
What this is for: Forecasting seasonal data Requirements: Python Anaconda distribution, Understanding of statistics and experience with machine learning Concepts covered: Calucating confidence intervals and forecasting future values with pmdarima library Download the Jupyter notebook One of the more helpful applications of data science to marketing is developing forecasts. You can use forecasts to predict […]
What this is for: Collecting comments from a public Facebook page and performing a basic content analysis Requirements: Python Anaconda distribution, basic understanding of HTML structure and Chrome inspector tool Concepts covered: Social listening, word clouds For anyone who works in strategic communications, it’s critical that you have a finger on the pulse of your […]
Google Analytics’ Demographics report can provide a wealth of valuable data about the users of your website, including age, gender, interests and affinity categories. One of the cool but lesser known features of Google Analytics is the ability to create pivot tables with your web data. In this quick tutorial, we’ll make a simple pivot […]
What this is for: Telling a Selenium web scraper to click on link or enter basic information into a form Requirements: Python Anaconda distribution, Basic knowledge of HTML structure and Chrome Inspector tool Concepts covered: Selenium Selenium is an incredibly useful tool for scraping websites with Python, but occasionally your scraper may need to interact […]