Our urban water management project has collected raw sensor data from drainage systems, and it needs to be cleaned and prepped for pollution level analysis.
Requirements:
Experience working with IoT or environmental data
Excel skills to align timestamps and filter out anomalies
Ability to normalize units and handle missing values
To Apply:
Mention any work you’ve done with sensor, weather, or environmental datasets.
Milestones
Project Deliverables & Tasks
Tasks Required:
Convert timestamps to unified timezone and format
Clean and standardize sensor readings
Remove or flag erroneous rows
Fill missing values via interpolation or flag
Merge both datasets into one master file
Deliverables:
Final cleaned Excel file
Log tab noting fixes and dropped entries