Today I encountered a file in the following format when extracting excel in python.
I want to convert it to the following format
At present, my idea is to look up the student number and name through the RE, get their corresponding index, and then fill in thewith the found values.
But I feel that the code is too slow. Do you guys have any good ideas or suggestions for improvement?
No answer yet