markdown_files/Data_Preparation_in_the_Editor.md

metadata

title: Data Preparation in the Editor
original_url: >-
  https://tds.s-anand.net/#/data-preparation-in-the-editor?id=data-preparation-in-the-editor
downloaded_at: '2025-06-08T23:22:43.469063'

Data Preparation in the Editor

You’ll learn how to use a text editor Visual Studio Code to process and clean data, covering:

• Format JSON files
• Find all and multiple cursors to extract specific fields
• Sort lines
• Delete duplicate lines
• Replace text with multiple cursors

Here are the links used in the video:

• City-wise product sales JSON

[Previous

Data Preparation in the Shell](#/data-preparation-in-the-shell)

[Next

Cleaning Data with OpenRefine](#/cleaning-data-with-openrefine)