I am trying to read a CSV file and then load that data into a table or a file. I am not getting any idea on how i can achieve this. It is somewhat complex for me. Can you give me some idea on how i can do it ? I just showed 9 lines here but my spreadsheet has thousands of lines so i am trying to find a best way.
My input file :
Code: Select all
Name A B C D
BIAM X . . .
CALD . . . X
COCO X . . .
CRE2 . . X .
CUST X . . .
HARP X . . .
DUF2 . . X .
EPS1 X . . .
EVA3 . X . .
My output should be like this.
Code: Select all
Name Role
BIAM A
CALD D
COCO A
CRE2 C
CUST A
HARP A
DUF2 C
EPS1 A
EVA3 B
Can you please give some ideas??