Have you looked at more than one tutorial for this kind of operation?
As an example: how about this one
Myself, I'd be looking at using OpenPyXL for this kind of work and I have in fact used said (not for this task, but for a far simper one) and it can get very involved and code heavy, if you want to have all the correct checks in place, which you should, tbh.
edit to add: I'm not a pandas user, but I've just learned that as of pandas version 2.0.0, the
As an example: how about this one
Myself, I'd be looking at using OpenPyXL for this kind of work and I have in fact used said (not for this task, but for a far simper one) and it can get very involved and code heavy, if you want to have all the correct checks in place, which you should, tbh.
edit to add: I'm not a pandas user, but I've just learned that as of pandas version 2.0.0, the
append()
method has been completely removed, so you may want to check your version and, if needs be, use the concat()
method.
Sig:
>>> import this
The UNIX philosophy: "Do one thing, and do it well."
"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse
"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein
>>> import this
The UNIX philosophy: "Do one thing, and do it well."
"The danger of computers becoming like humans is not as great as the danger of humans becoming like computers." :~ Konrad Zuse
"Everything should be made as simple as possible, but not simpler." :~ Albert Einstein