The Ultimate Guide to Eric’s Articles
All my content organized by topic…

Introduction
Hi, I’m Eric! I love creating coding tutorials, blogging about professional development, and inspiring others to check out data science. I typically write four articles a month, so follow me to stay up to date with my content! Below are all my articles categorized by Primary Topic.
Connect with me!
LinkedIn Twitter Instagram erickleppen.com
Topics
Plotly & Dash
SQL & Databases
Natural Language Processing
Finance & Trading
Professional Development
Data Science & Programming
Personal Essays
Plotly Dash (Dashboards) (Programming) (Business Intelligence) (Web Development)
I am a huge Dash advocate and run pythondashboards.com. If you’re New to the Dash framework by Plotly, start here! My latest Dash project is commanderdeals.com. A website I built completely using Python thanks to Dash!
Dashboards in Python for Beginners and Everyone Else using Dash
How to Setup User Authentication for Dash Apps using Python and Flask
How to Start a Business in an Afternoon Using Python and Dash
How to Create a Dashboard to Dominate the Stock Market Using Python and Dash
Dashboards in Python: 3 Advanced Examples for Dash Beginners and Everyone Else
Dashboards in Python Using Dash — Creating a Data Table using Data from Reddit
Dashboards in Python for Beginners using Dash — Responsive Mobile Dashboards with Bootstrap CSS…
Dashboards in Python for Beginners using Dash — Exporting Data from a Dashboard
Dashboards in Python for Beginners using Dash — Live Updates and Streaming Data into a Dashboard
The Easiest Way to Host a Multi-page Dashboard using Python, Dash, and Linux for Beginners
Bookmark my website, pythondashboards.com to stay up to date with new tutorials.
SQL & Relational Databases
I use SQL and databases daily in my profession and hobbies. If you’re a beginner start with the first article. Advanced users, check out some of my optimization tips!
Learn SQL Techniques: Selecting Data and More in SQL Server
Write Better SQL in 5 Minutes — Introduction to Dynamic SQL
Natural Language Processing (NLP) (Data Science) (Programming)
I am fascinated by NLP and have used tons of python libraries for various projects. Check out my tutorials to get started with natural language processing in Data Science!
3 Super Simple Projects to Learn Natural Language Processing using Python
Try TextHero: The Absolute Simplest way to Clean and Analyze Text in Pandas
Ultimate Beginners Guide to Collecting Text for Natural Language Processing (NLP) with Python — …
Simple Sentiment Analysis for NLP Beginners and Everyone Else using VADER and TextBlob
The Simple Approach to Word Embedding for Natural Language Processing using Python
Using Python to Analyze the Brutal Lyrics of The Black Dahlia Murder with Genius API, SpaCy…
Analyzing Wine Descriptions using the Natural Language Toolkit in Python
How to Vectorize Text in DataFrames for NLP Tasks — 3 Simple Techniques
K-Means Clustering Chardonnay Reviews using Scikit-Learn & NLTK
Generating Wine Recommendations using the Universal Sentence Encoder
Professional Development (Communication) (Writing) (Business) (Public Speaking)
My position involves a lot of communication skills like public speaking and writing. Check out my tips to become a legendary communicator. I cover everything from finding love to climbing the corporate ladder.
My 7 Rules for Getting Ahead in the 9–5 World
The Free and Simple Way to Promote Your Content
4 Tips for Finding Success as a New Product Analyst in Data Science
How a Degree in Writing Helped Me get a Job in Data Science
Stand Out! Leadership and Communication Skills for Analysts, Data Scientists, and Everyone Else
The Business Side of Data Science: 5 Tips for Presenting to Stakeholders
The Six Ways to Make People Like You — & How to Apply Them
The Strategy I used to Beat Online Dating and Find a Wife
Three Simple Lessons that Changed My Life in My 20's
What Have You Failed at Today? Three Things I Gave Up or Failed in order to Succeed
When I stopped Procrastinating
Your Articles DO NOT Need to be Brilliant to Make Money Online
The Four Principles that Transformed My Writing into Content that Earns Money
How to Avoid Giving Up — Overcome these 2 Reasons People Quit
Finance (Stocks) (Trading) (Options)
I have been trading stocks and options for around six years. I’ve written some tips for trading. I also write about using API and Python to collect market data.
The One Question Every Trader Needs to Ask
5 Things Every New Options Trader Should Know
Become a Consistent and Profitable Trader — Two Rules
Collect Stock and Options Data Easily using Python and Ally Financial API — 3 Example Queries
Embracing Manual Data Collection
Investing for my Future during the COVID Pandemic: One of the Lucky Ones
Data Science (Programming) (Analytics) (Cloud)
I started exploring data science, analytics and programming a couple years ago. I currently work on the Data Science team at Infinite Campus as a Software Product Analyst.
Why did I Ever Get Into Data Science?
Enter Analytics: From Boot Camp to working in Data Science
Three Data Science Technologies to Explore while you Self-Isolate: What are Docker, Airflow and…
Exploratory Data Analysis using Python. A Beef Jerky Data set
My Trick to Learning List Comprehensions in Python
Python Pandas Library for Beginners: A Simplified Guide for Getting Started and Ditching…
Using FunctionTransformer and Pipeline in SkLearn to Predict Chardonnay Ratings
A Simple Git Workflow for Github Beginners and Everyone Else
Affordable Options for Hosting Your Data Science Projects
Building a Cardboard Empire: Introduction to the TCGplayer API using Python
Create a Free Linux Virtual Machine on your Computer for Data Science Projects using VirtualBox…
Personal Essays (Comedy) (Sci-fi) (Gaming) (Politics)
I love writing! My background is technical writing and I hold a B.S. in Scientific and Technical Communication from the University of Minnesota.
I Drank Two Colas A Day for Breakfast for More Energy — & Here’s What Happened
When will we Live Forever? An Essay on the Tech bringing us Closer to Immortality
The Rise of American Anti-Leadership and its Neo-Marxist Response
Three Amazing Free-to-Play Video Games to try during Quarantine
Remember to follow and check back! Thanks for checking out my content!