BestHub
search
Sign in
Tag

duplicate rows

1 views collected around this technical thread.

Test Development Learning Exchange
Test Development Learning Exchange
Nov 17, 2024 · Fundamentals

Basic Data Cleaning Techniques with Pandas

This tutorial teaches fundamental data cleaning with Pandas, covering how to handle missing values, rename columns, and remove duplicate rows through clear explanations and complete code examples.

data cleaningduplicate rowsmissing values
0 likes · 6 min read
Basic Data Cleaning Techniques with Pandas
Qunar Tech Salon
Qunar Tech Salon
Jun 11, 2017 · Databases

Techniques for Removing Duplicate Rows and Adding Unique Constraints in PostgreSQL

This article examines common scenarios where duplicate rows prevent creating unique constraints, presents eight SQL‑based methods—including array functions, window functions, NOT IN/EXISTS, combined IN/NOT IN, EXISTS/NOT EXISTS, single‑statement deletes, and table‑copy approaches—provides test data, performance comparisons, and practical guidance for DBA operations.

Database AdministrationPostgreSQLSQL optimization
0 likes · 10 min read
Techniques for Removing Duplicate Rows and Adding Unique Constraints in PostgreSQL