MIKE ARMISTEADGANs: Generative Adversarial NetworksGenerative adversarial networks (GANs) can be used to help train a deep network model. What GANs can do is use the information that it…2 min read·Nov 29, 2020----
MIKE ARMISTEADBoostingMy last blog I explained bagging and now it’s time to discuss boosting, another method used in ensemble methods. The difference between…1 min read·Nov 22, 2020----
MIKE ARMISTEADEnsemble Methods and Random ForestsEnsembles is an algorithm that uses more than one model to make a prediction. The reason that this is a popular method is because idea…2 min read·Nov 21, 2020----
MIKE ARMISTEADUsing Google Cloud Platform and BigQuery with Jupyter NotebookI recently took a deep dive in the rabbit hole that is SQL. As I was practicing and mastering my query skills a practice problem talked…2 min read·Nov 9, 2020----
MIKE ARMISTEADExcel for Data AnalysisI am on the job hunt and talked to multiple data analysis to see what they think is most used on the job. Most of them said Python…2 min read·Nov 3, 2020----
MIKE ARMISTEADAltering and Updating SQL tablesNow there is a full database but you want to update some old rows. We will also use a WHERE operator to make sure we only do it to one row.2 min read·Nov 1, 2020----
MIKE ARMISTEADSQL JoinsCross join-both table name after from. This is the worst way to join tables because there are duplicate rows. The reason for this is…1 min read·Oct 29, 2020----
MIKE ARMISTEADAdvance SQL Cheat SheetThis is part 2 of my SQL cheat sheet. Part one for basics such as building tables, adding values and simple queries can be found here. Now…2 min read·Oct 28, 2020----
MIKE ARMISTEADBasic SQL cheat sheetI have been looking for a new job for a while now and every job post I see requires SQL. I try to review it every couple of days to stay…2 min read·Oct 27, 2020----
MIKE ARMISTEADPreparing data of Foreign Exchange Rate for Time Series ModelI have been working on a model that can predict the exchange rate for the Australian and US Dollar. The first thing I did was get my data…3 min read·Oct 22, 2020----