Python TypeError: expected str, bytes or os.PathLike object, not _io.TextIOWrapper

Question

I am trying to convert a pipe-delimited text file to a CSV file, and then iterate through and print the CSV file. Here is my code:


with open("...somefile.txt", "r") as text_file:
    text_reader = csv.reader(text_file, delimiter='|')
    with open("...somefile.csv", 'w') as csv_file:
        csv_writer = csv.writer(csv_file, delimiter=',')
        csv_writer.writerows(text_reader)

with open (csv_file, 'r') as f:
    reader = csv.reader (f, delimiter=',')
    for row in reader:
        print(row)

However, I am getting this error message :

----> 9 with open (csv_file, 'r') as f:
     10     reader = csv.reader (f, delimiter=',')
     11     for row in reader:

TypeError: expected str, bytes or os.PathLike object, not _io.TextIOWrapper

Can anyone explain what this means?

Also, if I were to make this into a function, how could I take in a file name as input and then change the file to add a .csv extension wen converting to a csv file?

Thanks

Omer Tuchfeld · Accepted Answer · 2020-03-16 12:18:32Z

6

You're passing open an already opened file, rather than the path of the file you created.

Replace:

with open (csv_file, 'r') as f:

with

with open ("...somefile.csv", 'r') as f:

To change the extension in a function:

import pathlib

def txt_to_csv(fname):
    new_name = f'{Path(fname).stem}.csv'

    with open(fname, "r") as text_file:
        text_reader = csv.reader(text_file, delimiter='|')
        with open(new_name, 'w') as csv_file:
            csv_writer = csv.writer(csv_file, delimiter=',')
            csv_writer.writerows(text_reader)

    with open (new_name, 'r') as f:
        reader = csv.reader (f, delimiter=',')
        for row in reader:
            print(row)

edited Mar 16, 2020 at 12:18

answered Mar 16, 2020 at 11:58

Omer Tuchfeld

3,0801 gold badge20 silver badges26 bronze badges

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

2 Comments

watermelon123 Over a year ago

thanks - if this was a function with the file as an input and I had to use a variable name instead of the original file route, what would be the solution?

Omer Tuchfeld Over a year ago

Edited to include the answer to your second question

Ambitions · Accepted Answer · 2020-03-16 12:04:43Z

1

I am not an expert of csv library. However, regarding your other question:

Also, if I were to make this into a function, how could I take in a file name as input and then change the file to add a .csv extension wen converting to a csv file?

Solution:

def converter(input_file_name):
  with open(input_file_name, 'r') as txt_file:
    output_file_name = input_file_name.replace('.txt', '.csv')
    with open(output_file_name, 'w') as csv_file:
      # your logic resides here.

answered Mar 16, 2020 at 12:04

Ambitions

2,6433 gold badges16 silver badges26 bronze badges

Collectives™ on Stack Overflow

Python TypeError: expected str, bytes or os.PathLike object, not _io.TextIOWrapper

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related