About
Blog
Contact
How to encode categorical variables ready for machine learning
Find out how to deal with categorical variables when using machine learning.
#Python
#HowTo
Chart rebranding challenge
Check out the before and after versions of my Lego branded bar chart.
#SWDchallenge
#Excel
How to write a Pandas dataframe to an SQLite table
Use SQLite to create a permanent copy of your dataframe.
#Python
#SQL
#HowTo
How to combine Python Lists Into a Pandas Dataframe
Lists are useful, but they are not easy to analyze.
#Python
#HowTo
Exporting Multiple Pandas Dataframes to Excel
Getting dataframes into Excel can be a bit trickier than expected.
#HowTo
#Python
#Excel
Ryanair - a Love-hate Relationship
What insights can we get by analysing customer reviews?
#SWDchallenge
#Python
#Excel
Scraping Trustpilot Reviews with Python
Use the Beautiful Soup package for HTML scraping.
#Python
#HowTo
The progression of world GDP - China vs. the U.S.
Decluttering and focusing global GDP charts.
#SWDchallenge
#Excel
Which Marketing Channels Do Customers Use Before Buying?
Visualize the customer journey using a Sankey Diagram
#SWDchallenge
#Tableau
How to Explode Arrays with Presto
Find out how to give each element of an array its own row
#SQL
#HowTo
How to Join DataFrames with PySpark
Learn how to use the join() DataFrame method
#Python
#HowTo
Tableau Data Blending Saved Me Two Days' Work!
Using a data blend to add metrics to your dashboard
#Tableau
««
«
1
2
3
»
»»