Pandas scenarios to interpret multi-line CSV entries with embedded newlines correctly
I'm trying to load a CSV file using Pandas 1.4.2, but I'm running into issues with entries that contain embedded newlines. The CSV file was generated from a third-party system and looks something like this: ```csv "Name","Address" "John Doe","123 Main St, Apt 4B\nNew York, NY 10001" "Jane Smith","456 Elm St, Suite 2A\nLos Angeles, CA 90001" ``` When I attempt to read this CSV using the following code: ```python import pandas as pd df = pd.read_csv('path/to/file.csv') print(df) ``` I get the following behavior: ``` ParserError: behavior tokenizing data. C behavior: Expected 2 fields in line 3, saw 3 ``` I understand that Pandas might be having trouble with the newline characters within the quoted strings. I've tried using the `quoting` parameter with the value `csv.QUOTE_ALL`, but it didn't help. Here's the adjusted code: ```python import pandas as pd import csv df = pd.read_csv('path/to/file.csv', quoting=csv.QUOTE_ALL) print(df) ``` This still leads to the same parsing behavior. I've also tried manually replacing the newline characters in the file with a placeholder string before reading it, but that approach feels hacky and behavior-prone. Does anyone have a recommended approach for correctly loading multi-line CSV entries in Pandas without running into these parsing issues? Any insights or alternative methods would be greatly appreciated! I'm working in a macOS environment.