convert multiple rows to columns in Linux using Python or Bash

Asked Dec 13 '17 at 16:42

Active Dec 13 '17 at 16:42

Viewed 36 times

I have the input as below

Input

Name1 Subject1 Marks Name1 Subject2 Marks Name2 Subject1 Marks Name2 Subject2 Marks

and want to convert to output as below

Name Subject1 Subject2 Name1 Marks Marks Name2 Marks Marks

asked Dec 13 '17 at 16:42

ajain

2

This looks like a job for pandas. More specifically, `pivot`. – cs95 Dec 13 '17 at 16:44
Yes I agree but I have the data in my Server and need to manipulate it there – ajain Dec 13 '17 at 16:50
Bash 4 solution: https://gist.github.com/altblue/2cd2518f2b32f15e6c9374d62d4bd4fe – altblue Dec 13 '17 at 19:34