7 Reusable DuckDB SQL Patterns for Fast Local Data Analysis

This article presents seven practical DuckDB SQL patterns—querying files directly, treating partition folders as tables, deduplicating with QUALIFY, computing rolling metrics with window functions, pivot/unpivot, handling JSON arrays, and exporting results to Parquet—plus tips and a mini case study that show how to turn a notebook into a lightweight OLAP engine without leaving the Python environment.

DuckDBJSONParquet

0 likes · 12 min read

7 Reusable DuckDB SQL Patterns for Fast Local Data Analysis

Test Development Learning Exchange

Nov 20, 2024 · Fundamentals

Data Reshaping with Pandas: melt and pivot Methods

This article teaches how to use Pandas for data reshaping, covering the melt method for converting wide-format data to long-format and the pivot method for the reverse transformation, with practical code examples.

DataFramesPivotPython

0 likes · 7 min read

Data Reshaping with Pandas: melt and pivot Methods

Alibaba Cloud Big Data AI Platform

Sep 4, 2023 · Big Data

Mastering MaxCompute PIVOT/UNPIVOT: Transform Rows and Columns Efficiently

This article introduces MaxCompute’s new PIVOT and UNPIVOT syntax, explains their use cases for converting rows to columns and vice versa, provides detailed syntax rules, and demonstrates practical examples with code snippets to simplify data transformation and boost developer productivity in big-data environments.

Big DataMaxComputePivot

0 likes · 14 min read

Mastering MaxCompute PIVOT/UNPIVOT: Transform Rows and Columns Efficiently

Laravel Tech Community

Jun 13, 2020 · Backend Development

Defining and Using Many-to-Many Relationships in Laravel Eloquent

This article explains how to define many-to-many relationships in Laravel's Eloquent ORM, covering the required pivot table, model methods, query constraints, pivot customization, and the use of custom pivot models with code examples.

EloquentLaravelORM

0 likes · 6 min read

Defining and Using Many-to-Many Relationships in Laravel Eloquent

Big Data Technology & Architecture

Apr 23, 2019 · Databases

Implementing Row-to-Column Pivot in Hive: Traditional and Map Approaches

This article explains how to perform row-to-column transformations (pivot) in Hive using two methods: a traditional SQL approach mimicking Oracle/SQL Server pivot syntax and a more concise map-based technique, comparing their syntax, performance, and memory considerations.

Big DataMAPPivot

0 likes · 3 min read

Implementing Row-to-Column Pivot in Hive: Traditional and Map Approaches