How a Jumia Product Dataset Was Cleaned and Turned Into an Excel Dashboard

·19 views

A data analyst built an interactive Excel dashboard to examine product trends on Jumia, one of Africa's largest e-commerce platforms, using a scraped dataset of 115 products. The raw data required significant cleaning, including stripping currency symbols from price fields and extracting numeric ratings from descriptive text strings. Derived columns for price, discount, and rating categories were created using nested IF formulas to make the data analysis-ready. A key finding during cleaning was that roughly half the product listings lacked review counts or ratings, flagged as a data-quality gap affecting pricing and merchandising decisions. The project aimed to answer practical business questions around the relationship between discounts, ratings, prices, and customer engagement.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Git Worktrees Offer a Clean Fix for Running Multiple Coding Agents in Parallel

Developer Andrew Pyle describes how running two AI coding agents simultaneously on the same project caused conflicts when both edited files in a shared directory. His initial instinct to coordinate agents through locks or queues proved flawed, as adding more agents only multiplied the coordination complexity. The cleaner solution, he argues, is eliminating shared state entirely rather than managing access to it. Git's built-in worktree feature allows each agent to operate in its own isolated checkout on a separate branch, all sharing one underlying object store without duplicating full repository history. This approach keeps setup costs low, scales easily to many parallel agents, and simplifies merging once each agent's work is complete.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How accidental robots.txt and sitemap changes silently hurt your search rankings

Two common SEO mistakes — deploying a staging robots.txt that blocks all crawlers and losing sitemap sections after a plugin update — often go unnoticed by site owners because they don't affect the visitor experience. Search engines, however, detect these changes gradually, and the resulting drop in organic traffic may only become visible in reports weeks later. Developers are advised to monitor key files like robots.txt, sitemap.xml, and ads.txt for unexpected changes, and to add automated smoke tests to their deployment pipelines. A sample bash script can flag potential de-indexing signals — such as a broad Disallow directive or a suspiciously small sitemap — immediately after each deploy. For controls embedded in HTML markup or HTTP headers, complementary tools like Google Search Console or scheduled site crawlers are recommended alongside file-change monitors.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How to Monitor Web Page Changes Without Building a Custom Scraper

Tracking updates on web pages — such as registration notices, pricing tables, or government announcements — can be done without writing custom scraping code. The first step is checking whether the page already offers an RSS or Atom feed, which is the simplest and most reliable monitoring method. For server-rendered pages, basic text-monitoring tools work well, while JavaScript-heavy pages may require browser-based monitors like Visualping or changedetection.io. Users can reduce false alerts by targeting specific page sections and avoiding dynamic elements like timestamps or view counters. Monitoring solutions range from free browser extensions and self-hosted scripts to paid hosted services, each offering different trade-offs between cost and technical effort.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

TypeSafe Launches Jev, an AI Model Built to Make Decisions, Not Generate Text

TypeSafe AI has introduced Jev, which it calls a System One model, designed to output structured decisions that software can consume directly rather than generating human-readable prose. Unlike traditional large language models that produce token sequences, Jev works by evaluating predefined decision options and returning typed outputs such as classifications, ranked scores, or calibrated probabilities. The model supports three core decision primitives: selecting from a fixed set of options, scoring on an ordered scale, and returning a yes/no probability for binary decisions. TypeSafe argues that many software tasks — such as routing, sentiment classification, guardrails, and escalation logic — do not require a generated explanation, only a reliable structured answer. The launch raises a broader architectural question about whether AI pipelines need a dedicated, lightweight decision layer separate from reasoning and generative models.

0 comments Read more at DEV Community