csv file having column not oriented properly
<p>I have a csv file which is as following</p>

<pre><code>1,'Man','Loves',
'Japan'
2,'Woman','Loves','Japan'
3,'Man','Loves,'Japan'
4,'Man','Loves',
'Japan'
5,'Man','Loves','Taiwan'
</code></pre>

<p>As we can see the csv file record moves to the next line in some cases . How can i correct it and make sure file is like this.</p>

<pre><code>  1,'Man','Loves','Japan'
  2,'Woman','Loves','Japan'
  3,'Man','Loves,'Japan'
  4,'Man','Loves','Japan'
  5,'Man','Loves','Taiwan'
</code></pre>

<p>Updated question</p>

<pre><code>x = re.findall(r.'Time (.*?);',data,re.DOTALL)
</code></pre>

<h2>This pull data between word 'Time' and ';'.This is further saved to csv file.</h2>

<p>Ideally the sting between 'Time' and ';' should be on same line but in some cases it on different lines. I think this causes problem. I tried using rstrip but it didn't help. The csv file was still same.</p>

<p>The code is on different machine(production) so  I typed what I could.</p>