Web Log Mining of Server Log Data of ‘Counselling Website’ Using Microsoft Excel and Implementation of Preprocessing Algorithm
Main Article Content
Abstract
Web log mining is essential for the generation of useful patterns from web log data. Web log mining is an indispensable tool to improve website services and servers performance. It gives valuable information to website administrators for the advancement of performance of a website. Web log data mining is possible from a wide variety of available tools. We have introduced a method for web log mining using Microsoft Excel. In this paper we have used different features of Microsoft Excel like macros, pivot tables, filtering tools, graphical tools for preprocessing of web log data. A preprocessing algorithm is proposed for data cleaning of web log data using these features. These preprocessed web log files used for pattern discovery and pattern analysis. After data preprocessing various usage patterns generated to reveal actual behaviour of visitors at the time of traversal at website ‘rajeducon.com’. Various patterns are also generated for raw web log data using Microsoft Excel.
Downloads
Metrics
Article Details
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
