Insert text into its proper cells - Python

Question

Hello, my friends

I am developing the code so that I can clean and organize the data (as shown above) and one of the best ways was to insert the data into a file CSV so that later I could return it in spreadsheet format, so I applied the following code:

import csv

with open('/content/Pasta2.csv', 'w') as out_file:
      writer = csv.writer(out_file, delimiter=',',lineterminator='\n')
      writer.writerow(('URL','Documento', 'Código CVM', 'Data de Referência', 'Status'))
      writer.writerow([linha_1])

teste_02 = pd.read_csv('/content/Pasta2.csv')

teste_02

However, the return that I have is shown in the image below, the code simply takes the text that is inside the "line_1' and does not divide the cells, I would like to know which code I can implement to solve this problem, can help me?

Expected Result:

Answer 1

Code that worked:

import csv

with open('/content/Pasta2.csv', 'w') as out_file:
      
      writer = csv.writer(out_file, delimiter=',',lineterminator='')
      writer.writerow(('URL','Documento', 'Código CVM', 'Data de Referência', 'Status'))
      writer.writerow(linha_1.replace('"','').split(','))

teste_02 = pd.read_csv('/content/Pasta2.csv')

teste_02

I made some changes and the result worked, the correct distribution was performed on the lines and also the line breaks.

Answer 2

It seems to me that you are writing the entire line in the first cell, trying to exchange the line 6 for:

writer.writerow(*[linha_1])