converting TXT to CSV python

Question

I have a txt data. it looks as follows

time pos
0.02 1
0.1 2
 ...

and so on. so the each line is separated with a space. I need to convert it in to a CSV file. like

time,pos
0.02,1
0.1,2
0.15,3

How can I do it with python ? This is what I have tried

time = []
pos = []

def get_data(filename):
    with open(filename, 'r') as csvfile:
        csvFileReader = csv.reader(csvfile)
        next(csvFileReader)
        for row in csvFileReader:
            time.append((row[0].split(' ')[0]))
            pos.append((row[1]))
    return

Does your file have any quoted arguments containing spaces? If not, would it suffice to just do line.replace(' ', ',')? — 0x5453
– 0x5453, Commented Apr 30, 2018 at 13:29

TheTechGuy · Accepted Answer · 2018-04-30 13:38:05Z

5

with open(filename) as infile, open('outfile.csv','w') as outfile: 
    for line in infile: 
        outfile.write(line.replace(' ',','))

edited Apr 30, 2018 at 13:38

TheTechGuy

1,6186 gold badges21 silver badges45 bronze badges

answered Apr 30, 2018 at 13:29

Sam

2281 silver badge10 bronze badges

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

4 Comments

TheTechGuy Over a year ago

Thanks, more pythonic :D

Harsha Biyani Over a year ago

you have to append \n at the end of every line

TheTechGuy Over a year ago

with your new edit '_io.TextIOWrapper' object has no attribute 'writeline'

Sam Over a year ago

I'm getting languages mixed up. It should work as it is now.

GSazheniuk · Accepted Answer · 2018-04-30 13:32:57Z

0

From here:

import csv
with open(filename, newline='') as f:
    reader = csv.reader(f, delimiter=' ')
    for row in reader:
        print(row)

For writing just use default options and it would save file with comma as a delimiter.

answered Apr 30, 2018 at 13:32

GSazheniuk

1,38410 silver badges17 bronze badges

Comments

Harsha Biyani · Accepted Answer · 2018-04-30 13:46:30Z

0

try:

import pandas as pd
with open(filename, 'r') as fo:
    data = fo.readlines()
    for d in range(len(data)):
        if d==0:
            column_headings = data[d].split()
        data_to_insert = data[d].split()
        pd.DataFrame(data_to_insert).to_excel('csv_file.csv', header=False, index=False, columns = column_headings))

edited Apr 30, 2018 at 13:46

answered Apr 30, 2018 at 13:38

Harsha Biyani

7,28810 gold badges42 silver badges64 bronze badges

1 Comment

TheTechGuy Over a year ago

TypeError: writelines() takes exactly one argument (0 given)

iRhonin · Accepted Answer · 2018-04-30 13:47:22Z

0

You can use this:

import csv
time = []
pos = []

def get_data(filename):
    with open(filename, 'r') as csvfile:
        csvfile1 = csv.reader(csvfile, delimiter=' ')
        with open(filename.replace('.txt','.csv'), 'w') as csvfile:
            writer = csv.writer(csvfile, delimiter=',')
            for row in csvfile1:
                writer.writerow(row)

answered Apr 30, 2018 at 13:47

iRhonin

3833 silver badges14 bronze badges

Collectives™ on Stack Overflow

converting TXT to CSV python

4 Answers 4

4 Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related