Tuesday, December 8, 2020

Web Scraping Using Beautiful Soup (Python lib) and Creating a job on Ms SQL to automate updation

 Step 1 : Web scraping Wikipedia using Pythons library Beautiful Soup to pull out info of Countries in Asia & Pacific.


                


Step 2 : Tidying up the output data a bit.
                    
                                    

Step 3 : Importing the data into MS SQL and creating a Sub Procedure to update.

                                

Step 4 : Connecting Tableau to MS SQL for final Visualization

                                   



No comments:

Post a Comment

Web Scraping Using Beautiful Soup (Python lib) and Creating a job on Ms SQL to automate updation

 Step 1 : Web scraping Wikipedia using Pythons library Beautiful Soup to pull out info of Countries in Asia & Pacific.                  ...