About
Blog
Contact
Python and SQL
<< Home
How to check the accuracy of your classification model
Introduction to accuracy score, confusion matrix, and F1-score.
#Python
#HowTo
How to build a decision tree model with scikit-learn
A step-by-step guide to building a classification model with scikit-learn.
#Python
#HowTo
How to split your data into train and test sets
Get confidence your model works by testing on a test set.
#Python
#HowTo
How to encode categorical variables ready for machine learning
Find out how to deal with categorical variables when using machine learning.
#Python
#HowTo
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
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
How to Aggregate Data with PySpark
Learn how to group your data and create summaries in PySpark
#Python
#HowTo
««
«
1
2
»
»»
