**I have a .txt file with 683,500 rows, every 7 rows its a different person that contain:**

1. ID
2. Name
3. Work position
4. Date 1 (year - month)
5. Date 2 (year - month)
6. Gross payment
7. Service time

**I would like to read that .txt and output (could be a json, csv, txt, or even in a database) every person in a 7 column, for example:**

```
ID    Name     Work position   Date 1   Date 2    Gross payment     Service time
ID    Name     Work position   Date 1   Date 2    Gross payment     Service time
ID    Name     Work position   Date 1   Date 2    Gross payment     Service time
ID    Name     Work position   Date 1   Date 2    Gross payment     Service time

```

---

Example in the txt:   

00000000886   

MANUEL DE JESUS SUBERVI PEÑA  

MAESTRO MEDIA GENERAL  

2006-08  

2021-09  

30,556.04  

15.7  

00000000086  

MANUEL DE JESUS SUBERVI PEÑA  

MAESTRO MEDIA GENERAL  

2006-01  

2021-09  

30,556.04  

15.7  

00100000086  

MANUEL DE JESUS SUBERVI PEÑA  

MAESTRO MEDIA GENERAL  

2006-01  

2021-09  

30,556.04  

15.7  

```
import csv

#opening file

file = open (r"C:\Users\Redford\Documents\Proyecto automatizacion\data1.txt") #open file
counter = 0
total_lines = len(file.readlines()) #count lines
#print('Total lines:', x)

#reading from file

content = file.read()
colist  = content.split ()
print(colist)

#read data from data1.txt and write in data2.txt

lines = open (r"C:\Users\Redford\Documents\Proyecto automatizacion\data1.txt")
arr = []
with open('data2.txt', 'w') as f:
    for line in lines:
        #arr.append(line)
        f.write (line)

```

I'm new to programing and I don't know how to translate my logic to code.