I have a DataFrame with multiple columns and rows. The rows are student names with marks and the columns are marking criteria. I want to save the first row (column names) along with each row in seperate files with the name of the student as the name file.
Example of my data:
| Marking_Rubric | Requirements and Delivery\nWeight 45.00% | Coding Standards\nWeight 10.00% | Documentation\nWeight 25.00% | Runtime - Effectiveness\nWeight 10.00% | Efficiency\nWeight 10.00% | Total | Comments |
|---|---|---|---|---|---|---|---|
| John Doe | 54 | 50 | 90 | 45 | 50 | 31 | Limited documentation |
| Jane Doe | 23 | 12 | 87 | 10 | 34 | 98 | No comments |
Desired output:
| Marking_Rubric | Requirements and Delivery | Coding Standards | Documentation | Runtime - Effectiveness | Efficiency | Total | Comments |
|---|---|---|---|---|---|---|---|
| John Doe | 54 | 50 | 90 | 45 | 50 | 31 | Limited documentation |
| Marking_Rubric | Requirements and Delivery | Coding Standards | Documentation | Runtime - Effectiveness | Efficiency | Total | Comments |
|---|---|---|---|---|---|---|---|
| Jane Doe | 23 | 12 | 87 | 10 | 34 | 98 | No comments |


