Full course · free on YouTube · 49 min

Python script to analyze log files: free, 49 minutes

One live workshop recording of about 49 minutes, published in August 2021. It introduces Python and Apache access logs, then walks through a demo script that parses a log file to CSV and analyses it with pandas.

22 chapters · published 19 Aug 2021 · 8,057 views as of 20 Nov 2026 · by Skill-Lync

Free. We ask for your name and phone once before it plays here · or watch on YouTube ↗

Who is this course for?

Computer science students and beginners who want to see a worked example of analysing web server logs with Python and pandas.

What will you learn?

  • What the common and combined Apache log formats contain, field by field
  • Why a text log is converted to CSV before analysis
  • Which Python libraries the demo uses and what each is for
  • How the demo parses a log file into a CSV with an Apache log parser library
  • How pandas group-by produces status-code, host, referrer and endpoint counts
  • How the demo charts errors per day and Googlebot mobile versus desktop hits

What does each part of the course cover?

6 sections, in watching order. Click a timestamp to jump the player there. The video description has no chapter list, so these chapters and timestamps were written from the video itself.

  1. 0:0011 min · 5 chapters

    Python background and why it is used

    The instructor outlines the agenda, then introduces Python: its origin and open-source licence, the reasons it is easy to start with (readability, interpretation, automatic memory management, lists and dictionaries, portability) and the application areas it is used in.

    Chapters
    • 0:00Welcome, agenda and what the workshop covers
    • 2:15Python background: origin, name and open-source licence
    • 3:14Why Python is popular: readability, quick development, object orientation, integration
    • 5:57Essential features: no compile step, no declarations, automatic memory management, built-in data types, portability
    • 8:22Where Python is used: AI and machine learning, data science, web, testing, desktop GUIs
  2. 11:0911 min · 5 chapters

    Installing Python and reading Apache access logs

    Shows the Windows installer and the add-to-PATH option, then explains what Apache access logs record, where they sit on a Linux server, and the fields of a line in the common and combined log formats, using one example line (get request for random.png, status 200).

    Chapters
    • 11:09Installing Python on Windows and adding it to PATH
    • 12:48What Apache access logs are and where they are stored
    • 15:12Why websites keep logs: debugging a crash
    • 15:57Common log format: the fields of one log line
    • 19:43Combined log format: referrer and user agent
  3. 21:466 min · 2 chapters

    Why logs are analysed

    Lists the uses the instructor sees for log analysis: understanding the audience, spotting suspicious activity, geographic traffic, performance and security, tracing failed transactions and planning bandwidth. The percentages quoted are illustrative examples, not results from the demo data.

    Chapters
    • 21:46Why analyse logs: audience, visitor activity, geography, performance, security
    • 26:22Transaction analysis and bandwidth planning from logs
  4. 27:5610 min · 4 chapters

    Libraries and parsing the log file to CSV

    Names the libraries used (Apache log parser, pandas, seaborn, matplotlib, NumPy), then walks through the PyCharm project: imports, a function that reads the log file line by line, parses it with the combined format and writes a CSV, and the run that produced 10,000 rows.

    Chapters
    • 27:56Libraries used in the demo: Apache log parser, pandas, seaborn, matplotlib, NumPy
    • 30:25Code structure: PyCharm, imports and the log-to-CSV function
    • 34:35Loading the CSV into a pandas data frame and preparing columns
    • 36:28Running the parser in PyCharm and creating the CSV
  5. 38:068 min · 4 chapters

    Analysing the CSV with pandas and charts

    Runs the analyses on the sample data: status-code counts on a log scale, top hosts, referrers and endpoints, non-200 URL paths, unique hosts and errors per day, and Googlebot hits split between mobile and desktop. Most use pandas group-by.

    Chapters
    • 38:06Status code analysis with group-by and a log-scale chart
    • 40:02Top hosts, referrers, endpoints and URL paths with non-200 status
    • 42:16Unique hosts per day and errors per day
    • 44:13Googlebot hits: share of traffic and mobile versus desktop
  6. 46:113 min · 2 chapters

    Evolution in analysis and career paths

    Closes with the instructor's view of where analysis is heading (machine learning, natural language processing, big data, recommendation systems) and the job areas the instructor links to Python, such as testing, development, server programs and AI.

    Chapters
    • 46:11Evolution in analysis: machine learning, NLP, big data, recommendations
    • 47:48Career paths and job areas for Python

Is the Python Script to Analyze Log Files course really free?

Yes. All 49 min of it is free on Skill-Lync's YouTube channel, with no payment. To watch it on this page with the chapter guide, leave your name and phone number once; you can also watch it directly on YouTube. It was published on 19 Aug 2021 and had 8,057 views as of 20 Nov 2026. This page adds the chapter guide, a study plan and what to learn next.

How long does the Python Script to Analyze Log Files course take to finish?

The video runs 49 min across 22 chapters. At one hour a day that is about 1 days; plan roughly twice that if you practise each exercise as you go. The longest section is "Python background and why it is used" (11 min), so give it its own days.

Does the free Python course come with a certificate?

The video description has a "claim your certificate" link, which now opens this page. To ask about a certificate for this course, leave your name and phone number in the form below and a Skill-Lync counsellor will call you back. The paid Skill-Lync courses linked here include a certificate along with mentor-reviewed projects.

What should I learn after this course?

The next step is Data Structures and Algorithms using Python (free lessons), then Core and Advanced Python Programming (₹40,000), then Post Graduate Program in Data Analytics and Data Science (₹2,75,000). The free course teaches the concepts; the paid Skill-Lync courses add graded projects, mentor feedback and, in the PG programs, placement support.

Do I need to know Python before watching this log analysis workshop?

The instructor says basic Python knowledge helps but is not required, and covers an introduction to Python, its features and installation first. The demo then uses third-party libraries (an Apache log parser, pandas, seaborn, matplotlib and NumPy), shown in PyCharm, so some programming background will make the code easier to follow.

What is the difference between Apache common and combined log format?

The workshop explains that the combined format has the same fields as the common format plus two more: the referrer (the page that linked to the requested file) and the user agent (the browser and operating system of the client). The instructor says most websites use the combined format.

What does the Python log analysis demo show?

It parses a sample Apache access log into a CSV of 10,000 entries, loads it into a pandas data frame and plots status-code counts, top hosts, referrers and endpoints, unique hosts and errors per day, and the split of Googlebot mobile and desktop hits.

Last updated 20 Nov 2026 · Course length, chapters, views and dates from the YouTube video on 20 Nov 2026 · Grow by Skill-Lync: free lessons from every course

Finished the course?

Ask about the certificate or your next course.

Leave your name and phone number. A Skill-Lync counsellor calls you back within one working day about the certificate for Python Script to Analyze Log Files and the course that fits where you want to work.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.

Free full course · Skill-Lync

Start watching

Free, no payment. Leave your name and phone once and the whole Python Script to Analyze Log Files course plays here, with every free lesson on Grow. A Skill-Lync counsellor may call you about the certificate or your next course.

By submitting you agree to our Terms and Privacy Policy.

Talk to a career counsellor

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.