Find Jobs
Hire Freelancers

Python script to run through CSV and fill in blank time blanks

£10-20 GBP

Closed
Posted almost 5 years ago

£10-20 GBP

Paid on delivery
Hi there, Need a simple python script that pulls in some time series data and fills in blank values. For example, data: 2010-03-28 00:00:00 0.2938 2010-03-28 00:01:00 0.2938 2010-03-28 00:02:00 0.2935 2010-03-28 00:03:00 0.2938 2010-03-28 00:05:00 0.2939 Notice that the data jumps from 00:03:00 to 00:05:00, I need that blank to be filled in so the data looks like this: 2010-03-28 00:00:00 0.2938 2010-03-28 00:01:00 0.2938 2010-03-28 00:02:00 0.2935 2010-03-28 00:03:00 0.2938 2010-03-28 00:04:00 NaN 2010-03-28 00:05:00 0.2939 Will provide you with a sample csv with 100 rows of data. You should use Pandas Python library. The script should be able to pull in a csv file, iterate through the data (for i in range (0,num_rows)) and fill in blanks like I've shown above. Some cases, the data will have a lot of blanks, i.e. may have a whole days worth of data missing, in cases like this the script should still populate the data the missing timestamp values along with NaN, as shown above. Thank you!
Project ID: 19996462

About the project

47 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
47 freelancers are bidding on average £17 GBP for this job
User Avatar
Hello It is elementary project can be completed in 20 mins of pure working time I have almost 3 years of experience with Python
£14 GBP in 1 day
4.9 (1125 reviews)
7.7
7.7
User Avatar
Hello,how are you? I have experiences for many years about python programming. I have done your proposal quickly and then u will get best result. I will do my best for you and you will be gotten best results Plz contact with me. Let's start this work! Regards
£20 GBP in 1 day
4.8 (99 reviews)
6.5
6.5
User Avatar
I have used Pandas in Python a few times. Can do your project for 1-2 horus time. Tahnk you ........
£20 GBP in 1 day
4.9 (130 reviews)
6.3
6.3
User Avatar
Hi, I can write a script which would do the task of taking csv as input and modifying the values. Please contact me if you're interested in working with me.
£15 GBP in 1 day
5.0 (30 reviews)
6.3
6.3
User Avatar
Hi. Simple project. Great app writer for your projects. I have writen python app, script for many years. I am ready to write your project. Thank you for visiting my profile
£20 GBP in 1 day
4.9 (85 reviews)
5.9
5.9
User Avatar
‌Hi, I have gone through your requirement to scrape lots of websites. I am EXPERT in building scraping tools /scripts. Hence, I can SURELY work on your project. I am having 4 YEARS of EXPERIENCE in developing PHP-PYTHON (Scrapy, Selenium) based web scraper as well as WINDOWS BASED web scraping software through which I have crawled many sites such as Craigslist, Amazon, Yelp and many others. I have also worked on complex site to bypass CAPTCHA with the use of PROXY IP bouncing techniques.. Let's work together :) Have a great day! I am glad to see your WORK HISTORY and positive reviews of other freelancers. I am really excited to work with you and would love to have a long-term business association for any of your data related needs less  ,,,,,,,,,,,,. ,
£66 GBP in 3 days
4.9 (111 reviews)
6.0
6.0
User Avatar
Hi, I would like to write the script for you that fills missing data with NaN. You can rely on me. I am an experienced Python developer. I am very good at Pandas. Looking forward to hear from you. Best regards, Oleg
£20 GBP in 1 day
5.0 (24 reviews)
5.8
5.8
User Avatar
Dear Employer, I have extensive experience in csv file processing using python and pandas. Please let me know if you are interested and I would be more than happy to assist you.
£13 GBP in 1 day
4.9 (72 reviews)
5.6
5.6
User Avatar
Hi, I have worked with pandas for data manipulation. I would like to work on you project. Let me know if you want to discuss further. Regards, Monir
£20 GBP in 2 days
4.9 (26 reviews)
5.5
5.5
User Avatar
Hello there, I am an Excel coder and I can code python for you. I think it so simple loop and can do in fews min. Please contact me.
£13 GBP in 1 day
5.0 (42 reviews)
4.9
4.9
User Avatar
hi i can do this.............................................................................................
£20 GBP in 1 day
5.0 (22 reviews)
5.1
5.1
User Avatar
I have good experiences developing code in Python Programming language for Scientific and data science projects for more than 4 years. I think your task can be easily implemented in Pandas. Thanks
£16 GBP in 1 day
5.0 (33 reviews)
5.0
5.0
User Avatar
Hi I can fill in this time series for you. The missing stock values in minute data will be filled with previous or older values as you want them to be. I have already done this before, in IB downloaded data. Message me, if you want me to proceed with your project. thanks.
£20 GBP in 3 days
4.7 (23 reviews)
5.1
5.1
User Avatar
Hi, How are you? I am very interest in your project. As I am a professional Expert with great experience and skills, I am sure that I can help you I'm ready to start to work on your project right now. If we clarify the requirements via chatting, I will provide you with top quality on time. If you trust and award me, so I will finish it rapidly and perfectly. I've always been giving clients satisfaction with the great quality of work for many clients. Thanks in advance.
£18 GBP in 1 day
4.8 (30 reviews)
5.1
5.1
User Avatar
Dear employer, Hi This is a simple Python project. I am working on it and try to give you the result in a few minutes. I will update this description. It would be highly appreciated if you could send me a message so we can discuss more. Regards, Amir
£18 GBP in 0 day
4.9 (29 reviews)
4.8
4.8
User Avatar
Hello sir, I've read the description of your project and I'm quite certain that what you want can be achieve with a couple of lines with Pandas. This is why I would offer the lowest bid if you would want to complete this for you
£13 GBP in 1 day
5.0 (15 reviews)
4.7
4.7
User Avatar
Hi, I am an experienced python developer with expertise in packages such as numpy, pandas etc. I can get this done in couple of hours. Regards, Sarmistha
£15 GBP in 1 day
5.0 (7 reviews)
4.4
4.4
User Avatar
I am expert with Python pandas and can do this task within a day. I am a professional Python developer and I can complete this task within timeline and in less budget. I will also provide support for this later if somethings goes wrong, Please feel free to text me and we can discuss on this further.
£15 GBP in 1 day
5.0 (8 reviews)
3.0
3.0
User Avatar
Super easy - the data just needs to be resampled using pandas in the right fashion. I have finished the code and have made it dynamic so, if your data set has 1 minute of time interval or 1 hour of time interval it will still work. I can get this out to you right away, drop me a text and let's get this rolling for you :)
£15 GBP in 1 day
4.2 (3 reviews)
2.9
2.9
User Avatar
Hello there fellow Brit, If interested, I can write this in PHP but with the same deliverables - a fully corrected CSV which can still easily be imported into python. Let me know what you think. Kind regards, Joseph
£10 GBP in 1 day
5.0 (4 reviews)
2.5
2.5

About the client

Flag of UNITED KINGDOM
Freiston, United Kingdom
5.0
5
Payment method verified
Member since Sep 5, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.