
Complété
Publié
Payé lors de la livraison
PROJECT TITLE: Extract Historical Hourly Forecast Temperature Data (Open-Meteo) PROJECT DESCRIPTION: I require extraction of historical hourly forecast temperature data from the Open-Meteo Previous Runs API. The goal is to retrieve archived hourly forecast temperatures for a fixed list of US locations from: START DATE: 2024-01-01 END DATE: [INSERT TODAY’S DATE] No UI, no dashboard, no hosting required. This is a data extraction and structuring task only. ------------------------------------------------------------ DATA SOURCE: Open-Meteo Previous Runs API Base endpoint: [login to view URL] ------------------------------------------------------------ REQUIRED VARIABLES (HOURLY): Retrieve the following hourly fields: - temperature_2m - temperature_2m_previous_day1 - temperature_2m_previous_day2 - temperature_2m_previous_day3 - temperature_2m_previous_day4 - temperature_2m_previous_day5 Timezone must be: UTC Temperature unit must be: Fahrenheit ------------------------------------------------------------ LOCATIONS: A total of 19 US locations will be provided including: - Station name - Latitude - Longitude All 19 must be included. ------------------------------------------------------------ DATE RANGE: Start: 2024-01-01 End: [INSERT TODAY’S DATE] Full continuous coverage required across entire range. ------------------------------------------------------------ REQUIRED OUTPUT STRUCTURE: Deliver as CSV (UTF-8 encoded). Each row must represent: (station_id, timestamp_utc, lead_days) Required columns: - station_id (string) - station_name (string) - latitude (float) - longitude (float) - timestamp_utc (ISO 8601 format, UTC) - lead_days (integer: 0–5) - temperature_f (float) Lead mapping: lead_days = 0 → temperature_2m lead_days = 1 → temperature_2m_previous_day1 lead_days = 2 → temperature_2m_previous_day2 lead_days = 3 → temperature_2m_previous_day3 lead_days = 4 → temperature_2m_previous_day4 lead_days = 5 → temperature_2m_previous_day5 ------------------------------------------------------------ DATA INTEGRITY REQUIREMENTS (MANDATORY): 1. No duplicate rows. Unique key must be: (station_id, timestamp_utc, lead_days) 2. No missing timestamps within API-available range. 3. All timestamps must be in UTC. 4. All lead_days layers (0–5) must be present for all timestamps returned. 5. Include an audit summary file showing: - Total rows per station - Total rows per lead_days layer - Date coverage per station - Count of null values (if any) ------------------------------------------------------------ EXTRACTION REQUIREMENTS: - Data must be retrieved in safe date windows (e.g., 7–30 day blocks) - Script must handle retries and timeouts - Full coverage must be verified before delivery ------------------------------------------------------------ DELIVERABLES: 1. Final clean CSV dataset 2. Audit summary file 3. Python extraction script used 4. Short README explaining extraction method ------------------------------------------------------------ ACCEPTANCE CRITERIA: Work will be accepted if: Before full run, please deliver a small paid sample: - 1 station for 2024-01-01 to 2024-01-31 - Full date range covered - No duplicate composite keys - Lead layers 0–5 present - Audit totals match dataset If the sample checks out, proceed with the full 19-station extraction This is a data extraction task only. No analysis required.
N° de projet : 40237147
138 propositions
Projet à distance
Actif à il y a 20 jours
Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux

This is a very clear and well-structured extraction task — I like it. You’re not asking for dashboards or fluff, just clean, verifiable data with strict integrity rules. That’s exactly the kind of work we do well. Here’s how I’d approach it: - Chunked extraction (7–14 day windows) from Open-Meteo Previous Runs API to avoid timeouts and rate limits - Automatic retries with exponential backoff - Strict UTC normalization at fetch time - Transformation layer that explodes the hourly response into `(station_id, timestamp_utc, lead_days)` rows (0–5 mapping exactly as defined) - Composite key validation before final export - Full continuity checks per station and per lead layer - Automated audit generator (row counts, date coverage, null counts, duplicate scan confirmation) You’ll receive: 1. Final UTF‑8 CSV (fully deduplicated) 2. Audit summary (station-level + lead-level + coverage validation) 3. Clean, documented Python script (modular + configurable date range) 4. Short README explaining method + verification steps A couple of small clarification points before starting: - You mention 4 US locations and then “All 19 must be included.” Should I proceed with 4 stations? - Should I freeze the end date at execution time (today’s actual UTC date), or do you prefer it passed dynamically in the script? We’ve been building data-driven systems since 2000, with a team of 25+ engineers. While our portfolio includes large-scale web systems, a big part of our backend work involves structured API extraction, validation logic, and reliable production-grade scripting. A few relevant builds: An API-based financial system with strict transaction integrity checks [login to view URL] A SaaS product with automated data validation and layered data flows [login to view URL] AWS / DevOps environments where we manage reliable scheduled processes and automation pipelines (Managing: [login to view URL], [login to view URL], [login to view URL] in AWS/Azure/DO) Even though this isn’t a UI project, the same backend rigor applies — especially with your no-duplicate composite key and full lead-layer enforcement requirements. I’ll also include a small internal validation report (not just counts) that verifies: - Timestamp continuity gaps - Lead layer completeness per timestamp - Deterministic row count expectation - Hash-based dataset fingerprint for integrity verification That way acceptance testing becomes straightforward and objective. Timeline estimate: 4–6 days including validation and QA. The bid below is a reasonable midpoint placeholder — once you confirm station count and any API constraints, I’ll lock it precisely. This is a clean engineering task. Happy to get it done properly.
$850 AUD en 5 jours
8,1
8,1
138 freelances proposent en moyenne $445 AUD pour ce travail

Hello, This is a structured data engineering task, and the integrity requirements are clear, which I appreciate. My approach would be to build a robust Python extraction script that: • Iterates through each station and pulls data in controlled date windows (e.g., 14–30 days per request) • Implements retry logic and timeout handling for API stability • Normalizes all timestamps to UTC and verifies continuous hourly coverage • Reshapes the six temperature layers into a long format with proper lead_days mapping (0–5) • Enforces composite key uniqueness before export After extraction, I will run a validation layer that checks: • No duplicate composite keys • Full date range coverage per station • Presence of all six lead layers for every timestamp • Null counts per field Deliverables will include: 1. Clean UTF-8 CSV dataset 2. Audit summary file with row counts per station, per lead layer, coverage window, and null statistics 3. Fully documented Python script 4. Short README explaining the extraction and validation workflow I focus on reproducible, audit-ready data pipelines where correctness is non-negotiable. Best, Jenifer
$500 AUD en 7 jours
9,4
9,4

With my extensive experience in data extraction, processing, and skills with Excel, I am well-equipped to tackle your project requirements. I have successfully performed various data extraction projects throughout my career, including those with large volumes of data and strict structuring guidelines, as you have specified. Your project demands not only technical skills but also a keen eye for detail to ensure the integrity and completeness of the extracted data. I understand this importance fully; hence will meticulously extract hourly forecast temperature data for the US locations you provided using Open-Meteo's Previous Runs API. Moreover, being skilled at automating repetitive tasks like this one through scripts,I will create a Python script to retrieve data in safe date windows, handle retries and timeouts ensuring full coverage before delivery. Finally, you can count on me for timely delivery of the final clean CSV dataset along with all the required audit files and documentation as mentioned in your project description. Trust me to deliver an accurate result that meets all your acceptance criteria. Looking forward to working with you!
$250 AUD en 1 jour
8,9
8,9

I have extensive experience in PHP, JavaScript, Python, Data Processing, and Excel, making me a strong fit for the Temperature Data Extraction (Open-Meteo API) project. I am confident in my ability to meet the project requirements efficiently. The budget can be adjusted after a detailed discussion, and I am committed to delivering high-quality results within your budget. Please review my 15-year-old profile to see my past work. Let's discuss the project further and I am eager to begin working on it immediately.
$525 AUD en 10 jours
8,7
8,7

Hello, As a seasoned data extraction professional with expertise in API Development and Python, I am confident in my ability to deliver exceptional results for your project. Over the years, I have mastered the art of extracting structured data from diverse sources, making me an ideal fit for this task. I have hands-on experience working with similar projects, ensuring maximum coverage while maintaining data integrity. In terms of technical capabilities, my proficiency in Python allows me to create scripts that efficiently handle retries, timeouts, and intermittent API windows. Additionally, my strong command over Excel ensures accurate structuring and manipulation of large data sets. You can be assured of no duplicate rows and all the timestamped data aligned correctly as per your requirements. let's connect, thank you Gaurav D.
$500 AUD en 7 jours
8,5
8,5

Hi I’m your web developer, ready to turn your project Temperature Data Extraction (Open-Meteo API) into reality! I’d love to discuss the details and create something amazing together. Feel free to message me anytime, and we can also hop on a quick video or audio call whenever it's convenient for you. I’ve developed many projects exactly like what you’re looking for. If you want to see more relevant samples, just contact me through the chatbox, and I’ll share them instantly. ★ Why Clients Trust Me 500+ successful web projects delivered 430+ positive client reviews Expert in PHP, JavaScript, Python, Data Processing, Excel, Data Extraction, API Development WordPress, Shopify, PHP, JavaScript, HTML, CSS, Plugin/Theme Development, Laravel, WebApp Clean, modern, responsive and SEO-optimized designs Fast delivery, great communication, and long-term support Available during EST hours for smooth collaboration If you want a professional developer who delivers quality work on time and stress-free, let’s connect. I’m excited to help build something amazing for you. Best regards, Kausar Parveen
$350 AUD en 3 jours
8,3
8,3

Hi there, I understand that you need to extract historical hourly forecast temperature data from the Open-Meteo Previous Runs API for a fixed list of US locations. My approach will ensure that all required fields are accurately retrieved and structured according to your specifications. I will implement a Python script to handle the data extraction, ensuring that it retrieves the necessary temperature data in safe date windows. The script will include error handling for retries and timeouts, guaranteeing reliability throughout the process. I prioritize clear communication and will provide you with a final clean CSV dataset, an audit summary file, and the extraction script along with a README for your reference. You can expect timely updates and a commitment to quality throughout the project. Looking forward to the opportunity to work together. Best regards, Burhan Ahmad TechPlus
$750 AUD en 5 jours
8,3
8,3

⭐⭐⭐⭐⭐ Extract Historical Hourly Forecast Temperature Data with Python ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project requirements and noticed you're looking for someone to extract historical hourly forecast temperature data from the Open-Meteo API. Look no further; Zohaib is here to help you! My team has successfully completed 50+ similar projects focused on data extraction. I will create a Python script to retrieve and structure the data efficiently. ➡️ Why Me? I can easily do your data extraction task as I have 5 years of experience in Python programming, API integration, data manipulation, and CSV handling. Not only this, but I also have a strong grip on data integrity checks and error handling, ensuring accurate and reliable output. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing this with you in chat. ➡️ Skills & Experience: ✅ Python Programming ✅ API Integration ✅ Data Extraction ✅ Data Structuring ✅ CSV Handling ✅ Data Integrity Checks ✅ Error Handling ✅ Timezone Management ✅ Script Optimization ✅ Data Retrieval ✅ Historical Data Analysis ✅ Audit Summary Generation Waiting for your response! Best Regards, Zohaib
$350 AUD en 2 jours
8,0
8,0

Hi I have downloaded data from Open-Meteo platform before and can provide you exactly the data you need, in CSV format using their API. I will provide you CSV data for targeted locations, a Python script as well as README instructions to setup and run the program later on your end. I'm available to discuss details in chat and can start right away. Abdul H.
$250 AUD en 2 jours
7,7
7,7

Hello, We've carefully reviewed your project for extracting historical hourly forecast temperature data from the Open-Meteo API, and we're excited about the opportunity to assist you. Your project requires precise data extraction and structuring, and we understand the importance of accuracy and completeness in this task. Having successfully completed similar projects involving data extraction and API integration, we have a strong grasp of the requirements, including handling date ranges, ensuring data completeness, and managing API retrievals efficiently. For instance, we recently worked on a project requiring large-scale data extraction using similar methodologies, which was delivered with high precision. Our extensive experience in Python, data processing, and API development positions us perfectly for this task. As experts in automation and intelligent systems, we ensure robust and scalable solutions. Our portfolio of over 200 clients attests to our commitment to delivering top-rated results consistently. We invite you to message us with further details. We'll provide a comprehensive, tailored proposal within 24 hours to outline our approach and solution for your project needs. Looking forward to collaborating, Puru Gupta
$750 AUD en 7 jours
7,9
7,9

Hello, Would you like to see a demo of the historical temperature data extraction solution before making any commitment? I specialize in efficiently extracting large datasets from APIs like Open-Meteo, ensuring precise temperature readings with full data integrity. Let’s discuss how I can deliver a comprehensive CSV dataset along with an audit summary that meets all your criteria—I'm eager to showcase the demo and ensure you have complete confidence in the solution. Regards, Smith
$500 AUD en 7 jours
7,4
7,4

Hello I am Software Developer and I have over 25 years of overall experience, including Web Scraping and Web Automation. I have got you need to extract data from Web based API - I can do it quickly
$251 AUD en 1 jour
7,5
7,5

Hi I can build a robust Python extraction pipeline that retrieves all historical hourly forecast temperatures (lead_days 0–5) from the Open-Meteo Previous Runs API and outputs a fully validated CSV dataset. The main technical challenge is ensuring complete, gap-free coverage across the large 2024-present date range while avoiding duplicates, which I solve using windowed API requests, composite-key validators, and structured retries with back-off. Each station’s data will be normalised into the required schema, mapped to UTC timestamps, and expanded into lead_days layers 0–5 with strict integrity checks. I will generate an audit summary file reporting row counts, missing timestamps, null values, and date coverage per station. The deliverables will include the clean CSV, the audit file, the Python script, and a README documenting the extraction method and safeguards. Before running the full job, I’ll provide the required paid sample for one station covering January 2024 with full validation. This process ensures accuracy, reproducibility, and end-to-end compliance with your acceptance criteria. Thanks, Hercules
$500 AUD en 7 jours
7,0
7,0

Hello! I am excited to submit my proposal for your project on extracting historical hourly forecast temperature data using the Open-Meteo API. With over 9 years of experience in full-stack development and strong expertise in PHP and backend services, I am confident in delivering a precise and efficient solution tailored to your needs. My team at Smart Sols specializes in API integrations and data extraction, ensuring clean, reliable, and well-structured data output. We take pride in clear communication and timely delivery, fully understanding the importance of accuracy in historical weather data extraction. I am ready to start immediately and will provide you with a robust, maintainable codebase that can be extended or adapted if needed in the future. Looking forward to collaborating and exceeding your expectations.
$750 AUD en 5 jours
6,9
6,9

As a skilled Full-Stack Web Developer leading BN-Droids Digital Services, data extraction and structuring are at the core of what I do best. My team excels in web data scraping, extracting and maintaining massive databases of millions of records daily, just like the one you require for this project. We're proficient with languages such as HTML5, CSS, JavaScript, and PHP - all key elements for the successful completion of this task.
$250 AUD en 7 jours
6,9
6,9

Hi, Thank you for considering my proposal. I have carefully reviewed the requirements for the project and I am confident in my ability to assist you. With over 8 years of real-world and freelance experience in Excel, I am well-equipped to handle the data extraction task you have outlined. I would like to connect with you in chat to discuss the specifics of your project further. Regards
$250 AUD en 1 jour
6,8
6,8

With over 8 years of professional experience in software development and data extraction, I am more than ready to tackle your project involving the Open-Meteo Previous Runs API. My extensive skill set includes expertise in Python, which has proven to be invaluable when it comes to automating tasks and ensuring seamless data retrieval and structuring. Let’s connect
$350 AUD en 2 jours
6,4
6,4

Hello, Thank you so much for posting this opportunity. It sounds like a great fit, and I’d love to be part of it! I’ve worked on similar projects before, and I’m confident I can bring real value to your project. I’m passionate about what I do and always aim to deliver work that’s not only high-quality but also makes things easier and smoother for my clients. Feel free to take a quick look at my profile to see some of the work I’ve done in the past. If it feels like a good match, I’d be happy to chat further about your project and how I can help bring it to life. I’m available to get started right away and will give this project my full attention from day one. Let’s connect and see how we can make this a success together! Looking forward to hearing from you soon. With Regards! Abhishek Saini
$750 AUD en 7 jours
6,7
6,7

Your Open-Meteo extraction will fail silently if you don't handle their archive retention policy - they purge forecast runs older than 90 days, which means your 2024-01-01 start date is already outside their available window. You'll get empty responses without error codes. Before I architect the extraction pipeline, I need clarity on two things: What's your actual use case for the previous_day layers? If you're building a forecast accuracy model, we need to align the lead_days with the actual forecast issuance time, not just stack temperature columns. Most clients misinterpret this API structure. Do you have fallback requirements if Open-Meteo's archive doesn't go back to January 2024? Their docs state 90-day retention, so we may need to pivot to their ERA5 reanalysis endpoint or accept partial coverage from ~October 2024 forward. Here's the extraction approach: - PYTHON + REQUESTS: Build a chunked retrieval system with exponential backoff to handle their 10K requests/day limit without triggering 429 errors or silent data gaps. - DATA VALIDATION LAYER: Implement composite key uniqueness checks and timestamp continuity verification before writing to CSV - catching missing hours at extraction time, not after delivery. - LEAD_DAYS TRANSFORMATION: Reshape the API's nested JSON structure into your flat schema while preserving the forecast-issuance-to-valid-time relationship that most scripts break. - AUDIT PIPELINE: Generate row counts, null detection, and coverage heatmaps per station using pandas profiling to prove completeness before you accept delivery. I've extracted 2M+ rows from weather APIs for 3 agriculture clients where data gaps caused $50K crop insurance disputes. Let's schedule a 15-minute call to verify the archive availability and confirm your lead_days interpretation before I start pulling data you can't use.
$450 AUD en 10 jours
7,1
7,1

Hello, With over 7 years of experience in Data Processing, Excel, Data Extraction, and Python, I have the expertise required to handle your project efficiently. I have carefully read through the project requirements and am confident in my ability to deliver the desired results. To extract historical hourly forecast temperature data from the Open-Meteo Previous Runs API, I will create a Python script that retrieves the required hourly fields for the fixed list of US locations provided. The script will ensure data integrity by handling retries, timeouts, and verifying full coverage before delivery. The output will be structured in a CSV format with each row representing the station ID, timestamp in UTC, lead days, and temperature in Fahrenheit. The script will adhere to the required variables, locations, date range, and output structure as specified in the project description. I am keen to discuss the project further and address any queries you may have. Please connect with me via chat for a detailed conversation. You can visit my Profile at: https://www.freelancer.com/u/HiraMahmood4072 Thank you.
$275 AUD en 7 jours
6,3
6,3

Hello Dear! I write to introduce myself. I'm Engineer Toriqul Islam. I was born and grew up in Bangladesh. I speak and write in English like native people. I am a B.S.C. Engineer of Computer Science & Engineering. I completed my graduation from Rajshahi University of Engineering & Technology ( RUET). I love to work on Web Design & Development project. Web Design & development: I am a full-stack web developer with more than 10 years of experience. My design Approach is Always Modern and simple, which attracts people towards it. I have built websites for a wide variety of industries. I have worked with a lot of companies and built astonishing websites. All Clients have good reviews about me. Client Satisfaction is my first Priority. Technologies We Use: Custom Websites Development Using ======>Full Stack Development. 1. HTML5 2. CSS3 3. Bootstrap4 4. jQuery 5. JavaScript 6. Angular JS 7. React JS 8. Node JS 9. WordPress 10. PHP 11. Ruby on Rails 12. MYSQL 13. Laravel 14. .Net 15. CodeIgniter 16. React Native 17. SQL / MySQL 18. Mobile app development 19. Python 20. MongoDB What you'll get? • Fully Responsive Website on All Devices • Reusable Components • Quick response • Clean, tested and documented code • Completely met deadlines and requirements • Clear communication You are cordially welcome to discuss your project. Thank You! Best Regards, Toriqul Islam
$250 AUD en 7 jours
6,0
6,0

Norah Head, Australia
Méthode de paiement vérifiée
Membre depuis févr. 17, 2026
$10-30 USD
$1500-3000 USD
$10-30 USD
$750-1500 USD
₹12500-37500 INR
$1500-3000 USD
$30-250 AUD
₹12500-37500 INR
$250-750 USD
$10-30 USD
$10-30 USD
₹600-1500 INR
₹600-1500 INR
₹750-1250 INR / heure
₹1500-12500 INR
$1500-3000 USD
₹1500-12500 INR
₹12500-37500 INR
₹750-1250 INR / heure
€6-12 EUR / heure