Multiple delimiters in single CSV file

by

Sticking with the standard library, re.split() can split a line at any of these characters:

import re

with open(file_name) as fobj:
    for line in fobj:
        line_data = re.split('Delim_first|Delim_second|[|]', line)
        print(line_data)

This will split at the delimiters |, Delim_first, and Delim_second.

Or with pandas:

import pandas as pd
df = pd.read_csv('multi_delim.csv', sep='Delim_first|Delim_second|[|]', 
                  engine="python", header=None)

Result:

enter image description here

More Related Contents:

  1. Convert commas decimal separators to dots within a Dataframe
  2. python pandas read_csv delimiter in column data
  3. create a loop inside a loop in python
  4. Python import csv to list
  5. Writing a pandas DataFrame to CSV file
  6. How to write to a CSV line by line?
  7. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  8. Writing a dictionary to a csv file with one line for every ‘key: value’
  9. How to write UTF-8 in a CSV file
  10. Using numpy.genfromtxt to read a csv file with strings containing commas
  11. How to keep leading zeros in a column when reading CSV with Pandas?
  12. How to transpose a dataset in a csv file?
  13. Writing Python lists to columns in csv
  14. Reading rows from a CSV file in Python
  15. CSV new-line character seen in unquoted field error
  16. How to read a CSV file from a URL with Python?
  17. Read CSV into a dataFrame with varying row lengths using Pandas
  18. Can you upload to S3 using a stream rather than a local file?
  19. Convert percent string to float in pandas read_csv
  20. How do you replace all the occurrences of a certain character in a string?
  21. Easiest way to read csv files with multiprocessing in Pandas
  22. Find all CSV files in a directory using Python
  23. Calculate summary statistics of columns in dataframe
  24. Python – re-ordering columns in a csv
  25. ValueError: not enough values to unpack (expected 11, got 1)
  26. how to specify the datetime format in read_csv
  27. UnicodeDecodeError when reading CSV file in Pandas
  28. How to upload a CSV file in FastAPI and convert it into JSON?
  29. Convert nested JSON to CSV file in Python
  30. ValueError: x and y must be the same size

Leave a Comment