w3resource

Python: Reads a CSV file and remove initial spaces, quotes around each entry and the delimiter


6. CSV Clean Entries

Write a Python program that reads a CSV file and remove initial spaces, quotes around each entry and the delimiter.

Sample Solution:

Python Code :

import csv
csv.register_dialect('csv_dialect',
                    delimiter='|',
                    skipinitialspace=True,
                    quoting=csv.QUOTE_ALL)
with open('temp.csv', 'r') as csvfile:
   reader = csv.reader(csvfile, dialect='csv_dialect')
   for row in reader:
       print(row)

temp.csv

"country_id"|"country_name"|"region_id"
"AR"|"Argentina"| 2
"AU"|"Australia"| 3
"BE"|"Belgium"| 1
"BR"|"Brazil"| 2
"CA"|"Canada"| 2

Sample Output:

['country_id', 'country_name', 'region_id']
['AR', 'Argentina', '2']
['AU', 'Australia', '3']
['BE', 'Belgium', '1']
['BR', 'Brazil', '2']
['CA', 'Canada', '2']

For more Practice: Solve these Related Problems:

  • Write a Python program to read a CSV file and remove initial spaces, surrounding quotes from each field, and the delimiter artifacts, then print the cleaned rows.
  • Write a Python script to process a CSV file by stripping unwanted quotes and spaces from each entry and then save the cleaned data to a new CSV file.
  • Write a Python program to import a CSV file, clean each entry by removing extra spaces and quotes, and then output the cleaned data as a list of lists.
  • Write a Python script to read a CSV file with irregular formatting, remove initial spaces and extraneous quotes, and then join the fields into a single formatted string per row.

Python Code Editor:


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Python program to read a given CSV files with initial spaces after a delimiter and remove those initial spaces.
Next: Write a Python program to read specific columns of a given CSV file and print the content of the columns.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.