LotCode: A unique code that identifies the parking lot LotCapacity: A number with the respective parking lot capacity LotOccupancy: A number with the current number of cars in the parking lot LotCode LotCapacity LotOccupancy TimeStamp Day Lot01 863 174 11/20/2016 8:01 Sunday Lot01 863 179 11/20/2016 8:27 Sunday Lot01 863 189 11/20/2016 9:01 Sunday Lot01 863 197 11/20/2016 9:27 Sunday Lot01 863 226 11/20/2016 10:01 Sunday Lot01 863 247 11/20/2016 10:27 Sunday Lot01 863 331 11/20/2016 11:01 Sunday Lot01 863 400 11/20/2016 11:27 Sunday Lot01 863 469 11/20/2016 12:01 Sunday Lot01 863 510 11/20/2016 12:34 Sunday Lot01 863 594 11/20/2016 13:07 Sunday Lot01 863 618 11/20/2016 13:27 Sunday Lot01 863 637 11/20/2016 14:01 Sunday
Scenario: A city’s administration isn’t driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time-consuming and contribute to congestion. Some cities have rolled out data-driven parking space management to reduce congestion and make traffic more fluid.
You’re a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app that motorists can access to find parking space availability in different parking lots throughout the city.
Instructions: Work with the provided Excel database. This database has the following columns:
- LotCode: A unique code that identifies the parking lot
- LotCapacity: A number with the respective parking lot capacity
- LotOccupancy: A number with the current number of cars in the parking lot
LotCode | LotCapacity | LotOccupancy | TimeStamp | Day |
Lot01 | 863 | 174 | 11/20/2016 8:01 | Sunday |
Lot01 | 863 | 179 | 11/20/2016 8:27 | Sunday |
Lot01 | 863 | 189 | 11/20/2016 9:01 | Sunday |
Lot01 | 863 | 197 | 11/20/2016 9:27 | Sunday |
Lot01 | 863 | 226 | 11/20/2016 10:01 | Sunday |
Lot01 | 863 | 247 | 11/20/2016 10:27 | Sunday |
Lot01 | 863 | 331 | 11/20/2016 11:01 | Sunday |
Lot01 | 863 | 400 | 11/20/2016 11:27 | Sunday |
Lot01 | 863 | 469 | 11/20/2016 12:01 | Sunday |
Lot01 | 863 | 510 | 11/20/2016 12:34 | Sunday |
Lot01 | 863 | 594 | 11/20/2016 13:07 | Sunday |
Lot01 | 863 | 618 | 11/20/2016 13:27 | Sunday |
Lot01 | 863 | 637 | 11/20/2016 14:01 | Sunday |
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 5 images