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…Nov 29, 2020Nov 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…Nov 22, 2020Nov 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…Nov 21, 2020Nov 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…Nov 9, 2020Nov 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…Nov 3, 2020Nov 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.Nov 1, 2020Nov 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…Oct 29, 2020Oct 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…Oct 28, 2020Oct 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…Oct 27, 2020Oct 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…Oct 22, 2020Oct 22, 2020