Mar-27-2023, 08:59 PM
(This post was last modified: Mar-27-2023, 08:59 PM by deanhystad.)
To fix you need to identify when a linefeed is not the end of a row, but a continuation of the description. You could look " - " at the start of the "Release_Date" to find the continuations. If the Overivew is "NaN" append the description to the previous description. If the Overview is a number, use the Overview, Popularity, Vote_Count, Vote_Average, and Original_Language as the Popularity, Vote_Count, Vote_Average, Original_Language and Genre for the row. Even then you still have that odd link after genre. Quite complicated.
Or you could just fix whatever is generating these files and have it place quotes around the Title and Overview. I edited your csv file and wrapped all the titles and Overviews in quotes. I left the linefeeds in the pixie bakeoff description and deleted the link after the pixie bakeoff genre (Animaged) as well as all the commas that were added to the csv file because you did not have quotes on the Overview. The modified csv file reads fine.
Or you could just fix whatever is generating these files and have it place quotes around the Title and Overview. I edited your csv file and wrapped all the titles and Overviews in quotes. I left the linefeeds in the pixie bakeoff description and deleted the link after the pixie bakeoff genre (Animaged) as well as all the commas that were added to the csv file because you did not have quotes on the Overview. The modified csv file reads fine.