CSV ToolsLesson 352Free preview

Swap CSV Columns

This lesson is part of Web Developer Tools · All levels

Summary

Swap CSV Columns swaps the positions of the two columns without changing the contents of each value. This operation is useful when the column sequence needs to be adjusted to the import format of other applications. The safe way is to read the header, find the index of the two columns by name, and then exchange the values on each row.

Key points

Swap swaps the positions of the two columns, not the entire row and column
Identify columns by header name to avoid error
Header and data must be exchanged together to keep the data in sync.
Use a CSV parser or DictReader to maintain field integrity
Swap is different from a transpose that changes the orientation of the entire table

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.