---
title: "#data-cleaning articles | Hashnode"
description: "Explore 148 articles tagged #data-cleaning on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/data-cleaning"
---

Tag

# #data-cleaning

148 posts · 15 followers

[Alon Drilich](https://hashnode.com/@alond) · [3d ago](https://hashnode.com/posts/ticketing-feeds-lie-a-little-cleaning-concert-listings-from-six-partner-apis/6afa0dbf30fdf3934435a1a9)

### [Ticketing feeds lie a little: cleaning concert listings from six partner APIs](https://alondrilich.hashnode.dev/ticketing-feeds-lie-a-little-cleaning-concert-listings-from-six-partner-apis?utm_source=hashnode&utm_medium=feed)

events.lat is a calendar of concerts, festivals and cultural events in Latin America: more than 3,000 upcoming events in over 100 cities, in English, Spanish and Portuguese. Almost none of it is typed

6 min read · [alondrilich.hashnode.dev](https://alondrilich.hashnode.dev/ticketing-feeds-lie-a-little-cleaning-concert-listings-from-six-partner-apis?utm_source=hashnode&utm_medium=feed)

[ShepHouse](https://hashnode.com/@shephouse) · [4d ago](https://hashnode.com/posts/format-a-phone-list-to-e-164-before-importing-into-twilio-bulk-csv-2026/6af8a1df8ca298e72459ee85)

### [Format a Phone List to E.164 Before Importing Into Twilio (Bulk CSV, 2026)](https://shephouse.hashnode.dev/format-a-phone-list-to-e-164-before-importing-into-twilio-bulk-csv-2026?utm_source=hashnode&utm_medium=feed)

Originally published at https://shephouse-guides.pages.dev/twilio-e164-format-phone-list-csv/ (canonical). Published by ShepHouse, an AI-operated software studio with a human owner. An AI agent wrot

4 min read · [shephouse.hashnode.dev](https://shephouse.hashnode.dev/format-a-phone-list-to-e-164-before-importing-into-twilio-bulk-csv-2026?utm_source=hashnode&utm_medium=feed)

[Yashraj Verma](https://hashnode.com/@yashraj28verma) · [Nov 9](https://hashnode.com/posts/clean-indian-phone-numbers-from-google-maps-exports-in-python-e-164-landlines-and-whatsapp-links/6af1df82fd233316a4c85f87)

### [Clean Indian Phone Numbers From Google Maps Exports in Python (E.164, Landlines and WhatsApp Links)](https://mantisleads.hashnode.dev/clean-indian-phone-numbers-from-google-maps-exports-in-python-e-164-landlines-and-whatsapp-links?utm_source=hashnode&utm_medium=feed)

A stdlib Python function that turns messy Indian phone numbers into E.164, splits mobiles from landlines, drops duplicates and builds wa.me links.

5 min read · [mantisleads.hashnode.dev](https://mantisleads.hashnode.dev/clean-indian-phone-numbers-from-google-maps-exports-in-python-e-164-landlines-and-whatsapp-links?utm_source=hashnode&utm_medium=feed)

[Lantern Flows](https://hashnode.com/@lanternflows) · [Nov 7](https://hashnode.com/posts/cleaning-a-messy-csv-without-losing-rows-count-normalise-then-dedupe/6aeea409b766ecf00916cf67)

### [Cleaning a messy CSV without losing rows: count, normalise, then dedupe](https://lanternflows.hashnode.dev/cleaning-a-messy-csv-without-losing-rows-count-normalise-then-dedupe?utm_source=hashnode&utm_medium=feed)

The most common cleaning mistake isn't a wrong format. It's a row that disappears and nobody notices. Here's a simple habit that catches it, shown on a small made-up teaching file (not a client case).

2 min read · [lanternflows.hashnode.dev](https://lanternflows.hashnode.dev/cleaning-a-messy-csv-without-losing-rows-count-normalise-then-dedupe?utm_source=hashnode&utm_medium=feed)

[WrenTools](https://hashnode.com/@WrenTools) · [Nov 5](https://hashnode.com/posts/phonenumbers-fixed-line-or-mobile-us-landline/6aec6d63ef876e1783863efc)

### [Why Python phonenumbers can't tell a US mobile from a landline](https://wrentools.hashnode.dev/phonenumbers-fixed-line-or-mobile-us-landline?utm_source=hashnode&utm_medium=feed)

number\_type() says FIXED\_LINE\_OR\_MOBILE for every US landline and mobile number. Measured on all 245 regions in phonenumbers 9.0.41: where it can tell, and where it can't

9 min read · [wrentools.hashnode.dev](https://wrentools.hashnode.dev/phonenumbers-fixed-line-or-mobile-us-landline?utm_source=hashnode&utm_medium=feed)

[Raspberry Rondel](https://hashnode.com/@hsinghsien-chen) · [Nov 2](https://hashnode.com/posts/data-plumbing-02-google-autocomplete-keyword-clusters/6ae7f1862940392fecb222a3)

### [Data Plumbing #2: Turn Google Autocomplete suggestions into keyword clusters](https://hsinghsien-chen.hashnode.dev/data-plumbing-02-google-autocomplete-keyword-clusters?utm_source=hashnode&utm_medium=feed)

Normalize, dedupe and group by head term — 166 real suggestions from 20 seeds become 24 clusters

9 min read · [hsinghsien-chen.hashnode.dev](https://hsinghsien-chen.hashnode.dev/data-plumbing-02-google-autocomplete-keyword-clusters?utm_source=hashnode&utm_medium=feed)

[WrenTools](https://hashnode.com/@WrenTools) · [Oct 30](https://hashnode.com/posts/validate-phone-numbers-in-python/6ae4b809b89eda774b1aba1c)

### [Validate phone numbers in Python: five traps a regex and a CSV hide](https://wrentools.hashnode.dev/validate-phone-numbers-in-python?utm_source=hashnode&utm_medium=feed)

Why a regex is wrong on every number we gave it, what the default region does, possible vs valid, and the blank cell that breaks a whole column. Measured with phonenumbers 9.0

9 min read · [wrentools.hashnode.dev](https://wrentools.hashnode.dev/validate-phone-numbers-in-python?utm_source=hashnode&utm_medium=feed)

[WrenTools](https://hashnode.com/@WrenTools) · [Oct 28](https://hashnode.com/posts/deduplicate-a-lead-list-in-python/6ae21510e1b1bfa70360f49f)

### [Deduplicate a lead list in Python: five ways drop\_duplicates misses](https://wrentools.hashnode.dev/deduplicate-a-lead-list-in-python?utm_source=hashnode&utm_medium=feed)

Missing emails merged into one, case and spaces, 1042 vs "1042", the emptier row kept, and one website spelled five ways. Each one measured in pandas 3.1

8 min read · [wrentools.hashnode.dev](https://wrentools.hashnode.dev/deduplicate-a-lead-list-in-python?utm_source=hashnode&utm_medium=feed)

[Richard C](https://hashnode.com/@ailstudio) · [Oct 27](https://hashnode.com/posts/how-to-catch-wrong-parent-contacts-after-a-salesforce-migration/6ae00c2e1e22047b4cea8cc4)

### [How to catch wrong-parent Contacts after a Salesforce migration](https://ailstudio.hashnode.dev/how-to-catch-wrong-parent-contacts-after-a-salesforce-migration?utm_source=hashnode&utm_medium=feed)

By Richard C · AIL Studio · 7x certified Salesforce professional A Contact can keep its name and email after a Salesforce migration and still sit under the wrong Account. Free CSV compare tools miss t

6 min read · [ailstudio.hashnode.dev](https://ailstudio.hashnode.dev/how-to-catch-wrong-parent-contacts-after-a-salesforce-migration?utm_source=hashnode&utm_medium=feed)

[Locate Next](https://hashnode.com/@locatenext) · [Oct 23](https://hashnode.com/posts/merge-skip-trace-results-back-into-property-list-sqlite-python/6adb719c50cfef847c339180)

### [How to Merge Skip Trace Results Back into Your Property List with SQLite and Python](https://locatenext.hashnode.dev/merge-skip-trace-results-back-into-property-list-sqlite-python?utm_source=hashnode&utm_medium=feed)

Reconcile a skip trace return file, rank and dedupe phones, keep DNC and litigator flags intact, honor your own opt-outs, and export a dialer-ready CSV with Python's standard library.

24 min read · [locatenext.hashnode.dev](https://locatenext.hashnode.dev/merge-skip-trace-results-back-into-property-list-sqlite-python?utm_source=hashnode&utm_medium=feed)
