Automate Excel Activities using Python

Hi, Myself Raghavendra working for a Private organization. Day - In - Out, I work with excel files and created few Macros on my own. Organization is now looking to introduce Python for Automation. Hence, I seek assistance to automate my same activities using Python. I have two such activities. First Activity: Do Reconciliations. We get the data in a CSV extension, In this file, will be having fixed 58 headers. No. of. Rows will 3-8 L as the months passes. Basis other input file, will consider limited required columns and then, will start workings in CSV file, firstly will do the v-lookup using data from other input file and then based on only Seven columns will be assigning invoice name like wise will be filling all the 4-8 L rows. Example: Given, In column AB as ABCD and column AE as XYZ and AY as Chocki, AZ as Chocolate, BA as Sweetener, then will be Naming this line as CompanyName_month_year. From below table, If we look-in "United_States_Month_Year_Testing" and "Bermuda_States_Month_Year_Procurement" gettng repeated based on combination of "Consuming Country", "Billable Customer LE", "Billable Operating Country" if these columns matches, then the same Naming should be given. Please copy the below data in Excel for clear understanding. Consuming Country Billable Customer LE Billable Operating Country Naming Set ABCD A USA United_States_Month_Year_Testing Testing EFGH B BMU Bermuda_States_Month_Year_Procurement Procurement IJKL C CAD Canada_States_Month_Year_Marketing Marketing MNOP D MXN Mexico_States_Month_Year_Marketing Marketing ABCD A USA United_States_Month_Year_Testing Marketing EFGH B BMU Bermuda_States_Month_Year_Procurement Marketing ABCD B USA United_States_Month_Year_Procurement Procurement Once, the naming is done for all items then if any amount below threshold (example 100 rupees) for all that Names should pop-up as below threshold. if >=100 then comment should be invoice to be issued. After the Naming and comments are updated, the file should be saved in Excel Binary extension. This is my requirement. Based on the satisfaction level of first report, will be discussing on Second report. I can be contacted anytime after 11.AM. please. Also, I'm interested to join as a student to get trained and well-verse with Python for Excel. Looking forward for a response. Thank you, Raghavendra. k