Merge 4 CSVs into Interactive GPS/Magnetic Map in iGEM

Quick 1-3 day turnaround preferred. Phone-based client (share files via Google Drive link). Budget $150–$200 BTC depending on speed/quality.

Merging CSVs from 4 devices, Kepler.gl style interactive map with time playback, color by mag field, export HTML for website upload. 4 csv. files sent for trial period.

Hello freelancers!

I'm looking for someone experienced with data merging, GPS/magnetometer datasets, and interactive web visualizations to help turn my raw files into a professional, shareable product. I'm not tech-savvy with coding and have limited time/access to a computer (mostly phone-based), so I need this done efficiently and delivered ready for my existing hosted website.

Project Details: I have multiple.csv files (dozens total) exported from the CrowdMag app on 4 iOS devices (2 iPhones + 2 iPads). Each CSV includes: timestamps, latitude/longitude (GPS), altitude, magnetic field components (Bx, By, Bz, total in nT), accuracy, etc. Goal: Merge/clean all files into one master dataset (add a "Device" column like "iPhone1", "iPad2" based on filenames or patterns). Create a beautiful, interactive web-based map visualization with: Time-based playback/animation (like a timeline slider to show movement over time). Points/lines colored by magnetic field strength (total nT) or per device. Layers/filters for each device. Tooltips showing full details (timestamp, mag values, GPS, etc.).

Best tools: Kepler.gl (preferred

• export as self-contained HTML/JS), Folium/Python, Power BI publish to web, or similar no/low-code options that result in easy-to-es.

Provide the final output as a ZIP folder (HTML + JS/CSS/assets) with simple upload instructions for my website (e.g., via cPanel/FTP

• I can share access if needed, or just send files).

Bonus (optional, separate milestone): If I can later provide iOS forensic files (like cache.sqlite for GPS from iGem tool), overlay or compare with that data.

Requirements:

Experience with CSV handling (pandas/Excel/Power Query), geospatial data, and interactive maps (Kepler.gl, Leaflet, etc.). Comfortable delivering phone-friendly communication (Google Drive links for file sharing/previews Quick turnaround: Ideally 1–3 days max once files are shared.

Budget: USD 15/hour

Proposals: 9 freelancers have applied