Skip to content

vvkvivekl/Logs-Analysis-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 

Repository files navigation

Version Control with Git

This is the repo for Udacity's Logs Analysis Project. In the project, we have created software where analyzer can run command instead typing query.

This repo contains the source code of a Logs Analysis project.

Table of Contents

Instructions

  • Set-up Instructions

    1. Create the news database in PostgreSQL
      • From the command line, launch the psql console by typing: psql
      • Check to see if a news database already exists by listing all databases with the command: \l
      • If a news database already exists, drop it with the command: DROP DATABASE news;
      • Create the news database with the command: CREATE DATABASE news;
      • exit the console by typing: \q
    2. Download the schema and data for the news database:
    3. Unzip the downloaded file. unzip newsdata.zip.
      • You should now have an sql script called newsdata.sql.
    4. From the command line, navigate to the directory containing newsdata.sql.
    5. Import the schema and data in newsdata.sql to the news database by typing: psql -d news -f newsdata.sql
  • Installation (Run program)

  • clone the project
  • open terminal in project Dir.
  • go in news Dir. using cd news in terminal
  • run python newsdb.py
  • Usage

  • type numeric values and hit enter
  1. What are the most popular three articles of all time?
  2. Who are the most popular article authors of all time?
  3. On which days did more than 1% of requests lead to errors?
  4. exit

Output

Creators

Required software:

  • Python

About

Logs Analysis Project - Udacity

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages