CSV to Text File and write a line in newline

[atomxkai]

Hello,
The script generates output as 1 line for each record but I wanted to separate the output that looks like this. Your response is greatly appreciated. Thank you!

Output:
index
movie
genre year  country

1
movie1
action 2020 USA

2
movie2
drama 2019 UK

etc...

import csv
from datetime import date
import glob
from multiprocessing import Condition
from re import A
from tkinter import filedialog
import pandas as pd

header = ['index','movie','genre','year','country']

filename = 'dataFile.csv'

inFileData = open(filename, 'r')

rLines = inFileData.readlines() #process file later

inFileData.close()

#printing values in text file
with open('outputFile.txt', 'w') as outFileText:
    outFileText.write('Total Records: ')

    outFileText.write(rLines[0]) #writes header file

    recordIndex = 1
    for line in rLines[1:]:

        if recordIndex < 10:
            outFileText.write(line.replace(",", " ")) #REPLACE commas with whitespace
        
        recordIndex = recordIndex + 1    
           
outFileText.close()

[snippsat]

The script generates output as 1 line for each record but I wanted to separate the output that looks like this

Why do want structure it like this,its confusing and less readable way to structure it😕
Can write some stuff that would do it,the structure make not so easy will be so both ways(parse),
and then look at pandas way to structure it as you have it in import.

first = []
last = []
with open('datafile.csv') as f:
    next(f)
    for line in f:
        line = line.strip()
        first.append('\n'.join(line.split(",", 2)[:2]))
        last.append(' '.join(line.split(",", 2)[-1].split(',')))

lst = list(zip(first, last))
for item in lst:
    print(f'{item[0]}\n{item[1]}\n')

Output:
1
Movie1
ACTION 2021 USA

2
Movie2
DRAMA 2020 UK

3
Movie3
DRAMA 2019 SPAIN

4
Movie4
ACTION 2018 USA

5
Movie5
ACTION 2017 JAPAN

A look at Pandas,that use the standard(Excel,OpenOffice,Googgle sheet) way to structure it.

import pandas as pd

df = pd.read_csv('datafile.csv')

Output:
>>> df
   REC   MOVIE   GENRE  YEAR COUNTRY
0    1  Movie1  ACTION  2021     USA
1    2  Movie2   DRAMA  2020      UK
2    3  Movie3   DRAMA  2019   SPAIN
3    4  Movie4  ACTION  2018     USA
4    5  Movie5  ACTION  2017   JAPAN

Can turn it around,usually want to transpose to the first one.

Output:
>>> df.transpose()
              0       1       2       3       4
REC           1       2       3       4       5
MOVIE    Movie1  Movie2  Movie3  Movie4  Movie5
GENRE    ACTION   DRAMA   DRAMA  ACTION  ACTION
YEAR       2021    2020    2019    2018    2017
COUNTRY     USA      UK   SPAIN     USA   JAPAN 

[Larz60+]

Snippsat's method is better, but if you must use csv format:

from pathlib import Path
import csv
import os


def formatfile():
    os.chdir(os.path.abspath(os.path.dirname(__file__)))
    homepath = Path('.')
    infilename = homepath / 'datafile.csv'
    outfilename = homepath / 'outputFile.txt'
    header = 'index\nmovie\ngenre year country\n'

    with infilename.open() as fin, outfilename.open('w') as fout:
        crdr = csv.DictReader(fin)
        fout.write(header)
        for row in crdr:
            fout.write(f"\n{row['REC']}\n{row['MOVIE']}\n" \
                f"{row['GENRE']} {row['YEAR']} {row['COUNTRY']}\n")


if __name__ == '__main__':
    formatfile()

outputFile.txt:

Output:
index
movie
genre year country

1
Movie1
ACTION 2021 USA

2
Movie2
DRAMA 2020 UK

3
Movie3
DRAMA 2019 SPAIN

4
Movie4
ACTION 2018 USA

5
Movie5
ACTION 2017 JAPAN

[atomxkai]

thanks again snippsat!

it seems bit advance for me but I was able to run it successfully and i'm trying to fully grasp the script. this is a great option for me once i'm fully understand the process.

[atomxkai]

thank you Larz60+!

this is awesome! and also a great option for me that i can identify the headers are row[variables].