See Sample excel file. There are names of companies and their addresses. This is just sample. Actual file will be bigger. It goes to until column E.
Also, see the text file. It's just text file about a company.
Make a program that will add column F to the excel file. Column F will contain the text (.txt) file name that is associated with this company.
So, you need to merge excel data and text file using company names.
Remember. Not all company names exactly coincide. For example, "Corporation" can be written as "Corp" or "Co". There are many such examples. Tell me how you will handle this problem. Tell me all such examples.
When you bid, answer the following questions. Otherwise, your bid will be immediately removed.
1. Don’t be discouraged even if I hire someone before hiring you. I will hire multiple people because there are many documents. And I will pay all people I hire. Do you understand?
2. I said not all company names exactly coincide. For example, "Corporation" can be written as "Corp" or "Co". Tell me all such examples you know. I already know many examples. I am testing you.
28 szabadúszó tett átlagosan $162 árajánlatot erre a munkára
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Corporation could be written as, Corp, Corp. , CPN, Co, Co., or simply Coy and INC for incorporated. Please contact i will do this using python. Thanks.................................................