Save hours of browsing through the Internet and accelerate your workflow with code-ready templates for your programming projects. Personally crafted by 365 Data Science instructors, these templates will bring a surprising level of efficiency to your work process.

TemplatesSQL

Default Constraint in SQL Template

The Default Constraint in SQL template shows you how to assign a default value to a column in a table. If no other value is specified it will be added to all new records. Download and unzip the .zip file in a new folder. Inside the folder you will find a .sql file. Load it into MySQL Workbench. Some other related topics you might be interested are Primary Key Constraint in SQL, Not Null Constraint, and Unique Constraint.
You can now download the SQL template for free.
Default Constraint in SQL is among the topics covered in detail in the 365 Data Science program.

The Unique Constraint in SQL template shows you how to assign a UNIQUE KEY constraint to a table, used to avoid any duplicates and ensure unique values in the column. Download and unzip the .zip file in a new folder. Inside the folder you will find a .sql file. Load it into MySQL Workbench. Some other related topics you might be interested are Primary Key Constraint in SQL, Not Null Constraint, and Default Constraint.
You can now download the SQL template for free.
Unique Constraint in SQL is among the topics covered in detail in the 365 Data Science program.

The Cross Join in SQL template shows you how to take the values from a certain table and connects them with all the values from the tables we want to join it with. Download and unzip the .zip file in a new folder. Inside the folder you will find a .sql file. Load it into MySQL Workbench. Some other related topics you might be interested are Inner JOIN in SQL, Left JOIN in SQL, and Right JOIN in SQL.
You can now download the SQL template for free.
Cross JOIN in SQL is among the topics covered in detail in the 365 Data Science program.

The Right Join in SQL template shows you how to create a new instance of a table combining rows that have matching values from two tables plus all values from the right table that match no values from the left one. Download and unzip the .zip file in a new folder. Inside the folder you will find a .sql file. Load it into MySQL Workbench. Some other related topics you might be interested are Inner JOIN in SQL, Left JOIN in SQL, and Cross JOIN in SQL.
You can now download the SQL template for free.
Right JOIN in SQL is among the topics covered in detail in the 365 Data Science program.

The Left JOIN in SQL template shows you how to create a new instance of a table combining rows that have matching values from two tables plus all values from the left table that match no values from the right one. Download and unzip the .zip file in a new folder. Inside the folder you will find a .sql file. Load it into MySQL Workbench. Some other related topics you might be interested are Inner JOIN in SQL, Right JOIN in SQL, and Cross JOIN in SQL.
You can now download the SQL template for free.
Left JOIN in SQL is among the topics covered in detail in the 365 Data Science program.

The Scatter Plot with ggplot2 in R includes a color scheme from the Wes Anderson movie palette. The chart displays the relationship between the price and area of houses from a property data set. A scatter plot is one of the most widely used charts in statistics and data analytics. It shows a collection of data points across two axes, signifying two categories of the data we wish to compare. Some other related topics you might be interested are Bar chart with ggplot2 in R, Histogram with ggplot2 in R, Regression Scatter Plot with ggplot2 in R, and Line Chart with ggplot2 in R.
You can now download the R template for free.

The Exploring Data Skewness in R template shows whether the observations in a data set are concentrated on one side. Here you can see examples of three different data skews implemented in R - right skewness, zero skewness and left skewness. Some other related topics you might be interested in exploring are Calculating Data Variance in R, Calculating Data Median in R, Calculating Standard Deviation of data in R.
You can now download the R template for free.
Calculating Data Median in R is among the topics covered in detail in the 365 Data Science program.

The following Calculating Data Median in R template shows the mean, also known as the simple average. We can find the mean of a data set by adding up all of its components and then dividing them by the number of components contained in the data set. Some other related topics you might be interested in exploring are Calculating Data Variance in R, Calculating Data Median in R, Calculating Standard Deviation of Data in R and Exploring Data Skewness in R.
You can now download the R template for free.
Calculating Data Median in R is among the topics covered in detail in the 365 Data Science program.

The following Stacked Area Chart with ggplot2 in R template shows the popularity of different engine types in automobiles across several decades. An area chart is used when we are interested in tracking and comparing the volume of a few variables over time. In a stacked area chart each category is ‘stacked’ or ‘placed’ on top of the previous and there is no overlap among categories. Some other related topics you might be interested in exploring are Line Chart with ggplot2 in R, Bar Chart with ggplot2 in R, Pie Chart with ggplot2 in R and Scatter Plot with ggpot2 in R.
You can now download the R template for free.
Stacked Area Chart with ggplot2 in R is among the topics covered in detail in the 365 Data Science program.

The following For Loops in R shows how to calculate the sum of the numbers from 1 to 10 using a for loop. For loops are one of the most commonly used tools by any programmer and they are used when we want to repeat an action in the loop for a certain number of times. Some other related topics you might be interested in exploring are While Loops in R and If Else Else If statements .

The following Creating a Data Frame Object in R template shows you how to create a data frame in R from scratch and populate with different values. The example shows a car data frame, containing 5 columns, 3 of which are numeric and 2 of which are strings. You can use this template to create and fill out your own data frame. Some other related topics you might be interested to explore are Calculating Data Variance in R, Calculating Data Mean in R, Calculating Standard Deviation of Data in R, Exploring Data Skewness in R.
You can now download the R template for free.
Creating a Data Frame Object in R is among the topics covered in detail in the 365 Data Science program.

This Stacked Area Chart in Excel template displays the use of different fuel types from the year 1975 to 2016 for used cars. The chart is created with the stacked area chart in Excel. For completion a 100% stacked version of the chart is shown.
Some other related topics you might be interested to explore are Pie Chart in Excel, Line Chart in Excel, and Scatter Plot in Excel.
You can now download the Excel template for free.
Stacked Area Chart is among the topics covered in detail in the 365 Data Science program.

This Dealing with Missing Data in R template shows you how to check for missing values in a dataset and count them. It also provides two ways of dealing with missing values in a dataset - either by substituting the missing values with the average, or by removing the entries which have missing values in them.
Some other related topics you might be interested to explore are correlation between two variables in R, export data as csv in R, calculating data median in R, calculating data mean in R, and calculating standard deviation of data in R.
You can now download the R template for free.
Dealing with missing data in R is among the topics covered in detail in the 365 Data Science e-learning program.

A line chart is often used when we want to chronologically track the changes in value of a variable over a period of time and identify existing patterns and trends. Therefore, the line chart is often applied in financial statements, weather forecasts, stock market analysis and experiment statistics reports. This free .xlsx template displays the S&P 500 and Footsie indices for the second half of the economically devastating 2008 on a line chart

Linear Regression with statsmodels in Python Template

The following Linear Regression with Statsmodels in Python free .ipynb template shows how to solve a simple linear regression problem using the Ordinary Least Squares statsmodels library. We are going to examine the causal relationship between the independent variable in the dataset - SAT score of a student, and the dependent variable -the GPA score. This database is read with the help of the pandas library. Download and unzip the .zip file in a new folder. Inside the folder you will find a .csv and a .ipynb file. The first one contains the database and the second one contains the Python code. Open the .ipynb file using Jupyter notebook.

Calculating Standard Deviation of Data in R Template

This free .r template will show you how to calculate the standard deviation of data using the R programming language. The standard deviation is obtained by taking the square root of the variance of the data. It is used in many statistical analyses, whenever we have numerical data and is a measure of data dispersion. The standard deviation shows how closely data sits around the mean – a small value shows data, which is densely populated around the mean, a large standard deviation signifies data which is more dispersed.

Joins are the SQL tools that allow us to work with data from multiple tables simultaneously relying on the logical relationship between their objects. The INNER JOIN clause, in particular, creates a new instance of a table that combines rows with matching values from two tables. Thus, null values, or values appearing only in one of the tables, will not be extracted. In this free sql template you will be applying the SQL Inner Join clause on a set of business department tables.

Developed in the 1970s by a group of IBM researchers, SQL continues to be the most popular programming language for relational database management and is used by companies like Facebook to store mounts of user data. None of this would be possible without the foundation of the SQL language- the database. That is the place where information is organized into tables and can be accessed, manipulated, and retrieved in any desired way. Consider this as the very first step in your SQL journey as this free sql template will show you how to make a SQL database in MYSQL.

SQL is specifically designed to help you navigate through large amounts of structured data, modifying, retrieving, and creating new tables out of it. The having clause works in conjunction with common aggregate functions like min, max, ave, count and sum, and allows you to filter and return group results that meet the specified conditions. In this free sql template, you will apply the having clause to display salaries that are higher than a certain value in ascending order.

A box and whiskers chart graphically represents the distribution of data through their quartiles. It is often used in financial settings when analyzing the market volatility and can reveal the skewness of data or potential outliers. Тhis free .r template goes over the Titanic’s data set using the ggplot2 library in R, revealing interesting insights about e the survival rate based on age and sex. By following the outlined steps in this R template, you will learn how to convey the information professionally using the ggplot2 functionalities.

Check out our most helpful downloadable resources according to 365 Data Science’s students and expert team of instructors.

Templatespython

Linear Regression with statsmodels in Python Template

The following Linear Regression with Statsmodels in Python free .ipynb template shows how to solve a simple linear regression problem using the Ordinary Least Squares statsmodels library. We are going to examine the causal relationship between the independent variable in the dataset - SAT score of a student, and the dependent variable -the GPA score. This database is read with the help of the pandas library. Download and unzip the .zip file in a new folder. Inside the folder you will find a .csv and a .ipynb file. The first one contains the database and the second one contains the Python code. Open the .ipynb file using Jupyter notebook.

A box and whiskers chart graphically represents the distribution of data through their quartiles. It is often used in financial settings when analyzing the market volatility and can reveal the skewness of data or potential outliers. Тhis free .r template goes over the Titanic’s data set using the ggplot2 library in R, revealing interesting insights about e the survival rate based on age and sex. By following the outlined steps in this R template, you will learn how to convey the information professionally using the ggplot2 functionalities.

Developed in the 1970s by a group of IBM researchers, SQL continues to be the most popular programming language for relational database management and is used by companies like Facebook to store mounts of user data. None of this would be possible without the foundation of the SQL language- the database. That is the place where information is organized into tables and can be accessed, manipulated, and retrieved in any desired way. Consider this as the very first step in your SQL journey as this free sql template will show you how to make a SQL database in MYSQL.

A line chart is often used when we want to chronologically track the changes in value of a variable over a period of time and identify existing patterns and trends. Therefore, the line chart is often applied in financial statements, weather forecasts, stock market analysis and experiment statistics reports. This free .xlsx template displays the S&P 500 and Footsie indices for the second half of the economically devastating 2008 on a line chart

Feature Selection Through Standardization with sklearn in Python Template

The following Feature Selection Through Standardization with sklearn in Python template shows how to solve a multiple linear regression problem with two continuous features. These features are standardized using a StandardScaler() object. After fitting the model to the scaled data, we construct a summary table in the form of a dataframe. It stores the features as well as their biases and weights (the machine learning jargon for intercepts and coefficients). The irrelevant features are automatically penalized by a small magnitude of the weight. Such a procedure is known as feature scaling through standardization. Open the .ipynb file using Jupyter notebook. Another related topics is Feature selection through p-values with sklearn in Python. You can now download the Python template for free.
Feature Selection Through Standardization with sklearn in Python is among the topics covered in detail in the 365 Data Science program.

Pie charts are one of the most popular data visualization tools since they express the part-to whole relationship of a dataset in a very intuitive manner. As such they are best used when we want to communicate for example the revenue of each product and its relationship to the whole. The following free. xlsx template shows an Excel pie chart, displaying the number of cars using a particular type of fuel.

Joins are the SQL tools that allow us to work with data from multiple tables simultaneously relying on the logical relationship between their objects. The INNER JOIN clause, in particular, creates a new instance of a table that combines rows with matching values from two tables. Thus, null values, or values appearing only in one of the tables, will not be extracted. In this free sql template you will be applying the SQL Inner Join clause on a set of business department tables.

Feature Selection Through p-values with sklearn in Python Template

The following Feature Selection Through p-values with sklearn in Python template shows how to solve a multiple linear regression problem using the machine learning package sklearn. Based on the p-value of each feature, we can determine whether it is useful or irrelevant. Download and unzip the .zip file in a new folder. Inside the folder you will find a .csv and a .ipynb file. The first one contains the database and the second one contains the Python code. Open the .ipynb file using Jupyter notebook. Some other related topics are Feature selection through standardization with sklearn in Python.

Check out our most helpful downloadable resources according to 365 Data Science’s students and expert team of instructors.

Templatespython

Linear Regression with statsmodels in Python Template

The following Linear Regression with Statsmodels in Python free .ipynb template shows how to solve a simple linear regression problem using the Ordinary Least Squares statsmodels library. We are going to examine the causal relationship between the independent variable in the dataset - SAT score of a student, and the dependent variable -the GPA score. This database is read with the help of the pandas library. Download and unzip the .zip file in a new folder. Inside the folder you will find a .csv and a .ipynb file. The first one contains the database and the second one contains the Python code. Open the .ipynb file using Jupyter notebook.

A box and whiskers chart graphically represents the distribution of data through their quartiles. It is often used in financial settings when analyzing the market volatility and can reveal the skewness of data or potential outliers. Тhis free .r template goes over the Titanic’s data set using the ggplot2 library in R, revealing interesting insights about e the survival rate based on age and sex. By following the outlined steps in this R template, you will learn how to convey the information professionally using the ggplot2 functionalities.

Developed in the 1970s by a group of IBM researchers, SQL continues to be the most popular programming language for relational database management and is used by companies like Facebook to store mounts of user data. None of this would be possible without the foundation of the SQL language- the database. That is the place where information is organized into tables and can be accessed, manipulated, and retrieved in any desired way. Consider this as the very first step in your SQL journey as this free sql template will show you how to make a SQL database in MYSQL.

A line chart is often used when we want to chronologically track the changes in value of a variable over a period of time and identify existing patterns and trends. Therefore, the line chart is often applied in financial statements, weather forecasts, stock market analysis and experiment statistics reports. This free .xlsx template displays the S&P 500 and Footsie indices for the second half of the economically devastating 2008 on a line chart

Feature Selection Through Standardization with sklearn in Python Template

The following Feature Selection Through Standardization with sklearn in Python template shows how to solve a multiple linear regression problem with two continuous features. These features are standardized using a StandardScaler() object. After fitting the model to the scaled data, we construct a summary table in the form of a dataframe. It stores the features as well as their biases and weights (the machine learning jargon for intercepts and coefficients). The irrelevant features are automatically penalized by a small magnitude of the weight. Such a procedure is known as feature scaling through standardization. Open the .ipynb file using Jupyter notebook. Another related topics is Feature selection through p-values with sklearn in Python. You can now download the Python template for free.
Feature Selection Through Standardization with sklearn in Python is among the topics covered in detail in the 365 Data Science program.

Pie charts are one of the most popular data visualization tools since they express the part-to whole relationship of a dataset in a very intuitive manner. As such they are best used when we want to communicate for example the revenue of each product and its relationship to the whole. The following free. xlsx template shows an Excel pie chart, displaying the number of cars using a particular type of fuel.

Joins are the SQL tools that allow us to work with data from multiple tables simultaneously relying on the logical relationship between their objects. The INNER JOIN clause, in particular, creates a new instance of a table that combines rows with matching values from two tables. Thus, null values, or values appearing only in one of the tables, will not be extracted. In this free sql template you will be applying the SQL Inner Join clause on a set of business department tables.

Feature Selection Through p-values with sklearn in Python Template

The following Feature Selection Through p-values with sklearn in Python template shows how to solve a multiple linear regression problem using the machine learning package sklearn. Based on the p-value of each feature, we can determine whether it is useful or irrelevant. Download and unzip the .zip file in a new folder. Inside the folder you will find a .csv and a .ipynb file. The first one contains the database and the second one contains the Python code. Open the .ipynb file using Jupyter notebook. Some other related topics are Feature selection through standardization with sklearn in Python.