Logs Analysis-
-Project Description
-The purpose of the project is to do a log analysis of a given data for a news paper company -The script basically runs over a data and generates a report which comprises of following:
1)Three Most Popular Article with number of views 2)Most Popular Authors 3)Days when errors were more than 1% of overall days requests
-Requirements
It requires PostgreSQL, Python in order to run.
-Database Set-up
using this 'psql -d news -f newsdata.sql' you will be able to connect to datbase and run the sql file. get newsdata.sql https://d17h27t6h515a5.cloudfront.net/topher/2016/August/57b5f748_newsdata/newsdata.zip.
-How to run
In order to run you need to run python3 log_analysis.py