ISSS608 Sanghavy Data Preparation

From Visual Analytics and Applications
Revision as of 06:08, 18 July 2017 by Sanghavyb.2016 (talk | contribs) (Created page with "==Background of given data== The given Lekagul sensor data is a .csv file contains 4 fields: * Timestamp: the date and time the sensor reading was taken * Car-id: the assign...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Background of given data

The given Lekagul sensor data is a .csv file contains 4 fields:

  • Timestamp: the date and time the sensor reading was taken
  • Car-id: the assigned car ID from the entry gate
  • Car-type: Vehicle type as enumerated above. “P” is appended when it is a park vehicle.
  • Gate-name: name of the sensors taking the reading. See the map.


Car type

There are 7 types of car including the park vehicle and 5 different sensors present at each Gate type.

  • The dataset has the car type as integers 1, 2, 3, 4, 5, 6 and park vehicles as 2P
Integers Car type
1 2 axle car (or motorcycle)
2 2 axle truck
3 3 axle truck
4 4 axle (and above) truck
5 2 axle bus
6 3 axle bus
2P Park vehicle – 2 axle truck

Gate types

Gate Category Gate Name
Camping Camping0, Camping1, Camping2, Camping3, Camping4, Camping5, Camping6, Camping7, Camping8
Entrance Gate Entrance0, entrance1, entrance2, entrance3, entrance4
General Gates General-gate0, General-gate1, General-gate2, General-gate3, General-gate4, General-gate5, General-gate6, General-gate7
Gate Gate0, Gate1, Gate2, Gate3, Gate4, Gate5, Gate6, Gate7, Gate8
Ranger Stops Ranger-stop0, Ranger-stop1, Ranger-stop2, Ranger-stop3, Ranger-stop4, Ranger-stop5, Ranger-stop6, Ranger-stop7
Ranger Base ranger-base

Data Preparation – Tableau

STEP 1: Creating Aliases for Car Type

As mentioned in the background, the car type variable is represented as integers in the given .csv file. So, we create aliases for them to better understand and also for aesthetic purposes.

STEP 2: Grouping gate name

Secondly, the 40 gates available can be grouped into 5 types. As mentioned in Table 2, we can get 5 groups but we can separate Ranger base from ranger stops for better analysis and keep it as a separate variable.

STEP 3: CREATING X and Y COORDINATES FOR each sensor location

In this step, we create x and y coordinates for each sensor location. This is done by using the mapping feature in Tableau. First an excel file is created with the gate names and empty x and y columns with either null values or some sample values like shown below:

Q12 3 bus Sanghavy.JPG