Hello,
I have a CSV file containing [309291 rows x 3 columns]. A snapshot of my data is given below
query target Similarity
DB00091 DB00502 0.363395
DB00091 DB00706 0.193460
DB00091 DB01435 0.368020
DB00091 DB01095 0.274538
DB00091 DB00608 0.357236
... ... ...
DB13879 DB00502 0.461665
DB13879 DB00706 0.466264
DB13879 DB01435 0.388672
DB13879 DB01095 0.380627
DB13879 DB00608 0.300343
Please, notice this that, I have similarity values for DB00091 with 5 different target like DB00502, DB00706, DB01435, DB01095, DB00608 ,etc,.
Now, I want to change this CSV into a matrix format CSV. For example,
DB00502 DB00706 DB01435 DB01095 DB00608
DB00091 0.363395 0.193460 0.368020 0.274538 0.357236
DB13879 0.461665 0.466264 0.388672 0.380627 0.300343
Could you tell me how can I do it? Any kind of suggestion is appreciable.