Using excel for data mining (7) ---- filling data from examples, excel Data Mining

Using excel for data mining (7) ---- filling data from examples, excel Data Mining

After configuring the environment, you can use excel for data mining.

For environment configuration problems, see:

Http://blog.csdn.net/xinxing__8185/article/details/46445435

Example DMAddins_SampleData.xlsx

File: http://download.csdn.net/detail/xinxing__8185/8780481

 

In the data table, select the table analysis tools sample table, which displays user information statistics, including marital status, gender, income, children, education level, occupation, and house ownership, number of vehicles, area of residence, age, and whether bicycles have been purchased.

 

Hover the mouse over the data in the table, and an additional tab is displayed.

 

The sample filling tool extends the example in a partially filled column to all rows in the table. This tool uses the professional knowledge of some rows added to the table to fill in the top-up in the new column. It detects the association mode between the original column value and the information added by the user and extends these modes to all the remaining rows. This tool generates a mode report in the new worksheet, indicating the detected mode. This mode can be improved by adding more professional knowledge and re-running this tool.

 

Select Table Fill From Example

Select sample Filling

Click to run

Generated mode report:

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.