I have Select 2 parking lots and created a scatter plot showing occupancy rate against TimeStamp for the week 11/20/2016 - 11/26/2016. I am needing help answering these questions in bold. : Are occupancy rates time dependent? If so, which times seem to experience the highest occupancy rates? Is this what you expected?Thank you for your help!

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 in an effort 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 or not 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 motorists can access to find parking space availability in different parking lots throughout the city.

Part 1: Data Manipulation Download the Parking Lot Use data set. The data set 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 TimeStamp: a day/time combination indicating the moment when occupancy was measured Day: the day of the week corresponding to the TimeStamp Insert a new column, OccupancyRate, recording occupancy rate as a percentage with 1 decimal.