Skip to content

panmpan17/UdacityLogsAnalysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 

Repository files navigation

UdacityLogsAnalysis

Purpose

Analyze date from Postgres database which from a fictional website.

To find out the questions beblows:

  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?

Database Structure

authors

  • id
  • name
  • bio

articles

  • id
  • title
  • slug
  • lead
  • body
  • author
  • time

log

  • id
  • ip
  • method
  • path
  • status
  • time

Requirement

Execute

execute $ psql -d news -f newsdata.sql

execute $ python main.py

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages