Convert CSV File to txt file in Python with comma

Question

I would like to convert the following csv file to a txt file.

import csv
csv_file = (r'symbols/Input_weekly_insidebar.csv')
txt_file = (r'symbols/Input_weekly_insidebar.txt')
with open(txt_file, "w") as my_output_file:
   with open(csv_file, "r") as my_input_file:
     [ my_output_file.write(','.join(row)) for row in csv.reader(my_input_file)]
 
     
my_output_file.close()

In the txt output file each symbol should have a comma ',' after the symbol. Result should be:

Could you tell me what is wrong in my code? Because the above code produce an output without commas.

Thanks for your support.

You are not joining rows together. Your list comprehension should be inside your join(). — PM 77-1
– PM 77-1, Commented Jan 17, 2021 at 18:08
Untested: my_output_file.write(',', join([ row for row in csv.reader(my_input_file)]) — PM 77-1
– PM 77-1, Commented Jan 17, 2021 at 18:35

Lydia van Dyke · Accepted Answer · 2021-01-17 20:01:34Z

2

Because all rows only contain a single element, no separator will be inserted by ','.join(row). One simple way to fix it is to just pick the first and only element of each row, which is row[0].

I throw in a next(reader) in order to skip the csv header.

import csv

csv_file = r'symbols/Input_weekly_insidebar.csv'
txt_file = r'symbols/Input_weekly_insidebar.txt'
with open(txt_file, "w") as my_output_file:
    with open(csv_file, "r") as my_input_file:
        reader = csv.reader(my_input_file)
        next(reader)  # skip the header
        my_output_file.write(','.join(row[0] for row in reader))

Please note that you should not manually call my_output_file.close() because you are already using a with statement to open your files. The with statement closes the files for you already.

edited Jan 17, 2021 at 20:01

answered Jan 17, 2021 at 19:43

Lydia van Dyke

2,5263 gold badges15 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Convert CSV File to txt file in Python with comma

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