Tamamlanmış

Parse Excel Spreadsheet and save relevant data to CSV file

On the website of the Insurance Association of Cyprus you can find a collection of Excel spreadsheets that contain details about the performance of the investment funds of each insurance company.

This is the web page: [login to view URL]

I would like a python script to extract the prices of all the funds, for all the insurance companies, and save them to a CSV file.

The input to the script should be a single xlsx file. For example, the latest file shown on the above web page is the file "Unit Linked Prices 2018".

The columns of the output CSV file should be:

1. Company

2. Fund

3. Establishment

4. Month

5. Year

6. Available

7. Fund Size

8. Offer Price

9. Bid Price

At the end of the project I would like the deliverable will be a script written in python 3. I will run the script myself using the xlsx files to get the csv files. The script should be well documented.

I attach an example csv file that includes only the data for a single fund from a specific insurance company. The data is taken from the file "Unit Linked Prices 2018". The script should extract the data for all the funds from all the insurance companies shown in the spreadsheet.

Beceriler: Python

Daha fazlasını gör: how to open csv file in excel 2010, how to force excel to open csv files with data arranged in columns, convert text file to excel 2013, import text file into excel 2016, import csv into excel 2016, csv to excel online, how to open csv file in excel with columns, how to open csv file in excel 2016, upload data csv file mysql, source code export sql data csv file vb6, import data csv file sql 2005, retrieve data csv file, send form data csv file asp, submit form data csv file, save form data cvs file server, excel script copy cell data closed file, page data csv file html, export table data csv file php, excel vba import data csv file, excel update data csv file often

İşveren Hakkında:
( 1 değerlendirme ) Nicosia, Cyprus

Proje NO: #18219654

Seçilen:

pravins9

I have a lot of experience in reading and writing spreadsheets through Python. 1. The input .xlsx file will be read by xlrd library of Python. 2. relevant data will be extracted. 3. extracted data will be written to a Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(1 Yorum)
2.5

Bu iş için 27 freelancer ortalamada €120 teklif veriyor

mingxiao2008

Hello, Dear I am very interested in your project and I have experienced in developing Python and Web Scraping. I will work very hard and best for you. Best Regards

€155 EUR in 3 gün içinde
(52 Değerlendirme)
7.0
leemilun

Hi I am expert in Python. I checked your project and I think I am able to do this project. I want to work for this project. Thanks gao

€155 EUR in 3 gün içinde
(35 Değerlendirme)
6.2
hunmin888

hi. your project requirement is very clear for me. i am a python expert. i have a good experience in python. so if you give me this project, i will satisfy you surely. our budget may be negotiable. thanks.

€155 EUR in 3 gün içinde
(40 Değerlendirme)
6.2
Mickelson

Hi Nice to meet you. I'm python expert and my last project on freelancer.com is also python scraping task. My past works: Youtube comment scrapping Real estate property list to csv Job-site content to csv And sc Daha Fazla

€150 EUR in 3 gün içinde
(48 Değerlendirme)
6.0
brianconey

Hello . Thanks for your posting. I have read your job descriptions. Did you check your website on gtmetrix and google insight and pingdom ? on Gtmetrix how much time the pageload speed is ? Anyhow I can fix the is Daha Fazla

€50 EUR in 3 gün içinde
(19 Değerlendirme)
5.7
zekovicm

Hi there,I am Miljan,Data Parsing expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within Daha Fazla

€170 EUR in 3 gün içinde
(18 Değerlendirme)
5.9
TakaAlex

Hi, there! Very interested on your project. With over 7 years' python experience for data feeding and manipulation, I can meet your full requirements in high quality on time. Also having rich experience on CSV manag Daha Fazla

€277 EUR in 3 gün içinde
(9 Değerlendirme)
5.3
naravila

Hello, I read your requirement carefully and bid here. As you can see my profile, I am a senior Python developer. And I have plenty of experience parsing and managing CSV and Excel file. I can finish your task perf Daha Fazla

€150 EUR in 3 gün içinde
(11 Değerlendirme)
5.3
sohandas

Hello, i have checked the "Unit Linked Prices 2018" file and understood what output csv you want, i will write the program in python using pandas, can you please pm so that we can discuss more....thanks!

€150 EUR in 3 gün içinde
(18 Değerlendirme)
5.2
lightingdavid

Hey? How are you? I have reviewed "Parse Excel Spreadsheet and save relevant data to CSV file" .I have good skills for these (Python). I have been working for 7 yrs in this scope. While we contract and work in our Daha Fazla

€155 EUR in 3 gün içinde
(26 Değerlendirme)
5.0
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong work experience in Reac Daha Fazla

€155 EUR in 3 gün içinde
(4 Değerlendirme)
5.3
bluesea1990

Hi, How are you? I have just read your job description carefully and I understood exactly what do you want. I have an expertise. Looking for your kind reply. Thanks for your attention. Best Regards.

€88 EUR in 3 gün içinde
(7 Değerlendirme)
3.6
nvchien94

I am an python dev and I can do it for y, simple way by selenium. Contact me and we can start. Maybe some question for detail. Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(8 Değerlendirme)
3.3
thangict93

Hi Sir! I'm a technical leader with 3 years of experience. I am certain, I can resolve this project. I have a similar project written in Python. I still support any change in one month after the project is comple Daha Fazla

€30 EUR in 3 gün içinde
(4 Değerlendirme)
2.4
Graphs02

Hello there, I'd like to make a contribution and help you out with your project because I have experience working with python and handling excel files entries, therefore I can guarantee the satisfaction on the needs in Daha Fazla

€125 EUR in 3 gün içinde
(5 Değerlendirme)
2.3
Dushyant111

Hey, I have experience in data mining job and I'm well versed with Python packages such as Pandas, Request, Openpyxl. I believe I can do your job. Let's discuss more about you project.

€55 EUR in 4 gün içinde
(1 Yorum)
1.9
Kamalbhatia528

Hi I am working as a python developer from one year in a reputed mnc. I can do your work with perfection and ensure you that my code will be delivered to you on time. I have understood your requirements. and pa Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(1 Yorum)
0.6
Jong0714

Dear Hiring Manager. I am a python Developer with over 4 years of experience and 5 years undergraduate degree in software engineering. Working on Machine Learning and AI projects mostly. Skills summary: • Strong kn Daha Fazla

€80 EUR in 2 gün içinde
(0 Değerlendirme)
0.0
ammy001

I have good experience in python programming and some of the main libraries of python that can be useful for this project

€55 EUR in 3 gün içinde
(0 Değerlendirme)
0.0
€155 EUR in 3 gün içinde
(0 Değerlendirme)
0.0