Yellow cover of Train and Test Split with sklearn in Python. This template resource is from 365 Data Science.
Templates python

Train and Test Split with sklearn in Python Template

Hristina Hristova

Hristina Hristova

Head of Data Content
The Train and Test Split with sklearn in Python template shows how to prevent overtraining of the machine learning algorithm by using the convenient train_test_split() method provided by sklearn to split a database into two parts - a training and a testing dataset. Some other related topics you might be interested are Regression Summary Table with sklearn in Python, Feature Selection through p-values with sklearn in Python, Feature Selection through Standardization with sklearn in Python, Predictions with Standardized Coefficients with sklearn in Python. You can now download the Python template for free. The Train and Test Split with sklearn in Python template is among the topics covered in detail in the 365 Data Science program.
Hristina Hristova

Hristina Hristova

Head of Data Content

Who is it for

This is an open-access Excel template that is going to be very helpful for Data Scientists, Data Analysts, Business Analysts and anyone who wants to know how to calculate the correlation in Excel.

How it can help you

The idea of a machine learning algorithm is that it learns from a set of training examples. We then test the knowledge of the model by feeding it new, unseed test data. Usually, raw data is not served to us with labels training and testing. This we need to do ourselves and the following template aims to help you with the task.

Most Popular Templates

Check out the best online resources for data science according to our students and expert team of instructors—available to download and use for free.

Data Science Shortcuts Cheat Sheet
Templates theory

Data Science Shortcuts Cheat Sheet

Discover how to boost your productivity using this data science shortcuts cheat sheet with over 2,000 workarounds in Python IDEs, such as Jupyter, Spyder Rodeo, PyCharm, and Atom, compatible with various operating systems. Amplify your proficiency in R with R Studio shortcuts, streamline MATLAB operations, and manage databases efficiently with SQL shortcuts.     Enhance data visualization in Tableau, easily manage Excel spreadsheets, and conduct statistical analyses seamlessly in SPSS and SAS. This data science shortcuts cheat sheet lets you speed up your everyday tasks while achieving your goals.

Learn More
Yellow cover of Obtaining Descriptive Statistics about the Data in Python. This template resource is from 365 Data Science.
Templates python

Obtaining Descriptive Statistics about the Data in Python

The following template demonstrates how to obtain an overview about the dataset. It shows the application of the .describe() method on a pandas Series object. Some other related topics you might be interested in are Delivering an Array with the Unique Values from a Dataset in Python, Converting Series into Arrays in Python, Ordering the Rows from a Data Table According to the Values in a Column in Python, Data Selection in Python, and Common Attributes for Working with DataFrames in Python. The Obtaining Descriptive Statistics about the Data in Python template is among the topics covered in detail in the 365 Program. 

Learn More
Green Cover of Normal Distribution in Excel . The template resource is from 365 Data Science.
Templates excel

Normal Distribution in Excel Template

This Normal Distribution in Excel template demonstrates that the sum of 2 randomly thrown dice is normally distributed. Open the .xlsx file with Microsoft Excel. Study the structure of the file and experiment with different values. Some other related topics you might be interested to explore are Positive Skew in Excel, Zero Skew in Excel, Negative Skew in Excel, Uniform Distribution in Excel, Standard Normal Distribution in Excel You can now download the Excel template for free. Normal Distribution in Excel is among the topics covered in detail in the 365 Data Science program

Learn More
Yellow cover of Common Attributes for Working with DataFrames in Python. This template resources is from 365 Data Science.
Templates python

Common Attributes for Working with DataFrames in Python

The following template demonstrates the application of important pandas attributes when cleaning, preprocessing, and analyzing a dataset. Some other related topics you might be interested in are Data Selection in Python, Indexing with.iloc[] and .loc[] in Python, Delivering an Array with the Unique Values from a Dataset in Python, Converting Series into Arrays in Python, and Using Pandas Methods for Working with Series Objects in Python. The Common Attributes for Working with DataFrames in Python template is among the topics covered in detail in the 365 Program. 

Learn More
Green Cover of Histogram in Excel. This template resource is from 365 Data Science Team.
Templates excel

Histogram in Excel Template

This Histogram in Excel includes a sample dataset, a frequency distribution table constructed from this dataset, and 2 histograms visualizing the data - one representing frequency and a second one representing relative frequency. Some other related topics you might be interested to explore are Pie Chart in Excel, Line Chart in Excel , Bar and Line Chart in Excel and Stacked Area Chart in Excel. You can now download the Excel template for free. Histogram in Excel is among the topics covered in detail in the 365 Data Science program.

Learn More
Yellow Cover of Linear Regression with Statsmodels in Python. This template resource is from 365 Data Science.
Templates python

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.

Learn More
Yellow cover of Confusion Matrix with statsmodels in Python. This template resource is from 365 Data Science.
Templates python

Confusion Matrix with statsmodels in Python Template

In this Confusion Matrix with statsmodels in Python template, we will show you how to solve a simple classification problem using the logistic regression algorithm. Then, we will create a python confusion matrix of the model using the statsmodels library and make the table more beautiful and readable with the help of the pandas library. Some other related topics you might be interested in are Logistic regression with statsmodels in Python, Logistic Regression Curve in Python, Model Accuracy in Python. You can now download the Python template for free. The Confusion Matrix with statsmodels in Python template is among the topics covered in detail in the 365 Data Science program.

Learn More
Green cover Correlation in Excel. This template resource is from 365 Data Science.
Templates excel

Correlation in Excel Template

The Correlation in Excel template demonstrates how the correlation coefficient can be calculated in Excel. Some other related topics you might be interested in are Calculating the Variance in Excel, Standard Deviation in Excel, Coefficient of Variation in Excel, Covariance in Excel. You can now download the Excel template for free. The Correlation in Excel template is among the topics covered in detail in the 365 Data Science program.

Learn More
Templates python

Train and Test Split with sklearn in Python Template

Yellow cover of Train and Test Split with sklearn in Python. This template resource is from 365 Data Science.