I have a tab-delimited .txt file containing:
1 Julia aa bb
8 William dd ee ff gg
which I want to reform this as below:
1 Julia aa
1 Julia bb
8 William dd
8 William ee
8 William ff
8 William gg
Is it possible by this code:
res = (df.set_index(['Firstqolumn','qolumn'])
.drop('Temp',axis=1)
.stack()
.droplevel(-1)
.reset_index(name='Values')
)
res
My data has no header. How can I do it by python, bash script or excel?
New contributor
Faramarz Ghasemian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
4