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 Daha Fazla
Bu iş için 27 freelancer ortalamada €120 teklif veriyor
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.
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!
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.
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