With SQL you may need to create a table within your database for your analysis. Using the SQL CREATE TABLE command makes it easy. Here I will show you the command to create a table using MySQL. CREATE TABLE table_name (column_name column_type); This is a generic command that you can…

After creating your repository in Github how do you get your changes and update on it? After all, Github is not really a blog site where you click upload or edit, except for a few things, like the README. Often projects that are posted on Github are worked on via…

A database management system (DBMS) makes retrieving, manipulating, and managing data much more easily with SQL instead of just running it straight from the shell. The DBMS usually automatically keeps the data organized for you when it come to files and record structure. Different types of DBMS’s are: MySQL, PostgreSQL…

Feature selection is a term in machine learning for variables. When we test a model we want to know which variables affect it the most. This is what has a very big impact on your model. After data cleaning, feature selection should be a must when beginning your project. Choosing…

Microsoft Excel is a great source for analyzing data especially utilizing a feature called Macros. If you do repetitive tasks in excel, a macro is helps you save it and be able to apply that certain task to other to be used in the future. It is a wonderful time…

Excel for Data Analysis Excel is not just for keeping track of bills or a place to type phone numbers in to. It is a great tool for data analytics that can do a lot. You can run calculations on it and process large amounts of data. …

A correlation heatmap is graphical representation using color gradients to show a relationship between variables. The values are represented in colors in a gradient. The stronger the color between two variables, the more correlation there is. Whereas, the lighter the gradient, Correlation is between -1 and 1. In addition to…

JOIN clauses are what link two tables together and there are a few in SQL worth knowing. These clauses link the tables easily and efficiently. For this article, I will list the four types of JOIN clauses so you can get an idea of them. Inner Join: retrieves matching values…

A Confusion matrix is useful to test the performance of your classification model in machine learning. It will tell you the true positive, false positive, true negative, and true positive. It is used to measure the performance of a classification model. The give a a good idea of a model’s…