Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Python,Python Numpy,Pandas,Data Science freelancer for Combining Multiple Sensor Data CSVs into a single CSV job

Posted at - Apr 26, 2023


OVERVIEW
I have a collection of sensor data from 40 sites in a CSV format. There is one folder for each site. In each folder, there are many CSVs.

The project is to combine each of the CSVs for a site into a single CSV with all sensor data for that site.

This should be relatively trivial to do in Python, though it will require creating a single, comprehensive list of all timestamps, ordering them, and then correctly populating sensor values correctly in each row based on those timestamps. If you can provide python source code that does this, that would be appreciated.

SOURCE CSVs
Each CSV contains three headers per row: point, ts, val

point: The UUID for that sensor
ts: The timestamp when the value was recorded by that sensor
val: The value recorded by the sensor

OUTPUT CSVS
The CSV filename format should be buildingname_first-reading-date_last-reading-date_sensor-count.
I will share one csv file with shortlisted candidates.
The CSV header format should be ts,point1,point2,point3.

DELIVERABLES
A successful output of the project will be:
- A zip file with 40 CSVs
- Each CSVs formatted as buildingname_first-ts_last-ts_sensor-count
Complete data will be provided to the winning candidate.

About the recuiterMember since Mar 14, 2020 Vinod Kumar
from Saratov, Russia

Skills & Expertise Required

Python Python Numpy Pandas Data Science 

Open for hiringApply before - Apr 25, 2024

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$71.97
Cost

Offer to work on this project closes in 27 days!
Are you interested in this Opportunity?

Apply Now

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Data Mining And Management category.


Related Jobs


Latest In Python Jobs


Latest In Python Numpy Jobs


Latest In Pandas Jobs


Latest In Data Science Jobs