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...

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

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.

1 2 3 4 5 6 7 8 9 10 11 12

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.

1 2 3

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:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

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].