Combine and resample
You'll now combine environmental data with a traffic dataset.
The traffic consists of 2 columns, light_veh and heavy_veh.
heavy_vehrepresents the number of heavy vehicles like lorries or busses per hour on a road of a small city.light_vehcontains the number of light vehicles, like automobiles or motorbikes per hour on that road.
The environmental dataset consists of
temperaturein degree Celsius.humidityin percent.sunshineduration in seconds.
Since the traffic-dataset is in 1 hour buckets, but the environmental data is in 10 minute buckets, you'll need a way to resolve this.
The data is available as environ and traffic.
This exercise is part of the course
Analyzing IoT Data in Python
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Combine the DataFrames
environ_traffic = pd.____([____], axis=____)
# Print first 5 rows
____