Tag: projects
-
How Much Time Do you Spend in Meetings?
In this post, I’ll analyze my Google Calendar events to see exactly how much time I spend in meetings each week.
-
Analyzing COVID-19 Data
I’ll be analyzing COVID-19 data in a Jupyter Notebook for this post.
-
How I use Salesforce as a Simple Campaign Outreach Tool
The Salesforce Campaign object is a great way to bucket contacts for mass outreach. However, there are limited ways to actually getting contacts assigned to a campaign. In this project, I’ll discuss the Salesforce limitations and how I can get around them using the Salesforce API and Python.
-
How to Export a Pandas DataFrame to an HTML Table and Add Custom Styling or CSS Classes
Using the built-in Pandas function to export a DataFrame to an HTML table is quick way to export your DataFrame but it does has some limitations. Using a for loop to create your HTML table allows you to add any custom styling or CSS classes for enhanced formatting. In this post, I’ll walk you through…
-
How to use Google Sheets as a Basic Web Scrapper
Easily and automatically capture data from websites using some built-in functionality in Google Sheets.
-
How to Calculate a Net Promoter Score (NPS) using Python
The Net Promoter Score has become a popular way to analyze survey data. Instead of calculating a straight average for 0 through 10 scores, scores are bucketed into Detractors, Passives, and Promoters. In this post, I’ll use the Net Promoter Score methodology and apply it to a dataset of raw scores using Python.
-
How to Automatically Create a Series Subplots from a DataFrame using a For Loop in Python
I have found that using a For Loop to create a series of subplots allows for greater flexibility to customize the individual plots compared to using the Pandas plot function. In this post, I’ll show you how to use a For Loop to create individual subplots and axes variables from a single Pandas DataFrame.
-
Essential Excel shortcuts
The hallmark of any great investment banking analyst is the ability to navigate Excel without a mouse. In this post, I’ll walk you through the most frequently used Excel shortcuts and some of my favorites. Any Excel user can benefit from these.
-
Analyzing COVID-19 Data in Python
In this post I’ll walk through pulling COVID-19 data, cleaning it, and then visualizing it.
-
Sending an HTML Formatted Email with Attachments through Gmail using Python
In this post, I will walk through sending HTML formatted emails with inline images and attachments.