From the course: Advanced Python in Excel: Machine Learning
Join today to access over 25,500 courses taught by industry experts.
Classification models for business data
From the course: Advanced Python in Excel: Machine Learning
Classification models for business data
- [Instructor] In this chapter, you will learn about classification models and how to apply them to business data. Classification models are used to categorize data into predefined classes based on input features. You will start again by loading your dataset with the function Excel. Then you'll need to import the necessary libraries, Pandas for data manipulation, scikit-learn for building and evaluating models and maplotlib and seaborn for data visualizations. In this case, you'll need to create a binary target variable. This creates a new column called HighValueOrder to indicate if an order store a value exceeds 500. These steps prepare the data for training a classification model to predict high value orders. Then you'll select features and the target variable. In this case, features are quantity, price, and discount, and the target variable is a high value order. Then you will split your data set into training and testing sets to train your model on one portion and validate its…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.