There is a problem in conversion of text file content into csv format using python

Question

I tried to convert text file content into a .csv format by reading each and every line using python csv module and converting that to a list. But i couldn't get the expected output and it stores the first line in a row but second line will be stored in 3rd row and 5th so on. Since I am new to python i don't know how to skip the line and store it in the right order.

def FileConversion():
   try:     
        with open('TextToCSV.txt', 'r') as textFile:
            LineStripped = (eachLine.strip() for eachLine in textFile)
            lines = (eachLine.split(" ") for eachLine in LineStripped if eachLine)            
            with open('finalReport.csv', 'w') as CSVFile:
                writer = csv.writer(CSVFile)
                writer.writerow(('firstName', 'secondName', 'designation', "age"))
                writer.writerows(lines)

Hi @Praveenkumar, I tried your code but it seems to work just fine. Can you show an example of your input and output, just to be sure? — rje
– rje, Commented Oct 26, 2018 at 12:37
And also what you expect to get as a result instead of what you got. — Matthieu Brucher
– Matthieu Brucher, Commented Oct 26, 2018 at 12:38
Maybe put your write loop on the outside, instead of the inside? — rassar
– rassar, Commented Oct 26, 2018 at 12:39

rassar · Accepted Answer · 2018-10-26 12:44:03Z

3

Why don't you try doing something more simple:

import pandas as pd
aux = pd.read_csv("TextToCSV.txt", sep=" ")
aux.columns=['firstName', 'secondName', 'designation', "age"]

aux.to_csv("result.csv")

edited Oct 26, 2018 at 12:44

rassar

5,7103 gold badges29 silver badges46 bronze badges

answered Oct 26, 2018 at 12:43

jalazbe

2,0374 gold badges26 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

There is a problem in conversion of text file content into csv format using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related