AI Time Estimates for Coding Tasks

Take a messy, inconsistently formatted business expense spreadsheet and redesign it as a normalized relational database schema with proper tables, keys, and relationships.

Write Python code that parses JSON API responses, loads data into PostgreSQL, and includes error handling and logging.

Configure a GitHub Actions workflow that automatically runs tests, builds the Node.js project, and deploys it on every push to the main branch, including secrets management and deployment target integration.

Debug and refactor a slow Python data processing script, adding type hints and improving efficiency

Write Python code to ingest messy CSV files of customer transaction data, remove duplicate rows, and handle missing values using appropriate strategies (drop, fill, interpolate, etc.).

Build a Python web scraper for Zillow real estate listings that extracts, normalizes data, and computes price-per-square-foot statistics grouped by neighborhood

Containerise an existing Python web application using a multi-stage Dockerfile to separate build and runtime stages, and a docker-compose.yml for local development with volume mounts, environment variables, and service orchestration.

Writing PostgreSQL SQL queries to calculate user retention metrics and build cohort analysis tables, covering concepts such as date-truncated cohort assignment, week-over-week or month-over-month retention rates, and the self-joins or window functions needed to track user activity across time periods.

Write Python code to parse CSV files, clean missing data, and generate statistical summaries with visualizations

Debug and refactor a Python/pandas CSV processing script: identify performance bottlenecks, fix bugs, and optimize for speed and maintainability.

Build a Python web scraper targeting 10 e-commerce sites to extract competitor pricing data and persist results to a database. Requires per-site selector engineering, anti-bot mitigation, data modeling, and ongoing maintenance as sites change.

Debug and fix a Python script that processes image metadata and returns null values inconsistently

Write Python code to scrape real estate listings from a target website, parse structured fields (price, location, features), and export results to a CSV file. Complexity varies significantly depending on whether the site uses server-side HTML vs. JavaScript rendering, paginated results, and anti-bot protections.

Build a Python web scraper that collects product reviews from an e-commerce site and runs NLP-based sentiment analysis on the results

Debug a Python function that sorts a list of dictionaries by multiple nested keys incorrectly. Involves reading existing code, identifying the sorting logic bug (likely key extraction, nested access, or comparator ordering), and writing a verified fix.

Build a Python ETL script to extract customer transaction data from PostgreSQL, apply transformations, and load into a data warehouse

Write Python code to scrape weather data from a public API and generate daily forecasts in JSON format

Write a Python script that reads one or more CSV files, normalizes date columns to a consistent format, and flags rows that share the same email address or phone number as potential duplicates.

Build a Python script that calls a weather API (e.g. OpenWeatherMap), retrieves forecast data for 5 major cities, and generates readable weekly summary reports from that data.

Write Python code to scrape and parse real estate listing data from a website and organize it into a structured database