Flagging Patterns in Request Lines

Problem

You are given a DataFrame `request_log` (loaded from `request_log.csv`) with columns `line_id`, `path_text`, and `service`. Each row holds one captured request path and the service that emitted it.

Compute four diagnostic flags for every row, based on its `path_text`:

- `is_api`: 1 if the path begins with `/api`.
- `is_versioned`: 1 if the path ends with `v1`, `v2`, or `v3`.
- `has_admin`: 1 if the path contains the substring `admin`.
- `has_double_slash`: 1 if the path contains three or more consecutive slashes (`///`).

Return every row together with the four flag columns (`line_id`, `path_text`, `service`, `is_api`, `is_versioned`, `has_admin`, `has_double_slash`), ordered by `line_id`.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 7 rows with the columns line_id, path_text, service, is_api, is_versioned, has_admin, has_double_slash.

Starter code (Pandas (Python))

import pandas as pd

def flag_request_lines(request_log) -> pd.DataFrame:
    # Your code here
    return request_log

Related Pandas questions

• 7-Day Rolling Signup AverageMedium
• Accounts Streaming From Two Devices at OnceMedium
• Agent Resolution RateMedium
• Agents With a Dominant Contact ChannelMedium
• Airbnb Popularity Bucket PricingMedium
• Amazon Unique Shipments per MonthMedium