Lukket

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

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!

Evner: Python, Software Arkitektur, Web Skrabning

Se mere: read csv file using python script, python script csv tab, python script csv file, python remove rows with null, python replace empty string with none, pandas fill blanks with 0, how to delete empty rows in csv file python, python check if csv cell is empty, python csv, pandas remove rows with empty strings, how to remove null values in python, parsing csv file python script, python script read csv, python script parse csv, python script parse csv files, python script output csv file, python script handle csv file, python script modify csv file, python script parse csv text file, python script search csv file

Om arbejdsgiveren:
( 5 bedømmelser ) Freiston, United Kingdom

Projekt ID: #19996462

52 freelancere byder i gennemsnit £18 på dette job

vano101

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 på 1 dag
(916 bedømmelser)
7.4
kipdev13

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 c Flere

£20 GBP på 1 dag
(91 bedømmelser)
6.3
yesikov1224

[login to view URL] Credit is my motto. I am expert web scraping. I can avoid recaptcha. I can do your job with BS4 ,Perl script, Seleinum framework of python. I can do any project in your demand completely by my good experiences Flere

£15 GBP in 7 dage
(40 bedømmelser)
5.7
kaloyan13

I have used Pandas in Python a few times. Can do your project for 1-2 horus time. Tahnk you ........

£20 GBP på 1 dag
(82 bedømmelser)
5.8
oyasniy

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 reg Flere

£20 GBP på 1 dag
(19 bedømmelser)
5.5
mikeitexpert

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 på 1 dag
(54 bedømmelser)
5.2
smsaurabhv

‌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-PYTHO Flere

£66 GBP in 3 dage
(54 bedømmelser)
5.1
BestService222

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 cla Flere

£18 GBP på 1 dag
(24 bedømmelser)
4.9
hasnatkhurshid

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 Flere

£20 GBP in 3 dage
(22 bedømmelser)
5.0
ThilinaG01

hi i can do this.............................................................................................

£20 GBP på 1 dag
(9 bedømmelser)
4.3
Arahan00

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 dage
(5 bedømmelser)
4.1
£20 GBP in 0 dage
(19 bedømmelser)
4.6
nvchien94

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 på 1 dag
(23 bedømmelser)
4.2
Techiedev

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 på 1 dag
(13 bedømmelser)
3.8
bilalkamoon

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 th Flere

£13 GBP på 1 dag
(11 bedømmelser)
4.0
UndeadBug

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 på 1 dag
(10 bedømmelser)
3.8
Molotova

Dear sir. How are you? I have gone through the requirement and would like to raise my interest in the same. I am an expert at Python. I believe I have most of the skills that you are seeking and would like to be co Flere

£20 GBP på 1 dag
(2 bedømmelser)
3.1
abbasJz

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 Flere

£18 GBP in 0 dage
(7 bedømmelser)
3.0
sanidhyarajawat

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 some Flere

£15 GBP på 1 dag
(8 bedømmelser)
2.7
ludwig333

⭐ Good day,Dear!⭐ PYTHON Expert is HERE! I am a full-stack web developer experienced in PHP/CodeIgniter/Laravel and am interested in working for your project. I have expertise in PHP and can migrate to laravel. ⭐ htt Flere

£15 GBP in 7 dage
(4 bedømmelser)
2.7