You are given a dataset. The dataset file name is CAR_ACCIDENTS_VEECTORIA.csv. The file size is 2...

 

Transcribed Image Text:

You are given a dataset. The dataset file name is CAR_ACCIDENTS_VEECTORIA.csv. The file size is 2 kb. The data was created on 2 Jan 2020. The dataset was provided and prepared by Veectorian Government and is publicly available. Point of contact and team members are not provided. The full dataset is shown below: [20 marks] 1 ACCIDENT INDEX ACCIDENT_TIME ACC_TYPE Accident Type Descriptor T20060000010 1 Collision with vehicle 1 Collision with vehicle 7 Fall from or in moving vehicle 1 Collision with vehicle 1 Collision with vehicle 1 Collision with vehicle 2 3 T20060000018 4 T20060000022 5 T20060000023 6 T20060000026 7 T20060000028 8 T20060000035 9 T20060000042 10 T20060000044 11 T20060000046 12 T20060000047 13 T20060000050 14 T20060000066 15 T20060000094 16 T20060000095 17 T20060000096 18 T20060000105 19 T20060000111 20 T20060000114 21 T20060000116 12:42:00 19:10:00 12:10:00 11:49:00 10:45:00 16:15:00 10:55:00 22:00:00 8:55:00 11:00:00 11:53:00 11:50:00 4:30:00 15:55:00 16:15:00 13:30:00 18:30:00 22:30:00 7:25:00 9:15:00 4 Collision with a fixed object 4 Collision with a fixed object 1 Collision with vehicle 2 Struck Pedestrian 4 Collision with a fixed object 1 Collision with vehicle 2 Struck Pedestrian 1 Collision with vehicle 1 Collision with vehicle 1 Collision with vehicle 4 Collision with a fixed object 1 Collision with vehicle 1 Collision with vehicle 4 Collision with a fixed object SEVERITY SPEED, KM/H PERSONS INVOLVED 60 75.4 100 80 50 100 100 70 81.2 3 3 2 2 3 2 2 2 2 3 1 2 2 2 3 3 1 2 2 2 60 80 80 80 100 63.5 50 100 80 110 100 1. Create a data dictionary for the dataset. The data dictionary should include both the dataset description and the attribute description. 2. For each attribute, explain your choice of the data type. [6 marks for the dataset description. 2 marks for each correct attribute data type] 2 2 1 3 5 4 1 2 2 3 1 2 2 3 4 6 2 3 1 You are given a dataset. The dataset file name is CAR_ACCIDENTS_VEECTORIA.csv. The file size is 2 kb. The data was created on 2 Jan 2020. The dataset was provided and prepared by Veectorian Government and is publicly available. Point of contact and team members are not provided. The full dataset is shown below: [20 marks] 1 ACCIDENT INDEX ACCIDENT_TIME ACC_TYPE Accident Type Descriptor T20060000010 1 Collision with vehicle 1 Collision with vehicle 7 Fall from or in moving vehicle 1 Collision with vehicle 1 Collision with vehicle 1 Collision with vehicle 2 3 T20060000018 4 T20060000022 5 T20060000023 6 T20060000026 7 T20060000028 8 T20060000035 9 T20060000042 10 T20060000044 11 T20060000046 12 T20060000047 13 T20060000050 14 T20060000066 15 T20060000094 16 T20060000095 17 T20060000096 18 T20060000105 19 T20060000111 20 T20060000114 21 T20060000116 12:42:00 19:10:00 12:10:00 11:49:00 10:45:00 16:15:00 10:55:00 22:00:00 8:55:00 11:00:00 11:53:00 11:50:00 4:30:00 15:55:00 16:15:00 13:30:00 18:30:00 22:30:00 7:25:00 9:15:00 4 Collision with a fixed object 4 Collision with a fixed object 1 Collision with vehicle 2 Struck Pedestrian 4 Collision with a fixed object 1 Collision with vehicle 2 Struck Pedestrian 1 Collision with vehicle 1 Collision with vehicle 1 Collision with vehicle 4 Collision with a fixed object 1 Collision with vehicle 1 Collision with vehicle 4 Collision with a fixed object SEVERITY SPEED, KM/H PERSONS INVOLVED 60 75.4 100 80 50 100 100 70 81.2 3 3 2 2 3 2 2 2 2 3 1 2 2 2 3 3 1 2 2 2 60 80 80 80 100 63.5 50 100 80 110 100 1. Create a data dictionary for the dataset. The data dictionary should include both the dataset description and the attribute description. 2. For each attribute, explain your choice of the data type. [6 marks for the dataset description. 2 marks for each correct attribute data type] 2 2 1 3 5 4 1 2 2 3 1 2 2 3 4 6 2 3 1

Answer rating: 100% (QA)

a data dictionary for the car accidents dataset Data Dictionary for Car Accidentscsv Dataset Descrip... View the full answer