Kapalı

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!

Beceriler: Python, Yazılım Mimarisi, Web Scraping

Daha fazlasını gör: 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

İşveren Hakkında:
( 5 değerlendirme ) Freiston, United Kingdom

Proje NO: #19996462

Bu iş için 52 freelancer ortalamada £18 teklif veriyor

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(916 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(91 Değerlendirme)
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 Daha Fazla

£15 GBP in 7 gün içinde
(40 Değerlendirme)
5.7
kaloyan13

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(82 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(19 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(54 Değerlendirme)
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 Daha Fazla

£66 GBP in 3 gün içinde
(54 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(24 Değerlendirme)
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 Daha Fazla

£20 GBP in 3 gün içinde
(22 Değerlendirme)
5.0
ThilinaG01

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(9 Değerlendirme)
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 gün içinde
(5 Değerlendirme)
4.1
£20 GBP in 0 gün içinde
(19 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(23 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(13 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(11 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(10 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(2 Değerlendirme)
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 Daha Fazla

£18 GBP in 0 gün içinde
(7 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(8 Değerlendirme)
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 Daha Fazla

£15 GBP in 7 gün içinde
(4 Değerlendirme)
2.7