'Importing txt with line breaks
I want to import '.txt' file to python dataframe. However, whenever my 'text' or 'description' column includes a new line or line break, it recognizes as a new row.
For example, my txt file includes and it recognizes as 5 lines, but actually it is one data point (one row). How can I import it correctly as I intend to?
status_id,text,date,lang,date_joined,source,truncated_text,description
929519008734314496,40 Acres and a Mule by Brazilian Princess #NowPlaying,2017-11-12 01:19:35,en,2013-05-09 09:36:56,Twitter Web Client,False,"The Official Twitter of Brazilian Princess
I make Christian Trap Music
Creator of @AlphababyStore
I am a trafficking and domestic violence
Survivor
🔥Acts 2:38"
My target would be
status_id,text,date,lang,date_joined,source,truncated_text,description
929519008734314496,40 Acres and a Mule by Brazilian Princess #NowPlaying,2017-11-12 01:19:35,en,2013-05-09 09:36:56,Twitter Web Client,False,"The Official Twitter of Brazilian Princess I make Christian Trap Music Creator of @AlphababyStore I am a trafficking and domestic violence Survivor 🔥Acts 2:38"
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|