Đã Đóng

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!

Kĩ năng: Python, Kiến trúc phần mềm, Web Scraping

Xem nhiều hơn: 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

Về Bên Thuê:
( 5 nhận xét ) Freiston, United Kingdom

ID dự án: #19996462

52 freelancer đang chào giá trung bình £18 cho công việc này


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 trong 1 ngày
(916 Nhận xét)

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 Thêm

£20 GBP trong 1 ngày
(91 Nhận xét)

[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 Thêm

£15 GBP trong 7 ngày
(40 Nhận xét)

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

£20 GBP trong 1 ngày
(82 Nhận xét)

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 Thêm

£20 GBP trong 1 ngày
(19 Nhận xét)

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 trong 1 ngày
(54 Nhận xét)

‌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 Thêm

£66 GBP trong 3 ngày
(54 Nhận xét)

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 Thêm

£18 GBP trong 1 ngày
(24 Nhận xét)

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 Thêm

£20 GBP trong 3 ngày
(22 Nhận xét)

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

£20 GBP trong 1 ngày
(9 Nhận xét)

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 trong 2 ngày
(5 Nhận xét)
£20 GBP trong 0 ngày
(19 Nhận xét)

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 trong 1 ngày
(23 Nhận xét)

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 trong 1 ngày
(13 Nhận xét)

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 Thêm

£13 GBP trong 1 ngày
(11 Nhận xét)

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 trong 1 ngày
(10 Nhận xét)

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 Thêm

£20 GBP trong 1 ngày
(2 Nhận xét)

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 Thêm

£18 GBP trong 0 ngày
(7 Nhận xét)

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 Thêm

£15 GBP trong 1 ngày
(8 Nhận xét)

⭐ 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 Thêm

£15 GBP trong 7 ngày
(4 Nhận xét)