Terminé

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.

Compétences : Python

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Limassol, Cyprus

Nº du projet : #18219654

Décerné à:

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% EUR en 1 jour
(1 Évaluation)
1.3

33 freelance font une offre moyenne de €116 pour ce travail

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(46 Commentaires)
7.0
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(33 Commentaires)
6.2
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(20 Commentaires)
5.6
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(22 Commentaires)
5.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(9 Commentaires)
5.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(11 Commentaires)
5.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(7 Commentaires)
4.5
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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(10 Commentaires)
4.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(7 Commentaires)
4.4
tushortz

I can get this done ASAP .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(22 Commentaires)
4.4
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(4 Commentaires)
4.7
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(5 Commentaires)
3.7
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(5 Commentaires)
2.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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(1 Évaluation)
2.0
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(1 Évaluation)
1.6
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 4 jours
(1 Évaluation)
0.8
phdkemal

It is just a straightforward python data parsing task. I could do it in pandas (python) in two days.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 15 jours
(0 Commentaires)
0.0
isaakdeveloper

this is my experiences in web crawling : - News aggregator. crawls a list of websites, parses their contents and store them into database. - [login to view URL] subtitle convertor, get transcripts from web and convert t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)
0.0
valdemar1975

Hello, my name is Vladimir and I am Python developer from Russia (UTC+6) I want take your project, because I have hands on experience in parsing MS Excel Sheets using Python. Please, see my works in my portfolio. I h Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(0 Commentaires)
0.0