Tagged articles
groupby
36 articles · Page 1 of 1
This article benchmarks seven common pandas tasks—arithmetic, conditional mapping, dictionary lookup, string cleaning, group aggregation, binning, and query/eval—showing how vectorized alternatives can speed up loops by up to 7,000× and offering practical guidance on when each technique delivers meaningful gains.
NumPyPandasbenchmark
0 likes · 12 min read

The article shows why a naïve Pandas groupby on a 25‑million‑row DataFrame can take 40 minutes, identifies common performance killers, and demonstrates that converting the grouping column to the categorical dtype with observed=True and sort=False reduces runtime to about 4 seconds while also cutting memory usage dramatically.
PandasPythoncategory dtype
0 likes · 7 min read

This article walks through practical Python data‑analysis steps for vehicle telemetry, covering data import, time‑based calculations, SOC efficiency metrics, speed binning, group aggregation, common coding pitfalls, and tips for clean, reproducible analysis using pandas.
PandasSOCTime Series
0 likes · 8 min read

This article walks through a real‑world Pandas question, showing the original dataset, the expected output, and two concise code solutions—one using groupby with unique strings and another with set conversion—plus a performance comparison.
code-exampledata-processinggroupby
0 likes · 4 min read

This article demonstrates six different Pandas techniques to group the values in a DataFrame column and reorder them according to their original appearance, providing complete code examples, execution results, and concise explanations for each method.
data-manipulationgroupby
0 likes · 6 min read

This article walks through a common Python data‑processing challenge—grouping numeric identifiers with corresponding strings—by presenting five distinct Pandas‑based solutions, complete with code snippets and visual results, enabling readers to efficiently transform raw lists into organized dictionaries.
Code ExamplesPythondata processing
0 likes · 8 min read

This article walks through a real‑world Python data‑analysis question, showing two practical Pandas solutions—one using groupby with custom string handling and another simpler approach—to deduplicate records while preserving preceding approval comments.
data-cleaningdeduplicationgroupby
0 likes · 4 min read

This tutorial walks you through pandas fundamentals—including reading CSV/Excel files, creating Series and DataFrames, performing basic operations, cleaning data, using loc/iloc indexing, grouping, concatenating, merging, and handling time series—providing code examples and visual outputs for each step.
Time Seriesdata cleaninggroupby
0 likes · 14 min read

This article walks through a real‑world Python data‑cleaning task where duplicate workflow IDs must be removed without losing earlier approval comments, presenting two pandas‑based solutions with code examples and detailed explanations.
data cleaningduplicate removalgroupby
0 likes · 4 min read

This tutorial teaches how to use the Pandas library's groupby method to group data by one or multiple columns and apply aggregation functions such as sum, mean, max, and min, with clear code examples and a practical exercise.
Pythondata aggregationdata analysis
0 likes · 4 min read

This article explains the challenges of high‑cardinality GroupBy operations, describes SLS's underlying implementation and session‑based optimizations, and presents three real‑world test cases that demonstrate up to an eight‑fold speed improvement for massive data aggregations.
SLSSQL Optimizationgroupby
0 likes · 10 min read

This article explains why high‑cardinality GroupBy queries are slow, describes SLS's underlying aggregation pipeline, and shows how adjusting session parameters and enabling high‑cardinality optimizations can reduce query times from dozens of seconds to just a few seconds across three real‑world test scenarios.
SLSSQLbig-data
0 likes · 11 min read

This comprehensive tutorial walks you through pandas basics, including reading CSV and Excel files, creating Series and DataFrames, performing data inspection, cleaning, indexing, hierarchical indexing, time‑series handling, grouping, aggregation, concatenation, merging, and practical code examples with visual outputs.
Time Seriesdata cleaninggroupby
0 likes · 12 min read


21CTOJul 30, 2024 · Frontend Development
The article reviews ECMAScript 2024, highlighting new small‑scale features such as improved WebAssembly interop, enhanced Promise utilities, group‑by methods, better Unicode handling, async locking with Atomics.waitAsync, and resizable ArrayBuffers, while also discussing upcoming proposals for 2025.
ECMAScript 2024JavaScriptPromises
0 likes · 17 min read

This article demonstrates how Java Stream operations such as map, flatMap, groupBy, and reduce can be directly applied to Spark, providing step‑by‑step code examples, explanations of transformation versus action operators, and practical tips for handling exceptions in distributed data processing.
Java StreamSparkflatMap
0 likes · 25 min read

This article explains how to use Python's pandas library to group a dataset by multiple fields, sort by end timestamps, and retain only the first record when consecutive timestamps are within 20 seconds, providing a reusable code snippet and sample output.
PandasPythonTime Series
0 likes · 5 min read

This article walks through a Python pandas solution that groups a dataset by multiple fields, orders rows by end time, and retains only the first record when successive end times are within a 20‑second window, complete with optimized code snippets and explanations.
PandasPythongroupby
0 likes · 6 min read

This article explains how to group a dataset by multiple columns, sort each group by an end‑time column, and keep only the first record when consecutive timestamps differ by less than 20 seconds, using a concise Pandas solution.
PandasPythondata-processing
0 likes · 5 min read

This article walks through a pandas data‑processing question where a one‑column DataFrame is grouped every five rows and reshaped into five columns, presenting two Python solutions—including list slicing and groupby aggregation—along with clear code examples and explanations.
PandasPythondata transformation
0 likes · 4 min read

This article demonstrates how developers familiar with Java Stream APIs can quickly grasp fundamental Spark operations—including map, flatMap, groupBy, and reduce—by translating stream examples into Spark code, providing complete code snippets, explanations of transformations versus actions, and practical tips for handling exceptions in distributed processing.
Java StreamSparkbig data
0 likes · 24 min read

This article walks through a real‑world Pandas grouping problem, showing how to aggregate song and actor data, concatenate song IDs with commas, and sum tags, providing clear code examples and explanations to help Python learners solve similar data‑processing challenges.
Code TutorialPandasPython
0 likes · 3 min read

This article demonstrates how to replace Excel's common data‑analysis tasks—such as VLOOKUP, data import/export, pivot tables, and charting—by using Python's pandas library together with Plotly for visualization, providing code examples and performance tips for each scenario.
VLOOKUPdata-analysisgroupby
0 likes · 15 min read

This article shows how to use Pandas to group rows by multiple columns, collect the values of another column into a list, and then join them into a comma‑separated string, providing two concise code solutions and a performance comparison.
PandasPythondata-processing
0 likes · 3 min read

This article demonstrates how to deduplicate invoice numbers and compute monthly order counts in retail data using pandas, comparing three approaches—unique with explode, groupby with value_counts, and drop_duplicates—while highlighting performance differences and providing complete code examples.
Pandasdata analysisdeduplication
0 likes · 5 min read

This article demonstrates how to de‑duplicate rows and concatenate string values within each id‑type group in a pandas DataFrame using drop_duplicates, groupby, agg, set, unique, and str.join techniques.
PandasString Concatenationduplicate removal
0 likes · 6 min read

This article demonstrates how to use pandas' groupby and diff functions to calculate daily differences for numeric columns within each category, offering four implementation methods—including apply, direct diff, transform, and a custom function—complete with code examples and visual results.
PandasPythondata analysis
0 likes · 7 min read

This article explains how to iterate over DataFrame rows with pandas iterrows(), demonstrates grouping data using pandas groupby() with examples of splitting, aggregation, transformation, and filtration, and provides complete code snippets for each operation.
Pandasaggregationdata-analysis
0 likes · 7 min read

This article compiles thirteen concise pandas techniques—including missing‑value calculation, group‑by max row extraction, multi‑column aggregation, string filtering, memory optimization, and more—to help Python users perform data analysis more efficiently and effectively.
Pandasdata analysisdataframe
0 likes · 9 min read

This article walks through a real‑world data‑cleaning task where duplicate process IDs are removed but earlier approval comments are retained, showcasing two pandas‑based solutions, code snippets, and practical tips for handling empty cells.
PandasPythondata-cleaning
0 likes · 4 min read

This tutorial shows how to calculate upward and downward differences of numeric columns for each category in a pandas DataFrame by sorting, grouping with groupby, and applying diff through several concise methods, including a custom helper function.
PandasPythondata analysis
0 likes · 7 min read

This guide shows how to transform an array of employee objects into a grouped structure by age using both a custom reduce‑based groupBy function and the modern Array.prototype.groupBy method, including examples of conditional grouping.
JavaScriptarrayfrontend
0 likes · 3 min read

An experienced data practitioner shares a concise pandas tutorial that shows how to recompute column aggregates after grouping, using a flexible function that applies arithmetic operations like addition, subtraction, multiplication, or division to the grouped results.
PandasPythondata aggregation
0 likes · 6 min read

This article demonstrates several practical techniques—including sorting before grouping, using drop_duplicates, and leveraging NumPy stacking—to extract the top N rows for each group in a pandas DataFrame, compares their performance, and provides a reusable function for custom use.
PandasTOP Ngroupby
0 likes · 9 min read

This article demonstrates how to use pandas groupby, list aggregation, sorting, deduplication, and explode (or a custom apply function) to retrieve each user's top‑priority tag while preserving other tag columns, comparing two practical implementations and their performance trade‑offs.
PandasPythondata-processing
0 likes · 6 min read

This tutorial demonstrates two pandas approaches to retrieve each user's highest‑priority label based on ordered tags, covering data preparation, grouping, custom sorting with key functions, deduplication, and the explode method, complete with code snippets and performance considerations.
PandasPythondata-processing
0 likes · 7 min read

This tutorial demonstrates how to read an Excel file with pandas, convert an 8‑digit birthdate column to datetime, calculate age, and then use groupby to produce aggregated statistics by age and gender, including combined summaries for all students and females only.
PandasPythonage-calculation
0 likes · 4 min read
