Toggle navigation
Erik Rood
About
Contact
Projects (chronological)
Find-me - Connecting advertisers with content creators
Storyrake - Receive email summaries covering your favorite subreddits
Data Interview Q's - Get better at data science interviews with a few questions per week
Database of email newsletters seeking advertising
Weekly newsletter with useful coding tips/tricks, covering automation, API integrations, and data analysis/visualization, with a focus on Python.
Articles
Of the largest 500 public companies, the Tobacco industry generates the highest net income per employee
Salary distribution in sports
Understanding the price-earnings (P/E) ratio
Walking is 3 times more expensive than driving, from a fuel (calories vs. gas) perspective
Interconnectedness of companies
Corporate effective tax rates
Printing cost [calculator]
Why the Dow Jones is useless
ROI of college vs. stock market
Income divide
Free time [calculator]
'Fair value' of a stock [calculator]
Calculating 'fair value' of a stock - methodology
Exponential decay of caffeine for popular beverages
Python Snippets
Dropping rows/columns from a Pandas dataframe
Import (or export) data from CSV into (or out of) a Pandas dataframe
Rename Pandas dataframe columns
Find and replace characters in Pandas dataframe columns
Create a new column in Pandas dataframe
Merge two dataframes together in Pandas
Create a pivot table from a Pandas dataframe
Slice a string in python (right, left, mid equivalents)
Connecting python to Google Sheets and pushing a Pandas dataframe to a worksheet
Generate current time in python
Web scraping with python using Beautiful Soup
Select rows from a Pandas DataFrame based on values in a column
Convert strings to lower and uppercase in Python
Convert to number to float, int, and string in Python
Concatenate two arrays (lists) in Python
Get row and column count for Pandas dataframe
Iterating over rows in Pandas dataframe
Change the order of columns in Pandas dataframe
Break a long line into multiple lines in Python
Replace all NaN values with 0's in a column of Pandas dataframe
If and else statements in Python
Create and run a function in Python
Convert column in Pandas dataframe to a list
Sort a dataframe in Pandas based on multiple columns
Count the frequency a value occurs in Pandas dataframe
Open a browser url using Python
For loop in Python
Extract month and year from column in Pandas, create new column
Drop duplicate rows in Pandas based on column value
Get the # of columns in a Pandas dataframe
Select Pandas dataframe rows between two dates
Add new column to Pandas dataframe with default value
Import data from MongoDB to Pandas
Generate a scatter plot using Seaborn in Python
Generate a scatter plot using Matplotlib in Python
Generate a bar chart using Matplotlib in Python
Get the mean and median from a Pandas column in Python
Convert a list of Python dictionaries to a Pandas dataframe
Check whether a Python string contains another string
Remove NaN values from a Pandas series
Concatenate Pandas dataframes (like a union function in SQL)
Enter your email to be notified when I write something ~1x/month