Hard CSV parsing

[wmfagri]

Hello everybody! How yall doing?

I am thinking about creating a code to help me parse a csv data base...
but I am having a really hard time to even think how to start it..

Most of the databases I work with look like this:

https://drive.google.com/open?id=19YiwF5...rSRwiBr_ku

They are a sort of small datasets glued together in one big csv... with different column number each set..

They can come from 2 different analysis as in the column "Method", DualSoil and DualMining..

My plan is to split the analysis...

How could I organize this file into 2 different new csvs based on the method column with only one column header?

Any ideas to help me?

I would really appreciate any help!

Thanks u all!