Convert tab-delimited txt file into a csv file using Python

by

csv supports tab delimited files. Supply the delimiter argument to reader:

import csv

txt_file = r"mytxt.txt"
csv_file = r"mycsv.csv"

# use 'with' if the program isn't going to immediately terminate
# so you don't leave files open
# the 'b' is necessary on Windows
# it prevents \x1a, Ctrl-z, from ending the stream prematurely
# and also stops Python converting to / from different line terminators
# On other platforms, it has no effect
in_txt = csv.reader(open(txt_file, "rb"), delimiter="\t")
out_csv = csv.writer(open(csv_file, 'wb'))

out_csv.writerows(in_txt)

More Related Contents:

  1. create a loop inside a loop in python
  2. Python import csv to list
  3. Writing a pandas DataFrame to CSV file
  4. How to write to a CSV line by line?
  5. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  6. Python out of memory on large CSV file (numpy)
  7. Writing a dictionary to a csv file with one line for every ‘key: value’
  8. How do I write data into CSV format as string (not file)?
  9. Save results to csv file with Python
  10. How to write UTF-8 in a CSV file
  11. Using numpy.genfromtxt to read a csv file with strings containing commas
  12. Split string on commas but ignore commas within double-quotes?
  13. Read CSV file with comma within fields in Python
  14. How to keep leading zeros in a column when reading CSV with Pandas?
  15. How to transpose a dataset in a csv file?
  16. Writing Python lists to columns in csv
  17. Reading rows from a CSV file in Python
  18. Python read csv – BOM embedded into the first key
  19. How to skip the headers when processing a csv file using Python?
  20. Read csv from Google Cloud storage to pandas dataframe
  21. Converting images to csv file in python
  22. convert csv file to list of dictionaries
  23. Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python [duplicate]
  24. module ‘pandas’ has no attribute ‘read_csv
  25. Python CSV: Remove quotes from value
  26. Conditional row read of csv in pandas
  27. Pandas read_csv dtype read all columns but few as string
  28. csv: writer.writerows() splitting my string inputs
  29. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?
  30. How to convert csv to json in python?

Leave a Comment