Python Copy names from txt file to csv format

Question

I have a text file consisting of group name, Age, Education details  I want only to copy names from that text file to excel sheet. In the excel sheet names should come Row by row.

Eg: Let us assume this how my text file looks like.

Group 1 Punith 34 MCA Rahlul 33 BCA Jagadish 35 MCA Azhar 40 BE

Group 2  Ajay 32 BCA Pradeep 30 BCA Venkat 25 MCA Sujith 20 BE

when i run the python code i should get output as (I should GET OUTPUT row by row in excel sheet, Clumn1 should be name, Column 2 should be Age and Column should be Education details)

Punith 34 MCA

Rahul 33 BCA

Jagadish 35 MCA

Azhar. 40 BE

Ajay 32 BCA

Pradeep 30 BCA

Venkat  25 MCA

Sujith 20 BE

Can anyone help me with a python code. I am new to python i need it urgent work.

Answer 1

Hi@ANAND,

It depends on your use case. In which format you want to retrieve your dataset. According to your example, you can try something as given below.

import pandas as pd
data = pd.read_csv('data.txt.txt',header=None)
data = data.applymap(lambda x: str(x.replace(' ',',')))
data = data[0].str.split(',',expand=True)
df1 = data.iloc[:,2:5]
df2 = data.iloc[:,5:8]
df3 = data.iloc[:,8:11]
objs = [df1,df2,df3]

You have to create some python code according to your use case.

Hope this will give you some idea.