Python script - create excel files based on filter

€8-50 EUR

Completed

Posted

9 months ago

€8-50 EUR

Paid on delivery

I am looking for a Python script developer to create excel files based on a filter. The requirements for the project are as follows: Output Format: - The desired output format for the excel files is XLSX. Source of Data: - The data that will be filtered is sourced from a CSV file. Filters: - There will be 2-4 different filters that need to be applied to the data. The CSV file contains data on customers and their holidays, days of sick and unpaid days. I need to filter (like a pivot table) based on approved type of day off, total count of number of days per person. Each file is filtered by country and then put into an excel file Naming Convention: " [Country Name] Holiday Report Sep 2023" Please look at the CSV file and the output jpeg. Ideal Skills and Experience: - Proficiency in Python programming language. - Experience in working with excel files and handling data manipulation. - Knowledge of CSV file handling and filtering. - Strong problem-solving skills and attention to detail. If you have the necessary skills and experience, please submit your proposal. Feel free to ask any further clarifications regarding the project.

Python

Excel

Data Processing

Project ID: 37109088

About the project

46 proposals

Remote project

Active 9 mos ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

€50 EUR in 2 days

4.9

(649 reviews)

8.6

46 freelancers are bidding on average €31 EUR for this job

@Fazeennazar

*** Python Expert for your project : Filter csv and generate Excel output *** I read your project description very carefully. I have a deep understanding and experience in the areas of Python that you mentioned. I've previously worked on so many projects for other employers. Here is my profile URL: https://www.freelancer.com/u/Fazeennazar Check out my past reviews and skills. So, I would like to go through more specific discussions with you to provide successful results. Thank you, Mohamed F.

€29 EUR in 1 day

5.0

(238 reviews)

7.4

@aminbros

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

€50 EUR in 7 days

5.0

(43 reviews)

6.6

@mahmoudembaby1

Hello, I am interested in helping you build a very simple tool that will create Excel files based on your filters. I understand what you need and I am sure I can get it done in less than 3 hours today for only € 30. Eagerly look forward to working with you!

€30 EUR in 1 day

5.0

(149 reviews)

6.7

@devendrathakur12

I can create a Python script that filters and organizes data from a CSV file into XLSX format as per your requirements. With my expertise in Python, data manipulation, and Excel handling, I'll ensure accurate and organized holiday reports for each country. Let's discuss the project specifics and get started!

€80 EUR in 1 day

5.0

(17 reviews)

5.4

@faisal9263

Hi, I possess the required expertise to fulfill your project needs. With a strong command of Python, I'll develop a script that extracts data from the CSV file, applies multiple filters, and generates organized XLSX reports. I have a proven track record in data manipulation, particularly in Excel and CSV handling. My attention to detail ensures accurate filtering. The final script will efficiently group data by country and produce files named as per your convention. I'm eager to leverage my skills to deliver a seamless solution tailored to your specifications. Let's collaborate to bring this project to fruition effectively. Thanks

€30 EUR in 1 day

5.0

(19 reviews)

5.4

@hotanloc

I saw your project description carefully. I can complete this task with high quality on time. My core skill is Data processing and ML/DL that train the model from your data. After that i will predict future value base on trained model. I have full experiences in this work. Please sned me your message to discuss your project detail more...I am waiting your reply now. Thanks.

€19 EUR in 1 day

4.7

(13 reviews)

5.2

@amrkhaled32

Hello, I hope you are doing well, how are you? if you are looking for someone who can do the job in a fast and reliable way you are in the right place! I am an expert in Python, I have great experience with modules of Python like selenium, requests, beautiful soup, pandas, and much more. Do you have a budget in mind for this project? I can do the project for you and do the script that creates excel files based on the filter required. I have done many file formatting projects before. Allow me to show you my talent! Best regards, Rawan

€30 EUR in 3 days

4.9

(23 reviews)

5.0

@EmiliaSimon

Hello, I can help you write a script to filter data from a csv file and save it in Excel format. I am a Data Scientist with extensive experience in Python programming (Pandas, NumPy, Statsmodels, Matplotlib, Seaborn, Sikit-Learn, NLTK, Networx, etc.), and I can quickly and easily deliver the results you need. Please feel free to contact me to discuss your project in more detail. Thanks a lot. Best regards, Emilia

€20 EUR in 2 days

5.0

(34 reviews)

5.0

@arbu1499

Hello there! With extensive expertise in Python scripting and data manipulation, I'm well-equipped to develop a solution that generates excel files based on your specified filters. I'm confident in creating an efficient script that processes the CSV data, applies the necessary filters, and outputs the desired XLSX format, all while adhering to your naming convention. I'm eager to delve into the specifics of your project in order to ensure accurate implementation. Let's chat further to clarify any details and discuss the best approach to meet your requirements. Looking forward to our conversation, Kind Regards, Arbaz A

€50 EUR in 3 days

5.0

(9 reviews)

4.2

@sambit2723

I have gone through your requirements. I have experience on both python and excel Macro. We have 2 options either using python we can achieve this or by adding a macro in your excel we can do same. Please message me to discuss on it.

€30 EUR in 2 days

5.0

(3 reviews)

3.9

@darios1

Hi there, I can do your project. I know Python well, I use Spyder and Jupyter to code. I have Python 3.

€23 EUR in 7 days

5.0

(12 reviews)

3.6

@DataAnalysisGuru

Hello, I am a proficient Python developer with extensive experience in data manipulation and excel file handling. I am confident in my ability to create a script that generates XLSX files based on the specified filters. I have worked with CSV files extensively and am adept at applying filters to extract the desired data.

€19 EUR in 7 days

5.0

(8 reviews)

3.6

@jowharfazal

I had a good look at your input (CSV) file and the desired output format (image file). With my years of experience in programming and recent 4 years in Python, I can fulfill your requirement withint 2 days' time using a python script. Please feel free to message me on chat here, if you want to assign me the task.

€15 EUR in 2 days

5.0

(4 reviews)

3.0

@linuxholic

Hi, I am an expert in Python working for quite a few years, I have read your project proposal. I can help with your Python project to your needs. We need to discuss in detail about requirements/issues... I will provide you a quality work. Let's chat to proceed.

€22 EUR in 5 days

5.0

(2 reviews)

2.6

@starsudtaryan

Hi there! My name is Aryan, and I'm a python/C++ programmer and a quantitative researcher. I have extensive experience in working with excel files and handling data manipulation. With my extensive knowledge of Python and its related libraries such as pandas and numpy, I am confident that I can complete your project quickly and accurately. I would be delighted to apply my skills to create the necessary excel files based on a filter. Specifically, you are looking for a Python script developer to create XLSX files based on 2-4 different filters that need to be applied to the data. I understand from your description that you require the output format for the files to be XLSX, along with source data sourced from a CSV file. With this knowledge at hand, I am confident that I can provide the necessary solutions to complete your project quickly and efficiently. If you choose me for this job, you can rest assured that you will be getting good communication skills, reliability, and trustworthiness in addition to quality workmanship - all qualities that you would love in a contractor.

€40 EUR in 7 days

4.7

(11 reviews)

3.0

@hassamuddin258

Hi there, I have seen your pivot sample.I can convert your Excel file into a pivot with the above-required condition using Python, in just one day. Message me so I can assist you with this. Thanks

€30 EUR in 1 day

5.0

(6 reviews)

2.6

@darpyong

Warm Greetings! Hope you're doing well. Thanks for posting the project. As a senior full stack developer with 9+ years of experience and I'm proficient in handling CSV files using Python pandas and csv. I have tons of experience in this field so I'm confident to complete your project without issue. Hope we can cooperate with the project. Best regards.

€30 EUR in 1 day

5.0

(1 review)

2.2

@raushan790

Hello, my name is Raushan and I am an experienced Python developer. I am confident that I can provide the best solution for your project - creating Excel files based on a filter. With 8 years of web development experience and expertise, I am well-placed to tackle this project. I understand that you are looking for a Python script developer to create excel files based on a filter. The requirements for the project are as follows: Output Format: XLSX Source of Data: CSV file Filters: There will be 2-4 different filters that need to be applied to the data. Naming Convention: Holiday Report Sep 2023 for each country pair

€20 EUR in 2 days

5.0

(1 review)

1.6

@artem0507

Hello. I checked your proposal carefully. As a veteran python expert, I am expertise in python and google sheets. I have extract data from csv and i am familiar with excel macros and excel vba. I can handle this. I look forward to hearing from you. Kind regards.

€30 EUR in 7 days

4.6

(1 review)

1.0

@niceoksanadonets

Hi, Faiza E. I've gone through the job posting. It seems that you're looking for a programmer who have rich experiences on Excel, Data Processing and Python. I am checking your attachment, I'll update you shortly... I've worked with another client in this space, I think you might find it very interesting to have chat. Regards, Oksana

€25 EUR in 4 days