I have the following example csv with 4 column and 6 rows that has cells with embedded returns. In my experience, this is very common when working with CSVs that contain text data.
Here's an example CSV file:
Criterion for organ dysfunction,Suggested thresholds,Conditions,Severity
"Venoarterial ECLS, temporary or durable LVAD or RVAD support",NA,None,Severe
Cardiac Arrest,NA,None,Severe
Heart rate (HR),">2SD above normal for age
•→ 0-7 days: HR>180
•→ >1 week - 1 m: HR>180
•→ >1 m - <1 y: HR>180
•→ >1 y - <6 y: HR>160
•→ 6 y - <13 y: HR>150
•→ 13 y - <18 y: HR>130",If present at the same time as any of the other criteria for CV organ dysfunction,Not graded
Systolic blood pressure (SBP),"More than 2SD below normal for age
•→ 0-7 days: SBP<50
•→ >1 week - 1 m: SBP<70
•→ >1 m - <1 y: SBP<75
•→ >1 y - <6 y: SBP<75
•→ 6 y - <13 y: SBP<80
•→ 13 y - <18 y: SBP<80",If present at the same time as any of the other criteria for CV organ dysfunction,Not graded
Vasoactive-Inotropic Score,≥5,If present at the same time as any of the other criteria for CV organ dysfunction,Not graded
Instead of having the expected output of 4 column and 6 rows, I get this:
| Criterion for organ dysfunction |
Suggested thresholds |
Conditions |
Severity |
| "Venoarterial ECLS |
temporary or durable LVAD or RVAD support" |
NA |
None |
| Cardiac Arrest |
NA |
None |
Severe |
I have the following example csv with 4 column and 6 rows that has cells with embedded returns. In my experience, this is very common when working with CSVs that contain text data.
Here's an example CSV file:
Instead of having the expected output of 4 column and 6 rows, I get this: