Excel Automation using Python

 We can use Python to automate most of the things that we do on Excel just like creating a macro in VBA, it is a good alternative to VBA.

I had an unclean and unstructured excel file which was copy pasted from a website. The first option I had was to try to clean it on Tableau Prep but what I later realized is that Tableau Prep can be good on data which is structured and easy to clean. But for a completely scrambled data the best options are either VBA or Python.

1. Unstructured Data

    

2. Python Code

    

    

3. Final Output