I. Descriptive Statistics For "CVE Details" Site

Parts of the work

1) run script scrapProducts.py for scraping products for each year in the range 1999-2019. This script creates many xslx-files (1999_31_5.xlsx, 1999_36_23.xlsx, ... ) for each products:

2) run script createGeneralDF.py. This script creates All_Data_for_Analysis.xlsx from xslx-files (1999_31_5.xlsx, 1999_36_23.xlsx, ... ).

3) run this jupyter notebook for the analysis. The file All_Data_for_Analysis.xlsx from previous step is input file.

4) the script userDialog.py produces 1 ouput file for the single product_id, vendor_id, year. For example, this is user dialog during the script running:

This script gives opportunity to add the new file before combine all xlsx-files to All_Data_for_Analysis.xlsx.

II. Descriptive Statistics For "CVE Details" Site --- Each Project ID - Vendor ID

Parts of the work

1) run script eachFromGeneral.py for the creating data for each products and all years in the range 1999-2019. This script creates many xslx-files in the folder 'EachProducts': 31_5_for_Analysis.xlsx, 36_23_for_Analysis.xlsx, ... for each products during all years.

2) run this jupyter notebook for the analysis. The file All_Data_for_Analysis.xlsx from previous milestone is the input file.