Fill in correct data and missing data in to Spreadsheet from Wikipedia etc..

Manual Excel tables expansion, requires a little common sense and critical thinking which cannot be achieved with scrapers. Fill in the model series and mode generation column for each car. This can be done by grouping similar model names together and entering the model generation and series based on year. Currently the sheet looks like so, empty series and generation column This can be done by researching on wikipedia. or other sites (wikipedia being more reliable) For Example: We are looking at BMW 3series [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Model series for the most part is pretty easy as it can be just copied down following a pattern from the model_name column For example all 3xx model_name values are a 3 series all 5xx model_name values are a 5 series Model Generation This requires more research The model generation follows the following years of production since all 3 series produced from model_year 1982 - 1991 are E30 all 3xx model_names are to be pasted as E30. 3-series models between 1991 - 1998 would be labels E36 generation. Prior to 1975 - 1981 would be labeled E21. Outstanding model_bodies; Most detail and research There are missing model_years & model_bodies for most model_series. Create missing rows for Body styles and years of production. For Example: [login to view URL](E30) Copy existing rows and change year and update model_id by adding letter is ascending order behind Model_id's for new rows must not have ascending number but must be appended with a letter starting with A to Z if more are require AA etc.. This will prevent conflicts with existing entries in model_id's Sofar 38000 rows to group by series and generation. Does not include the missing model year/bodies rows that you will have to create. Interest in cars is a plus [login to view URL] Here are some FAQ: Examples: - The model generation for 911 needs to be different. for example year 1996 porsche 911. model generation is 993 - VW is simpler. In the chart is shows generations in roman numerals. Golf I, Golf II, Golf II, Golf IV, Golf V, Golf VI, Golf VII. All these are the same series name Golf if you select the VW Golf in Wikipedia you see they the generation is called MK1, MK2, MK3, MK4, MK5. MK6, MK7 -Audi is the same Series F103 is only 1 generation series Series 80 is 4 generation series (B1/B2/B3/B4)[login to view URL] Series A4 is 4 generation series (B5/B6/B7/B8)[login to view URL] - Smilar with nissan, looks like it needs a little more research and series are not as consistant, more model variation fewer generations If you look at the nissan silvia you will see it also has 7 generations [login to view URL] - For example in the year 1989 there is no BMW E30 325i 325 only shows until 1986 if you look at the production years in the attached picture the model goes from 1985-1991. 2) Please look for consistency with series "3-Series" "3 Series" is the same thing so stick to one "3-Series" and override "3 Series" 3) Please be consistent with mode_body_style Sedan = Saloon, Please override saloon Station Wagon = Touring, Please override them all to "Wagon" List of Body Styles: Convertible / Coupe / Hatchback / Sedan / SUV / Crossover / Truck / Van / Minivan / Wagon. 95% models will fit into these categories. Please review this for all generations 4) Wrong model_name in BMW 3 Series is not a model name. if you look at Trim it says Sedan 328i/328i xdrive/ 335i/ 335i xDrive the model names should be 328 and 335 respectively Please review this for all model_names 5) Porsche: Series is wrong. 930 / 964 / 993 / 996 / 997 / 991 are all generation of 911. They are the same as the Model_Name