phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Merge 4 CSVs into Interactive GPS/Magnetic Map in iGEM

  • Posted:
  • Proposals: 8
  • Remote
  • #4476958
  • Open for Proposals
Ashik R.David O.James H.Aurel H.Nikola C. + 3 others have already sent a proposal.
  • 5

Description

Experience Level: Entry
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-upload files.

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.

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Deborah Willy H.

    Hi Ashik,

    Your project is exactly the kind of data-to-visual storytelling I love working on — turning raw GPS and magnetometer data into a clean, interactive map isn’t just about merging files, it’s about making your data easy to explore, understand, and present professionally.

    I understand you need a fast, reliable solution that works smoothly even with your phone-based workflow, and delivered ready-to-upload without any technical stress on your end — I’ve got you covered.

    Here’s how I’ll handle your project efficiently:

    ✔ Clean and merge all CSV files into one structured master dataset (with proper device labeling like iPhone1, iPad2)
    ✔ Process and optimize GPS + magnetic field data for smooth performance
    ✔ Build a Kepler.gl-style interactive map with:
    – Time-based playback/animation slider
    – Color visualization by magnetic field strength
    – Device-based filtering layers
    – Rich tooltips (timestamp, GPS, mag values, etc.)

    ✔ Export as a self-contained HTML package ready for your website
    ✔ Provide a simple upload guide (or assist with setup if needed)
    ✔ Share previews via Google Drive for easy phone access

    I’ve worked with CSV datasets, geospatial visualization, and interactive mapping tools, delivering clean, user-friendly outputs clients can use immediately without technical hassle.

    Given your timeline, I can deliver a high-quality result within 1–3 days, depending on file size — with clear communication throughout.

    If you’d like, I can also handle future data overlays (like iOS forensic files) as a next step.

    Let’s get this done quickly and professionally for you.
    Feel free to send over the sample CSVs — I’m ready to start right away.