Based on the data shown here the GigBAR Move is the top visited product page of 2020. But how are the company's dealers are representing the top product on their websites? Using the total CSV file with all the dealers nationwide we did research to have a sample of 14 random dealers that sell the GigBAR Move on their website. We compiled data on the logo, price and description by scraping each dealers' website using Beautiful Soup. At the end of the scraping we got all the data for each dealer and converted that into a data frame using Pandas, conducted ETL and finally converted it into a CSV that would be loaded into PosgreSQL. Using Flask we converted the PosgreSQL table into a JSON file which allows dealer filtering via a dropdown field.

Name Logo Description Price Website