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:
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.
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
33 freelance font une offre moyenne de €116 pour ce travail
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
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.
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
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
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
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
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
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!
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
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
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
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
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.
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.
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.
It is just a straightforward python data parsing task. I could do it in pandas (python) in two days.
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
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