Can anybody help with coding the below

Question

I have multiple text files saved in a folder. In each text file, there are few reject codes written among other things. I need to copy a file's all the reject codes in a particular cell in excel.(seperated by a comma (,) ) Can anybody help on how to do the same with Python?

Answer 1

Try using OS and Pandas, sounds like a great use case for those 2 libraries. You can "walk" the directories and manipulate the files with Pandas

Answer 2

csv ? python has csv module.
but depend on the size Pandas may be better

Answer 3

Yeah, the Pandas CSV functions work on text files