President Donald Trump is known to tweet a lot. This blog will look at Trump’s tweeting habits in 2019. First we must import the necessary libraries. The code below uses Twint to scrape all the tweets from Donald Trump’s twitter page from 2019. …

This blog is a continuation of my last two blogs. Speechiness Spotify defines Speechiness as follows: Speechiness detects the presence of spoken words in a track. The more exclusively speech-like the recording (e.g. talk show, audio book, poetry), the closer to 1.0 the attribute value. Values above 0.66 describe tracks that…

This blog is a continuation of my last blog, Using SQL to Investigate Spotify’s Top Songs: Part 1.If you have not read it, now would be a good time to look at it as it includes the necessary libraries needed for download and how to convert a csv file to a sqlite data table. This blog will continue a SQL investigation of the top songs on Spotify in August of 2019. The data used in this investigation can be downloaded here.

This blog is an SQL investigation of the top songs on Spotify in August of 2019. The data used in this investigation can be downloaded here. To begin, the necessary libraries must be downloaded. Next, the csv file, ‘top50.csv’ must be read as a pandas data frame. The headers were…

There are a few ways to collect tweets from Twitter. You can use the Twitter API but the Twitter API limits the number of tweets you can collect. You can manually scrape the tweets you want but this can be time consuming. Another option is to use Twint. Twint is…

When it comes to evaluating how well a model performs there are multiple metrics that can be used. To choose the evaluation metric to best evaluate your model, it is vital that you understand what each metric calculates. …

Data cleaning is an important step in the data science process. Without cleaning data, results from analyses can be inaccurate. Cleaning data will lead to better analytics and improve decisions and insights derived from the data. The data set that is used in this blog is the kc_house_data from https://www.kaggle.com/shivachandel/kc-house-data…

What is A Python Dictionary A Python dictionary is a data type that holds a collection of key-value pairs. A dictionary is similar to a list, but instead of each element containing a single value, each element is a key-value pair. Another difference between a dictionary and a list is that the contents of a…

This tutorial will be a brief introduction to INDEPENDENT SUBQUERIES. A SUBQUERY is a query inside a query. An INDEPENDENT SUBQUERY is a subquery that can be run on its own, without the main subquery. We will be using the Football Delphi database, which can be downloaded here. If you…