Convert txt to csv python script

Question

I have a  txt file with this inside - 2 9 Gardena CA  What I m trying to do is convert that text into a  csv  table  using a python script    import csv import itertools  with open  log txt    r   as in file      stripped    line strip   for line in in file      lines    line for line in stripped if line      grouped   itertools izip   lines    3      with open  log csv    w   as out file          writer   csv writer out file          writer writerow   title    intro            writer writerows grouped    The output I get in the log csv file is - title intro tagline  What I would want the log csv file to show is   title intro 2 9 Gardena CA

User · Answer

import pandas as pd df   pd read fwf  log txt   df to csv  log csv

User · Answer

I suposse this is the output you need   title intro tagline 2 9 Gardena CA  It can be done with this changes to your code  import csv import itertools  with open  log txt    r   as in file      lines   in file read   splitlines       stripped    line replace  quot   quot   quot   quot   split   for line in lines      grouped   itertools izip   stripped  1      with open  log csv    w   as out file          writer   csv writer out file          writer writerow   title    intro    tagline            for group in grouped              writer writerows group

User · Answer

You need to split the line first   import csv  with open  log txt    r   as in file      stripped    line strip   for line in in file      lines    line split      for line in stripped if line      with open  log csv    w   as out file          writer   csv writer out file          writer writerow   title    intro            writer writerows lines

User · Answer

This is how I do it    with open txtfile   r   as infile  open csvfile   w   as outfile          stripped    line strip   for line in infile          lines    line split      for line in stripped if line          writer   csv writer outfile          writer writerows lines    Hope it helps

[python] Convert txt to csv python script

Examples related to python

Examples related to csv

Examples related to text