InsideEdgeInsideEdge
Download App

Phase 8 · Data Cleaning & Wrangling

Topics

Data Type Conversion

Part of the Data Analyst Roadmap.

Summary

Fixing columns that were imported as the wrong type — dates read as text, numbers read as strings with commas — a small but extremely common source of broken calculations.

How to Learn This

  • 1Practice converting a text 'date-looking' column into an actual date type.
  • 2Learn to spot when a numeric column has been silently imported as text.
  • 3Check data types immediately after importing any new dataset, as a habit.

Previous

Handling Duplicates

Next

Outlier Handling

More topics in Data Cleaning & Wrangling

Identifying Data Quality IssuesHandling Missing DataHandling DuplicatesOutlier HandlingStandardizing & Normalizing DataData Validation RulesETL Basics (Extract, Transform, Load)Documenting Data Cleaning Decisions
InsideEdge

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.

Download
InsideEdge