Oct-23-2019, 10:26 AM
I have a CVS file, published by the author of a scientific paper, having 700,000 rows. I want to split this file up into smaller "units" preferably putting the results into EXCEL.
The limits of the "units" are set by the contents of column 9 of 10. Column 9 runs for roughly 1000 rows and then the content of (row,9) changes.
I understand that pandas will do this and I understand the general way to go.
BUT I got stuck on the detail : I cannot just figure out how to run down (row,9) until (row,9) changes from, say, E456 to BV789.
Please point me to a good descriptive reference because I haven't, so far, been able to find one.
The limits of the "units" are set by the contents of column 9 of 10. Column 9 runs for roughly 1000 rows and then the content of (row,9) changes.
I understand that pandas will do this and I understand the general way to go.
BUT I got stuck on the detail : I cannot just figure out how to run down (row,9) until (row,9) changes from, say, E456 to BV789.
Please point me to a good descriptive reference because I haven't, so far, been able to find one.