Pandas Categorical Data Tutorial
Use Pandas Categorical dtype to cut memory, speed up groupby, and encode ordered categories cleanly with practical conversion and pitfall notes.
1745 posts · page 25 of 37
Use Pandas Categorical dtype to cut memory, speed up groupby, and encode ordered categories cleanly with practical conversion and pitfall notes.
Hands-on pandas patterns for cleaning messy real-world data, covering missing values, types, duplicates, strings, and a reliable cleaning pipeline.
Master pandas groupby with single and multi-column aggregations, named outputs, transform, and filter for clean analytical pipelines.
Pick the right pandas combining function with clear examples of inner, outer, left, right joins, concat, and the gotchas that cause silent bugs.
Practical pandas speedups: vectorization, dtype tuning, categorical columns, eval/query, and chunked I/O patterns that turn slow scripts into responsive pipelines.
A practical guide to Pandas MultiIndex: when to use it, how it really works, and the slicing, stacking, and groupby patterns that make hierarchical data manageable.
Learn how to use pandas pivot_table to summarize, reshape, and aggregate data with multiple indexes, columns, and custom aggregation functions in real workflows.
A practical tour of the Pandas .str accessor: cleaning text, extracting patterns, splitting and joining, dealing with missing values, and writing string code that stays fast.
Work with datetime indexes, resampling, rolling windows, lag features, and timezone gotchas to analyze time series cleanly in pandas.
Use Pandas rolling, expanding, and ewm window functions to compute moving averages, running totals, and time-aware aggregations with clear examples.
Master async iterators in Node.js for streaming files, paginated APIs, and backpressure-aware data processing.
Learn how the Node.js cluster module forks worker processes to use every CPU core and how to share sockets between them safely.
Step through Node.js code with Chrome DevTools and VS Code by attaching to the built-in inspector, including remote and production debugging tips.
EventEmitter is the backbone of Node. Here are the patterns that make it useful in real systems and the mistakes that turn it into a footgun.
Compare Express and Fastify on performance, ergonomics, plugin model, and TypeScript support to pick the right HTTP framework for your project.
Read and write files in modern Node using fs/promises, and learn when to switch to streams for memory-friendly processing of large data.
Build a typed, high-performance gRPC server in Node.js with protobuf definitions, streaming RPCs, and production-ready patterns.
Implement graceful shutdown in Node.js services with signal handling, connection draining, and timeouts that survive real production deploys.
Find and fix memory leaks in Node.js using heap snapshots, sampling, and a few reliable patterns to avoid leaks.
Model MongoDB data in Node.js with Mongoose, covering schemas, validation, queries, population, and indexes for production apps.
Set up structured, high-performance logging in Node.js with Pino, including child loggers, redaction, and pretty-printing for development.
Understand when to reach for child processes, worker threads, or the cluster module to scale Node.js workloads.
Build a reliable background job system in Node.js using Redis and BullMQ, with queues, workers, retries, and scheduled jobs.
How Node.js streams really work, why backpressure matters, and how to compose readable, writable, and transform streams without blowing up memory.
Set up a clean, modern TypeScript project for Node.js with tsconfig, build scripts, ESM, and a dev loop that does not get in your way.
When to reach for worker_threads versus cluster in Node.js, with a clear mental model, real code, and the pitfalls that bite people in production.
Use Zod to validate and infer types for request payloads, environment variables, and external data in Node.js apps.
A field guide to the most common prompt engineering anti-patterns, why they degrade LLM output quality, and concrete refactors that fix each one.
How to build evaluation loops for prompts so you can iterate with evidence instead of vibes. Covers datasets, graders, regressions, and how to make eval cheap enough to run often.
How to coax LLMs into producing predictable, parseable output using output formatters, JSON schemas, examples, and validation loops that actually hold up in production code paths.
Decide between zero-shot and few-shot prompting by weighing example quality, cost, and how strictly you need to control output format.
Learn the ReAct pattern, a prompting technique that combines reasoning and action to build effective tool-using LLM agents.
Learn how self-consistency prompting samples multiple reasoning paths and aggregates answers to improve accuracy, with hands-on examples and trade-offs.
Write system prompts that steer model behavior reliably: role, format, constraints, refusals, and evaluation patterns that actually work.
Practical prompt engineering for building software with LLMs: structure, few-shot, chain-of-thought, role messages, and what actually moves quality.
Explore Tree of Thought prompting, which lets LLMs branch, evaluate, and backtrack through reasoning steps to solve problems chain-of-thought cannot.
How to write prompts and tool definitions that make function calling reliable. Covers schemas, descriptions, examples, error handling, and patterns for multi-tool agents.
Learn how chunk overlap rescues boundary context in RAG pipelines, with practical strategies for choosing overlap size and shape for different corpora.
Compare fixed-size, sentence, semantic, and structural chunking for retrieval augmented generation and pick the right one for your corpus.
An overview of document loaders in RAG pipelines, covering common formats, libraries, and how to choose the right loader for your data.
Measure RAG quality with recall@k, MRR, context precision, faithfulness, and answer relevancy so you can iterate on data, not vibes.
Graph RAG combines knowledge graphs with retrieval augmented generation to handle multi-hop questions and complex reasoning.
Combine lexical BM25 with dense vector search to recover the queries each method misses on its own and boost RAG retrieval quality.
Learn how Hypothetical Document Embeddings (HyDE) improve RAG recall by embedding a generated answer instead of the raw query, with examples and trade-offs.
How to use metadata filters in RAG to improve precision, scope retrieval, and enforce permissions without sacrificing recall.
Add a reranker on top of vector retrieval to dramatically improve top-k quality with cross-encoders, late interaction, and LLM rerankers.
Build self-query retrievers that translate natural language into structured metadata filters plus a semantic query for more precise RAG results.
Use LangSmith to trace, debug, and evaluate RAG pipelines step by step, from instrumentation to dataset replay and regression detection.