This repository contains a sample code of web scrapping. The goal is to download the hospital provider data from Intuitive (Da Vinci's parent company) by state.
Then, I compiled data, combined with data from other source (Definitive), removed the duplicate ones, and visualize using Tableau.
Similarly, the other web scrapping file is the code to scrap data of procedure volume based on CPT codes and States in the US. By compiling data via R and visualizing through Tableau, one is able to see the trend of clinical service of his/her interest over year.
![Screenshot 2023-05-19 at 16 39 45](https://private-user-images.githubusercontent.com/69967271/239632898-dd313668-aa67-4325-9a27-5f538f59fe9f.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTk2MzczNzgsIm5iZiI6MTcxOTYzNzA3OCwicGF0aCI6Ii82OTk2NzI3MS8yMzk2MzI4OTgtZGQzMTM2NjgtYWE2Ny00MzI1LTlhMjctNWY1MzhmNTlmZTlmLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MjklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjI5VDA0NTc1OFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIyMzQ3MWJlZTE2YzFmYjk4OGNkZWY1ODM3YzhhMTA4MjgxMTVkMWRiZWJmYmU5ZGVmNTljMTM4MDBhM2RkMzEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.o7DweRoW-vy5rS4tqCpC02zCewANCk6Q3VJoXHRnQ_s)